public ActionResult Edit(NoStockType obj) { try { NSession.Update(obj); NSession.Flush(); List <NoStockLinkType> list1 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <NoStockLinkType> >(obj.rowse); NSession.Delete("from NoStockLinkType where PId='" + obj.Id + "'"); NSession.Flush(); NSession.Clear(); foreach (NoStockLinkType link in list1) { link.OldSKU = obj.OldSKU; link.SKU = obj.SKU; link.PId = obj.Id; link.CreateBy = CurrentUser.Realname; link.CreateOn = DateTime.Now; NSession.Save(link); NSession.Flush(); } } catch (Exception ee) { return(Json(new { errorMsg = "出错了" })); } return(Json(new { IsSuccess = "true" })); }
public JsonResult Create(NoStockType obj) { try { obj.Enabled = 1; obj.CreateBy = CurrentUser.Realname; obj.CreateOn = DateTime.Now; NSession.SaveOrUpdate(obj); NSession.Flush(); List <NoStockLinkType> list1 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <NoStockLinkType> >(obj.rows); foreach (NoStockLinkType link in list1) { link.OldSKU = obj.OldSKU; link.SKU = obj.SKU; link.PId = obj.Id; link.CreateBy = CurrentUser.Realname; link.CreateOn = DateTime.Now; NSession.Save(link); NSession.Flush(); } } catch (Exception ee) { return(Json(new { errorMsg = "出错了" })); } return(Json(new { IsSuccess = "true" })); }
public ActionResult SetSKUCode2(int code) { IList <SKUCodeType> list = NSession.CreateQuery("from SKUCodeType where Code=:p").SetInt32("p", code).SetMaxResults(1).List <SKUCodeType>(); if (list.Count > 0) { SKUCodeType sku = list[0]; if (sku.IsOut == 1 || sku.IsSend == 1) { return(Json(new { IsSuccess = false, Result = "条码:" + code + " 已经配过货,SKU:" + sku.SKU + " 出库时间:" + sku.PeiOn + ",出库订单:" + sku.OrderNo + " ,请将此产品单独挑出来!" })); } if (sku.IsScan == 1) { return(Json(new { IsSuccess = false, Result = "条码:" + code + " 已经清点扫描了,SKU:" + sku.SKU + " 刚刚已经扫描过了。你查看下是条码重复扫描了,还是有贴重复的了!" })); } sku.IsScan = 1; NSession.Save(sku); NSession.Flush(); object obj = NSession.CreateQuery("select count(Id) from SKUCodeType where SKU=:p and IsScan=1 and IsOut=0").SetString("p", sku.SKU). UniqueResult(); return(Json(new { IsSuccess = true, Result = "条码:" + code + " 的信息.SKU:" + sku.SKU + " 此条码未出库。条码正确!!!", ccc = sku.SKU + "已经扫描了" + obj + "个" })); } else { return(Json(new { IsSuccess = false, Result = "条码:" + code + " 无法找到 ,请查看扫描是否正确!" })); } }
public ActionResult ImportPlan(string fileName) { DataTable dt = OrderHelper.GetDataTable(fileName); IList <WarehouseType> list = NSession.CreateQuery(" from WarehouseType").List <WarehouseType>(); for (int i = 0; i < dt.Rows.Count; i++) { PurchasePlanType p = new PurchasePlanType { CreateOn = DateTime.Now, BuyOn = DateTime.Now, ReceiveOn = DateTime.Now, SendOn = DateTime.Now }; p.PlanNo = Utilities.GetPlanNo(NSession); p.SKU = dt.Rows[i]["SKU"].ToString(); p.Price = Convert.ToDouble(dt.Rows[i]["单价"].ToString()); p.Qty = Convert.ToInt32(dt.Rows[i]["Qty"].ToString()); p.DaoQty = 0; p.ProductName = ""; p.Freight = Convert.ToDouble(dt.Rows[i]["运费"].ToString()); p.ProductUrl = dt.Rows[i]["产品链接"].ToString(); p.PicUrl = dt.Rows[i]["图片链接"].ToString(); p.Suppliers = dt.Rows[i]["供应商"].ToString(); p.LogisticsMode = dt.Rows[i]["发货方式"].ToString(); p.TrackCode = dt.Rows[i]["追踪码"].ToString(); p.Status = dt.Rows[i]["状态"].ToString(); p.Memo = dt.Rows[i]["备注"].ToString(); NSession.Save(p); NSession.Flush(); } return(Json(new { IsSuccess = true })); }
public JsonResult Create(MachineType obj) { try { if (obj.StartDate < Convert.ToDateTime("2000-01-01")) { obj.StartDate = Convert.ToDateTime("2000-01-01"); } if (obj.EndDate < Convert.ToDateTime("2000-01-01")) { obj.EndDate = Convert.ToDateTime("2000-01-01"); } if (obj.BuyDate < Convert.ToDateTime("2000-01-01")) { obj.BuyDate = Convert.ToDateTime("2000-01-01"); } if (IsCreateOk(obj.Code)) { return(Json(new { errorMsg = "编号已经存在" })); } NSession.Save(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult Create(EbayMessageReType obj) { try { EbayMessageType ebaymessage = ebay.GetById(obj.MessageId); obj.ItemId = ebaymessage.ItemId; obj.EbayId = ebaymessage.MessageId; obj.ReplayBy = CurrentUser.Realname; obj.SenderEmail = ebaymessage.SenderEmail; obj.SenderID = ebaymessage.SenderID; obj.Account = ebaymessage.Shop; obj.ReplayOn = DateTime.Now; obj.UploadTime = Convert.ToDateTime("2000-01-01"); NSession.Save(obj); NSession.Flush(); ebaymessage.ReplayBy = obj.ReplayBy; ebaymessage.ReplayOn = obj.ReplayOn; ebaymessage.MessageStatus = "已回复"; NSession.Update(ebaymessage); NSession.Flush(); } catch (Exception ee) { return(Json(new { errorMsg = "出错了" })); } return(Json(new { IsSuccess = "true" })); }
public JsonResult UpdateRate() { try { cn.com.webxml.webservice.ForexRmbRateWebService server = new cn.com.webxml.webservice.ForexRmbRateWebService(); DataSet ds = server.getForexRmbRate(); foreach (DataRow dr in ds.Tables[0].Rows) { CurrencyType c = new CurrencyType(); c.CurrencyCode = dr["Symbol"].ToString(); c.CurrencyName = dr["Name"].ToString(); NSession.Delete(" from CurrencyType where CurrencyCode='" + c.CurrencyCode + "'"); NSession.Flush(); c.CurrencySign = ""; string str = dr["fBuyPrice"].ToString(); if (string.IsNullOrEmpty(str)) { str = "0"; } c.CurrencyValue = Math.Round(Convert.ToDecimal(str) / 100, 5); c.CreateOn = DateTime.Now;; NSession.Save(c); } } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult EditProcessed(int Id) { EbayMessageType ebaymessage = ebay.GetById(Id); EbayMessageReType obj = new EbayMessageReType(); obj.ItemId = ebaymessage.ItemId; obj.EbayId = ebaymessage.MessageId; obj.Account = ebaymessage.Shop; obj.BodyRe = ""; obj.ItemId = ebaymessage.ItemId; obj.SenderID = ebaymessage.SenderID; obj.SenderEmail = ebaymessage.SenderEmail; obj.EbayId = ebaymessage.MessageId; obj.ReplayBy = CurrentUser.Realname; obj.SenderEmail = ebaymessage.SenderEmail; obj.SenderID = ebaymessage.SenderID; obj.Account = ebaymessage.Shop; obj.ReplayOn = DateTime.Now; obj.UploadTime = Convert.ToDateTime("2000-01-01"); NSession.Save(obj); NSession.Flush(); ebaymessage.ReplayBy = CurrentUser.Realname; ebaymessage.ReplayOn = DateTime.Now; ebaymessage.MessageStatus = "已回复"; NSession.Update(ebaymessage); NSession.Flush(); return(Json(new { IsSuccess = "true" })); }
public ActionResult SetMP(string a, string m, string p, int uid) { string[] ms = m.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); string[] ps = p.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); string[] fos = a.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); PermissionScopeType sc = null; NSession.CreateQuery("delete from PermissionScopeType where ResourceCategory='" + ResourceCategoryEnum.User.ToString() + "' and ResourceId=" + uid).ExecuteUpdate(); foreach (var item in ms) { if (string.IsNullOrEmpty(item)) { continue; } sc = new PermissionScopeType(); sc.ResourceCategory = ResourceCategoryEnum.User.ToString(); sc.ResourceId = uid; sc.TargetCategory = TargetCategoryEnum.Module.ToString(); sc.TargetId = Convert.ToInt32(item); NSession.Save(sc); NSession.Flush(); } foreach (var item in ps) { if (string.IsNullOrEmpty(item)) { continue; } ; sc = new PermissionScopeType(); sc.ResourceCategory = ResourceCategoryEnum.User.ToString(); sc.ResourceId = uid; sc.TargetCategory = TargetCategoryEnum.PermissionItem.ToString(); sc.TargetId = Convert.ToInt32(item); NSession.Save(sc); NSession.Flush(); } foreach (var item in fos) { if (string.IsNullOrEmpty(item)) { continue; } ; sc = new PermissionScopeType(); sc.ResourceCategory = ResourceCategoryEnum.User.ToString(); sc.ResourceId = uid; sc.TargetCategory = TargetCategoryEnum.Account.ToString(); sc.TargetId = Convert.ToInt32(item); NSession.Save(sc); NSession.Flush(); } return(Json(new { IsSuccess = true })); }
public void AddAreaCountry(string id, int tid) { NSession.Delete("from LogisticsAreaCountryType where CountryCode=" + id + " and AreaCode in (select Id from LogisticsAreaType where LId =(select LId from LogisticsAreaType where Id=" + tid + "))"); NSession.Flush(); LogisticsAreaCountryType logcountry = new LogisticsAreaCountryType { CountryCode = id, AreaCode = tid }; NSession.Save(logcountry); }
public JsonResult Create(LogisticsAreaType obj) { obj.LId = int.Parse(Session["lid"].ToString()); try { NSession.Save(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public void NoAttend(DateTime LastAttend) { TimeSpan day = DateTime.Now.Date - LastAttend; for (int i = 1; i < day.Days; i++) { AttendType obj = new AttendType() { CurrentDate = DateTime.Now.Date.AddDays(-i), UserId = CurrentUser.Id, UserCode = CurrentUser.Code, RealName = CurrentUser.Realname }; NSession.Save(obj); NSession.Flush(); } }
public ActionResult Copy(NewGuideType obj) { try { obj.CreateOn = DateTime.Now; NSession.Save(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult PrintSKU(int Id) { PlanDaoType obj = NSession.Get <PlanDaoType>(Id); if (obj != null) { NSession.Flush(); IList <PurchasePlanType> plans = NSession.CreateQuery("from PurchasePlanType where PlanNo=:p and SKU=:p2").SetString("p", obj.PlanNo).SetString("p2", obj.SKU).SetMaxResults(1).List <PurchasePlanType>(); PurchasePlanType plan = plans[0]; IList <SKUCodeType> list = NSession.CreateQuery("from SKUCodeType where SKU=:p1 and PlanNo=:p2 and Code >=:p3 order by Id").SetString("p1", obj.SKU). SetString("p2", obj.PlanNo).SetInt32("p3", obj.SKUCode).SetMaxResults(obj.RealQty).List <SKUCodeType>(); DataTable dt = new DataTable(); dt.Columns.Add("sku"); dt.Columns.Add("name"); dt.Columns.Add("num"); dt.Columns.Add("date"); dt.Columns.Add("people"); dt.Columns.Add("desc"); dt.Columns.Add("code"); int i = 1; foreach (SKUCodeType skuCodeType in list) { DataRow dr = dt.NewRow(); dr[0] = plan.SKU; dr[1] = plan.ProductName; dr[2] = i + "/" + obj.RealQty; dr[3] = plan.BuyOn; dr[4] = plan.BuyBy; dr[5] = plan.PlanNo; dr[6] = skuCodeType.Code; dt.Rows.Add(dr); i++; } DataSet ds = new DataSet(); ds.Tables.Add(dt); if (plan.ExpectReceiveOn < (new DateTime(2000, 1, 1))) { plan.ExpectReceiveOn = new DateTime(2000, 1, 1); } PrintDataType data = new PrintDataType(); data.Content = ds.GetXml(); data.CreateOn = DateTime.Now; NSession.Save(data); NSession.Flush(); return(Json(new { IsSuccess = true, Result = data.Id })); } return(Json(new { IsSuccess = false })); }
public JsonResult Create(ProductType obj) { try { string filePath = Server.MapPath("~"); obj.CreateOn = DateTime.Now; string pic = obj.PicUrl; if (!string.IsNullOrEmpty(pic)) { obj.PicUrl = Utilities.BPicPath + obj.SKU + ".jpg"; obj.SPicUrl = Utilities.SPicPath + obj.SKU + ".png"; Utilities.DrawImageRectRect(pic, filePath + obj.PicUrl, 310, 310); Utilities.DrawImageRectRect(pic, filePath + obj.SPicUrl, 64, 64); } List <ProductComposeType> list1 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ProductComposeType> >(obj.rows); if (list1.Count > 0) { obj.IsZu = 1; } obj.Enabled = 1; NSession.SaveOrUpdate(obj); NSession.Flush(); foreach (ProductComposeType productCompose in list1) { productCompose.SKU = obj.SKU; productCompose.PId = obj.Id; NSession.Save(productCompose); NSession.Flush(); } List <ProductIsInfractionType> list2 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ProductIsInfractionType> >(obj.rows2); foreach (ProductIsInfractionType item in list2) { item.OldSKU = obj.OldSKU; item.SKU = obj.SKU; NSession.Save(item); NSession.Flush(); } AddToWarehouse(obj); LoggerUtil.GetProductRecord(obj, "商品创建", "创建一件商品", CurrentUser, NSession); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult Create(PlacardType obj) { try { obj.CreateOn = DateTime.Now; obj.CreateBy = CurrentUser.Realname; NSession.Save(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public ActionResult SetSKUCode(int code, string sku) { return(Json(new { IsSuccess = false, Result = "此功能作废,请不要这个功能!" })); object count = NSession.CreateQuery("select count(Id) from ProductType where SKU='" + sku + "'").UniqueResult(); sku = sku.Trim(); SqlConnection conn = new SqlConnection("server=122.227.207.204;database=Feidu;uid=sa;pwd=`1q2w3e4r"); string sql = "select top 1 SKU from SkuCode where Code={0}or Code={1} "; conn.Open(); SqlCommand sqlCommand = new SqlCommand(string.Format(sql, code, (code + 1000000)), conn); object objSKU = sqlCommand.ExecuteScalar(); conn.Close(); if (objSKU != null) { if (objSKU.ToString().Trim().ToUpper() != sku.Trim().ToUpper()) { return(Json(new { IsSuccess = false, Result = "这个条码对应是的" + objSKU + ",不是现在的:" + sku + "!" })); } } if (Convert.ToInt32(count) > 0) { object count1 = NSession.CreateQuery("select count(Id) from SKUCodeType where Code=:p").SetInt32("p", code). UniqueResult(); if (Convert.ToInt32(count1) == 0) { SKUCodeType skuCode = new SKUCodeType { Code = code, SKU = sku, IsNew = 0, IsOut = 0 }; NSession.Save(skuCode); NSession.Flush(); Utilities.StockIn(1, sku, 1, 0, "条码清点入库", CurrentUser.Realname, "", NSession); return(Json(new { IsSuccess = true, Result = "添加成功!" })); } else { return(Json(new { IsSuccess = false, Result = "这个条码已经添加!" })); } } else { return(Json(new { IsSuccess = false, Result = "没有这个产品!" })); } }
private void UserLogin() { string ip = GetClientIP(); string mac = GetMACByIP(ip); UserLoginType obj = new UserLoginType { UserCode = CurrentUser.Code, UserName = CurrentUser.Realname, IP = ip, MAC = mac, CreateOn = DateTime.Now }; NSession.Save(obj); NSession.Flush(); }
public JsonResult Create(LogisticsModeType obj) { try { if (IsCreateOk(obj.ParentID, obj.LogisticsCode)) { return(Json(new { errorMsg = "此代码已存在!" })); } NSession.Save(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public ActionResult PrintSKU(int Id) { StockInType obj = NSession.Get <StockInType>(Id); if (obj != null) { NSession.Flush(); IList <SKUCodeType> list = NSession.CreateQuery("from SKUCodeType where PlanNo='" + obj.Id + "'"). List <SKUCodeType>(); DataTable dt = new DataTable(); dt.Columns.Add("sku"); dt.Columns.Add("name"); dt.Columns.Add("num"); dt.Columns.Add("date"); dt.Columns.Add("people"); dt.Columns.Add("desc"); dt.Columns.Add("code"); int i = 1; foreach (SKUCodeType skuCodeType in list) { DataRow dr = dt.NewRow(); dr[0] = obj.SKU; dr[1] = obj.SKU; dr[2] = i + "/" + obj.Qty; dr[3] = obj.CreateOn; dr[4] = obj.CreateBy; dr[5] = "手动入库"; dr[6] = skuCodeType.Code; dt.Rows.Add(dr); i++; } DataSet ds = new DataSet(); ds.Tables.Add(dt); PrintDataType data = new PrintDataType(); data.Content = ds.GetXml(); data.CreateOn = DateTime.Now; NSession.Save(data); NSession.Flush(); return(Json(new { IsSuccess = true, Result = data.Id })); } return(Json(new { IsSuccess = false })); }
public JsonResult Create(ProjectType obj) { try { if (obj.RealEndDate < Convert.ToDateTime("2000-01-01")) { obj.RealEndDate = Convert.ToDateTime("2000-01-01"); } obj.CreateOn = DateTime.Now; obj.CreateBy = CurrentUser.Realname; NSession.Save(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult Create(PurchaseTroubleType obj) { try { obj.CreateBy = CurrentUser.Realname; obj.CreateOn = DateTime.Now; obj.DealOn = Convert.ToDateTime("2000-01-01"); NSession.Save(obj); NSession.Flush(); PurchasePlanController a = new PurchasePlanController(); PurchasePlanType pu = a.GetById(obj.PurchaseId); LoggerUtil.GetPurchasePlanRecord(pu, "采购问题", "采购出现问题:" + obj.TroubleDetail, CurrentUser, NSession); } catch (Exception ee) { return(Json(new { errorMsg = "出错了" })); } return(Json(new { IsSuccess = "true" })); }
public JsonResult Create(SupplierType obj) { try { List <SuppliersProductType> list1 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SuppliersProductType> >(obj.rows); NSession.Save(obj); NSession.Flush(); foreach (SuppliersProductType product in list1) { product.SId = obj.Id; NSession.Save(product); NSession.Flush(); } } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public ActionResult EditStatus(string p, string s) { List <ProductType> products = NSession.CreateQuery("from ProductType where Id in(" + p + ")").List <ProductType>().ToList(); foreach (ProductType productType in products) { productType.Status = s; NSession.Update(productType); NSession.Flush(); LoggerUtil.GetProductRecord(productType, "订单产品属性修改", "产品:" + productType.SKU + "状态修改为“" + s + "”", CurrentUser, NSession); if (s == "停产") { int count = 0; string orderid = ""; List <OrderType> orderTypes = NSession.CreateQuery( "from OrderType where Id in(select OId from OrderProductType where SKU='" + productType.SKU + "') and Status='已处理' and Enabled=1") .List <OrderType>().ToList(); foreach (OrderType orderType in orderTypes) { orderType.IsStop = 1; NSession.Update(orderType); NSession.Flush(); LoggerUtil.GetOrderRecord(orderType, "订单产品属性修改", "产品:" + productType.SKU + "状态修改为“" + s + "”,同时订单属性设置为停售订单", CurrentUser, NSession); orderid += orderType.OrderNo + " "; count++; } NSession.CreateQuery("update OrderProductType set IsQue=2 where SKU='" + productType.SKU + "'").UniqueResult(); PlacardType placard = new PlacardType { CardType = "产品", Title = productType.SKU + " 停产", Content = "相关" + count + "条订单编号: " + orderid, CreateBy = "系统自动", CreateOn = DateTime.Now, IsTop = 1 }; NSession.Save(placard); NSession.Flush(); } } return(Json(new { IsSuccess = true })); }
private void SaveSupplier(PurchasePlanType obj) { object exit = NSession.CreateQuery("from SupplierType where SuppliersName='" + obj.Suppliers + "'").UniqueResult(); if (exit == null) { SupplierType super = new SupplierType { SuppliersName = obj.Suppliers }; NSession.Save(super); NSession.Flush(); SuppliersProductType product = new SuppliersProductType { SId = super.Id, SKU = obj.SKU, Price = obj.Price, Web = obj.ProductUrl }; NSession.Save(product); NSession.Flush(); } else { IList <SupplierType> list = NSession.CreateQuery("from SupplierType where SuppliersName='" + obj.Suppliers + "'").List <SupplierType>(); object productexit = NSession.CreateQuery("from SuppliersProductType where SId='" + list[0].Id + "' and SKU='" + obj.SKU + "' ").UniqueResult(); if (productexit == null) { SuppliersProductType product = new SuppliersProductType { SId = list[0].Id, SKU = obj.SKU, Price = obj.Price, Web = obj.ProductUrl }; NSession.Save(product); NSession.Flush(); } } }
public JsonResult ReturnOrder(string o, string p) { List <OrderType> orders = NSession.CreateQuery("from OrderType where OrderNo='" + o + "'").List <OrderType>().ToList(); if (orders.Count > 0) { OrderType order = orders[0]; order.Status = OrderStatusEnum.退货订单.ToString(); order.BuyerMemo = p + " " + order.BuyerMemo; NSession.Update(order); NSession.Flush(); OrderReturnRecordType record = new OrderReturnRecordType(); record.Account = order.Account; record.Platform = order.Platform; record.ReturnLogisticsMode = order.LogisticMode; record.OrderExNO = order.OrderExNo; record.OrderNo = order.OrderNo; record.OrderSendOn = order.ScanningOn; record.ReturnType = p; record.OldTrackCode = order.TrackCode; record.CreateOn = DateTime.Now; record.Country = order.Country; record.CurrencyCode = order.CurrencyCode; record.Amount = order.Amount; record.BuyerName = order.BuyerName; record.OrderCreateOn = order.CreateOn; record.OId = order.Id; NSession.Save(record); NSession.Flush(); LoggerUtil.GetOrderRecord(order, "订单退货扫描!", "订单设置为退货", CurrentUser, NSession); return(Json(new { IsSuccess = true, Result = "订单:" + order.OrderNo + " 已经添加到退货~!" })); } return(Json(new { IsSuccess = false, Result = "找不到该订单" })); }
public JsonResult EmailRe(EmailReturnType obj) { try { DateTime ReTime = DateTime.Now; SendMail(obj.REmail, obj.Subject, obj.Content); obj.CreateOn = ReTime; obj.CreateBy = ReTime; NSession.Save(obj); IList <EmailType> mail = NSession.CreateQuery("from EmailType c where c.Id=:id").SetInt32("id", obj.EId).List <EmailType>(); mail[0].IsReply = 1; mail[0].ReplyOn = ReTime; NSession.Update(mail[0]); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public void SaveAmount(DisputeType obj) { RefundAmountType amount = new RefundAmountType { DId = obj.Id, OrderNo = obj.OrderNo, OrderExNo = obj.OrderExNo, Platform = obj.Platform, Account = obj.Account, Amount = obj.Amount, CreateBy = CurrentUser.Realname, CreateOn = DateTime.Now, EmailAccount = obj.EmailAccount, TransactionNo = obj.TransactionNo, Status = "未审核", AmountType = obj.AmountType, AuditOn = Convert.ToDateTime("2000-01-01") }; NSession.Save(amount); NSession.Flush(); }
public ActionResult Edit(ProductType obj) { try { string str = ""; obj.Enabled = 1; ProductType obj2 = GetById(obj.Id); List <ProductComposeType> list1 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ProductComposeType> >(obj.rows); List <ProductComposeType> pis = NSession.CreateQuery("from ProductComposeType where SKU='" + obj.SKU + "'").List <ProductComposeType>().ToList <ProductComposeType>(); if (list1.Count != pis.Count) { str += "组合产品由<br>"; foreach (var item in pis) { str += Zu(item); } str += "修改为<br> "; foreach (var item in list1) { str += Zu(item); } str += "<br>"; } else { foreach (var item in pis) { int check = 0; foreach (var it in list1) { if (it.SrcSKU == item.SrcSKU && it.SrcQty == item.SrcQty) { check = 1; } } if (check != 1) { str += "组合产品由<br>"; foreach (var zu in pis) { str += Zu(zu); } str += "修改为<br> "; foreach (var zu in list1) { str += Zu(zu); } str += "<br>"; } } } NSession.Delete("from ProductComposeType where SKU='" + obj.SKU + "'"); NSession.Flush(); NSession.Clear(); foreach (ProductComposeType productCompose in list1) { productCompose.SKU = obj.SKU; productCompose.PId = obj.Id; NSession.Save(productCompose); NSession.Flush(); NSession.Clear(); obj.IsZu = 1; } str += Utilities.GetObjEditString(obj2, obj) + "<br>"; List <ProductIsInfractionType> list2 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ProductIsInfractionType> >(obj.rows2); foreach (ProductIsInfractionType item in list2) { IList <ProductIsInfractionType> qin = NSession.CreateQuery("from ProductIsInfractionType where SKU='" + obj.SKU + "' and Platform='" + item.Platform + "'").List <ProductIsInfractionType>(); if (qin.Count != 0) { foreach (var s in qin) { if (item.Isinfraction != s.Isinfraction) { str += item.Platform + "是否侵权由" + s.Isinfraction + "修改为" + item.Isinfraction + "<br>"; } } } } NSession.Delete("from ProductIsInfractionType where SKU='" + obj.SKU + "'"); NSession.Flush(); NSession.Clear(); foreach (ProductIsInfractionType item in list2) { item.OldSKU = obj.OldSKU; item.SKU = obj.SKU; NSession.Save(item); NSession.Flush(); NSession.Clear(); } NSession.Update(obj); NSession.Flush(); NSession.Clear(); //修改库存中的数据 IList <WarehouseStockType> list = NSession.CreateQuery(" from WarehouseStockType where PId=" + obj.Id).List <WarehouseStockType>(); // //在仓库中添加产品库存 // if (list.Count > 0) { foreach (var item in list) { item.Pic = obj.SPicUrl; item.SKU = obj.SKU; item.Title = obj.ProductName; item.UpdateOn = DateTime.Now; NSession.Update(item); NSession.Flush(); } } else { AddToWarehouse(obj); } LoggerUtil.GetProductRecord(obj, "商品修改", str, CurrentUser, NSession); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public ActionResult SetPrintData(string m, string r, string d, string t) { d = d.Replace("\r", "").Replace("\n", ","); IList <OrderType> objectses = NSession.CreateQuery("from OrderType where IsAudit=0 and OrderNo IN('" + d.Replace(",", "','") + "')").List <OrderType>(); string NotPrint = ""; foreach (OrderType c in objectses) { NotPrint += c.OrderNo + " ;"; } string sql = ""; sql = @"select (select COUNT(1) from OrderProducts where OrderProducts.OId=O.id) as 'GCount',O.IsPrint as 'PCount' ,O.Id,O.OrderNo,o.OrderExNo,O.Account,O.Platform,O.Amount,O.CurrencyCode,O.BuyerEmail,O.BuyerName,O.LogisticMode,O.IsSplit,O.IsRepeat,O.IsAudit, O.BuyerMemo,O.SellerMemo,O.CreateOn,O.Freight,O.Weight,O.TrackCode,O.Country,OA.Addressee,OA.Street,OA.County,OA.City,OA.Province, OA.Phone,OA.Tel,OA.PostCode,OA.CountryCode,OP.SKU,OP.Standard,OP.Remark,OP.Title,OP.Qty,OP.ExSKU,P.OldSKU,P.Category,P.SPicUrl,P.OldSKU,P.Location,P.ProductName, R.RetuanName ,R.City as 'RCity',R.Street as 'RStreet',R.Phone as 'RPhone',R.Tel as 'RTel',R.County as 'RCounty',(select top 1 CCountry from Country where ECountry=O.Country) as CCountry,O.GenerateOn, R.Country as 'RCountry',R.PostCode as 'RPostCode',R.Province as 'RProvince' from Orders O left join OrderProducts OP on o.Id=op.OId left join OrderAddress OA on o.AddressId=oa.Id Left Join Products P ON OP.SKU=P.SKU left join ReturnAddress R On r.Id=" + r; //2013.9.22 添加 sal不打印,直接硬编码.--> 看后期是否可以变成过滤模块吧, sql += " where O.IsAudit=1 and O.OrderNo IN('" + d.Replace(",", "','") + "') and O.LogisticMode not like '%sal%' and O.Account not in ('wunderschoen_dream')"; DataSet ds = new DataSet(); IDbCommand command = NSession.Connection.CreateCommand(); command.CommandText = sql; SqlDataAdapter da = new SqlDataAdapter(command as SqlCommand); da.Fill(ds); ds.Tables[0].DefaultView.Sort = " OrderNo Asc"; if (t == "多物品订单") { ds.Tables[0].DefaultView.RowFilter = " GCount >1"; } else { List <string> list = new List <string>(); DataTable dt1 = ds.Tables[0]; foreach (DataRow dr in dt1.Rows) { if (list.Contains(dr["OrderNo"].ToString())) { dr.Delete(); } else { list.Add(dr["OrderNo"].ToString()); } } ds.Tables[0].DefaultView.Sort = " OrderNo Asc"; } DataTable dt = ds.Tables[0].DefaultView.ToTable(); dt.Columns.Add("PrintName"); dt.Columns.Add("AreaName"); List <string> list2 = new List <string>(); foreach (DataRow dr in dt.Rows) { dr["PrintName"] = CurrentUser.Realname; if (dr["LogisticMode"].ToString() == "BLS") { dr["TrackCode"] = "1372100" + dr["OrderNo"].ToString(); } object obj = NSession.CreateSQLQuery("select top 1 AreaName from [LogisticsArea] where LId = (select top 1 ParentID from LogisticsMode where LogisticsCode='" + dr["LogisticMode"] + "') and Id =(select top 1 AreaCode from LogisticsAreaCountry where [LogisticsArea].Id=AreaCode and CountryCode in (select ID from Country where ECountry='" + dr["Country"] + "') )").UniqueResult(); dr["AreaName"] = obj; if (list2.Contains(dr["OrderNo"].ToString())) { } else { LoggerUtil.GetOrderRecord(Convert.ToInt32(dr["Id"]), dr["OrderNo"].ToString(), "订单打印", CurrentUser.Realname + "订单打印!", CurrentUser, NSession); list2.Add(dr["OrderNo"].ToString()); } } //标记打印 NSession.CreateQuery("update OrderType set IsPrint=IsPrint+1 where IsAudit=1 and OrderNo IN('" + d.Replace(",", "','") + "') and LogisticMode not like '%sal%'").ExecuteUpdate(); ds.Tables.Clear(); ds.Tables.Add(dt); if (NotPrint != "") { NotPrint = "有" + objectses.Count + "条订单没有审核,无法发打印,订单号:" + NotPrint; } PrintDataType data = new PrintDataType(); data.Content = ds.GetXml(); data.CreateOn = DateTime.Now; NSession.Save(data); NSession.Flush(); return(Json(new { IsSuccess = true, Result = data.Id })); }