public ActionResult Address() { string SnNum = WebUtil.GetQueryStringValue<string>("SnNum", string.Empty); if (SnNum.IsEmpty()) { ViewBag.CusAddress = new CusAddressEntity(); return View(); } else { List<CusAddressEntity> list = Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] as List<CusAddressEntity>; if (!list.IsNullOrEmpty()) { CusAddressEntity entity = list.FirstOrDefault(a => a.SnNum == SnNum); entity = entity.IsNull() ? new CusAddressEntity() : entity; ViewBag.CusAddress = entity; } else { CustomerProvider provider = new CustomerProvider(); CusAddressEntity entity = provider.GetSingleAddress(SnNum); entity = entity == null ? new CusAddressEntity() : entity; ViewBag.CusAddress = entity; } return View(); } }
public ActionResult AddCustomer([ModelBinder(typeof(JsonBinder<CustomerEntity>))] CustomerEntity entity) { List<CusAddressEntity> list = Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] as List<CusAddressEntity>; list = list == null ? new List<CusAddressEntity>() : list; CustomerProvider provider = new CustomerProvider(); int line = 0; if (entity.CusNum.IsEmpty()) { entity.CreateTime = DateTime.Now; entity.CusNum = SequenceProvider.GetSequence(typeof(CustomerEntity)); line = provider.AddCustomer(entity, list); } else { line = provider.Update(entity, list); } if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } else { this.ReturnJson.AddProperty("d", ""); } return Content(this.ReturnJson.ToString()); }
public ActionResult Add() { Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] = null; string CusNum = WebUtil.GetQueryStringValue<string>("CusNum", string.Empty); if (CusNum.IsEmpty()) { ViewBag.Customer = new CustomerEntity(); ViewBag.DdlCusType = EnumHelper.GetOptions<ECusType>("","请选择客户类别"); return View(); } else { CustomerProvider provider = new CustomerProvider(); CustomerEntity entity = provider.GetSingleCustomer(CusNum); entity = entity == null ? new CustomerEntity() : entity; ViewBag.DdlCusType = EnumHelper.GetOptions<ECusType>(entity.CusType, "请选择客户类别"); ViewBag.Customer = entity; List<CusAddressEntity> listResult = provider.GetAddressList(entity.CusNum); if (!listResult.IsNullOrEmpty()) { Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] = listResult; } return View(); } }
/// <summary> /// 客户下拉列表 /// </summary> /// <param name="roleNum"></param> /// <returns></returns> public static string GetCustomerList(string cusNum) { CustomerProvider provider = new CustomerProvider(); List<CustomerEntity> list = provider.GetList(); StringBuilder sb = new StringBuilder(); string CusTemplate = "<option value='{0}' {1}>{2}</option>"; sb.AppendFormat(CusTemplate, "", "", "请选择客户"); if (!list.IsNullOrEmpty()) { foreach (CustomerEntity cus in list) { sb.AppendFormat(CusTemplate, cus.CusNum, cus.CusNum == cusNum ? "selected='selected'" : string.Empty, cus.CusName); } } return sb.ToString(); }
public ActionResult CustomerReportTOP10() { int queryTime = WebUtil.GetFormValue<int>("QueryTime", 0); int pageIndex = 1; int pageSize = 10; string storageNum = this.DefaultStore; OutStorageProvider provider = new OutStorageProvider(); OutStorageEntity entity = new OutStorageEntity(); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; List<OutStorageEntity> listResult = provider.GetListTOP10(queryTime, storageNum); listResult = listResult.IsNull() ? new List<OutStorageEntity>() : listResult; CustomerProvider cusProvider = new CustomerProvider(); foreach (OutStorageEntity item in listResult) { CustomerEntity tempItem = cusProvider.GetSingleCustomer(item.CusNum); item.CusName = tempItem.CusName; item.CusType = tempItem.CusType; } /*******************************************订单数量排名前十的客户饼图数据****************************************************/ StringBuilder sb = new StringBuilder(); sb.Append("<pie>"); listResult.ForEach(a => { if (a.Num > 0) { sb.AppendFormat("<slice title=\"{0}\">{1}</slice>", a.CusName, a.Num.ToString()); } }); sb.Append("</pie>"); this.ReturnJson.AddProperty("InStorageData", sb.ToString()); string json = ConvertJson.ListToJson<OutStorageEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount); return Content(this.ReturnJson.ToString()); }
public ActionResult CustomerDetailList() { 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; CustomerProvider provider = new CustomerProvider(); CustomerEntity entity = new CustomerEntity(); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; List<CustomerEntity> listResult = provider.GetCustomerList(entity, ref pageInfo); listResult = listResult.IsNull() ? new List<CustomerEntity>() : listResult; OutStorageProvider outProvider = new OutStorageProvider(); foreach (CustomerEntity item in listResult) { item.Num = outProvider.GetNumByCusNum(item.CusNum, queryTime, storageNum); } string json = ConvertJson.ListToJson<CustomerEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount); return Content(this.ReturnJson.ToString()); }
public ActionResult GetSelectAddress() { string CusNum = WebUtil.GetFormValue<string>("CusNum", string.Empty); List<CusAddressEntity> list = null; if (!CusNum.IsEmpty()) { CustomerProvider provider = new CustomerProvider(); list = provider.GetAddressList(CusNum); } list = list == null ? new List<CusAddressEntity>() : list; string json = ConvertJson.ListToJson<CusAddressEntity>(list, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); return Content(this.ReturnJson.ToString()); }
public ActionResult GetCustomerList() { int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 1); int pageSize = WebUtil.GetFormValue<int>("pageSize", 15); string CusNum = WebUtil.GetFormValue<string>("CusNum", string.Empty); int CusType = WebUtil.GetFormValue<int>("CusType", 0); CustomerProvider provider = new CustomerProvider(); CustomerEntity entity = new CustomerEntity(); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; if (!CusNum.IsEmpty()) { entity.Begin<CustomerEntity>() .Where<CustomerEntity>("CusNum", ECondition.Like, "%" + CusNum + "%") .Or<CustomerEntity>("CusName", ECondition.Like, "%" + CusNum + "%") .End<CustomerEntity>(); } if (CusType != 0) { entity.Where<CustomerEntity>(a => a.CusType == CusType); } List<CustomerEntity> listResult = provider.GetCustomerList(entity, ref pageInfo); string json = ConvertJson.ListToJson<CustomerEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount); return Content(this.ReturnJson.ToString()); }
public ActionResult GetContact() { string snNum = WebUtil.GetFormValue<string>("SnNum",string.Empty); CustomerProvider provider = new CustomerProvider(); CusAddressEntity entity= new CusAddressEntity(); entity = provider.GetSingleAddress(snNum); if (entity.IsNotNull()) { StringBuilder sb = new StringBuilder(); List<CusAddressEntity> listResult = new List<CusAddressEntity>(); listResult.Add(entity); string json = ConvertJson.ListToJson(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); } return Content(this.ReturnJson.ToString()); }
public ActionResult Delete(string cusNum) { CustomerProvider provider = new CustomerProvider(); int line = provider.Delete(cusNum); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } else { this.ReturnJson.AddProperty("d", ""); } return Content(this.ReturnJson.ToString()); }
public ActionResult DelCusAddress(string cusNum, string snNum) { List<CusAddressEntity> list = Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] as List<CusAddressEntity>; list = list == null ? new List<CusAddressEntity>() : list; if (list.Exists(a => a.SnNum == snNum)) { list.Remove(a=>a.SnNum==snNum); CustomerProvider provider = new CustomerProvider(); provider.DelCusAddress(snNum, cusNum); } Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] = list; this.ReturnJson.AddProperty("d", "success"); return Content(this.ReturnJson.ToString()); }
public ActionResult Auto(string cusName) { CustomerProvider provider = new CustomerProvider(); List<CustomerEntity> list = provider.GetList(); if (!list.IsNullOrEmpty() && !cusName.IsEmpty()) { list = list.Where(a => a.CusNum.Contains(cusName) || a.CusName.Contains(cusName)).ToList(); } list = list.IsNull() ? new List<CustomerEntity>() : list; StringBuilder sb = new StringBuilder(); JsonObject jsonObject = null; foreach (CustomerEntity t in list) { jsonObject = new JsonObject(); jsonObject.AddProperty("CusNum", t.CusNum); jsonObject.AddProperty("CusName", t.CusName); //jsonObject.AddProperty("Phone", t.Phone); sb.Append(jsonObject.ToString() + "\n"); } if (sb.Length == 0) { sb.Append("\n"); } return Content(sb.ToString()); }