public void ImportMaterialNeed(bool isRollBack)
{
ShiftModelFacade shiftModelFacade = new ShiftModelFacade(this._DataProvider);
DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(this._DataProvider);
object[] objs = ConvertArrayListToObjectArray(_ImportDataTable);
object[] objDt = ConvertArrayListToObjectArray(_ImportDataTable);
try
{
_DataProvider.BeginTransaction();
if (objs != null && objDt != null)
{
for (int i = 0; i < objs.Length; i++)
{
try
{
MaterialReqStd materialReqStd = objs[i] as MaterialReqStd;
if (_MaterialFacade == null)
{
_MaterialFacade = new MaterialFacade(_DataProvider);
}
object objWorkPlan = _MaterialFacade.GetMaterialReqStd(materialReqStd.ItemCode, materialReqStd.OrganizationID);
if (objWorkPlan != null)
{
_DataProvider.Update(objs[i]);
_DataProvider.Update(objDt[i]);
}
else
{
_DataProvider.Insert(objDt[i]);
}
GridRecord row = _ImportGridRow[i] as GridRecord;
row.Items.FindItemByKey("ImportResult").Text = _LanguageComponent1.GetString("$CycleImport_Success");
row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
}
catch (Exception ex)
{
GridRecord row = _ImportGridRow[i] as GridRecord;
row.Items.FindItemByKey("ImportResult").Text = "导入失败";
row.Items.FindItemByKey("ImportResult").CssClass = "ForeColorRed";
this.ErrorArray.Add(ex);
}
}
}
_DataProvider.CommitTransaction();
}
catch (Exception ex)
{
_DataProvider.RollbackTransaction();
this.ErrorArray.Add(ex);
}
}
protected override object GetEditObject()
{
if (_Facade == null)
{
_Facade = new MaterialFacade(base.DataProvider);
}
MaterialReqStd MaterialReqStd = this._Facade.CreateNewMaterialReqStd();
MaterialReqStd.ItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeEdit.Text));
MaterialReqStd.RequestQTY = int.Parse(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtQTY.Text)));
MaterialReqStd.MaintainUser = this.GetUserCode();
MaterialReqStd.OrganizationID = int.Parse(this.DropDownListOrg.SelectedValue);
return(MaterialReqStd);
}
private void GetImportObjectType(ref object obj, string importType)
{
if (obj == null)
{
return;
}
DBDateTime now = FormatHelper.GetNowDBDateTime(this._DataProvider);
switch (importType.ToUpper())
{
case "WORKPLAN":
if (_MOFacade == null)
{
_MOFacade = new MOFacade(_DataProvider);
}
WorkPlan workPlan = obj as WorkPlan;
workPlan.MaintainUser = _UserCode;
workPlan.MaintainDate = now.DBDate;
workPlan.MaintainTime = now.DBTime;
workPlan.ActionStatus = WorkPlanActionStatus.WorkPlanActionStatus_Init;
workPlan.MaterialStatus = MaterialWarningStatus.MaterialWarningStatus_No;
object mo = _MOFacade.GetMO(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(workPlan.MoCode)));
workPlan.ItemCode = ((MO)mo).ItemCode;
break;
case "MATERIALNEED":
MaterialReqStd materialReqStd = obj as MaterialReqStd;
materialReqStd.MaintainUser = _UserCode;
materialReqStd.MaintainDate = now.DBDate;
materialReqStd.MaintainTime = now.DBTime;
break;
case "PLANWORKTIME":
PlanWorkTime planWorkTime = obj as PlanWorkTime;
planWorkTime.MaintainUser = _UserCode;
planWorkTime.MaintainDate = now.DBDate;
planWorkTime.MaintainTime = now.DBTime;
break;
default:
break;
}
}
protected void cmdImport_ServerClick(object sender, System.EventArgs e)
{
this._Facade = new MaterialFacade(this.DataProvider);
string errorItemCode = string.Empty;
string fileName = FileLoadProcess.UploadFile2ServerUploadFolder(this.Page, this.fileInit, null);
if (fileName == null)
{
WebInfoPublish.Publish(this, "$Error_UploadFileIsEmpty", this.languageComponent1);
return;
}
if (!fileName.ToLower().EndsWith(".csv"))
{
WebInfoPublish.Publish(this, "$Error_UploadFileTypeError", this.languageComponent1);
return;
}
this.ViewState.Add("UploadedFileName", fileName);
if (items == null)
{
items = GetAllItem();
if (items == null)
{
return;
}
}
if (items == null || items.Length == 0)
{
return;
}
int successNum = 0;
int failNum = 0;
string objValue = string.Empty;
string orgID = GlobalVariables.CurrentOrganizations.First().OrganizationID.ToString();
string mUser = GetUserCode();
for (int i = 0; i < items.Length; i++)
{
string itemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(GetFieldValue(items[i], "ITEMCODE")));
string requestQty = FormatHelper.CleanString(GetFieldValue(items[i], "RequestQTY"));
if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "OK", true) == 0 ||
string.Compare(GetFieldValue(items[i], "EAttribute1"), "Insert", true) == 0)
{
object obj = _Facade.GetMaterialReqStd(itemCode, int.Parse(orgID));
MaterialReqStd newMaterialReqStd = new MaterialReqStd();
if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "Insert", true) == 0)
{
newMaterialReqStd.ItemCode = itemCode;
newMaterialReqStd.OrganizationID = int.Parse(orgID);
newMaterialReqStd.RequestQTY = int.Parse(requestQty);
newMaterialReqStd.MaintainUser = mUser;
_Facade.AddMaterialReqStd(newMaterialReqStd);
}
else
{
MaterialReqStd objMaterialReqStd = obj as MaterialReqStd;
objValue = requestQty.ToString();
if (objValue != string.Empty)
{
objMaterialReqStd.RequestQTY = int.Parse(objValue);
}
objMaterialReqStd.MaintainUser = mUser;
if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "OK", true) == 0)
{
_Facade.UpdateMaterialReqStd(objMaterialReqStd);
}
}
successNum++;
}
else
{
failNum++;
errorItemCode += GetFieldValue(items[i], "ITEMCODE").ToString() + "\\n";;
}
}
errorItemCode = "\\n导入失败的料号：\\n" + errorItemCode;
string strMessage = "导入完成: 成功" + successNum + "笔, 失败" + failNum + "笔\\n" + errorItemCode;
string alertInfo =
string.Format("<script language=javascript>alert('{0}');</script>", strMessage);
if (!this.IsClientScriptBlockRegistered("ImportAlert"))
{
this.RegisterClientScriptBlock("ImportAlert", alertInfo);
}
items = null;
}
