private string confirmaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Order.BusinessWorkOrder bc = new project.Business.Order.BusinessWorkOrder();
bc.load(jp.getValue("id"));
string InfoMsg = bc.confirm(user.Entity.AccID, bc.Entity.OrderNo, "", "", user.Entity.UserNo, user.Entity.UserName);
if (InfoMsg != "")
{
flag = "3";
collection.Add(new JsonStringValue("info", InfoMsg));
}
else
{
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")))));
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "confirm"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Order.BusinessWorkOrder bc = new project.Business.Order.BusinessWorkOrder();
bc.load(jp.getValue("id"));
bc.Entity.IsDel = !bc.Entity.IsDel;
int r = bc.delete();
if (r <= 0)
{
flag = "2";
}
else
{
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")))));
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "delete"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
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 updateaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
string result = "";;
try
{
Business.Order.BusinessWorkOrder bc = new project.Business.Order.BusinessWorkOrder();
bc.load(jp.getValue("id"));
if (bc.Entity.Status != "OPEN")
{
flag = "3";
}
else
{
collection.Add(new JsonStringValue("CustNo", bc.Entity.CustNo));
collection.Add(new JsonStringValue("CustName", bc.Entity.CustName));
collection.Add(new JsonStringValue("OrderNo", bc.Entity.OrderNo));
collection.Add(new JsonStringValue("OrderName", bc.Entity.OrderName));
collection.Add(new JsonStringValue("OrderDate", ParseStringForDate(bc.Entity.OrderDate)));
collection.Add(new JsonStringValue("OrderType", bc.Entity.OrderType));
collection.Add(new JsonStringValue("SaleNo", bc.Entity.SaleNo));
collection.Add(new JsonStringValue("LinkMan", bc.Entity.LinkMan));
collection.Add(new JsonStringValue("LinkTel", bc.Entity.LinkTel));
collection.Add(new JsonStringValue("Addr", bc.Entity.Addr));
collection.Add(new JsonStringValue("Remark", bc.Entity.Remark));
collection.Add(new JsonStringValue("AlloDept", bc.Entity.AlloDept));
collection.Add(new JsonStringValue("AlloDeptName", bc.Entity.AlloDeptName));
collection.Add(new JsonStringValue("AlloUser", bc.Entity.AlloUser));
collection.Add(new JsonStringValue("AlloUserName", bc.Entity.AlloUserName));
collection.Add(new JsonStringValue("Person", bc.Entity.Person));
collection.Add(new JsonStringValue("PersonName", bc.Entity.PersonName));
collection.Add(new JsonStringValue("Region", bc.Entity.Region));
collection.Add(new JsonStringValue("RegionName", bc.Entity.RegionName));
collection.Add(new JsonStringValue("OrderHour", (bc.Entity.OrderDate.Hour < 10 ? "0" + bc.Entity.OrderDate.Hour.ToString() : bc.Entity.OrderDate.Hour.ToString())));
collection.Add(new JsonStringValue("OrderMinute", (bc.Entity.OrderDate.Minute < 10 ? "0" + bc.Entity.OrderDate.Minute.ToString() : bc.Entity.OrderDate.Minute.ToString())));
collection.Add(new JsonStringValue("CustneedTime", ParseStringForDate(bc.Entity.CustneedTime)));
collection.Add(new JsonStringValue("CustneedHour", (bc.Entity.CustneedTime.Hour < 10 ? "0" + bc.Entity.CustneedTime.Hour.ToString() : bc.Entity.CustneedTime.Hour.ToString())));
collection.Add(new JsonStringValue("CustneedMinute", (bc.Entity.CustneedTime.Minute < 10 ? "0" + bc.Entity.CustneedTime.Minute.ToString() : bc.Entity.CustneedTime.Minute.ToString())));
}
}
catch
{ flag = "2"; }
collection.Add(new JsonStringValue("type", "update"));
collection.Add(new JsonStringValue("flag", flag));
result = collection.ToString();
return(result);
}
private string imgaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
System.Text.StringBuilder sb = new System.Text.StringBuilder("");
string flag = "1";
try
{
Business.Order.BusinessWorkOrder bc = new project.Business.Order.BusinessWorkOrder();
bc.load(jp.getValue("id"));
Business.Base.BusinessFlowNode node = new Business.Base.BusinessFlowNode();
foreach (Entity.Base.EntityFlowNode it in node.GetFlowNodeListQuery(string.Empty, string.Empty, user.Entity.AccID))
{
Business.Order.BusinessWorkOrderImages bd = new Business.Order.BusinessWorkOrderImages();
if (bd.GetWorkOrderImagesCount(user.Entity.AccID, bc.Entity.OrderNo, it.NodeNo) > 0)
{
sb.Append("<div class=\"row cl\" style=\"border-bottom:solid 1px #AFD4E2; height:150px;\">");
sb.Append("<label class=\"form-label col-1\">" + it.NodeName + "</label>");
sb.Append("<div class=\"formControls col-8\">");
foreach (Entity.Order.EntityWorkOrderImages it1 in bd.GetWorkOrderImagesQuery(user.Entity.AccID, bc.Entity.OrderNo, it.NodeNo))
{
sb.Append("<img style=\"width:120px; height:120px; margin:10px;\" alt=\"\" src=\"../../upload/" + it1.Img + "\" />");
}
sb.Append("</div>");
sb.Append("</div>");
}
}
if (sb.ToString() == "")
{
sb.Append("<div class=\"row cl\">");
sb.Append("<div class=\"formControls col-8\" style=\"margin-left:30px;\">当前工单没有图片信息！</div>");
sb.Append("</div>");
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("liststr", sb.ToString()));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("type", "img"));
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());
}
