public ActionResult InstanceNew(SnapProdLineEx prodLineExInstance)
{
try
{
if (prodLineExInstance.DateType == com.Sconit.CodeMaster.TimeUnit.Day)
{
ModelState.Remove("DateIndex");
}
if (ModelState.IsValid)
{
if (prodLineExInstance.DateType == com.Sconit.CodeMaster.TimeUnit.Day)
{
prodLineExInstance.DateIndex = Convert.ToDateTime(prodLineExInstance.DateIndex).ToString("yyyy-MM-dd");
}
if (this.genericMgr.FindAll<long>("select count(*) from SnapProdLineEx as p where p.ProductLine=? and p.Item=? and p.DateIndex=? and p.DateType=? and p.SnapTime=? ",
new object[] { prodLineExInstance.ProductLine, prodLineExInstance.Item, prodLineExInstance.DateIndex, prodLineExInstance.DateType, prodLineExInstance.SnapTime })[0] > 0)
{
base.SaveErrorMessage(string.Format(Resources.EXT.ControllerLan.Con_AlreadyExistsSameFlowItemCodePlanTypeTypeTimeIndexSnapVersion, prodLineExInstance.ProductLine, prodLineExInstance.Item, prodLineExInstance.DateType, prodLineExInstance.DateIndex, prodLineExInstance.SnapTime));
return View(prodLineExInstance);
}
prodLineExInstance.Region = genericMgr.FindById<FlowMaster>(prodLineExInstance.ProductLine).PartyFrom;
//prodLineExInstance.IsManualCreate = true;
this.genericMgr.CreateWithTrim(prodLineExInstance);
SaveSuccessMessage(Resources.MRP.ProdLineExInstance.ProdLineExInstance_Added);
string productLine = prodLineExInstance.ProductLine;
string item = prodLineExInstance.Item;
string dateIndex = prodLineExInstance.DateIndex;
int dateType = (int)prodLineExInstance.DateType;
DateTime snapTime = prodLineExInstance.SnapTime;
IList<object> iList;
string sql = "select top 1 id from MRP_SnapProdLineEx where productLine=? and Item=? and DateType=? and SnapTime=? and dateIndex=? ";
object[] para = new object[] { productLine, item, dateIndex, dateType, snapTime, dateIndex };
iList = queryMgr.FindAllWithNativeSql<object>(sql, para);
int id = (int)iList.FirstOrDefault();
return new RedirectToRouteResult(new RouteValueDictionary { { "action", "InstanceEdit" }, { "controller", "MrpSnapProdLineEx" },
{ "id", id }});
}
}
catch (Exception e)
{
if (e is CommitResourceException)
{
SaveErrorMessage(Resources.EXT.ControllerLan.Con_AlreadyExitsSameData);
}
}
return View(prodLineExInstance);
}
public ActionResult InstanceEdit(SnapProdLineEx prodLineExInstance)
{
if (ModelState.IsValid)
{
prodLineExInstance.Region = genericMgr.FindById<FlowMaster>(prodLineExInstance.ProductLine).PartyFrom;
prodLineExInstance.SnapTime = genericMgr.FindById<SnapProdLineEx>(prodLineExInstance.Id).SnapTime;
this.genericMgr.UpdateWithTrim(prodLineExInstance);
SaveSuccessMessage(Resources.MRP.ProdLineExInstance.ProdLineExInstance_Updated);
}
return View(prodLineExInstance);
}
