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