public JsonResult DeleteConfirmed(int id) { try { PaypalAccountType obj = GetById(id); NSession.Delete(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult ToExcel(string search) { try { List <OrderPeiRecordType> objList = NSession.CreateQuery("from OrderPeiRecordType " + Utilities.SqlWhere(search)) .List <OrderPeiRecordType>().ToList(); Session["ExportDown"] = ExcelHelper.GetExcelXml(Utilities.FillDataTable((objList))); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true, ErrorMsg = "导出成功" })); }
public JsonResult Create(LanguageType obj) { try { NSession.SaveOrUpdate(obj); NSession.Flush(); Language.ReLoadLanguage(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult DeleteConfirmed(int id) { try { EbayMessageType obj = GetById(id); NSession.Delete(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { ErrorMsg = "出错了", IsSuccess = false })); } 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 JsonResult List(int page, int rows, string search) { string orderby = " order by CurrentDate desc "; string where = Utilities.SqlWhere(search); IList <AttendType> objList = NSession.CreateQuery("from AttendType " + where + orderby) .SetFirstResult(rows * (page - 1)) .SetMaxResults(rows) .List <AttendType>(); object count = NSession.CreateQuery("select count(Id) from AttendType " + where).UniqueResult(); return(Json(new { total = count, rows = objList.OrderByDescending(p => p.CurrentDate) })); }
public JsonResult List(int page, int rows, string sort, string order, string search) { string orderby = Utilities.OrdeerBy(sort, order); string where = Utilities.SqlWhere(search); IList <PaypalAccountType> objList = NSession.CreateQuery("from PaypalAccountType" + where + orderby) .SetFirstResult(rows * (page - 1)) .SetMaxResults(rows * page) .List <PaypalAccountType>(); object count = NSession.CreateQuery("select count(Id) from PaypalAccountType " + where).UniqueResult(); return(Json(new { total = count, rows = objList })); }
public JsonResult DeleteConfirmed(int id) { try { PlacardType obj = GetById(id); NSession.Delete(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { errorMsg = "出错" + ee.Message })); } 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 List(int page, int rows, string sort, string order, string search, string infraction = "", string c = "") { string orderby = Utilities.OrdeerBy(sort, order); string where = Utilities.SqlWhere(search); if (where != "") { where += " and Enabled <>0"; } else { where = "where Enabled <>0"; } if (infraction != "") { where += InfractionWhere(infraction); } if (!string.IsNullOrEmpty(c)) { string cs = ""; IList <object> objectes = NSession.CreateSQLQuery(@"with a as( select * from ProductCategory where ID=" + c + @" union all select x.* from ProductCategory x,a where x.ParentId=a.Id) select Name from a").List <object>(); foreach (object item in objectes) { cs += "'" + item + "',"; } if (cs.Length > 0) { cs = cs.Trim(','); } where += " and Category in (" + cs + ")"; } IList <ProductType> objList = NSession.CreateQuery("from ProductType " + where + orderby) .SetFirstResult(rows * (page - 1)) .SetMaxResults(rows) .List <ProductType>(); foreach (ProductType item in objList) { item.Infraction = Infraction(item.SKU); } object count = NSession.CreateQuery("select count(Id) from ProductType " + where).UniqueResult(); return(Json(new { total = count, rows = objList })); }
public JsonResult ToDispute(int id) { try { DisputeType obj = GetById(id); obj.DisputesType = "纠纷"; NSession.Update(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" }, JsonRequestBehavior.AllowGet)); } return(Json(new { IsSuccess = true, ErrorMsg = "转换成功" }, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteConfirmed(int id) { try { SupplierType obj = GetById(id); NSession.Delete(obj); NSession.Delete("from SuppliersProductType where SId='" + obj.Id + "'"); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public ActionResult Edit(LogisticsAreaType obj) { obj.LId = int.Parse(Session["lid"].ToString()); try { NSession.Update(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult List() { IList <PermissionItemType> objList = NSession.CreateQuery("from PermissionItemType").List <PermissionItemType>(); IList <PermissionItemType> fristList = objList.Where(p => p.ParentId == 0).OrderByDescending(p => p.SortCode).ToList(); foreach (PermissionItemType item in fristList) { List <PermissionItemType> fooList = objList.Where(p => p.ParentId == item.Id).OrderByDescending(p => p.SortCode).ToList(); item.children = fooList; GetChildren(objList, item); } return(Json(new { total = fristList.Count, rows = fristList })); }
public JsonResult DeleteConfirmed(int id) { try { NoStockType obj = GetById(id); obj.Enabled = 0; NSession.Update(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { errorMsg = "出错了" })); } return(Json(new { IsSuccess = "true" })); }
public JsonResult Create(OrganizeType obj) { try { obj.CreateOn = DateTime.Now; obj.CreateBy = CurrentUser.Realname; NSession.SaveOrUpdate(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult Delete(int id) { try { LanguageType obj = GetById(id); NSession.Delete(obj); NSession.Flush(); Language.ReLoadLanguage(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public void DelAreaCountry(string id, int tid) { LogisticsAreaCountryType logc = new LogisticsAreaCountryType { CountryCode = id.ToString(), AreaCode = tid }; IList <LogisticsAreaCountryType> list = NSession.CreateCriteria(typeof(LogisticsAreaCountryType)) .Add(Example.Create(logc)) .List <LogisticsAreaCountryType>(); foreach (LogisticsAreaCountryType item in list) { NSession.Delete(item); NSession.Flush(); } }
public string Infraction(string sku) { string str = ""; IList <ProductIsInfractionType> objs = NSession.CreateQuery("from ProductIsInfractionType where SKU='" + sku + "' and Isinfraction=1 ").List <ProductIsInfractionType>(); foreach (var item in objs) { str += item.Platform + "<br/>"; } if (str == "") { str = "否"; } return(str); }
public JsonResult Create(SoresAddType obj) { try { obj.CreateBy = CurrentUser.Realname; obj.CreateOn = DateTime.Now; NSession.SaveOrUpdate(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { 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 = "没有这个产品!" })); } }
public ActionResult Edit(PurchaseTroubleType obj) { try { obj.DealBy = CurrentUser.Realname; obj.DealOn = DateTime.Now; obj.Status = "已解决"; NSession.Update(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { errorMsg = "出错了" })); } return(Json(new { IsSuccess = "true" })); }
public JsonResult List(int page, int rows, string sort, string order, string search) { string orderby = Utilities.OrdeerBy(sort, order); string where = Utilities.SqlWhere(search); List <EbayType> objList = NSession.CreateSQLQuery( "select [Id],[ItemId],[ItemTitle],[Currency],[Price],[PicUrl],[StartNum],[NowNum],[ProductUrl],[StartTime],[CreateOn],[Account],[SKU],[Status],isnull((select top 1 COUNT(Id) from SKUCode where SKUCode.SKU = Ebay.SKU and IsOut=0 group by SKU),0) as UnPeiQty from Ebay " + where + orderby).AddEntity(typeof(EbayType)) .SetFirstResult(rows * (page - 1)) .SetMaxResults(rows) .List <EbayType>().ToList(); object count = NSession.CreateQuery("select count(Id) from EbayType " + where).UniqueResult(); return(Json(new { total = count, rows = objList })); }
/// <summary> /// 根据Id获取 /// </summary> /// <param name="Id"></param> /// <returns></returns> public EmailType GetById(int Id) { EmailType obj = NSession.Get <EmailType>(Id); if (obj == null) { obj = new EmailType { Id = 0 }; return(obj); } else { return(obj); } }
public JsonResult List() { string orderby = " order by Id desc "; IList <LogisticsAllocationType> objList = NSession.CreateQuery("from LogisticsAllocationType " + orderby) .List <LogisticsAllocationType>(); foreach (LogisticsAllocationType logisticsAllocationType in objList) { logisticsAllocationType.Content = null; logisticsAllocationType.QuerySql = null; } return(Json(new { total = objList.Count, rows = objList })); }
public JsonResult List(int page, int rows, string sort, string order, string search) { string orderby = Utilities.OrdeerBy(sort, order, "Id desc"); string where = Utilities.SqlWhere(search); //string where = string.IsNullOrWhiteSpace(search) ? string.Empty : " where " + search + " "; //Utilities.SqlWhere(search); List <LanguageType> objList = NSession.CreateQuery( "from LanguageType " + where + orderby) .SetFirstResult(rows * (page - 1)) .SetMaxResults(rows) .List <LanguageType>().ToList(); object count = NSession.CreateQuery("select count(Id) from LanguageType " + where).UniqueResult(); return(Json(new { total = count, rows = objList })); }
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 ActionResult Edit(LogisticsType obj) { try { if (IsOk(obj.Id, obj.LogisticsCode)) { return(Json(new { errorMsg = "此代码已存在,请检查后再作修改!" })); } NSession.Update(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult GetOrderByReturn(string o) { List <OrderType> orders = NSession.CreateQuery("from OrderType where OrderNo='" + o + "'").List <OrderType>().ToList(); if (orders.Count > 0) { OrderType order = orders[0]; if (order.Status != OrderStatusEnum.退货订单.ToString()) { string html = "<b>订单:{0} <br/>平台:{5} <br/>账户:{6} <br/>下单时间:{1} <br/>发货时间:{2} <br/>发货渠道:{3} <br/>发货条码:{4}</b>"; return(Json(new { IsSuccess = true, Result = string.Format(html, order.OrderNo, order.CreateOn, order.ScanningOn, order.LogisticMode, order.TrackCode, order.Platform, order.Account) })); } return(Json(new { IsSuccess = false, Result = "该订单已经退货!请不要重复扫描!" })); } return(Json(new { IsSuccess = false, Result = "找不到该订单" })); }