using System; using System.Collections.Generic; using System.Data; using DSWeb.SoftMng.Model; // ReSharper disable once CheckNamespace namespace DSWeb.SoftMng.BLL { //sys_secCompany public partial class sys_secCompanyServerBLL { private readonly DAL.sys_secCompanyServerDAL dal=new DAL.sys_secCompanyServerDAL(); #region Method /// /// 是否存在该记录 /// public bool Exists(string GID) { return dal.Exists(GID); } /// /// 增加一条数据 /// public int Add(sys_secCompany model) { return dal.Add(model); } /// /// 更新一条数据 /// public int Update(sys_secCompany model) { return dal.Update(model); } /// /// 删除一条数据 /// public int Delete(string GID) { return dal.Delete(GID); } /// /// 按条件批量删除(有风险) /// public int DeleteListWhere(string strWhere) { return dal.DeleteListWhere(strWhere); } /// /// 得到一个对象实体 /// public sys_secCompany GetModel(string GID) { DataSet ds = dal.GetModel(GID); if(ds.Tables.Count> 0){ var dt = ds.Tables[0]; if(dt.Rows.Count>0){ var dr = dt.Rows[0]; return DataRowToModel(dr); } return null; } return null; } /// /// 获得数据列表 /// public DataSet GetList(string strWhere) { return dal.GetList(strWhere); } /// /// 获得前几行数据 /// public DataSet GetList(int Top,string strWhere,string filedOrder) { return dal.GetList(Top,strWhere,filedOrder); } /// /// 获得数据列表 /// public List GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); return DataTableToList(ds.Tables[0]); } /// /// 获得数据列表 /// public List DataTableToList(DataTable dt) { List modelList = new List(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { for (int n = 0; n < rowsCount; n++) { var model = DataRowToModel(dt.Rows[n]); modelList.Add(model); } } return modelList; } /// /// 获得数据 /// public sys_secCompany DataRowToModel(DataRow dr) { var model = new sys_secCompany(); model.GID= dr["GID"].ToString(); model.CompanySecretKey= dr["CompanySecretKey"].ToString(); model.OperUser= dr["OperUser"].ToString(); if(dr["OperTime"].ToString()!="") model.OperTime=DateTime.Parse(dr["OperTime"].ToString()); return model; } /// /// 获得数据列表 /// public DataSet GetAllList() { return GetList(""); } /// /// 分页获取数据列表 /// /// /// /// /// /// public List GetModelList(int startIndex, int limit, string strWhere, string orderby) { int endIndex = startIndex + limit; DataSet ds = dal.GetListByPage(strWhere,orderby,startIndex,endIndex); return DataTableToList(ds.Tables[0]); } /// /// 获取记录总数 /// public int GetRecordCount(string strWhere) { return dal.GetRecordCount(strWhere); } #endregion } }