//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 }); }