private string adduseraction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Order.BusinessWorkOrder bc = new project.Business.Order.BusinessWorkOrder(); bc.load(jp.getValue("id")); foreach (string it in jp.getValue("labels").Split(';')) { Business.Order.BusinessWorkOrderPerson person = new Business.Order.BusinessWorkOrderPerson(); if (person.GetWorkOrderPersonListCount(user.Entity.AccID, bc.Entity.OrderNo, it, null, false) == 0) { person.Entity.AccID = user.Entity.AccID; person.Entity.CreateDate = GetDate(); person.Entity.CreateUser = user.Entity.UserName; person.Entity.IsBack = false; person.Entity.IsDel = false; person.Entity.OrderNo = bc.Entity.OrderNo; person.Entity.UserNo = it; person.Entity.UpdateUser = user.Entity.UserName; person.Entity.UpdateDate = GetDate(); int row = person.Save(); if (row > 0) { Business.Order.BusinessWorkOrderMsg msg = new Business.Order.BusinessWorkOrderMsg(); msg.Entity.AccID = user.Entity.AccID; msg.Entity.Sender = user.Entity.UserNo; msg.Entity.SendDate = GetDate(); msg.Entity.ToUser = person.Entity.UserNo; msg.Entity.Subject = "您有一张新的工单!"; msg.Entity.Context = "你有新的工单需要处理,工单号:" + bc.Entity.OrderNo; msg.Entity.RefNo = bc.Entity.OrderNo; msg.Entity.MsgType = "1"; msg.Entity.IsDel = false; msg.Entity.IsRead = false; msg.Entity.CreateDate = GetDate(); msg.Entity.CreateUser = user.Entity.UserNo; msg.Save(); } } } //修改退回状态 obj.ExecuteNonQuery("update WO_WorkOrder set IsBack=0,BackDate=null,backReason='' where RowPointer='" + bc.Entity.InnerEntityOID + "' and AccID='" + bc.Entity.AccID + "'"); obj.ExecuteNonQuery("update WO_WorkOrder_Person set IsBack=0 where OrderNo='" + bc.Entity.OrderNo + "' and AccID='" + bc.Entity.AccID + "'"); } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "adduser")); collection.Add(new JsonStringValue("flag", flag)); return(collection.ToString()); }
private string submitaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Order.BusinessWorkOrder bc = new project.Business.Order.BusinessWorkOrder(); if (jp.getValue("tp") == "update") { bc.load(jp.getValue("id")); bc.Entity.OrderName = jp.getValue("OrderName"); bc.Entity.OrderDate = ParseDateForString(jp.getValue("OrderDate") + " " + jp.getValue("OrderHour") + ":" + jp.getValue("OrderMinute") + ":00"); bc.Entity.OrderType = jp.getValue("OrderType"); bc.Entity.SaleNo = jp.getValue("SaleNo"); bc.Entity.AlloDept = jp.getValue("AlloDept"); bc.Entity.AlloUser = jp.getValue("AlloUser"); bc.Entity.CustNo = jp.getValue("CustNo"); bc.Entity.LinkMan = jp.getValue("LinkMan"); bc.Entity.LinkTel = jp.getValue("LinkTel"); bc.Entity.Addr = jp.getValue("Addr"); bc.Entity.Region = jp.getValue("Region"); string CustneedTime = ""; if (jp.getValue("CustneedTime") != "") { CustneedTime = jp.getValue("CustneedTime") + " " + jp.getValue("CustneedHour") + ":" + jp.getValue("CustneedMinute") + ":00"; } bc.Entity.CustneedTime = ParseDateForString(CustneedTime); //bc.Entity.Remark = jp.getValue("Remark"); int r = bc.Save(); if (r <= 0) { flag = "2"; } else { foreach (string it in jp.getValue("TreatUser").Split(';')) { Business.Order.BusinessWorkOrderPerson person = new Business.Order.BusinessWorkOrderPerson(); if (person.GetWorkOrderPersonListCount(user.Entity.AccID, bc.Entity.OrderNo, it, null, false) == 0) { person.Entity.AccID = user.Entity.AccID; person.Entity.CreateDate = GetDate(); person.Entity.CreateUser = user.Entity.UserName; person.Entity.IsBack = false; person.Entity.IsDel = false; person.Entity.OrderNo = bc.Entity.OrderNo; person.Entity.UserNo = it; person.Entity.UpdateUser = user.Entity.UserName; person.Entity.UpdateDate = GetDate(); int row = person.Save(); if (row > 0) { Business.Order.BusinessWorkOrderMsg msg = new Business.Order.BusinessWorkOrderMsg(); msg.Entity.AccID = user.Entity.AccID; msg.Entity.Sender = user.Entity.UserNo; msg.Entity.SendDate = GetDate(); msg.Entity.ToUser = person.Entity.UserNo; msg.Entity.Subject = "您有一张新的工单!"; msg.Entity.Context = "你有新的工单需要处理,工单号:" + bc.Entity.OrderNo; msg.Entity.RefNo = bc.Entity.OrderNo; msg.Entity.MsgType = "1"; msg.Entity.IsDel = false; msg.Entity.IsRead = false; msg.Entity.CreateDate = GetDate(); msg.Entity.CreateUser = user.Entity.UserNo; msg.Save(); } } } } } else { string OrderNo = ""; string today = GetDate().ToString("yyMMdd"); DataTable dt = obj.ExecuteDataSet("select top 1 OrderNo from WO_WorkOrder where OrderNo like N'" + today + "%' and AccID='" + user.Entity.AccID + "' order by OrderNo desc").Tables[0]; if (dt.Rows.Count > 0) { OrderNo = (long.Parse(dt.Rows[0]["OrderNo"].ToString()) + 1).ToString(); } else { OrderNo = today + "0001"; } bc.Entity.OrderNo = OrderNo; bc.Entity.OrderName = jp.getValue("OrderName"); bc.Entity.OrderDate = ParseDateForString(jp.getValue("OrderDate") + " " + jp.getValue("OrderHour") + ":" + jp.getValue("OrderMinute") + ":00"); bc.Entity.OrderType = jp.getValue("OrderType"); bc.Entity.SaleNo = jp.getValue("SaleNo"); bc.Entity.AlloDept = jp.getValue("AlloDept"); bc.Entity.AlloUser = jp.getValue("AlloUser"); bc.Entity.CustNo = jp.getValue("CustNo"); bc.Entity.LinkMan = jp.getValue("LinkMan"); bc.Entity.LinkTel = jp.getValue("LinkTel"); bc.Entity.Addr = jp.getValue("Addr"); bc.Entity.Region = jp.getValue("Region"); //bc.Entity.Remark = jp.getValue("Remark"); string CustneedTime = ""; if (jp.getValue("CustneedTime") != "") { CustneedTime = jp.getValue("CustneedTime") + " " + jp.getValue("CustneedHour") + ":" + jp.getValue("CustneedMinute") + ":00"; } bc.Entity.CustneedTime = ParseDateForString(CustneedTime); bc.Entity.AccID = user.Entity.AccID; bc.Entity.Status = "OPEN"; bc.Entity.CreateTime = GetDate(); bc.Entity.CreateUser = user.Entity.UserNo; bc.Entity.UpdateDate = GetDate(); bc.Entity.UpdateUser = user.Entity.UserName; int r = bc.Save(); if (r <= 0) { flag = "2"; } else { foreach (string it in jp.getValue("TreatUser").Split(';')) { Business.Order.BusinessWorkOrderPerson person = new Business.Order.BusinessWorkOrderPerson(); if (person.GetWorkOrderPersonListCount(user.Entity.AccID, bc.Entity.OrderNo, it, null, false) == 0) { person.Entity.AccID = user.Entity.AccID; person.Entity.CreateDate = GetDate(); person.Entity.CreateUser = user.Entity.UserName; person.Entity.IsBack = false; person.Entity.IsDel = false; person.Entity.OrderNo = bc.Entity.OrderNo; person.Entity.UserNo = it; person.Entity.UpdateUser = user.Entity.UserName; person.Entity.UpdateDate = GetDate(); int row = person.Save(); if (row > 0) { Business.Order.BusinessWorkOrderMsg msg = new Business.Order.BusinessWorkOrderMsg(); msg.Entity.AccID = user.Entity.AccID; msg.Entity.Sender = user.Entity.UserNo; msg.Entity.SendDate = GetDate(); msg.Entity.ToUser = person.Entity.UserNo; msg.Entity.Subject = "您有一张新的工单!"; msg.Entity.Context = "你有新的工单需要处理,工单号:" + bc.Entity.OrderNo; msg.Entity.RefNo = bc.Entity.OrderNo; msg.Entity.MsgType = "1"; msg.Entity.IsDel = false; msg.Entity.IsRead = false; msg.Entity.CreateDate = GetDate(); msg.Entity.CreateUser = user.Entity.UserNo; msg.Save(); } } } Business.Order.BusinessWorkOrderLog log = new Business.Order.BusinessWorkOrderLog(); log.Entity.AccID = user.Entity.AccID; log.Entity.OrderNo = bc.Entity.OrderNo; log.Entity.LogDate = GetDate(); log.Entity.LogType = "Add"; log.Entity.LogUser = user.Entity.UserNo; log.Entity.Remark = "新建工单:" + bc.Entity.OrderNo; log.Save(); } } } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "submit")); collection.Add(new JsonStringValue("flag", flag)); if (flag == "1") { collection.Add(new JsonStringValue("liststr", createList(jp.getValue("OrderNoS"), jp.getValue("OrderNameS"), jp.getValue("MinOrderDate"), jp.getValue("MaxOrderDate"), jp.getValue("StatusS"), jp.getValue("SaleNoS"), jp.getValue("RegionS"), jp.getValue("AlloDeptS"), jp.getValue("AlloUserS"), jp.getValue("CustNoS"), jp.getValue("OrderTypeS"), jp.getValue("IsBackS"), jp.getValue("IsHangUpS"), int.Parse(jp.getValue("page"))))); } return(collection.ToString()); }