/// <summary>
/// 更新一筆記錄
/// </summary>
/// <returns></returns>
public void UpdateSpecialOrder(SpecialOrderInfo sepcialOrder)
{
try
{
DeliveryRepository.UpdateSpecialOrder(sepcialOrder);
}
catch (Exception)
{
throw;
}
}
protected void btnAdd_ServerClick(Object sender, EventArgs e)
{
SpecialOrderInfo item = new SpecialOrderInfo();
SpecialOrderStatus OrderStatus = SpecialOrderStatus.Created;
item.Editor = this.HiddenUserName.Value;
item.FactoryPO = this.txtFactoryPO.Value.Trim();
item.Category = this.dCategory.Value.Trim();
item.AssetTag = this.txtAssetTag.Value.Trim();
item.Qty = Convert.ToInt32(this.txtQty.Value);
item.Status = OrderStatus;
item.Remark = this.txtRemark.Value.Trim();
try
{
if (iSpecialOrder.ExistSpecialOrder(item.FactoryPO))
{
showErrorMessage("[" + item.FactoryPO + "]:此FactoryPO已經存在...");
return;
}
else
{
iSpecialOrder.InsertSpecialOrder(item);
}
}
catch (FisException ex)
{
showErrorMessage(ex.mErrmsg);
return;
}
catch (Exception ex)
{
//show error
showErrorMessage(ex.Message);
return;
}
btnQuery_ServerClick(sender, e);
this.updatePanel1.Update();
ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "saveUpdate", "AddUpdateComplete('" + item.FactoryPO + "');DealHideWait();", true);
}
protected void btnOK_ServerClick(Object sender, EventArgs e)
{
string fullFileName = "";
try
{
DataTable dt = new DataTable();
if (dFileUpload.FileName.Trim() == "")
{
pmtMessage4 = this.GetLocalResourceObject(Pre + "_pmtMessage4").ToString();
showErrorMessage(pmtMessage4);
return;
}
if (dFileUpload.HasFile)
{
string fileName = dFileUpload.FileName;
string filePath = HttpContext.Current.Server.MapPath("~");
string path = filePath + "\\tmp";
//根下tmp目录存上传临时文件
MakeDirIfNotExist(path);
try
{
string extName = fileName.Substring(fileName.LastIndexOf("."));
//if (extName != ".xls")
//{
// pmtMessage2 = this.GetLocalResourceObject(Pre + "_pmtMessage2").ToString();
// showErrorMessage(pmtMessage2);
// return;
//}
////////////////////
Guid guid = System.Guid.NewGuid();
fullFileName = path + "\\" + guid.ToString() + extName;
dFileUpload.PostedFile.SaveAs(fullFileName);
dt = ExcelManager.getExcelSheetData(fullFileName);
}
catch
{
pmtMessage2 = this.GetLocalResourceObject(Pre + "_pmtMessage2").ToString();
showErrorMessage(pmtMessage2);
return;
}
int startRow = EXCEL_DATA_START_ROW;
int endRow = dt.Rows.Count + startRow;
if (endRow < startRow)
{
pmtMessage3 = this.GetLocalResourceObject(Pre + "_pmtMessage3").ToString();
showErrorMessage(pmtMessage3);
return;
}
List<SpecialOrderInfo> importList = new List<SpecialOrderInfo>();
int iRowsCountNPOI = dt.Rows.Count;
Dictionary<string, int> modelInList = new Dictionary<string, int>();
List<string> Assettag = new List<string>();
for (int iRow = 1; iRow < iRowsCountNPOI; iRow++)
{
int lineNum = iRow + EXCEL_DATA_START_ROW - 1;
string Value1NPOI = dt.Rows[iRow][0].ToString();
string Value2NPOI = dt.Rows[iRow][1].ToString();
string Value3NPOI = dt.Rows[iRow][2].ToString();
if (Value1NPOI == "" && Value2NPOI == "" && Value3NPOI == "")
{
continue;
}
if (Value1NPOI == "" || Value2NPOI == "" || Value3NPOI == "")
{
pmtMessage5= this.GetLocalResourceObject(Pre + "_pmtMessage5").ToString();
string tmpMessage = pmtMessage5 + " " + lineNum.ToString();
showErrorMessage(tmpMessage);
return;
}
int outValue;
if (Int32.TryParse(Value2NPOI, out outValue) != true)
{
pmtMessage5 = this.GetLocalResourceObject(Pre + "_pmtMessage5").ToString();
string tmpMessage = pmtMessage5 + " " + lineNum.ToString();
showErrorMessage(tmpMessage);
return;
}
if (modelInList.ContainsKey(Value1NPOI) == false)
{
modelInList.Add(Value1NPOI, outValue);
Assettag.Add(Value3NPOI);
}
else
{
//int currentNum = modelInList[Value1NPOI] + outValue;
//modelInList[Value1NPOI] = currentNum;
showErrorMessage("上傳資料重複：第"+ lineNum+"行，『" + Value1NPOI + "』");
return;
}
}
int count = 0;
foreach (KeyValuePair<string, int> kvp in modelInList)
{
SpecialOrderInfo item = new SpecialOrderInfo();
SpecialOrderStatus Status = SpecialOrderStatus.Created;
item.FactoryPO = kvp.Key;
item.Qty = kvp.Value;
item.AssetTag = Assettag[count];
item.Editor = this.HiddenUserName.Value;
item.Category = this.HidCategory.Value;
item.Status = Status;
item.Remark = "";
importList.Add(item);
count++;
}
if (importList.Count < 1)
{
pmtMessage3 = this.GetLocalResourceObject(Pre + "_pmtMessage3").ToString();
showErrorMessage(pmtMessage3);
return;
}
IList<string> List = iSpecialOrder.InsertSpecialOrder(importList);
string dataString="";
ListToString(List, ref dataString);
this.dUploadTableResultData.Value = dataString;
}
else
{
pmtMessage2 = this.GetLocalResourceObject(Pre + "_pmtMessage2").ToString();
showErrorMessage(pmtMessage2);
return;
}
}
catch (FisException ex)
{
showErrorMessage(ex.mErrmsg);
return;
}
catch (Exception ex)
{
//show error
showErrorMessage(ex.Message);
return;
}
finally
{
TryDeleteTempFile(fullFileName);
}
ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "OKComplete", "OKComplete();DealHideWait();", true);
}