//BillingType:0普通账单，1特殊账单,2其他賬單
public ActionResult SubmitFlow(int BillingType,string billids,List<string[]> dataListFromTable)
{
//billid 从Invoice页面传入
//int[] arrbillid =new int[2]{1,2};
string[] arrbillid = billids.Split(',');
try
{
TugDataEntities db = new TugDataEntities();
foreach (string sidx in arrbillid)
{
int idx = Util.toint(sidx);
Billing billobj = db.Billing.Where(u => u.IDX == idx).FirstOrDefault();
if (billobj == null)
{
continue ;
//return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
int newTimesNo =Util.toint(billobj.TimesNo) + 1; //第几次流程
//将流程信息写入Flow表
#region
string mark = Util.GetSequence("F");
for(int i=0;i<dataListFromTable.Count-1;i++)//最后一行空行
{
TugDataModel.Flow obj = new Flow();
obj.BillingID = idx;
obj.MarkID = newTimesNo;
obj.Phase = i;
obj.Task =dataListFromTable[i][0] ;
string Name11=dataListFromTable[i][1];
UserInfor us1 = db.UserInfor.Where(u => u.Name1 == Name11).FirstOrDefault();
obj.FlowUserID = us1.IDX;
obj.StDate = dataListFromTable[i][2];
obj.EndDate =dataListFromTable[i][3] ;
obj.System = "Tug";
obj.OwnerID = -1;
obj.CreateDate = obj.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
obj.UserID = Session.GetDataFromSession<int>("userid");
//obj.State =0;
obj.Sign =mark;
//obj.UserDefinedCol1 = "";
//obj.UserDefinedCol2 = "";
//obj.UserDefinedCol3 = "";
//obj.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"] != "")
// obj.UserDefinedCol5 = Util.toint(Request.Form["UserDefinedCol5"]);
//obj.UserDefinedCol6 =;
//obj.UserDefinedCol7 =;
//obj.UserDefinedCol8 =;
//obj.UserDefinedCol9 = "";
//obj.UserDefinedCol10 = "";
obj = db.Flow.Add(obj);
db.SaveChanges();
}
#endregion
//将提交审核写入Approve
#region
TugDataModel.Approve objapp = new Approve();
objapp.BillingID = idx;
objapp.FlowMark = newTimesNo;
objapp.Phase = 0;
objapp.Task = dataListFromTable[0][0];
objapp.Accept=2;
objapp.Remark="";
string Name12 = dataListFromTable[0][1];
UserInfor us2 = db.UserInfor.Where(u => u.Name1 == Name12).FirstOrDefault();
objapp.PersonID = us2.IDX;
objapp.System="Tug";
objapp.OwnerID=-1;
objapp.CreateDate = objapp.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
objapp.UserID = Session.GetDataFromSession<int>("userid");
objapp = db.Approve.Add(objapp);
db.SaveChanges();
#endregion
//更新Billing表的流程信息
#region
billobj.TimesNo = newTimesNo;
billobj.Status = dataListFromTable[1][0];
billobj.Phase = 1;
db.Entry(billobj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
#endregion
//更新orderinfor、orderservice表中的HasInFlow
//OrderLogic.UpdateHasInFlow(idx, "是");
if (BillingType!=2) FinanceLogic.SetOrderServiceFlowingStatus(BillingType, idx, "是");
}
}
catch (Exception exp)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
public ActionResult FlowAddEdit()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.Flow obj = new Flow();
obj.BillingID = -1;
obj.MarkID = -1;
obj.Phase = -1;
obj.Task = Request.Form["Task"];
obj.FlowUserID = Util.toint(Request.Form["FlowUserID"]);
obj.StDate = Request.Form["StDate"];
obj.EndDate = Request.Form["EndDate"];
obj.System = "Billing";
obj.OwnerID = -1;
obj.CreateDate = obj.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
obj.UserID = Session.GetDataFromSession<int>("userid");
obj.State = -1;
obj.Sign = "";
//obj.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
//obj.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
//obj.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
//obj.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
//if (Request.Form["UserDefinedCol5"] != "")
// obj.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
//if (Request.Form["UserDefinedCol6"] != "")
// obj.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
//if (Request.Form["UserDefinedCol7"] != "")
// obj.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
//if (Request.Form["UserDefinedCol8"] != "")
// obj.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
//obj.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
//obj.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
obj = db.Flow.Add(obj);
db.SaveChanges();
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
}
#endregion Add
#region Edit
if (Request.Form["oper"].Equals("edit"))
{
try
{
TugDataEntities db = new TugDataEntities();
int idx = Util.toint(Request.Form["IDX"]);
Flow obj = db.Flow.Where(u => u.IDX == idx).FirstOrDefault();
if (obj == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
obj.BillingID = -1;
obj.MarkID = -1;
obj.Phase = -1;
obj.Task = Request.Form["Task"];
obj.FlowUserID = Util.toint(Request.Form["FlowUserID"]);
obj.StDate = Request.Form["StDate"];
obj.EndDate = Request.Form["EndDate"];
obj.System = "Billing";
obj.OwnerID = -1;
obj.CreateDate = obj.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
obj.UserID = Session.GetDataFromSession<int>("userid");
obj.State = -1;
obj.Sign = "";
obj.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
obj.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
obj.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
obj.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
obj.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
obj.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
obj.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
obj.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
obj.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
obj.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception exp)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
