public static void SavaAndCheckData(ref VVIRFQManager vvirfdetail, ref SystemMessages sysmgs,HttpRequestBase request) { Dictionary<string, object> data = new Dictionary<string, object>(); foreach(string key in request.Form.Keys) { if (!data.ContainsKey(key)) { data.Add(key,request.Form[key]); } } VVIRFQManager checkdata = new VVIRFQManager(); VVIRFQManager.CheckData(request, ref sysmgs); //检查数据通过则执行保存到数据库 if (sysmgs.isPass) { NameValueCollection Result = BI.SGP.BLL.Models.VVIRFQManager.Save(request); string ID = Result["ID"]; int vvirfqid = 0; Int32.TryParse(ID, out vvirfqid); //有MSG返回,表示保存失败 if (string.IsNullOrEmpty(Result["Mgs"]) == false) { sysmgs.isPass = false; sysmgs.MessageType = "Save Error"; sysmgs.Messages.Add("Save Error", Result["Mgs"]); } else { sysmgs.isPass = true; sysmgs.MessageType = "Save Success"; //sysmgs.Messages.Add("Save Success", Result["Mgs"]); } if (vvirfqid > 0) { vvirfdetail = VVIRFQManager.GetDetailById(vvirfqid); } } else // 检查数据不通过 { sysmgs.MessageType = "Error"; } }
//public static int GetRFQID(string vvinumber) //{ // string strSql = "SELECT RFQID FROM V_SGPForVVI WHERE RFQID = @VVINumber"; // int RFQID = 0; // RFQID = (int)DbHelperSQL.GetSingle(strSql, new SqlParameter("@VVINumber", vvinumber)); // return RFQID; //} private static void FillData(VVIRFQManager VVIRFQData, DataRow dr) { Type tp = typeof(VVIRFQManager); for (int i = 0; i < dr.Table.Columns.Count; i++) { string propertyName = dr.Table.Columns[i].ColumnName; PropertyInfo propertyinfo = tp.GetProperty(propertyName); if (propertyinfo != null && dr[i] != DBNull.Value) { propertyinfo.SetValue(VVIRFQData, dr[i], null); } } }
public static List<VVIRFQManager> GetDetail(int ID) { string strSql = "SELECT * FROM V_SGPForVVI WHERE ID = @ID"; DataTable dt = DbHelperSQL.Query(strSql, new SqlParameter("@ID", ID)).Tables[0]; List<VVIRFQManager> DetailData = new List<VVIRFQManager>(); if (dt.Rows.Count == 0) { return DetailData; } foreach (DataRow dr in dt.Rows) { VVIRFQManager Detail = new VVIRFQManager(); for (int i = 0; i < dr.Table.Columns.Count; i++) { FillData(Detail, dr); } DetailData.Add(Detail); } return DetailData; }
/// <summary> /// Update RFQ VVI Value /// </summary> /// <returns></returns> public ActionResult SaveVVIDetailData() { VVIRFQManager vvirfqdetail = new VVIRFQManager(); SystemMessages sysmgs = new SystemMessages(); VVIRFQManager.SavaAndCheckData(ref vvirfqdetail, ref sysmgs, Request); //WFTemplate wf = new WFTemplate("VVIWF",vvirfqdetail.ID.Value); //if(wf.CurrentActivity.ID==104) //{ // VVIRFQManager.UpdateOperationForPostBack(vvirfqdetail.ID.Value.ToString()); //} string html = ""; if (sysmgs.isPass == true) { html = SGP.BLL.UIManager.VVIUIManager.GenrateVVIRFQDetail(vvirfqdetail, vvirfqdetail.ID.ToString(), "Edit"); } // string aa = Request.Form["Number"]; var returnData = new { HTML = html, ID = vvirfqdetail.ID, SysMsg = sysmgs }; return Json(returnData, JsonRequestBehavior.AllowGet); }
/// <summary> /// Update RFQ VVI Value & Submit RFQ VVI to next stage /// </summary> /// <returns></returns> public ActionResult RFQVVISaveAndSubmit() { VVIRFQManager vvirfdetail = new VVIRFQManager(); SystemMessages sysmgs = new SystemMessages(); VVIRFQManager.SavaAndCheckData(ref vvirfdetail, ref sysmgs, Request); WFTemplate wfTemplate = new WFTemplate("VVIWF", vvirfdetail.ID.Value); if (sysmgs.isPass) { try { sysmgs.Merge(wfTemplate.Run()); } catch (Exception ex) { sysmgs.isPass = false; sysmgs.Messages.Add("System Exception", ex.Message); } } string[] WFIDS = { "104" }; string PDFDIV = ""; if (WFIDS.Contains(wfTemplate.CurrentActivity.ID.ToString())) { if (wfTemplate.CurrentActivity.ID == 104) { VVIRFQManager.UpdateOperationForPostBack(vvirfdetail.ID.Value.ToString()); } PDFDIV = @"<button id=""btnDownlPDF"" class=""btn btn-purple"" onclick=""return downloadpdf();"" > Download PDF <i class=""icon-file small-30""></i> </button>"; } var returnData = new { HTML = SGP.BLL.UIManager.UIManager.GenrateModelforRFQVVIDetail(vvirfdetail, wfTemplate.CurrentActivity.ID.ToString()), RFQNumber = vvirfdetail.Number, RFQID = vvirfdetail.RFQID, ID = vvirfdetail.ID, SysMsg = sysmgs, PDF = PDFDIV }; return Json(returnData, JsonRequestBehavior.AllowGet); }
/// <summary> /// RFQ VVI skip stage /// </summary> /// <returns></returns> public ActionResult RFQVVISaveAndSkip() { VVIRFQManager vvirfdetail = new VVIRFQManager(); SystemMessages sysmgs = new SystemMessages(); VVIRFQManager.SavaAndCheckData(ref vvirfdetail, ref sysmgs, Request); WFTemplate wfTemplate = new WFTemplate("VVIWF", vvirfdetail.ID); if (sysmgs.isPass) { string toActivityId = Request.Form["toActivityId"]; int toActId = 0; int.TryParse(toActivityId, out toActId); if (toActId > 0) { try { sysmgs.Merge(wfTemplate.Skip(toActId)); } catch (Exception ex) { sysmgs.isPass = false; sysmgs.Messages.Add("System Exception", ex.Message); } } } string[] WFIDS = { "3", "4", "5", "6", "7" }; string PDFDIV = ""; if (WFIDS.Contains(wfTemplate.CurrentActivity.ID.ToString())) { PDFDIV = @"<button id=""btnDownlPDF"" class=""btn btn-purple"" onclick=""return downloadpdf();"" > Download PDF <i class=""icon-file small-30""></i> </button>"; } var returnData = new { HTML = SGP.BLL.UIManager.UIManager.GenrateModelforRFQVVIDetail(vvirfdetail, wfTemplate.CurrentActivity.ID.ToString()), RFQNumber = vvirfdetail.Number, RFQID = vvirfdetail.RFQID, ID = vvirfdetail.ID, SysMsg = sysmgs, PDF = PDFDIV }; return Json(returnData, JsonRequestBehavior.AllowGet); }
//public ActionResult AssignSupplier() //{ // SystemMessages sysmgs = new SystemMessages(); // string vvirfqid = string.Empty; // sysmgs.isPass = true; // try // { // //curd.Save(); // string number = Request.Form["Number"]; // string suppiler = Request.Form["SupplierCode"]; // string VVINumber = number + "-" + suppiler; // if (VVIRFQManager.CheckVVINumberExists(VVINumber)) // { // sysmgs.isPass = false; // sysmgs.MessageType = "Aleady Assgined"; // sysmgs.Messages.Add("Aleady Assgined", "Aleady Assgined"); // } // else // { // NameValueCollection Result = VVIRFQManager.AssignSuppliers(Request); // if (string.IsNullOrEmpty(Result["Mgs"]) == false) // { // sysmgs.isPass = false; // sysmgs.MessageType = "Assgin Error"; // sysmgs.Messages.Add("Assgin Error", Result["Mgs"]); // } // else // { // sysmgs.isPass = true; // sysmgs.MessageType = "Assgin Success"; // //sysmgs.Messages.Add("Save Success", Result["Mgs"]); // } // } // } // catch (Exception ex) // { // sysmgs.isPass = false; // sysmgs.MessageType = "Assgin Error"; // sysmgs.Messages.Add("Assgin Error", ex.ToString()); // } // var returnData = new // { // SysMsg = sysmgs // }; // return Json(returnData, JsonRequestBehavior.AllowGet); //} public ActionResult PostBacKToGP() { VVIRFQManager vvirfqdetail = new VVIRFQManager(); SystemMessages sysmgs = new SystemMessages(); VVIRFQManager.SavaAndCheckData(ref vvirfqdetail, ref sysmgs, Request); string html = ""; if (sysmgs.isPass == true) { html = SGP.BLL.UIManager.VVIUIManager.GenrateVVIRFQDetail(vvirfqdetail, vvirfqdetail.ID.ToString(), "Edit"); } // string aa = Request.Form["Number"]; var returnData = new { HTML = html, ID = vvirfqdetail.ID, SysMsg = sysmgs }; return Json(returnData, JsonRequestBehavior.AllowGet); }