public IList <StaffInfo> GetListByOrg(int pageIndex, int pageSize, out int totalRecords, object orgId, string sqlWhere, params SqlParameter[] cmdParms) { var queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); IEnumerable <StaffInfo> staffs = null; if (!string.IsNullOrEmpty(queryModel.Keyword)) { staffs = _db.Staffs.Find(m => (m.Coded + m.Phone).Contains(queryModel.Keyword)); } else { staffs = _db.Staffs.FindAll(); } if (staffs == null) { totalRecords = 0; return(null); } totalRecords = staffs.Count(); var datas = staffs.Skip((pageIndex - 1) * pageSize).Take(pageSize); return(datas.ToList()); }
public IList <SiteMultiInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { var queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); IEnumerable <SiteMultiInfo> siteMultis = null; if (!string.IsNullOrEmpty(queryModel.Keyword)) { siteMultis = _db.SiteMultis.Find(m => m.Coded.Contains(queryModel.Keyword) || m.Named.Contains(queryModel.Keyword)); } else { siteMultis = _db.SiteMultis.FindAll(); } if (siteMultis == null) { totalRecords = 0; return(null); } totalRecords = siteMultis.Count(); var datas = siteMultis.Skip((pageIndex - 1) * pageSize).Take(pageSize); foreach (var item in datas) { var sitePictureInfo = _db.SitePictures.FindOne(m => (m.FileDirectory + m.FileName).Equals(item.SiteLogo)); item.SiteLogoId = sitePictureInfo == null ? Guid.Empty : sitePictureInfo.Id; } return(datas.ToList()); }
public IList <ComboboxInfo> GetCbbList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { var queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); IEnumerable <SitePictureInfo> sitePictures = null; if (!string.IsNullOrEmpty(queryModel.Keyword)) { sitePictures = _db.SitePictures.Find(m => m.FunType.Contains(queryModel.Keyword)); } else { sitePictures = _db.SitePictures.FindAll(); } if (sitePictures == null) { totalRecords = 0; return(null); } totalRecords = sitePictures.Count(); var datas = sitePictures.Skip((pageIndex - 1) * pageSize).Take(pageSize); var cbbDatas = new List <ComboboxInfo>(); foreach (var item in datas) { cbbDatas.Add(new ComboboxInfo(item.Id.ToString(), string.Format("{0}{1}{2}", "/Asset", item.FileDirectory, item.FileName))); } return(cbbDatas); }
public PandianInfo GetModelByJoin(string sqlWhere, params SqlParameter[] cmdParms) { PandianInfo pandianInfo = ConvertToModel.ToModel <PandianInfo>(cmdParms); if (!pandianInfo.Id.Equals(Guid.Empty)) { return(_db.Pandians.FindById(pandianInfo.Id)); } return(null); }
public IList <SiteMenusInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { LiteQueryModel queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); if (!queryModel.ApplicationId.Equals(Guid.Empty)) { return(_db.SiteMenus.Find(m => m.ApplicationId.Equals(queryModel.ApplicationId)).ToList()); } return(_db.SiteMenus.FindAll().ToList()); }
public IList <BarcodeTemplateInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms) { BarcodeTemplateInfo model = ConvertToModel.ToModel <BarcodeTemplateInfo>(cmdParms); IEnumerable <BarcodeTemplateInfo> datas = _db.BarcodeTemplates.FindAll(); if (!string.IsNullOrEmpty(model.TypeName)) { datas = datas.Where(m => m.TypeName.Equals(model.TypeName)); } return(datas.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); }
public IList <ProductInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { LiteQueryModel queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); Query query = null; if (!queryModel.MgrDepmtId.Equals(Guid.Empty)) { query = Query.And(Query.EQ("MgrDepmtId", queryModel.MgrDepmtId)); } if (!queryModel.CategoryId.Equals(Guid.Empty)) { query = Query.And(Query.EQ("CategoryId", queryModel.CategoryId)); } if (!queryModel.UseDepmtId.Equals(Guid.Empty)) { query = Query.And(Query.EQ("UseDepmtId", queryModel.CategoryId)); } if (!queryModel.StoragePlaceId.Equals(Guid.Empty)) { query = Query.And(Query.EQ("StoragePlaceId", queryModel.CategoryId)); } if (queryModel.StartDate != DateTime.MinValue && queryModel.EndDate != DateTime.MinValue) { query = Query.And(Query.Between("BuyDate", queryModel.StartDate, queryModel.EndDate)); } else { if (queryModel.StartDate != DateTime.MinValue) { query = Query.And(Query.GTE("BuyDate", queryModel.StartDate)); } if (queryModel.EndDate != DateTime.MinValue) { query = Query.And(Query.LT("BuyDate", queryModel.EndDate)); } } if (!string.IsNullOrEmpty(queryModel.UserRule)) { query = Query.And(Query.Where("MgrDepmtId", m => queryModel.UserRule.Contains(m))); } if (query != null) { return(_db.Products.Find(query).ToList()); } else { return(_db.Products.FindAll().ToList()); } }
public IList <FeatureUserInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { FeatureUserInfo model = ConvertToModel.ToModel <FeatureUserInfo>(cmdParms); IEnumerable <FeatureUserInfo> datas = _db.FeatureUsers.FindAll(); if (!model.UserId.Equals(Guid.Empty)) { datas = datas.Where(m => m.UserId.Equals(model.UserId)); } if (!string.IsNullOrEmpty(model.TypeName)) { datas = datas.Where(m => m.TypeName.Equals(model.TypeName)); } return(datas.ToList()); }
public List <SiteRolesInfo> GetAspnetList(string appName, string sqlWhere, params SqlParameter[] cmdParms) { var queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); IEnumerable <SiteRolesInfo> siteRoles = null; var appid = new Applications().GetAspnetAppId(appName); if (!string.IsNullOrEmpty(queryModel.SqlIn)) { siteRoles = _db.SiteRoles.Find(m => m.ApplicationId.Equals(appid) && queryModel.SqlIn.Contains(m.Named)); } else { siteRoles = _db.SiteRoles.Find(m => m.ApplicationId.Equals(appid)); } return(siteRoles.ToList()); }
public IList <ProductRepairExtendInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { LiteQueryModel queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); Query query = null; if (!string.IsNullOrEmpty(queryModel.Keyword)) { query = Query.And(Query.Or(Query.Contains("Named", queryModel.Keyword), Query.Contains("Coded", queryModel.Keyword))); } IEnumerable <ProductRepairInfo> datas = null; if (query == null) { datas = _db.ProductRepairs.FindAll(); } else { datas = _db.ProductRepairs.Find(query); } if (datas == null) { totalRecords = 0; return(null); } totalRecords = datas.Count(); IEnumerable <ProductRepairInfo> pageDatas = datas.Skip((pageIndex - 1) * pageSize).Take(pageSize); List <ProductRepairExtendInfo> result = new List <ProductRepairExtendInfo>(); foreach (ProductRepairInfo pr in pageDatas) { result.Add(ToProductRepairExtendInfo(pr)); } return(result); }
public IList <ProductInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { LiteQueryModel queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); Query query = null; if (!queryModel.MgrDepmtId.Equals(Guid.Empty)) { query = Query.And(Query.EQ("MgrDepmtId", queryModel.MgrDepmtId)); } if (!string.IsNullOrEmpty(queryModel.UserRule)) { query = Query.And(Query.Where("MgrDepmtId", m => queryModel.UserRule.Contains(m))); } if (!string.IsNullOrEmpty(queryModel.Keyword)) { query = Query.And(Query.Or(Query.Contains("Named", queryModel.Keyword), Query.Contains("Coded", queryModel.Keyword))); } IEnumerable <ProductInfo> datas = null; if (query != null) { datas = _db.Products.Find(query); } else { datas = _db.Products.FindAll(); } totalRecords = datas.Count(); IEnumerable <ProductInfo> pageDatas = datas.Skip((pageIndex - 1) * pageSize).Take(pageSize); foreach (ProductInfo p in pageDatas) { AppendFullInfo(p); } return(pageDatas.ToList()); }
public DataSet GetExportData(string sqlWhere, params SqlParameter[] cmdParms) { DataSet ds = new DataSet("products"); DataTable dt = new DataTable("products"); dt.Columns.Add("资产编码", typeof(string)); dt.Columns.Add("资产名称", typeof(string)); dt.Columns.Add("规格型号", typeof(string)); dt.Columns.Add("数量", typeof(string)); dt.Columns.Add("单价", typeof(string)); dt.Columns.Add("金额", typeof(string)); dt.Columns.Add("计量单位", typeof(string)); dt.Columns.Add("资产属性", typeof(string)); dt.Columns.Add("资产来源", typeof(string)); dt.Columns.Add("供应商", typeof(string)); dt.Columns.Add("购入日期", typeof(string)); dt.Columns.Add("启用日期", typeof(string)); dt.Columns.Add("使用期限", typeof(string)); dt.Columns.Add("使用人", typeof(string)); dt.Columns.Add("资产分类编码", typeof(string)); dt.Columns.Add("资产分类", typeof(string)); dt.Columns.Add("使用部门编码", typeof(string)); dt.Columns.Add("使用部门", typeof(string)); dt.Columns.Add("实物管理部门编码", typeof(string)); dt.Columns.Add("实物管理部门", typeof(string)); dt.Columns.Add("存放地点编码", typeof(string)); dt.Columns.Add("存放地点", typeof(string)); Query query = null; LiteQueryModel queryModel = ConvertToModel.ToModel <LiteQueryModel>(cmdParms); if (!string.IsNullOrEmpty(queryModel.UserRule)) { query = Query.Where("DepmtId", m => queryModel.UserRule.Contains(m)); } IEnumerable <ProductInfo> datas = null; if (query == null) { datas = _db.Products.FindAll(); } else { datas = _db.Products.Find(query); } if (datas != null) { foreach (ProductInfo p in datas) { AppendFullInfo(p); DataRow dr = dt.NewRow(); dr["资产编码"] = p.Coded; dr["资产名称"] = p.Named; dr["规格型号"] = p.SpecModel; dr["数量"] = p.Qty; dr["单价"] = p.Price; dr["金额"] = p.Amount; dr["计量单位"] = p.MeterUnit; dr["资产属性"] = p.Pattr; dr["资产来源"] = p.SourceFrom; dr["供应商"] = p.Supplier; dr["购入日期"] = p.BuyDate.ToString("yyyy-MM-dd"); dr["启用日期"] = p.EnableDate; dr["使用期限"] = p.UseDateLimit; dr["使用人"] = p.UsePersonName; dr["资产分类编码"] = p.CategoryCode; dr["资产分类"] = p.CategoryName; dr["使用部门编码"] = p.UseOrgCode; dr["使用部门"] = p.UseOrgName; dr["实物管理部门编码"] = p.MgrOrgCode; dr["实物管理部门"] = p.MgrOrgName; dr["存放地点编码"] = p.StoragePlaceCode; dr["存放地点"] = p.StoragePlaceName; dt.Rows.Add(dr); } } ds.Tables.Add(dt); return(ds); }