/// <summary> /// 删除 /// </summary> /// <param name="userCode"></param> /// <returns></returns> public int Delete(string supNum) { SupplierEntity entity = new SupplierEntity(); entity.IsDelete = (int)EIsDelete.Deleted; entity.IncludeIsDelete(true); entity.Where(a => a.SupNum == supNum); int line = this.Supplier.Update(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_SUPPLIER_CACHE); } return line; }
/// <summary> /// 添加供应商 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int AddSupplier(SupplierEntity entity) { entity.IsDelete = (int)EIsDelete.NotDelete; entity.CreateTime = DateTime.Now; entity.CreateUser = ""; entity.IncludeAll(); int line = this.Supplier.Add(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_SUPPLIER_CACHE); } return line; }
public static Supplier_CE ToCE(SupplierEntity item) { Supplier_CE target = new Supplier_CE(); target.ID=item.ID; target.SupNum=item.SupNum; target.SupName=item.SupName; target.Phone=item.Phone; target.Fax=item.Fax; target.Email=item.Email; target.ContactName=item.ContactName; target.Address=item.Address; target.CreateUser=item.CreateUser; target.Description=item.Description; target.IsDelete=item.IsDelete; target.CreateTime=item.CreateTime; return target; }
public ActionResult SupplierDetailList() { int queryTime = WebUtil.GetFormValue<int>("QueryTime", 0); int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 0); int pageSize = WebUtil.GetFormValue<int>("pageSize", 0); string storageNum = this.DefaultStore; SupplierProvider provider = new SupplierProvider(); SupplierEntity entity = new SupplierEntity(); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; List<SupplierEntity> listResult = provider.GetList(entity, ref pageInfo); listResult = listResult.IsNull() ? new List<SupplierEntity>() : listResult; InStorageProvider inProvider = new InStorageProvider(); foreach (SupplierEntity item in listResult) { item.Num = inProvider.GetNumBySupNum(item.SupNum, queryTime, storageNum); } string json = ConvertJson.ListToJson<SupplierEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount); return Content(this.ReturnJson.ToString()); }
private static void GetProCatInfo(System.Data.DataSet dataset, List<SupplierEntity> list) { var rows = dataset.Tables[0].Rows; if (rows.Count > 2) { for (var i = 2; i < rows.Count; i++) { SupplierEntity entity = new SupplierEntity(); var row = rows[i]; entity.SupNum = row[1].ToString(); if (string.IsNullOrEmpty(entity.SupNum)) continue; entity.SupName = row[2].ToString(); entity.Phone = row[3].ToString(); entity.Fax = row[4].ToString(); entity.Email = row[5].ToString(); entity.ContactName = row[6].ToString(); entity.Address = row[7].ToString(); entity.Description = row[8].ToString(); entity.IsDelete = (int)EIsDelete.NotDelete; entity.CreateTime = DateTime.Now; list.Add(entity); } } }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string SupNum = WebUtil.GetFormValue<string>("SupNum", string.Empty); SupplierProvider provider = new SupplierProvider(); SupplierEntity entity = new SupplierEntity(); List<SupplierEntity> list = provider.GetList(); if (!list.IsNullOrEmpty()) { List<SupplierEntity> listResult = list.Where(a => a.SupNum.Contains(SupNum) || a.SupName.Contains(SupNum)).ToList(); listResult = listResult.IsNull() ? new List<SupplierEntity>() : listResult; if (listResult.IsNotNull()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号 ")); dt.Columns.Add(new DataColumn("供应商编号")); dt.Columns.Add(new DataColumn("供应商名称")); dt.Columns.Add(new DataColumn("电话")); dt.Columns.Add(new DataColumn("传真")); dt.Columns.Add(new DataColumn("Email")); dt.Columns.Add(new DataColumn("联系人")); dt.Columns.Add(new DataColumn("地址")); dt.Columns.Add(new DataColumn("描述")); int count = 1; foreach (SupplierEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.SupNum; row[2] = t.SupName; row[3] = t.Phone; row[4] = t.Fax; row[5] = t.Email; row[6] = t.ContactName; row[7] = t.Address; row[8] = t.Description; dt.Rows.Add(row); count++; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("供应商管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("供应商管理", "供应商", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!") ; } } return Content(this.ReturnJson.ToString()); }
public ActionResult GetSupplierList() { int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 1); int pageSize = WebUtil.GetFormValue<int>("pageSize", 15); string SupNum = WebUtil.GetFormValue<string>("SupNum", string.Empty); SupplierProvider provider = new SupplierProvider(); SupplierEntity entity = new SupplierEntity(); List<SupplierEntity> list = provider.GetList(); if (!list.IsNullOrEmpty()) { List<SupplierEntity> listResult = list.Where(a => a.SupNum.Contains(SupNum) || a.SupName.Contains(SupNum)).ToList(); List<SupplierEntity> returnList = listResult.Skip((pageIndex - 1) * pageSize).Take(pageSize).OrderByDescending(a => a.ID).ToList(); string json = ConvertJson.ListToJson<SupplierEntity>(returnList, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", listResult.Count); } return Content(this.ReturnJson.ToString()); }
/// <summary> /// 获得所有供应商信息 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List<SupplierEntity> GetList() { //List<SupplierEntity> listResult = CacheHelper.Get(CacheKey.JOOSHOW_SUPPLIER_CACHE) as List<SupplierEntity>; //if (!listResult.IsNullOrEmpty()) //{ // return listResult; //} SupplierEntity entity = new SupplierEntity(); entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); List<SupplierEntity> listResult = this.Supplier.GetList(entity); //if (!listResult.IsNullOrEmpty()) //{ // CacheHelper.Insert(CacheKey.JOOSHOW_SUPPLIER_CACHE, listResult); //} return listResult; }
/// <summary> /// 修改 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Update(SupplierEntity entity) { entity.Include(a => new { a.ID, a.SupNum, a.SupName, a.SupType,a.Email, a.Phone, a.Fax, a.ContactName, a.Address, a.Description }); entity.Where(a => a.SupNum == entity.SupNum); int line = this.Supplier.Update(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_SUPPLIER_CACHE); } return line; }
/// <summary> /// 获得所有供应商信息 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List<SupplierEntity> GetList(SupplierEntity entity, ref PageInfo pageInfo) { entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); int rowCount = 0; List<SupplierEntity> listResult = this.Supplier.GetList(entity,pageInfo.PageSize,pageInfo.PageIndex,out rowCount); pageInfo.RowCount = rowCount; return listResult; }