private void btnResolve_InProduct_Click(object sender, EventArgs e)
{
try
{
string yearMonth = "";
择年月 frm = new 择年月();
if (frm.ShowDialog() == DialogResult.OK)
{
yearMonth = frm._Str_YearMonth;
}
else
{
return;
}
//DataTable tempTable = _Service_InProcutReport.GetAllInProductInfo(零件供应商耗用报表.Name, yearMonth);
//if (tempTable != null && tempTable.Rows.Count > 0)
//{
// if (MessageDialog.ShowEnquiryMessage("年月：【"+ yearMonth +"】,已存在记录，重复导入"))
// {
// }
//}
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
if (!dtTemp.Columns.Contains("图号型号"))
{
throw new Exception("文件无【图号型号】列名");
}
if (!dtTemp.Columns.Contains("物品名称"))
{
throw new Exception("文件无【物品名称】列名");
}
if (!dtTemp.Columns.Contains("规格"))
{
throw new Exception("文件无【规格】列名");
}
if (!dtTemp.Columns.Contains("耗用数"))
{
throw new Exception("文件无【耗用数】列名");
}
if (!dtTemp.Columns.Contains("供应商"))
{
throw new Exception("文件无【供应商】列名");
}
List <Bus_WorkShop_InProduct_Resolve> lstInfo = new List <Bus_WorkShop_InProduct_Resolve>();
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
int goodsID = UniversalFunction.GetGoodsID(dtTemp.Rows[i]["图号型号"].ToString(),
dtTemp.Rows[i]["物品名称"].ToString(), dtTemp.Rows[i]["规格"].ToString());
if (goodsID == 0)
{
throw new Exception(string.Format("第【{0}】行，图号型号：{1}，物品名称：{2}，规格：{3}，无法找到匹配的物品ID", i.ToString(),
dtTemp.Rows[i]["图号型号"].ToString(), dtTemp.Rows[i]["物品名称"].ToString(), dtTemp.Rows[i]["规格"].ToString()));
}
Bus_WorkShop_InProduct_Resolve tempInfo = new Bus_WorkShop_InProduct_Resolve();
tempInfo.F_Id = Guid.NewGuid().ToString();
tempInfo.GoodsID = goodsID;
tempInfo.Provider = dtTemp.Rows[i]["供应商"].ToString();
tempInfo.YearMonth = yearMonth;
decimal goodsCount = 0;
Decimal.TryParse(dtTemp.Rows[i]["耗用数"] == null ? "" : dtTemp.Rows[i]["耗用数"].ToString(), out goodsCount);
tempInfo.GoodsCount = goodsCount;
lstInfo.Add(tempInfo);
}
_Service_InProcutReport.InputResolveInfo(lstInfo);
MessageDialog.ShowPromptMessage("导入成功");
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}
private void btnSupplementary_InProduct_Click(object sender, EventArgs e)
{
try
{
string yearMonth = "";
择年月 frm = new 择年月();
if (frm.ShowDialog() == DialogResult.OK)
{
yearMonth = frm._Str_YearMonth;
}
else
{
return;
}
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
if (!dtTemp.Columns.Contains("图号型号"))
{
throw new Exception("文件无【图号型号】列名");
}
if (!dtTemp.Columns.Contains("物品名称"))
{
throw new Exception("文件无【物品名称】列名");
}
if (!dtTemp.Columns.Contains("规格"))
{
throw new Exception("文件无【规格】列名");
}
if (!dtTemp.Columns.Contains("实盘数"))
{
throw new Exception("文件无【实盘数】列名");
}
List <Bus_WorkShop_InProduct> lstInfo = new List <Bus_WorkShop_InProduct>();
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
int goodsID = UniversalFunction.GetGoodsID(dtTemp.Rows[i]["图号型号"].ToString(),
dtTemp.Rows[i]["物品名称"].ToString(), dtTemp.Rows[i]["规格"].ToString());
if (goodsID == 0)
{
throw new Exception(string.Format("第【{0}】行，图号型号：{1}，物品名称：{2}，规格：{3}，无法找到匹配的物品ID", i.ToString(),
dtTemp.Rows[i]["图号型号"].ToString(), dtTemp.Rows[i]["物品名称"].ToString(), dtTemp.Rows[i]["规格"].ToString()));
}
Bus_WorkShop_InProduct tempInfo = new Bus_WorkShop_InProduct();
tempInfo.F_Id = Guid.NewGuid().ToString();
tempInfo.GoodsID = goodsID;
tempInfo.YearMonth = yearMonth;
decimal goodsCount = 0;
Decimal.TryParse(dtTemp.Rows[i]["实盘数"] == null ? "" : dtTemp.Rows[i]["实盘数"].ToString(), out goodsCount);
tempInfo.NowBalanceCount = goodsCount;
lstInfo.Add(tempInfo);
}
_Service_InProcutReport.InputNowBalanceCount(lstInfo);
MessageDialog.ShowPromptMessage("导入成功");
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}