public void EditInventoryPlan(HttpContext context) { string callback = context.Request["jsoncallback"]; int planid = Convert.ToInt32(context.Request["itemid"]); string name = context.Request["name"]; int result; if (new EmsBLL.InventoryPlan().IsNameExists(name, planid)) { result = -1; } else { EmsModel.InventoryPlan plan = new EmsBLL.InventoryPlan().GetEmsModel(planid); string useridcard = context.Request["useridcard"]; plan.Id = planid; plan.Name = name; plan.InventoryTime = Convert.ToDateTime(context.Request["invtime"]); plan.Type = Convert.ToByte(context.Request["type"]); plan.Editor = useridcard; plan.UpdateTime = DateTime.Now; result = new EmsBLL.InventoryPlan().Update(plan); } //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + result + "})"); HttpContext.Current.Response.End(); }
public void AddInventoryPlan(HttpContext context) { string callback = context.Request["jsoncallback"]; string name = context.Request["name"]; int result; if (new EmsBLL.InventoryPlan().IsNameExists(name)) { result = -1; } else { string useridcard = context.Request["useridcard"]; EmsModel.InventoryPlan plan = new EmsModel.InventoryPlan(); plan.Name = name; plan.InventoryNo = context.Request["invno"]; plan.InventoryTime = Convert.ToDateTime(context.Request["invtime"]); plan.Type = Convert.ToByte(context.Request["type"]); plan.Creator = useridcard; plan.CreateTime = DateTime.Now; plan.Status = 0; plan.IsGenerate = 0; plan.IsDelete = 0; result = new EmsBLL.InventoryPlan().Add(plan); } //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + result + "})"); HttpContext.Current.Response.End(); }
public JsonModel CreateInventoryList(int planid, string type, string useridcard) { //定义JSON标准格式实体中 JsonModel jsonModel = new JsonModel(); try { //事务 using (SqlTransaction trans = dal.GetTran()) { try { int listCount = new EmsDAL.InventoryList().AddInventoryList(trans, planid, type, useridcard); if (listCount <= 0) { trans.Rollback();//回滚 jsonModel.Status = "no"; jsonModel.Msg = "生成盘点单失败"; return(jsonModel); } int addCount = dal.AddInventoryListDetail(trans, planid, type); if (addCount <= 0) { trans.Rollback();//回滚 jsonModel.Status = "no"; jsonModel.Msg = "生成盘点单失败"; return(jsonModel); } EmsModel.InventoryPlan plan = new EmsBLL.InventoryPlan().GetEmsModel(planid); plan.IsGenerate = 1; int upcount = new EmsDAL.InventoryPlan().Update(plan); if (upcount <= 0) { trans.Rollback();//回滚 jsonModel.Status = "no"; jsonModel.Msg = "生成盘点单失败"; return(jsonModel); } trans.Commit();//提交 } catch (Exception) { trans.Rollback();//回滚 throw; } } jsonModel.Status = "ok"; jsonModel.Msg = "操作成功"; return(jsonModel); } catch (Exception ex) { jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
public void GetModelById(HttpContext context) { string callback = context.Request["jsoncallback"]; int planid = Convert.ToInt32(context.Request["itemid"]); //序列化 System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer(); EmsModel.InventoryPlan plan = new EmsBLL.InventoryPlan().GetEmsModel(planid); //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + jss.Serialize(plan) + "})"); HttpContext.Current.Response.End(); }
public void DeleteInventoryPlan(HttpContext context) { string callback = context.Request["jsoncallback"]; int planid = Convert.ToInt32(context.Request["intID"]); EmsModel.InventoryPlan plan = new EmsBLL.InventoryPlan().GetEmsModel(planid); plan.Id = planid; plan.IsDelete = 1; int result = new EmsBLL.InventoryPlan().Update(plan); //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + result + "})"); HttpContext.Current.Response.End(); }
public void GetDataPage(HttpContext context) { string callback = context.Request["jsoncallback"]; //当前页 int startIndex = Convert.ToInt32(context.Request["startIndex"]); //页容量 int pageSize = Convert.ToInt32(context.Request["pageSize"]); string name = context.Request["name"]; EmsModel.InventoryPlan plan = new EmsModel.InventoryPlan(); if (!string.IsNullOrEmpty(name)) { plan.Name = name; } plan.IsDelete = 0; //序列化 System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer(); EmsModel.JsonModel mod = new EmsBLL.InventoryPlan().GetJsonModel(plan, startIndex, pageSize); //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + jss.Serialize(mod) + "})"); HttpContext.Current.Response.End(); }