public JsonResult AjaxBatchPublish() { List <int> sysnoList = SerializationUtility.JsonDeserialize2 <List <int> >(Request.Params["sysNoList"]); var batchResult = GiftPromotionService.BatchSubmitAudit(sysnoList, UserAuthHelper.GetCurrentUser().UserDisplayName); return(Json(new { successCount = batchResult.Item1, failCount = batchResult.Item2, resultMsg = batchResult.Item3 })); }
public ActionResult AjaxSaveProductStockAdjustmentInfo() { if (!string.IsNullOrEmpty(Request["info"])) { ProductStockAdjustInfo adjustInfo = SerializationUtility.JsonDeserialize2 <ProductStockAdjustInfo>(Request["info"]); if (null != adjustInfo) { if (!adjustInfo.SysNo.HasValue) { adjustInfo.Status = ProductStockAdjustStatus.Origin; } else { foreach (var item in adjustInfo.AdjustItemList) { item.InUserSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo; } } adjustInfo.CurrencyCode = 1; adjustInfo.VendorSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo; adjustInfo.InUserSysNo = adjustInfo.EditUserSysNo = adjustInfo.AuditUserSysNo = UserAuthHelper.GetCurrentUser().UserSysNo; adjustInfo.InDate = adjustInfo.EditDate = adjustInfo.AuditDate = DateTime.Now; } ProductPurchaseService.SaveProductStockAdjustmentInfo(adjustInfo); } return(Json(new { Data = true })); }
public ActionResult AjaxAddTemplate() { var storePage = SerializationUtility.JsonDeserialize2 <StorePage>(Request.Form["data"]); var pageLayouts = StoreService.QueryAllPageLayout(); var pageTemplateKey = storePage.StorePageTemplate.Key; var Temp = StoreService.QueryStorePageTemplateByTemplateKey(pageTemplateKey); storePage.StorePageTemplate.PageTemplateType = Temp.PageTemplateType; storePage.StorePageTemplate.DataValue = Temp.DataValue; storePage.StorePageTemplate.PageTypeKey = Temp.PageTypeKey.Trim(); storePage.StorePageTemplate.Name = Temp.Name; storePage.StorePageTemplate.Desc = Temp.Desc; storePage.StorePageTemplate.TemplateViewPath = Temp.TemplateViewPath; storePage.StorePageTemplate.MockupUrl = Temp.MockupUrl; storePage.StorePageTemplate.Status = Temp.Status; storePage.StorePageTemplate.Memo = Temp.Memo; storePage.StorePageTemplate.Priority = Temp.Priority; foreach (var storePageLayout in pageLayouts) { if (pageTemplateKey.Contains(storePageLayout.PageLayoutKey)) { storePage.StorePageTemplate.StorePageLayouts.Add(storePageLayout); } } return(Json(storePage)); }
protected T GetParams <T>() { var str = GetParams(); var obj = new JavaScriptSerializer().Deserialize <T>(str); return(SerializationUtility.JsonDeserialize2 <T>(str)); }
protected T BuildQueryFilterEntity <T>(Action <T> manualMapping) where T : class { object t = Activator.CreateInstance(typeof(T)); if (!string.IsNullOrEmpty(this.Request["queryfilter[]"])) { t = SerializationUtility.JsonDeserialize2 <T>(this.Request["queryfilter[]"]); } if (t is QueryFilter) { //每页显示条数: int pageSize = Convert.ToInt32(Request["length"]); //当前页码: int pageIndex = Convert.ToInt32(Request["start"]) % pageSize == 0 ? Convert.ToInt32(Request["start"]) / pageSize : Convert.ToInt32(Request["start"]) / pageSize + 1; //排序: string sortBy = null; if (!string.IsNullOrEmpty(Request["order[0][column]"])) { string colIndex = Request["order[0][column]"]; string sortByField = string.IsNullOrEmpty(Request[string.Format("columns[{0}][name]", colIndex)]) ? Request[string.Format("columns[{0}][data]", colIndex)] : Request[string.Format("columns[{0}][name]", colIndex)]; string sortDir = Request["order[0][dir]"]; sortBy = string.Format("{0} {1}", sortByField, sortDir.ToUpper()); } ((QueryFilter)t).PageSize = pageSize; ((QueryFilter)t).PageIndex = pageIndex; ((QueryFilter)t).SortFields = sortBy; } if (manualMapping != null) { manualMapping((T)t); } return((T)t); }
public JsonResult AjaxGetProductSalesAreaInfo() { var queryFilter = SerializationUtility.JsonDeserialize2 <ProductQueryFilter>(this.Request["queryfilter[]"]); var data = ProductMaintainService.GetProductSalesAreaInfoBySysNo(queryFilter); return(AjaxGridJson(data)); }
public ActionResult AjaxMaintainUpdate() { var soUpdateInfo = SerializationUtility.JsonDeserialize2 <SOUpdateInfo>(Request.Form["data"]); SOService.SOUpdate(soUpdateInfo); return(new JsonResult()); }
public ActionResult AjaxSOVoid() { SOIncomeRefundInfo refundInfo = SerializationUtility.JsonDeserialize2 <SOIncomeRefundInfo>(Request.Form["data"]); LoginUser user = EntityConverter <UserAuthVM, LoginUser> .Convert(UserAuthHelper.GetCurrentUser()); SOService.VoidSO(refundInfo.SOSysNo.Value, refundInfo, loginUser: user); return(new JsonResult()); }
public ActionResult AjaxSOOutStock() { SOOutStockWaitReportRequest outStockWaitReportRequest = SerializationUtility.JsonDeserialize2 <SOOutStockWaitReportRequest>(Request.Form["data"]); LoginUser user = EntityConverter <UserAuthVM, LoginUser> .Convert(UserAuthHelper.GetCurrentUser()); outStockWaitReportRequest.User = user; SOService.OutStockWaitReport(outStockWaitReportRequest); return(new JsonResult()); }
public ActionResult AjaxAddNewPurchaseOrderItem() { if (string.IsNullOrWhiteSpace(Request["Data"])) { throw new BusinessException("采购商品信息为空"); } PurchaseOrderItemProductInfo product = SerializationUtility.JsonDeserialize2 <PurchaseOrderItemProductInfo>(Request["Data"]); PurchaseOrderItemInfo orderItemInfo = ProductPurchaseService.AddNewPurchaseOrderItem(product, UserAuthHelper.GetCurrentUser().SellerSysNo); return(Json(orderItemInfo)); }
public ActionResult AjaxAbandonPurchaseOrder() { if (string.IsNullOrWhiteSpace(Request["Data"])) { throw new BusinessException("采购单信息为空"); } PurchaseOrderInfo poInfo = SerializationUtility.JsonDeserialize2 <PurchaseOrderInfo>(Request["Data"]); SetUserInfo(poInfo); poInfo = ProductPurchaseService.AbandonPO(poInfo); return(Json(poInfo)); }
public T DecryptCookie <T>(string cookieValue, Dictionary <string, string> parameters) { T result = default(T); string strEncCookieValue = string.Empty; string strContent = string.Empty; string strSHA1Sign = string.Empty; string strShA1Temp = string.Empty; string[] arrayCookieValue = new string[2]; try { if (cookieValue.Length < 40) { return(result); } // 取出签名和密文 strSHA1Sign = cookieValue.Substring(0, 40); strEncCookieValue = cookieValue.Substring(40); // 签名校验 strShA1Temp = HashEncrypt.SHA1Encrypt(HttpUtility.UrlDecode(strEncCookieValue).Trim() + parameters["hashkey"]); if (strSHA1Sign != strShA1Temp) { return(result); } strEncCookieValue = HttpUtility.UrlDecode(strEncCookieValue); // 还原成明文 strContent = RC4Encrypt.Decrypt(strEncCookieValue, parameters["rc4key"], RC4Encrypt.EncoderMode.HexEncoder); if (strContent.Length == 0) { return(result); } arrayCookieValue = SerializationUtility.JsonDeserialize2 <string[]>(strContent); if (arrayCookieValue != null && arrayCookieValue.Length == 3) { if (DateTime.Parse(arrayCookieValue[1]) > DateTime.Now && GetClientIP() == arrayCookieValue[2]) { result = SerializationUtility.JsonDeserialize2 <T>(arrayCookieValue[0]); //Cookie有效,则继续延续有效期 CookieHelper.SaveCookie <T>(parameters["nodeName"], result); } } return(result); } catch { return(result); } }
public ActionResult AjaxAppForCertification() { var request = Request.Form["data"]; var data = SerializationUtility.JsonDeserialize2 <CertificationInfo>(Request.Form["data"]); data.SellerName = CurrUser.SellerName; data.SellerSysNo = CurrUser.SellerSysNo; data.UserID = CurrUser.UserID; data.Status = "I"; data.UserDisplayName = CurrUser.UserDisplayName; StoreService.SaveCertification(data); return(Json(new { Success = true, Message = LanguageHelper.GetText("操作成功") })); }
public static ShoppingCart GetShoppingCartByCustomer(int userSysNo) { ShoppingCart shoppingCart = GetShoppingCartFromCookieOrCreateNew(); if (shoppingCart == null) { shoppingCart = new ShoppingCart(); } string key = CookieHelper.GetCookie <string>(MY_SHOPPINGCART_SIGN_KEY); if (String.IsNullOrEmpty(key)) { key = Guid.NewGuid().ToString("N"); CookieHelper.SaveCookie <string>(MY_SHOPPINGCART_SIGN_KEY, key); } shoppingCart.ShoppingCartID = key; if (userSysNo > 0) { //获取数据库最新数据购物车 ShoppingCartPersistent shoppingCartPersistent = ShoppingPersistentDA.GetShoppingCartByCustomer(userSysNo); ShoppingCart newShoppingCart = new ShoppingCart(); if (shoppingCartPersistent != null && !string.IsNullOrEmpty(shoppingCartPersistent.ShoppingCart)) { newShoppingCart = SerializationUtility.JsonDeserialize2 <ShoppingCart>(shoppingCartPersistent.ShoppingCart); } //判断购物车是否发生变化 if (newShoppingCart.ShoppingCartID != shoppingCart.ShoppingCartID) { newShoppingCart.ShoppingCartID = shoppingCart.ShoppingCartID; //合并购物车 MergeShoppingCart(shoppingCart, newShoppingCart); } //写入DB ShoppingPersistentDA.SaveShoppingCart(new ShoppingCartPersistent() { CustomerSysNo = userSysNo, ShoppingCart = SerializationUtility.JsonSerialize2(shoppingCart), ShoppingCartMini = "" }); } else { shoppingCart = GetShoppingCartFromCookie(); } //写入Cookie CookieHelper.SaveCookie <ShoppingCart>(MY_SHOPPINGCART_COOKIE_NAME, shoppingCart); return(shoppingCart); }
public static StorePage QueryStorePageByPageName(string pageName, int sellerSysNo) { var page = StoreDA.QueryStorePageByPageName(pageName, sellerSysNo); if (page != null) { var value = page.DataValue; if (!string.IsNullOrEmpty(value)) { var result = SerializationUtility.JsonDeserialize2 <StorePage>(value); result.SysNo = page.SysNo; return(result); } } return(null); }
public ActionResult AjaxSaveBasicInfo() { var info = SerializationUtility.JsonDeserialize2 <StoreBasicInfo>(Request.Form["data"]); info.Status = 1; info.SellerSysNo = CurrUser.SellerSysNo; info.InUserSysNo = CurrUser.UserSysNo; info.InUserName = CurrUser.UserDisplayName; info.EditDate = DateTime.Now; info.EditUserName = CurrUser.UserDisplayName; info.EditUserSysNo = CurrUser.UserSysNo; StoreService.SaveStoreBasicInfo(info); var result = new { Success = true, Message = LanguageHelper.GetText("保存成功") }; return(Json(result)); }
public ActionResult AjaxSavePurchaseOrder() { if (string.IsNullOrWhiteSpace(Request["Data"])) { throw new BusinessException("采购单信息为空"); } PurchaseOrderInfo poInfo = SerializationUtility.JsonDeserialize2 <PurchaseOrderInfo>(Request["Data"]); SetUserInfo(poInfo); poInfo.VendorInfo = new VendorBasicInfo() { VendorID = UserAuthHelper.GetCurrentUser().SellerSysNo.ToString() }; poInfo = ProductPurchaseService.CreatePO(poInfo); return(Json(poInfo)); }
public ActionResult AjaxSavePageHeader() { var data = SerializationUtility.JsonDeserialize2 <StorePageHeader>(Request.Form["data"]); data.SellerSysNo = CurrUser.SellerSysNo; data.EditDate = DateTime.Now; data.EditUserName = CurrUser.UserDisplayName; data.EditUserSysNo = CurrUser.UserSysNo; if (!data.SysNo.HasValue) { data.InDate = data.EditDate; data.InUserName = data.EditUserName; data.InUserSysNo = data.EditUserSysNo; } StoreService.SavePageHeader(data); return(Json(new { Success = true, Message = LanguageHelper.GetText("操作成功") })); }
public JsonResult SaveGiftPromotion() { var result = 0; if (!string.IsNullOrEmpty(Request["giftInfo"])) { SalesGiftInfo giftInfo = SerializationUtility.JsonDeserialize2 <SalesGiftInfo>(Request["giftInfo"]); if (null != giftInfo) { giftInfo.SellerSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo; giftInfo.InUserSysNo = UserAuthHelper.GetCurrentUser().UserSysNo; giftInfo.InUserName = UserAuthHelper.GetCurrentUser().UserDisplayName; giftInfo.EditUserSysNo = UserAuthHelper.GetCurrentUser().UserSysNo; giftInfo.EditUser = giftInfo.EditUserName = UserAuthHelper.GetCurrentUser().UserDisplayName; } result = GiftPromotionService.SaveGiftPromotionInfo(giftInfo, UserAuthHelper.GetCurrentUser().UserDisplayName); } return(Json(new { Data = result })); }
/// <summary> /// 查询区域 /// </summary> /// <returns></returns> public ActionResult QueryArea() { var queryFilter = SerializationUtility.JsonDeserialize2 <AreaInfoQueryFilter>(this.Request["queryfilter[]"]); switch (queryFilter.ProvinceSysNo) { case "-1": queryFilter.ProvinceSysNo = null; break; case "-2": queryFilter.ProvinceSysNo = ConstValue.regionHuadong; break; case "-3": queryFilter.ProvinceSysNo = ConstValue.regionHuanan; break; case "-4": queryFilter.ProvinceSysNo = ConstValue.regionHuabei; break; case "-5": queryFilter.ProvinceSysNo = ConstValue.regionHuazhong; break; case "-6": queryFilter.ProvinceSysNo = ConstValue.regionXinan; break; case "-7": queryFilter.ProvinceSysNo = ConstValue.regionXibei; break; case "-8": queryFilter.ProvinceSysNo = ConstValue.regionDongbei; break; } var data = CommonService.QueryArea(queryFilter); return(AjaxGridJson(data)); }
public ActionResult FinancialReportDataText() { SalesStatisticsReportQueryFilter filter = SerializationUtility.JsonDeserialize2 <SalesStatisticsReportQueryFilter>(Request.Form["data"]); filter.C1SysNo = filter.Category.C1SysNo == 0 ? null : filter.Category.C1SysNo; filter.C2SysNo = filter.Category.C2SysNo == 0 ? null : filter.Category.C2SysNo; filter.C3SysNo = filter.Category.C3SysNo == 0 ? null : filter.Category.C3SysNo; filter.SortFields = "B.ProductID DESC"; int MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo; filter.VendorSysNoList = new List <int>(); filter.VendorSysNoList.Add(MerchantSysNo); filter.SOStatusList = new List <int>(); if (filter.SOStatus.HasValue) { filter.SOStatusList.Add(filter.SOStatus.Value); } var result = FinancialReportService.SalesStatisticsReportQuery(filter); string text = ""; if (result.SalesStatisticsResult.ResultList != null && result.SalesStatisticsResult.ResultList.Count > 0) { string page = string.Format("{0}: --- 销售成本:{1} 销售金额:{2} 优惠金额:{3} 实际销售金额:{4} 商品毛利:{5}", "本页小计", result.CostReportStatisticList[0].ProductCost, result.CostReportStatisticList[0].ProductPriceAmount, result.CostReportStatisticList[0].PromotionDiscountAmount, result.CostReportStatisticList[0].ProductSaleAmount, result.CostReportStatisticList[0].ProductGrossMargin); string Total = string.Format("{0}: --- 销售成本:{1} 销售金额:{2} 优惠金额:{3} 实际销售金额:{4} 商品毛利:{5}", "全部总计", result.CostReportStatisticList[1].ProductCost, result.CostReportStatisticList[1].ProductPriceAmount, result.CostReportStatisticList[1].PromotionDiscountAmount, result.CostReportStatisticList[1].ProductSaleAmount, result.CostReportStatisticList[1].ProductGrossMargin); text = "<div class='col-md-12' style='color:red;'>" + page + "</div><div class='col-md-12' style='color:red;'>" + Total + "</div>"; } return(Content(text)); }
public ActionResult FreeShippingChargeRuleSave() { FreeShippingChargeRuleInfo info = SerializationUtility.JsonDeserialize2 <FreeShippingChargeRuleInfo>(Request.Form["data"]); var loginUser = UserAuthHelper.GetCurrentUser(); info.SellerSysNo = loginUser.SellerSysNo; info.InUserSysNo = loginUser.UserSysNo; info.InUserName = loginUser.UserDisplayName; info.EditUserSysNo = loginUser.UserSysNo; info.EditUserName = loginUser.UserDisplayName; if (info.SysNo > 0) { FreeShippingChargeRuleService.Update(info); return(JsonSuccess(info.SysNo.Value, LanguageHelper.GetText("更新成功。"))); } else { FreeShippingChargeRuleService.Create(info); return(JsonSuccess(info.SysNo.Value, LanguageHelper.GetText("创建成功。"))); } }
public T DecryptCookie <T>(string cookieValue, Dictionary <string, string> parameters) { T result = default(T); string strEncCookieValue = string.Empty; string strContent = string.Empty; string strSHA1Sign = string.Empty; string strShA1Temp = string.Empty; try { if (cookieValue.Length < 40) { return(result); } // 取出签名和密文 strSHA1Sign = cookieValue.Substring(0, 40); strEncCookieValue = cookieValue.Substring(40); // 签名校验 strShA1Temp = HashEncrypt.SHA1Encrypt(HttpUtility.UrlDecode(strEncCookieValue).Trim() + parameters["hashkey"]); if (strSHA1Sign != strShA1Temp) { return(result); } strEncCookieValue = HttpUtility.UrlDecode(strEncCookieValue); // 还原成明文 strContent = RC4Encrypt.Decrypt(strEncCookieValue, parameters["rc4key"], RC4Encrypt.EncoderMode.HexEncoder); if (strContent.Length == 0) { return(result); } result = SerializationUtility.JsonDeserialize2 <T>(strContent); return(result); } catch { return(result); } }
public ActionResult AjaxSaveAttachment() { var data = SerializationUtility.JsonDeserialize2 <List <StoreAttachment> >(Request.Form["data"]); data.ForEach(p => { p.SellerSysNo = CurrUser.SellerSysNo; p.EditDate = DateTime.Now; p.EditUserName = CurrUser.UserDisplayName; p.EditUserSysNo = CurrUser.UserSysNo; p.Status = 1; if (!p.SysNo.HasValue) { p.InUserName = CurrUser.UserDisplayName; p.InUserSysNo = CurrUser.UserSysNo; } }); StoreService.SaveStoreAttachment(data); return(Json(new { Success = true, Message = LanguageHelper.GetText("操作成功"), Data = StoreService.QueryStoreAttachment(CurrUser.SellerSysNo) })); }
public ActionResult AjaxSOOpreate() { var soSysNos = SerializationUtility.JsonDeserialize2 <int[]>(Request.Form["data"]); var opreateName = Request.Form["opreateName"]; switch (opreateName) { case "AuditAccept": SOService.AuditAccept(soSysNos); break; case "BatchVoid": LoginUser user = EntityConverter <UserAuthVM, LoginUser> .Convert(UserAuthHelper.GetCurrentUser()); SOService.BatchVoidSO(soSysNos, user: user); break; case "BatchOutStock": SOService.BatchOutStock(soSysNos); break; case "BatcReported": SOService.BatcReported(soSysNos); break; case "BatchCustomsPass": SOService.BatchCustomsPass(soSysNos); break; case "BatchUpdateToPaid": SOService.BatcUpdateToPaid(soSysNos); break; default: throw new BusinessException(LanguageHelper.GetText("无效的操作类型")); } return(new JsonResult()); }
public ActionResult AjaxSaveStorePage() { var data = SerializationUtility.JsonDeserialize2 <StorePage>(Request.Form["data"]); data.SellerSysNo = CurrUser.SellerSysNo; data.EditDate = DateTime.Now; data.EditUserName = CurrUser.UserDisplayName; data.EditUserSysNo = CurrUser.UserSysNo; data.InUserSysNo = CurrUser.UserSysNo; data.InDate = DateTime.Now; data.InUserName = CurrUser.UserDisplayName; var flag = Request.Form["flag"]; if (flag.Equals("save")) { if (!data.Status.HasValue) { data.Status = 1; } data.DataValue = SerializationUtility.JsonSerialize2(data); StoreService.SaveStorePage(data); } else if (flag.Equals("audit")) { data.Status = 2;//待审核 审核通过Status=3 data.DataValue = SerializationUtility.JsonSerialize2(data); StoreService.SaveStorePage(data); } else { data.Status = 1; data.DataValue = SerializationUtility.JsonSerialize2(data); StoreService.PublishStorePage(data); } return(Json(new { Success = true, Message = LanguageHelper.GetText("操作成功") })); }
public ActionResult AjaxSaveExcel() { var data = SerializationUtility.JsonDeserialize2 <List <ExcelInfo> >(Request.Form["data"]); if (!string.IsNullOrEmpty(data[0].Url)) { System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex("."); System.Text.RegularExpressions.Match m = r.Match(data[0].Url); if (m.Success) { string suffix = data[0].Url.Substring(data[0].Url.LastIndexOf(".") + 1); if (suffix != "xls" && suffix != "xlsx" && suffix != "xlsm") { throw new BusinessException(LanguageHelper.GetText("只能导入Excel格式,请参考模板!!!")); } } } string Url = System.Web.HttpContext.Current.Server.MapPath(string.Format("~/UploadFiles/{0}", data[0].Url)); DataTable dt = FileSvr.GetExcelDatatable(Url, data[0].Name); if (dt.Rows.Count > 0) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("<SOTrackingInfos>"); string UserID = UserAuthHelper.GetCurrentUser().UserID; int SellerSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo; int[] soSysNos = new int[dt.Rows.Count]; ArrayList TrackingNumbers = new ArrayList(); int i = 0; foreach (DataRow dr in dt.Rows) { SOOutStockWaitReportRequest outStockWaitReportRequest = new Entity.SO.SOOutStockWaitReportRequest(); outStockWaitReportRequest.Logistics = new LogisticsInfo(); //如果订单号为空,SOSysNo=0 if (!string.IsNullOrEmpty(dr[0].ToString())) { try { outStockWaitReportRequest.SOSysNo = int.Parse(dr[0].ToString()); } catch (Exception ex) { throw new BusinessException(LanguageHelper.GetText("订单号只能是正整数")); } } else { outStockWaitReportRequest.SOSysNo = 0; } outStockWaitReportRequest.Logistics.TrackingNumber = string.IsNullOrEmpty(dr[1].ToString()) ? "" : dr[1].ToString(); soSysNos.SetValue(outStockWaitReportRequest.SOSysNo, i++); TrackingNumbers.Add(outStockWaitReportRequest.Logistics.TrackingNumber); stringBuilder.Append("<SOTrackingInfo><SONumber>" + outStockWaitReportRequest.SOSysNo + "</SONumber><TrackingNumber>" + outStockWaitReportRequest.Logistics.TrackingNumber + "</TrackingNumber></SOTrackingInfo>"); } stringBuilder.Append("</SOTrackingInfos>"); SOService.CreatMoreSOSysNoAndTrackingNumber(stringBuilder.ToString(), UserID, SellerSysNo, soSysNos, TrackingNumbers); return(Json(new { Success = true, Message = LanguageHelper.GetText("操作成功") })); } else { return(Json(new { Error = true, Message = LanguageHelper.GetText("Excel没有数据") })); } }
public ActionResult Save() { string json = Request["data"]; if (string.IsNullOrWhiteSpace(json)) { throw new BusinessException("传入数据不能为空"); } Company entity = SerializationUtility.JsonDeserialize2 <Company>(json); SetEntityBaseUserInfo(entity); entity.CompanyStatus = CompanyStatus.Init; if (string.IsNullOrEmpty(entity.Name)) { throw new BusinessException("请输入客户名称"); } SystemUser customer = new SystemUser(); //if (!string.IsNullOrEmpty(entity.ContactCellPhone)) //{ if (string.IsNullOrEmpty(entity.ContactName)) { throw new BusinessException("请输入联系人姓名"); } if (string.IsNullOrEmpty(entity.ContactCellPhone)) { throw new BusinessException("请输入联系人手机号"); } if (!WebPortalHelper.IsPhonenum(entity.ContactCellPhone)) { throw new BusinessException("请输入正确的手机号!"); } customer = SystemUserService.LoadSystemUserByLoginNameAndCellPhone(entity.ContactCellPhone, ConstValue.ApplicationID); // } Company company = CompanyService.LoadCompanyByName(entity.Name); if (entity.SysNo > 0) { Company curentcompany = CompanyService.LoadCompany(entity.SysNo, false); if (curentcompany == null) { throw new BusinessException("未找到此公司的相关信息"); } if (company != null && company.SysNo != curentcompany.SysNo) { throw new BusinessException("系统中已存在当前客户,请重新输入客户名称!"); } if (customer != null && customer.SysNo > 0 && ((!string.IsNullOrEmpty(entity.ContactCellPhone) && !string.Equals(customer.CellPhone, entity.ContactCellPhone)) || (entity.SysNo != customer.MasterSysNo))) { throw new BusinessException("系统中已存在此手机号,请更换手机号重试!"); } using (ITransaction it = TransactionManager.Create()) { //if (!string.IsNullOrEmpty(entity.ContactCellPhone)) //{ // if (customer == null || !string.Equals(entity.ContactCellPhone, customer.CellPhone)) // { // customer = new SystemUser(); // customer.MasterSysNo = entity.SysNo; // customer.LoginName = customer.CellPhone = entity.ContactCellPhone; // customer.LoginPassword = AuthMgr.EncryptPassword(entity.ContactCellPhone); // customer.UserFullName = entity.ContactName; // customer.CommonStatus = CommonStatus.Actived; // SetEntityBaseUserInfo(customer); // var usersysno = user_service.InsertSystemUser(customer); // if (usersysno > 0) // { // if (rolesysno != 0) // { // List<Role> roles = new List<Role> { new Role { SysNo = rolesysno } }; // usersrole.SaveUsersRole(usersysno, roles, ConstValue.ApplicationID); // } // } // } //} entity.CompanyStatus = curentcompany.CompanyStatus; entity.AccountSysNo = curentcompany.AccountSysNo; if (curentcompany.CompanyStatus == CompanyStatus.Invalid) { entity.CompanyStatus = CompanyStatus.Init; } CompanyService.UpdateCompany(entity); it.Complete(); } } else { if (company != null) { throw new BusinessException("系统中已存在当前客户,请重新输入客户名称!"); } if (customer != null && customer.SysNo > 0) { throw new BusinessException("系统中已存在此手机号,请更换手机号重试!"); } if (!string.IsNullOrEmpty(entity.ContactCellPhone)) { customer = new SystemUser(); customer.LoginName = entity.LoginName; customer.CellPhone = ""; customer.LoginPassword = AuthMgr.EncryptPassword(entity.LoginName); customer.UserFullName = entity.ContactName; customer.CommonStatus = CommonStatus.Actived; SetEntityBaseUserInfo(customer); } using (ITransaction it = TransactionManager.Create()) { entity.SysNo = CompanyService.InsertCompany(entity); customer.MasterSysNo = entity.SysNo; if (!string.IsNullOrEmpty(entity.ContactCellPhone)) { var usersysno = user_service.InsertSystemUser(customer); if (usersysno > 0) { entity.AccountSysNo = usersysno; CompanyService.UpdateCompany(entity); if (rolesysno != 0) { List <Role> roles = new List <Role> { new Role { SysNo = rolesysno } }; usersrole.SaveUsersRole(usersysno, roles, ConstValue.ApplicationID); } } } it.Complete(); } } return(Json(new AjaxResult { Success = true, Message = "保存成功", Data = entity.SysNo }, JsonRequestBehavior.AllowGet)); }
public T DecryptCookie <T>(string cookieValue, Dictionary <string, string> parameters) { return(SerializationUtility.JsonDeserialize2 <T>(cookieValue)); }
public FileResult AjaxFinancialExportData(string queryString) { //每页显示条数: SalesStatisticsReportQueryFilter getQueryEntity = SerializationUtility.JsonDeserialize2 <SalesStatisticsReportQueryFilter>(queryString); getQueryEntity.C1SysNo = getQueryEntity.Category.C1SysNo == 0 ? null : getQueryEntity.Category.C1SysNo; getQueryEntity.C2SysNo = getQueryEntity.Category.C2SysNo == 0 ? null : getQueryEntity.Category.C2SysNo; getQueryEntity.C3SysNo = getQueryEntity.Category.C3SysNo == 0 ? null : getQueryEntity.Category.C3SysNo; getQueryEntity.SortFields = "B.ProductID DESC"; int MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo; getQueryEntity.VendorSysNoList = new List <int>(); getQueryEntity.VendorSysNoList.Add(MerchantSysNo); getQueryEntity.SOStatusList = new List <int>(); if (getQueryEntity.SOStatus.HasValue) { getQueryEntity.SOStatusList.Add(getQueryEntity.SOStatus.Value); } getQueryEntity.PageSize = 10000000; getQueryEntity.PageIndex = 0; SalesStatisticsReport result = FinancialReportService.SalesStatisticsReportQuery(getQueryEntity); List <DataTable> dataTableList = new List <DataTable>(); if (result.SalesStatisticsResult.ResultList.Count <= 0) { throw new BusinessException("无数据可导出!!!"); } DataTable newDt = ToDataTableTow(result.SalesStatisticsResult.ResultList); dataTableList.Add(newDt); List <ColumnData> columndatalist = new List <ColumnData>(); ColumnData columndata = null; columndata = new ColumnData() { FieldName = "ProductID", Width = 20, Title = "商品ID" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "ProductName", Width = 30, Title = "商品名称" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "C1Name", Width = 15, Title = "一级分类" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "C2Name", Width = 15, Title = "二级分类" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "C3Name", Width = 15, Title = "三级分类", ValueFormat = "" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "BeginDate", Width = 20, Title = "开始时间" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "EndDate", Width = 20, Title = "结束时间" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "BrandName", Width = 20, Title = "品牌" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "VendorName", Width = 20, Title = "供应商" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "StockName", Width = 20, Title = "仓库" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "BMCode", Width = 20, Title = "BM编号" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "ProductProperty1", Width = 20, Title = "属性1" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "ProductProperty2", Width = 20, Title = "属性2" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "Quantity", Width = 20, Title = "数量" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "ProductCost", Width = 20, Title = "销售成本" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "ProductPriceAmount", Width = 20, Title = "销售金额" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "PromotionDiscountAmount", Width = 20, Title = "优惠金额" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "ProductSaleAmount", Width = 20, Title = "实际销售金额" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "PayTypeName", Width = 20, Title = "支付方式" }; columndatalist.Add(columndata); columndata = new ColumnData() { FieldName = "ProductGrossMargin", Width = 20, Title = "商品毛利" }; columndatalist.Add(columndata); List <List <ColumnData> > columnList = new List <List <ColumnData> >(); columnList.Add(columndatalist); //步骤5:调用生成Excel的公共方法,返回 /*例如: * IFileExport excelExport = new ExcelFileExporter(); * byte[] excelByte = excelExport.CreateFile(dataTableList, columnList, null, out fileName, "测试导出Excel"); * return File(new MemoryStream(excelByte), "application/ms-excel", fileName); */ string fileName = ""; IFileExport excelExport = new ExcelFileExporter(); byte[] excelByte = excelExport.CreateFile(dataTableList, columnList, null, out fileName, "销售统计报表"); return(File(new MemoryStream(excelByte), "application/ms-excel", fileName)); }