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 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 JsonResult DeleteConfirmed(int id) { try { PermissionScopeType obj = GetById(id); NSession.Delete(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
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 ActionResult Edit(LanguageType obj) { try { NSession.Clear(); NSession.Update(obj); NSession.Flush(); Language.ReLoadLanguage(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
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 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 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 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 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 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 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 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 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" })); }
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 DoNo(int o) { QuestionOrderType obj = GetById(o); OrderType orderType = NSession.Get <OrderType>(obj.OId); if (orderType != null) { orderType.Enabled = 0; NSession.Update(orderType); NSession.Flush(); obj.Status = 2; NSession.Update(obj); NSession.Flush(); OrderHelper.GetOrderRecord(orderType, "拒绝问题订单", "" + CurrentUser.Realname + "将订单设为隐藏!", CurrentUser.Realname, NSession); } return(Json(new { IsSuccess = "true" })); }
public JsonResult Create(CountryType obj) { try { if (IsCreateOk(obj.ECountry)) { return(Json(new { errorMsg = "编号已经存在" })); } NSession.SaveOrUpdate(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
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 DeleteConfirmed(int id) { try { StockInType obj = GetById(id); NSession.Delete("from SKUCodeType where PlanNo='" + obj.Id + "'"); NSession.Flush(); Utilities.StockOut(1, obj.SKU, obj.Qty, "入库删除", CurrentUser.Realname, "", "", NSession); NSession.Delete(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult Create(logisticsSetupType obj) { try { obj.SetupName = obj.SetupId; obj.CreateOn = DateTime.Now; obj.CreateBy = GetCurrentAccount().Realname; obj.LogisticsName = NSession.Get <LogisticsType>(obj.LId).LogisticsName; NSession.SaveOrUpdate(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { errorMsg = "出错了" })); } return(Json(new { IsSuccess = "true" })); }
public ActionResult Edit(DictionaryClassType obj) { try { DictionaryClassType c = GetById(obj.Id); NSession.CreateSQLQuery("update Dictionarys set DicCode='" + obj.Code + "' where DicCode='" + c.Code + "' ") .UniqueResult(); NSession.Clear(); NSession.Update(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
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 Edit(MachineType obj) { try { if (IsOk(obj.Id, obj.Code)) { 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 DeleteConfirmed(int id) { try { ProductType obj = GetById(id); NSession.Delete(obj); NSession.Flush(); NSession.Delete("from WarehouseStockType where SKU='" + obj.SKU + "'"); NSession.Flush(); LoggerUtil.GetProductRecord(obj, "删除商品", "商品被删除", CurrentUser, NSession); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult Create(LogisticsType obj) { try { if (IsCreateOk(obj.LogisticsCode)) { return(Json(new { errorMsg = "此代码已存在,请检查后再创建!" })); } obj.CreateOn = DateTime.Now; NSession.SaveOrUpdate(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult Save(AccountFeeType obj) { try { if (obj.AmountBegin >= obj.AmountEnd) { return(Json(new { IsSuccess = false, ErrorMsg = "开始金额不能大于结束金额" })); } new System.Data.DataTable().Compute(obj.FeeFormula.Replace("T", "10"), ""); NSession.SaveOrUpdate(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "公式错误" })); } return(Json(new { IsSuccess = true })); }
public ActionResult ResetFreight(string search, decimal z) { string orderby; var where = GetWhere(null, null, search, out @orderby); IList <OrderType> objList = NSession.CreateQuery("from OrderType " + where + orderby) .List <OrderType>(); foreach (OrderType orderType in objList) { double d = 0; orderType.Freight = Convert.ToDouble(OrderHelper.GetFreight(orderType.Weight, orderType.LogisticMode, orderType.Country, NSession, z)); NSession.SaveOrUpdate(orderType); NSession.Flush(); OrderHelper.SaveAmount(orderType, NSession); } return(Json(new { IsSuccess = true })); }