private void btnInput_Click(object sender, EventArgs e)
{
try
{
if (MessageDialog.ShowEnquiryMessage("请确认所导入的EXCEL文件第一列为所需要导入的编号信息且列名为【旧箱箱号】，第二列为所需要导入的编号信息且列名为【新箱箱号】") == DialogResult.No)
{
return;
}
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
else
{
foreach (DataRow dr in dtTemp.Rows)
{
if (dr[0].ToString().Trim().Length != 0 && dr[1].ToString().Trim().Length != 0)
{
txtOldCVTNumber.Text = dr[0].ToString();
txtNewCVTNumber.Text = dr[1].ToString();
btnAdd_Click(sender, e);
}
}
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}
private void 导入EXCELToolStripMenuItem_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_err);
return;
}
if (dtTemp.Rows.Count == 0 ||
dtTemp.Columns[0].ColumnName != "物品ID" ||
dtTemp.Columns[1].ColumnName != "图号型号" ||
dtTemp.Columns[2].ColumnName != "物品名称" ||
dtTemp.Columns[3].ColumnName != "规格" ||
dtTemp.Columns[4].ColumnName != "物品实际平均价")
{
MessageDialog.ShowPromptMessage(string.Format("{0} 中没有包含所需的信息，无法导入！",
openFileDialog1.FileName));
}
else
{
m_blFlag = true;
dataGridView1.DataSource = dtTemp;
MessageDialog.ShowPromptMessage("导入成功请点击【物品平均价校对】进行校对");
}
}
private void btnInExcel_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_strError);
return;
}
if (CheckTable(dtTemp))
{
if (!m_serverCVTCustomer.BatchInsertCVTCustomerInformation(dtTemp, out m_strError))
{
MessageDialog.ShowPromptMessage(m_strError);
return;
}
else
{
string strMessage = "";
if (m_strError != null)
{
strMessage = "\n以下车架号的记录日期格式不正确"
+ m_strError + "\n系统已默认为【2099-12-31】，请自行修改";
}
MessageDialog.ShowPromptMessage("导入成功" + strMessage);
}
}
ClearDate();
RefreshDataGirdView(m_serverCVTCustomer.GetCVTCustomerInformation());
}
private void 导入toolStripButton_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(error);
return;
}
if (CheckTable(dtTemp))
{
if (!m_personnerServer.InsertPersonnelArchiveInfo(dtTemp, out error))
{
MessageDialog.ShowPromptMessage(error);
return;
}
else
{
MessageDialog.ShowPromptMessage("导入成功!");
}
}
RefreshControl();
}
private void btnInExcel_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
MessageDialog.ShowPromptMessage("文件无效，转换失败");
return;
}
if (!dtTemp.Columns.Contains("图号型号"))
{
MessageDialog.ShowPromptMessage("无【图号型号】列");
return;
}
if (!dtTemp.Columns.Contains("物品名称"))
{
MessageDialog.ShowPromptMessage("无【物品名称】列");
return;
}
if (!dtTemp.Columns.Contains("规格"))
{
MessageDialog.ShowPromptMessage("无【规格】列");
return;
}
if (!dtTemp.Columns.Contains("基数"))
{
MessageDialog.ShowPromptMessage("无【基数】列");
return;
}
if (!dtTemp.Columns.Contains("总成型号"))
{
MessageDialog.ShowPromptMessage("无【总成型号】列");
return;
}
if (!dtTemp.Columns.Contains("安全库存"))
{
MessageDialog.ShowPromptMessage("无【安全库存】列");
return;
}
try
{
m_serverCBOM.BatchInsertCGBom(dtTemp);
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
RefreshData();
MessageDialog.ShowPromptMessage("导入完成");
}
private void btn_QuestionBank_Input_Click(object sender, EventArgs e)
{
try
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
if (!dtTemp.Columns.Contains("考题ID"))
{
MessageDialog.ShowPromptMessage("文件中无【考题ID】列");
return;
}
if (!dtTemp.Columns.Contains("考题类型"))
{
MessageDialog.ShowPromptMessage("文件中无【考题类型】列");
return;
}
if (!dtTemp.Columns.Contains("考题内容"))
{
MessageDialog.ShowPromptMessage("文件中无【考题内容】列");
return;
}
if (!dtTemp.Columns.Contains("选项"))
{
MessageDialog.ShowPromptMessage("文件中无【选项】列");
return;
}
if (!dtTemp.Columns.Contains("选项内容"))
{
MessageDialog.ShowPromptMessage("文件中无【选项内容】列");
return;
}
if (!dtTemp.Columns.Contains("答案"))
{
MessageDialog.ShowPromptMessage("文件中无【答案】列");
return;
}
_ServiceBasicInfo.InputQuestionsBank(_CourseInfo.ID, dtTemp);
MessageDialog.ShowPromptMessage("导入成功");
dgv_QuestionBank.DataSource =
new BindingCollection <View_HR_Train_QuestionBank>(_ServiceBasicInfo.GetListQuestionBank(_CourseInfo.ID));
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
if (txtClient.Text == "")
{
MessageDialog.ShowPromptMessage("请选择客户后再进行此操作！");
return;
}
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_error);
return;
}
if (CheckTable(dtTemp))
{
dtTemp.Columns.Add("物品ID");
dtTemp.Columns.Add("客户零件代码");
dtTemp.Columns.Add("客户零件名称");
DataRow dr = dtTemp.NewRow();
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
DataRow row = dtTemp.Rows[i];
row["物品ID"] = UniversalFunction.GetGoodsID(row["图号型号"].ToString(), row["物品名称"].ToString(), row["规格"].ToString());
if (Convert.ToInt32(row["物品ID"]) == 0)
{
MessageDialog.ShowPromptMessage("第" + i + "行零件有误，请确认！");
return;
}
DataTable dt = m_salesOrderServer.GetCommunicate(txtClient.Tag.ToString(),
Convert.ToInt32(row["物品ID"]));
if (dt != null && dt.Rows.Count > 0)
{
row["客户零件代码"] = m_salesOrderServer.GetCommunicate(txtClient.Tag.ToString(),
Convert.ToInt32(row["物品ID"])).Rows[0]["CommunicateGoodsCode"];
row["客户零件名称"] = m_salesOrderServer.GetCommunicate(txtClient.Tag.ToString(),
Convert.ToInt32(row["物品ID"])).Rows[0]["CommunicateGoodsName"];
}
else
{
row["客户零件代码"] = "";
row["客户零件名称"] = "";
}
}
dgvPartList.DataSource = dtTemp;
}
}
private void btnIn_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_strErr);
return;
}
if (dtTemp.Rows.Count == 0 ||
dtTemp.Columns[0].ColumnName != "物品ID" ||
dtTemp.Columns[1].ColumnName != "图号型号" ||
dtTemp.Columns[2].ColumnName != "物品名称" ||
dtTemp.Columns[3].ColumnName != "规格" ||
dtTemp.Columns[4].ColumnName != "单位" ||
dtTemp.Columns[5].ColumnName != "单价")
{
MessageDialog.ShowPromptMessage(string.Format("{0} 中没有包含所需的信息，无法导入！",
openFileDialog1.FileName));
}
else
{
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
View_F_GoodsPlanCost tempGoodsLnq = UniversalFunction.GetGoodsInfo(dtTemp.Rows[i]["图号型号"].ToString(),
dtTemp.Rows[i]["物品名称"].ToString(), dtTemp.Rows[i]["规格"].ToString());
if (tempGoodsLnq != null)
{
dtTemp.Rows[i]["物品ID"] = tempGoodsLnq.序号;
dtTemp.Rows[i]["单位"] = tempGoodsLnq.单位;
}
else
{
dtTemp.Rows.RemoveAt(i);
}
}
if (!m_serverThreePacketsOfTheRepairBill.UpdateAllGoodsUnitPrice(
MessageBox.Show("是否删除原有记录", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes? true : false,
dtTemp, out m_strErr))
{
MessageDialog.ShowPromptMessage(m_strErr);
}
dataGridView1.DataSource = m_serverThreePacketsOfTheRepairBill.GetGoodsUnitPriceInfo();
userControlDataLocalizer1.Init(dataGridView1, this.Name,
UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));
MessageDialog.ShowPromptMessage("导入成功");
}
}
private void btnInputExcel_Click(object sender, EventArgs e)
{
try
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
if (!dtTemp.Columns.Contains("图号型号"))
{
MessageDialog.ShowPromptMessage("文件无【图号型号】列名");
return;
}
if (!dtTemp.Columns.Contains("物品名称"))
{
MessageDialog.ShowPromptMessage("文件无【物品名称】列名");
return;
}
if (!dtTemp.Columns.Contains("规格"))
{
MessageDialog.ShowPromptMessage("文件无【规格】列名");
return;
}
if (!dtTemp.Columns.Contains("批次号"))
{
MessageDialog.ShowPromptMessage("文件无【批次号】列名");
return;
}
if (!dtTemp.Columns.Contains("数量"))
{
MessageDialog.ShowPromptMessage("文件无【数量】列名");
return;
}
m_goodsServer.InsertInfoExcel(m_billNo, dtTemp);
MessageDialog.ShowPromptMessage("导入成功");
m_queryGoodsInfo = m_goodsServer.GetGoods(m_billNo);
RefreshDataGridView(m_queryGoodsInfo);
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}
private void btnImport_Click(object sender, EventArgs e)
{
if (openFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1.OpenFile());
if (dtTemp == null)
{
MessageDialog.ShowPromptMessage(m_err);
return;
}
else
{
if (!dtTemp.Columns.Contains("零件编码") ||
!dtTemp.Columns.Contains("零件名称") ||
!dtTemp.Columns.Contains("规格") ||
!dtTemp.Columns.Contains("基数"))
{
MessageDialog.ShowPromptMessage("表中的列未包含【零件编码】，【零件名称】，【规格】，【基数】，请重新核对");
}
DataTable sourceTable = ((DataTable)Dgv_Main.DataSource).Clone();
foreach (DataRow dr in dtTemp.Rows)
{
if (dr["零件编码"].ToString().Trim().Length > 0 ||
dr["零件名称"].ToString().Trim().Length > 0)
{
DataRow tempRow = sourceTable.NewRow();
tempRow["产品编码"] = tbsEditionName.Tag.ToString();
tempRow["父级编码"] = "";
tempRow["零件编码"] = dr["零件编码"];
tempRow["零件名称"] = dr["零件名称"];
tempRow["规格"] = dr["规格"];
tempRow["基数"] = dr["基数"];
tempRow["别名"] = "";
tempRow["顺序位置"] = 0;
sourceTable.Rows.Add(tempRow);
}
}
Dgv_Main.DataSource = sourceTable;
}
}
private void 导入toolStripButton_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_error);
return;
}
if (!m_providerServer.InsertProvidersInfo(dtTemp, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
}
}
private void btnInExcel_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_err);
return;
}
if (dtTemp.Rows.Count == 0 ||
!dtTemp.Columns.Contains("新箱号") ||
!dtTemp.Columns.Contains("旧箱号") ||
!dtTemp.Columns.Contains("新箱型号") ||
!dtTemp.Columns.Contains("旧箱型号") ||
!dtTemp.Columns.Contains("备注"))
{
MessageDialog.ShowPromptMessage(string.Format("{0} 中没有包含所需的信息，无法导入！",
openFileDialog1.FileName));
}
else
{
string strBatchNo = m_sell.GetMatchingBillID();
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
m_lnqNewAndOld.BatchNo = strBatchNo;
m_lnqNewAndOld.NewProductCode = dtTemp.Rows[i]["新箱号"].ToString();
m_lnqNewAndOld.OldProductCode = dtTemp.Rows[i]["旧箱号"].ToString();
m_lnqNewAndOld.NewEdition = dtTemp.Rows[i]["新箱型号"].ToString();
m_lnqNewAndOld.OldEdition = dtTemp.Rows[i]["旧箱型号"].ToString();
m_lnqNewAndOld.Remark = dtTemp.Rows[i]["备注"].ToString();
if (m_sell.IsSameProductMatchingInfo(m_lnqNewAndOld))
{
if (!m_sell.AddMatchingInfo(m_lnqNewAndOld, out m_err))
{
MessageDialog.ShowPromptMessage(m_err);
}
}
}
MessageDialog.ShowPromptMessage("导入成功!");
}
dataGridView1.DataSource = m_sell.GetProductCodeMatchingInfo();
dataGridView1.Columns["序号"].Visible = false;
}
private void btn变更允许调休小时数_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog dialog = new OpenFileDialog();
DataTable dt = ExcelHelperP.RenderFromExcel(dialog);
if (dt != null)
{
List <HR_AttendanceSummary> lstSummary = new List <HR_AttendanceSummary>();
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((dt.Rows[i]["工号"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dt.Rows[i]["工号"].ToString())) ||
(dt.Rows[i]["年份"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dt.Rows[i]["年份"].ToString())) ||
(dt.Rows[i]["月份"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dt.Rows[i]["月份"].ToString())) ||
(dt.Rows[i]["允许调休小时数"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dt.Rows[i]["允许调休小时数"].ToString())))
{
throw new Exception("第" + (i + 2).ToString() + "行记录存在【空数据】");
}
if (UniversalFunction.GetPersonnelInfo(dt.Rows[i]["工号"].ToString()) == null)
{
throw new Exception("【工号】：" + dt.Rows[i]["工号"].ToString() + "， 不存在");
}
HR_AttendanceSummary summary = new HR_AttendanceSummary();
summary.WorkID = dt.Rows[i]["工号"].ToString();
summary.Year = Convert.ToInt32(dt.Rows[i]["年份"]);
summary.Month = Convert.ToInt32(dt.Rows[i]["月份"]);
summary.AllowMobileVacationHours = Convert.ToDouble(dt.Rows[i]["允许调休小时数"]);
lstSummary.Add(summary);
}
m_attendanceServer.UpdateAllowMobileHours(lstSummary);
MessageDialog.ShowPromptMessage("修改【允许调休小时数】成功");
}
}
catch (Exception exce)
{
MessageDialog.ShowErrorMessage(exce.Message);
}
}
private void btnImport_Click(object sender, EventArgs e)
{
if (txtFileName.Text.Trim().Length > 0)
{
if (System.IO.File.Exists(txtFileName.Text))
{
openFileDialog1.FileName = txtFileName.Text;
}
else
{
MessageDialog.ShowPromptMessage("不存在的数据文件：" + txtFileName.Text);
return;
}
}
if (GlobalObject.GeneralFunction.IsNullOrEmpty(openFileDialog1.FileName))
{
MessageDialog.ShowPromptMessage("请选择要导入的文件后再进行此操作！");
return;
}
try
{
Data = ExcelHelperP.RenderFromExcel(openFileDialog1.OpenFile());
if (Data != null || Data.Rows.Count == 0 ||
Data.Columns[0].ColumnName != "液力变矩器型号" || Data.Columns[4].ColumnName != "变矩器出厂编号")
{
MessageDialog.ShowPromptMessage(string.Format("{0} 中没有包含所需的信息，无法导入！", openFileDialog1.FileName));
return;
}
Complete = true;
this.DialogResult = DialogResult.OK;
}
catch (Exception exce)
{
MessageDialog.ShowErrorMessage(exce.Message);
}
}
private void btnIn_Click(object sender, EventArgs e)
{
主机厂报表操作指示窗体 form = new 主机厂报表操作指示窗体();
form.ShowDialog();
if (!form.BlFlag)
{
return;
}
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_strErr);
return;
}
if (dtTemp.Rows.Count == 0 ||
dtTemp.Columns[0].ColumnName != "图号型号" ||
dtTemp.Columns[1].ColumnName != "物品名称" ||
dtTemp.Columns[2].ColumnName != "协议单价" ||
dtTemp.Columns[3].ColumnName != "实挂数量")
{
MessageDialog.ShowPromptMessage(string.Format("{0} 中没有包含所需的信息，无法导入！",
openFileDialog1.FileName));
}
else
{
if (!m_serverComReportBill.UpdateSignTheBill(form.StrCommunicate, dtTemp, out m_strErr))
{
MessageDialog.ShowPromptMessage(m_strErr);
}
else
{
MessageDialog.ShowPromptMessage("导入成功");
}
}
}
private void 导入toolStripButton_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_error);
return;
}
if (CheckTable(dtTemp))
{
if (!m_postServer.AddDeptPost(dtTemp, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
return;
}
else
{
MessageDialog.ShowPromptMessage("导入成功!");
}
}
}
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;
}
}
private void btnLoadExcel_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
System.Data.DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null || dtTemp.Rows.Count == 0 || dtTemp.Columns.Count < 8 || dtTemp.Rows.Count != 39)
{
MessageDialog.ShowPromptMessage("加载的EXCEL文件数据格式错误");
return;
}
string error = null;
string productCode = dtTemp.Rows[0][3].ToString();
string cvtNumber = dtTemp.Rows[0][6].ToString();
if (!ServerModule.ServerModuleFactory.GetServerModule <IProductCodeServer>().VerifyProductCodesInfo(
productCode, cvtNumber, GlobalObject.CE_BarCodeType.内部钢印码, out error))
{
MessageDialog.ShowErrorMessage(error);
return;
}
string 试验设备名称 = dtTemp.Rows[1][3].ToString();
string 油品 = "出光1";
string 试验结果 = dtTemp.Rows[37][5].ToString();
IPersonnelArchiveServer personnelInfoServer = Service_Peripheral_HR.ServerModuleFactory.GetServerModule <IPersonnelArchiveServer>();
string 装配员工号 = personnelInfoServer.GetPersonnelViewInfoByName(dtTemp.Rows[38][4].ToString());
if (GlobalObject.GeneralFunction.IsNullOrEmpty(装配员工号))
{
MessageDialog.ShowPromptMessage("文件中的装配员姓名在公司不唯一，无法获取到员工编号");
return;
}
string 线员工号 = personnelInfoServer.GetPersonnelViewInfoByName(dtTemp.Rows[38][7].ToString());
if (GlobalObject.GeneralFunction.IsNullOrEmpty(线员工号))
{
MessageDialog.ShowPromptMessage("文件中的下线员姓名在公司不唯一，无法获取到员工编号");
return;
}
string remark = dtTemp.Rows[35][2].ToString();
remark += string.Format("【工号：{0}, 姓名：{1}从EXCEL文件中导入】", BasicInfo.LoginID, BasicInfo.LoginName);
DataTable dt = new DataTable();
dt.Columns.Add("TestType"); // 试验类型，如：基本功能、N挡磨合等
dt.Columns.Add("TestItemName"); // 试验项目，如：密封性、传动平稳
dt.Columns.Add("TestCondition"); // 试验条件，如：整个试验过程中
dt.Columns.Add("TestRequirement"); // 试验要求，如：总成各结合面、外表面及油封刃口处不得有渗透现象
dt.Columns.Add("TestData"); // 试验数据，如：0.5Mpa
dt.Columns.Add("TestResult"); // 试验结论，如：合格
string 检测项目 = "";
string 试验项目 = "";
string 试验条件 = "";
string 试验要求 = "";
string 检测数据 = "";
string 试验项目测试结果 = "";
string 试验项目备份 = "";
for (int i = 3; i < 35; i++)
{
if (!GlobalObject.GeneralFunction.IsNullOrEmpty(dtTemp.Rows[i][1].ToString()))
{
检测项目 = dtTemp.Rows[i][1].ToString();
试验项目 = "";
试验项目备份 = "";
}
if (!GlobalObject.GeneralFunction.IsNullOrEmpty(dtTemp.Rows[i][2].ToString()))
{
试验项目备份 = dtTemp.Rows[i][2].ToString();
if (!GlobalObject.GeneralFunction.IsNullOrEmpty(dtTemp.Rows[i][3].ToString()))
{
试验项目 = dtTemp.Rows[i][2].ToString() + "-" + dtTemp.Rows[i][3].ToString();
}
else
{
试验项目 = dtTemp.Rows[i][2].ToString();
}
试验条件 = "";
}
else if (!GlobalObject.GeneralFunction.IsNullOrEmpty(dtTemp.Rows[i][3].ToString()))
{
试验项目 = 试验项目备份 + "-" + dtTemp.Rows[i][3].ToString();
试验条件 = "";
}
if (!GlobalObject.GeneralFunction.IsNullOrEmpty(dtTemp.Rows[i][4].ToString()))
{
试验条件 = dtTemp.Rows[i][4].ToString();
}
试验要求 = dtTemp.Rows[i][5].ToString();
检测数据 = dtTemp.Rows[i][6].ToString();
试验项目测试结果 = dtTemp.Rows[i][7].ToString();
dt.Rows.Add(new object[] { 检测项目, 试验项目, 试验条件, 试验要求, 检测数据, 试验项目测试结果 });
}
CvtTestInfo testInfo = new CvtTestInfo(
productCode + " " + cvtNumber, 试验设备名称, 油品, 试验结果, 装配员工号, 线员工号, remark, dt);
m_cvtTestDataService.SaveCVTExpData(testInfo);
MessageDialog.ShowPromptMessage(string.Format("导入【{0}】文件成功！", openFileDialog1.FileName));
}
catch (Exception exce)
{
MessageDialog.ShowErrorMessage(exce.Message);
}
//for (int row = 0; row < dtTemp.Rows.Count; row++)
//{
// for (int col = 0; col < dtTemp.Columns.Count; col++)
// {
// Console.Write("[{0}, {1}]：{2}\t", row, col, dtTemp.Rows[row][col].ToString());
// }
// Console.WriteLine();
//}
}
private void txtInport_Click(object sender, EventArgs e)
{
if (openFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
try
{
CursorControl.SetWaitCursor(this);
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1.OpenFile());
if (dtTemp == null)
{
MessageDialog.ShowPromptMessage(m_strError);
return;
}
if (CheckTable(dtTemp))
{
List <ZL_Database_Record> listRecord = new List <ZL_Database_Record>();
foreach (DataRow dr in dtTemp.Rows)
{
if (dr["序列号"].ToString().Trim().Length == 0)
{
continue;
}
ZL_Database_Record m_lnqRecord = new ZL_Database_Record();
m_lnqRecord.BillNo = openFileDialog1.FileName.Substring(0, openFileDialog1.FileName.LastIndexOf("\\") + 1) + dr["序列号"].ToString().Trim();
m_lnqRecord.CreationTime = ServerTime.Time;
m_lnqRecord.AssemblyCartonNo = dr["总成箱号"].ToString().Trim();
m_lnqRecord.CauseAnalysis = dr["原因分析"].ToString().Trim();
m_lnqRecord.FaultRatio = dr["故障比例"].ToString().Trim();
m_lnqRecord.Provider = dr["供应商"].ToString().Trim();
m_lnqRecord.FaultDescription = dr["故障描述"].ToString().Trim();
m_lnqRecord.FaultType = dr["故障类型"].ToString().Trim();
m_lnqRecord.Finder = dr["发现人员"].ToString().Trim();
m_lnqRecord.FindPlaces = dr["发现场所"].ToString().Trim();
m_lnqRecord.FindRole = dr["发现者"].ToString().Trim();
m_lnqRecord.GoodsCode = dr["图号型号"].ToString().Trim();
m_lnqRecord.GoodsName = dr["物品名称"].ToString().Trim();
m_lnqRecord.Spec = dr["规格"].ToString().Trim();
m_lnqRecord.Mileage = dr["行驶里程"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(dr["行驶里程"].ToString().Trim());
m_lnqRecord.Model = dr["型号"].ToString().Trim();
m_lnqRecord.OccurrenceTime = dr["发生时间"].ToString().Trim() == ""? null :
(DateTime?)Convert.ToDateTime(dr["发生时间"].ToString().Trim());
m_lnqRecord.TreatmentCountermeasures = dr["处理对策"].ToString().Trim();
m_lnqRecord.Type = dr["不良品类型"].ToString().Trim();
m_lnqRecord.Version = dr["版次"].ToString().Trim();
listRecord.Add(m_lnqRecord);
}
m_serverQylityDatabase.BatchInportInfo(listRecord);
MessageDialog.ShowPromptMessage("导入成功");
}
this.Cursor = System.Windows.Forms.Cursors.Arrow;
}
catch (Exception ex)
{
MessageDialog.ShowErrorMessage(ex.Message);
this.Cursor = System.Windows.Forms.Cursors.Arrow;
}
btnRefresh_Click(null, null);
}
private void 导入toolStripButton_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_error);
return;
}
if (!CheckTable(dtTemp))
{
return;
}
DataTable dtClone = dtTemp.Clone();
foreach (DataRow dr in dtTemp.Rows)
{
YX_LowestMarketPrice lowest = new YX_LowestMarketPrice();
int GoodsID = m_basicGoodsServer.GetGoodsIDByGoodsCode(dr["容大代码"].ToString(),
dr["零件名称"].ToString(), dr["规格"].ToString());
if (GoodsID != 0 && GoodsID != 7126)
{
lowest.GoodsID = GoodsID;
}
else
{
AddErrorInfo(ref dtClone, dr);
continue;
}
string clientCode = m_clientServer.GetClientCode(dr["客户名称"].ToString());
if (clientCode != "")
{
lowest.ClientID = clientCode;
}
else
{
AddErrorInfo(ref dtClone, dr);
continue;
}
int?communicateID = m_LowestPriceServer.GetCommunicateID(lowest.ClientID, dr["主机厂图号型号"].ToString(),
dr["主机厂物品名称"].ToString(), lowest.GoodsID, out m_error);
if (communicateID != null)
{
lowest.CommunicateID = communicateID;
}
else
{
AddErrorInfo(ref dtClone, dr);
continue;
}
lowest.Date = ServerTime.Time;
lowest.Price = Convert.ToDecimal(dr["配件含税单价（元）"].ToString());
lowest.TerminalPrice = Convert.ToDecimal(dr["配件终端最低价（元）"].ToString());
lowest.Rater = BasicInfo.LoginID;
lowest.Remark = dr["备注"].ToString();
if (!m_LowestPriceServer.InsertAndUpdateData(lowest, out m_error))
{
AddErrorInfo(ref dtClone, dr);
continue;
}
}
if (dtClone.Rows.Count > 0)
{
FormShowYXLowestPriceError form = new FormShowYXLowestPriceError(dtTemp, null);
form.ShowDialog();
}
else
{
MessageDialog.ShowPromptMessage("导入成功");
}
#region 逻辑代码修改 Modify by cjb on 2015.11.18
//bool flag = false;
////string GoodsName = "";
//for (int i = 0; i < dtTemp.Rows.Count; i++)
//{
// YX_LowestMarketPrice lowest = new YX_LowestMarketPrice();
// lowest.Date = ServerTime.Time;
// int GoodsID = m_basicGoodsServer.GetGoodsIDByGoodsCode(
// dtTemp.Rows[i]["容大代码"].ToString(), dtTemp.Rows[i]["零件名称"].ToString(), dtTemp.Rows[i]["规格"].ToString());
// if (GoodsID != 0 && GoodsID != 7126)
// {
// lowest.GoodsID = GoodsID;
// }
// else if (GoodsID == 7126)
// {
// dtTemp.Rows.RemoveAt(i);
// i--;
// continue;
// }
// else
// {
// //GoodsName += "容大代码为:" + dtTemp.Rows[i]["容大代码"].ToString() + ";零件名称:" +
// // dtTemp.Rows[i]["零件名称"].ToString() + "的零件有误,系统没有该零件;\r\n";
// flag = true;
// continue;
// }
// lowest.Price = Convert.ToDecimal(dtTemp.Rows[i]["配件含税单价（元）"].ToString());
// lowest.TerminalPrice = Convert.ToDecimal(dtTemp.Rows[i]["配件终端最低价（元）"].ToString());
// lowest.Rater = BasicInfo.LoginID;
// lowest.Remark = dtTemp.Rows[i]["备注"].ToString();
// string clientCode = m_clientServer.GetClientCode(dtTemp.Rows[i]["客户名称"].ToString());
// if (clientCode != "")
// {
// lowest.ClientID = clientCode;
// string communicateID = m_LowestPriceServer.GetCommunicateID(clientCode, dtTemp.Rows[i]["主机厂图号型号"].ToString(),
// dtTemp.Rows[i]["主机厂物品名称"].ToString(), GoodsID, out m_error);
// if (communicateID != "")
// {
// lowest.CommunicateID = communicateID;
// }
// else
// {
// flag = true;
// continue;
// }
// }
// else
// {
// flag = true;
// continue;
// }
// if (!m_LowestPriceServer.InsertAndUpdateData(lowest, out m_error))
// {
// flag = true;
// }
// else
// {
// dtTemp.Rows.RemoveAt(i);
// i--;
// }
//}
//if (flag)
//{
// FormShowYXLowestPriceError form = new FormShowYXLowestPriceError(dtTemp,null);
// form.ShowDialog();
//}
//else
//{
// MessageDialog.ShowPromptMessage("导入成功");
//}
#endregion
}
private void btnInput_Click(object sender, EventArgs e)
{
try
{
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("文件无【单价】列名");
}
if (!dtTemp.Columns.Contains("税率"))
{
throw new Exception("文件无【税率】列名");
}
if (!dtTemp.Columns.Contains("有效期开始时间"))
{
throw new Exception("文件无【有效期开始时间】列名");
}
if (!dtTemp.Columns.Contains("有效期结束时间"))
{
throw new Exception("文件无【有效期结束时间】列名");
}
List <Bus_PurchasingMG_UnitPriceList> lstTemp = new List <Bus_PurchasingMG_UnitPriceList>();
foreach (DataRow dr in dtTemp.Rows)
{
if ((dr["图号型号"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dr["图号型号"].ToString())) &&
(dr["物品名称"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dr["物品名称"].ToString())) &&
(dr["规格"] == null || GlobalObject.GeneralFunction.IsNullOrEmpty(dr["规格"].ToString())))
{
continue;
}
Bus_PurchasingMG_UnitPriceList tempInfo = new Bus_PurchasingMG_UnitPriceList();
string goodsMessage = "【图号型号】:" + (dr["图号型号"] == null ? "" : dr["图号型号"].ToString().Trim()).ToString()
+ "【物品名称】：" + (dr["物品名称"] == null ? "" : dr["物品名称"].ToString().Trim()).ToString()
+ "【规格】：" + (dr["规格"] == null ? "" : dr["规格"].ToString().Trim()).ToString();
View_F_GoodsPlanCost goodsInfo = UniversalFunction.GetGoodsInfo(dr["图号型号"] == null ? "" : dr["图号型号"].ToString().Trim(),
dr["物品名称"] == null ? "" : dr["物品名称"].ToString().Trim(),
dr["规格"] == null ? "" : dr["规格"].ToString().Trim());
if (goodsInfo == null)
{
throw new Exception("未找到对应的系统物品：" + goodsMessage);
}
//if (goodsInfo.禁用)
//{
// throw new Exception("此物品已被禁用无法导入：" + goodsMessage);
//}
tempInfo.GoodsID = goodsInfo.序号;
string strProvicer = dr["供应商"] == null ? "" : dr["供应商"].ToString();
View_Provider provider = UniversalFunction.GetProviderInfo(strProvicer);
if (provider == null)
{
throw new Exception("未找到对应的系统供应商：" + strProvicer);
}
if (!provider.是否在用)
{
throw new Exception("【系统供应商】：" + strProvicer + " 被禁用，无法导入");
}
tempInfo.Provider = provider.供应商编码;
tempInfo.Rate = dr["税率"] == null || dr["税率"].ToString().Trim() == "" ? 0 : Convert.ToInt32(dr["税率"]);
tempInfo.UnitPrice = dr["单价"] == null || dr["单价"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(dr["单价"]);
if (dr["有效期开始时间"] == null || dr["有效期开始时间"].ToString().Trim() == "")
{
throw new Exception("有效期开始时间有误：" + goodsMessage);
}
else
{
tempInfo.ValidityStart = Convert.ToDateTime(dr["有效期开始时间"]).Date;
}
if (dr["有效期结束时间"] == null || dr["有效期结束时间"].ToString().Trim() == "")
{
throw new Exception("有效期结束时间有误：" + goodsMessage);
}
else
{
tempInfo.ValidityEnd = Convert.ToDateTime(dr["有效期结束时间"]).Date;
}
lstTemp.Add(tempInfo);
}
_Service_UnitList.SaveInfo(lstTemp);
MessageDialog.ShowPromptMessage("导入并保存成功");
DataGridViewShow();
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
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 btnInput_BOM_Click(object sender, EventArgs e)
{
try
{
if (txtGoodsCode_BOM.Tag == null || txtGoodsCode_BOM.Text.Trim().Length == 0)
{
throw new Exception("请选择【总成/分总成】");
}
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_Bom> lstInfo = new List <Bus_WorkShop_InProduct_Bom>();
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_Bom bom = new Bus_WorkShop_InProduct_Bom();
bom.F_Id = Guid.NewGuid().ToString();
bom.GoodsID = goodsID;
bom.ProductGoodsID = Convert.ToInt32(txtGoodsCode_BOM.Tag);
decimal goodsCount = 0;
Decimal.TryParse(dtTemp.Rows[i]["用量"] == null ? "" : dtTemp.Rows[i]["用量"].ToString(), out goodsCount);
bom.UseCount = goodsCount;
lstInfo.Add(bom);
}
_Service_InProcutReport.InputBom(lstInfo);
MessageDialog.ShowPromptMessage("导入成功");
btnSelect_BOM_Click(null, null);
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}
private void 导入toolStripButton_Click(object sender, EventArgs e)
{
try
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
if (CheckTable(dtTemp))
{
#region 分析排班人员的打卡时间
List <HR_AttendanceMachineDataList> lstMachineDate = new List <HR_AttendanceMachineDataList>();
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
string workID = "";
string recordTime = "";
string beforTime = "";
string afterTime = "";
if (dtTemp.Columns.Contains("工号"))
{
workID = dtTemp.Rows[i]["工号"].ToString();
if (workID == "")
{
continue;
}
}
else
{
if (GlobalObject.GeneralFunction.IsNullOrEmptyObject(dtTemp.Rows[i]["日期"]) ||
GlobalObject.GeneralFunction.IsNullOrEmptyObject(dtTemp.Rows[i]["时间"]))
{
continue;
}
if (dtTemp.Rows[i]["登记号码"].ToString() == "")
{
continue;
}
string str = m_attendanceMachineServer.GetCardIDWorkIDMapping(dtTemp.Rows[i]["登记号码"].ToString());
if (str.Equals("0"))
{
//MessageDialog.ShowPromptMessage("【" + dtTemp.Rows[i]["登记号码"].ToString() + "】登记号码没有在映射表中！");
//return;
continue;
}
workID = str;
}
DateTime date = Convert.ToDateTime(dtTemp.Rows[i]["日期"].ToString());
DateTime beforTimeTemp = date.AddDays(-1);
DateTime afterTimeTemp = Convert.ToDateTime(dtTemp.Rows[i]["日期"].ToString()).AddDays(1);
string[] recordTimeTemp = dtTemp.Rows[i]["时间"].ToString().Split(' ');
HR_AttendanceSetting attendanceSet = m_attendanceSchemeServer.GetAttendanceSettingByWorkID(workID);
string[] schemeCode = attendanceSet.SchemeCode.Split(' ');
string mode = m_attendanceSchemeServer.GetAttendanceSchemeByCode(schemeCode[0]).AttendanceMode;
if (mode.Contains("自然月排班考勤"))
{
DataTable dtWorkSchedule = m_workSchedulingServer.GetWorkSchedulingByWorkIDAndDate(workID, Convert.ToDateTime(dtTemp.Rows[i]["日期"].ToString()));
if (dtWorkSchedule != null && dtWorkSchedule.Rows.Count > 0)
{
if (!Convert.ToBoolean(dtWorkSchedule.Rows[0]["isholiday"].ToString()))
{
string beginTime = Convert.ToDateTime(dtWorkSchedule.Rows[0]["beginTime"].ToString()).ToShortTimeString();
string punchInBegin = Convert.ToDateTime(dtWorkSchedule.Rows[0]["punchInBeginTime"].ToString()).ToShortTimeString();
string punchInEnd = Convert.ToDateTime(dtWorkSchedule.Rows[0]["punchInEndTime"].ToString()).ToShortTimeString();
string punchOutBegin = Convert.ToDateTime(dtWorkSchedule.Rows[0]["punchOutBeginTime"].ToString()).ToShortTimeString();
string punchOutEnd = Convert.ToDateTime(dtWorkSchedule.Rows[0]["punchOutEndTime"].ToString()).ToShortTimeString();
if ((Convert.ToDateTime(beginTime) - Convert.ToDateTime(punchInBegin)).Hours < 0)
{
if (i != dtTemp.Rows.Count - 1)
{
string str = dtTemp.Rows[i + 1]["时间"].ToString();
if (!str.Equals("0"))
{
string[] timeTemp = str.Split(' ');
if (recordTimeTemp.Length == 0)
{
beforTime = afterTimeTemp.Year + "年" + afterTimeTemp.Month + "月" + afterTimeTemp.Day + "日" + timeTemp[0];
afterTime = timeTemp[1];
}
else
{
afterTime = timeTemp[0];
}
}
}
}
if (Convert.ToInt32(dtWorkSchedule.Rows[0]["endOffSetDays"].ToString()) > 0)
{
afterTimeTemp = Convert.ToDateTime(dtTemp.Rows[i]["日期"].ToString()).AddDays(
Convert.ToInt32(dtWorkSchedule.Rows[0]["endOffSetDays"].ToString()));
string str = dtTemp.Rows[i + Convert.ToInt32(dtWorkSchedule.Rows[0]["endOffSetDays"].ToString())]["时间"].ToString();
if (!str.Equals("0"))
{
string[] timeTemp = str.Split(' ');
if (timeTemp[0] != "")
{
if (Convert.ToDateTime(timeTemp[0]) < Convert.ToDateTime(punchOutEnd))
{
afterTime = timeTemp[0];
}
}
}
}
if (beforTime != "")
{
if (!recordTime.Contains(beforTime))
{
recordTime = beforTime + " ";
}
}
for (int j = 0; j < recordTimeTemp.Length; j++)
{
if (recordTimeTemp[j] != "")
{
if (j != 0)
{
if (recordTimeTemp[j - 1] == recordTimeTemp[j])
{
continue;
}
if (Convert.ToDateTime(recordTimeTemp[j]).Hour - Convert.ToDateTime(recordTimeTemp[j - 1]).Hour == 0
&&
Convert.ToDateTime(recordTimeTemp[j]).Minute - Convert.ToDateTime(recordTimeTemp[j - 1]).Minute < 5)
{
continue;
}
}
recordTime += date.Year + "年" + date.Month + "月" + date.Day + "日" + recordTimeTemp[j] + " ";
}
}
if (afterTime != "")
{
string strAfter = afterTimeTemp.Year + "年" + afterTimeTemp.Month + "月" + afterTimeTemp.Day + "日" + afterTime;
if (!recordTime.Contains(strAfter))
{
recordTime += afterTimeTemp.Year + "年" + afterTimeTemp.Month + "月" + afterTimeTemp.Day + "日" + afterTime + " ";
}
}
}
else
{
for (int j = 0; j < recordTimeTemp.Length; j++)
{
if (recordTimeTemp[j] != "")
{
if (j != 0)
{
if (recordTimeTemp[j - 1] == recordTimeTemp[j])
{
continue;
}
if (Convert.ToDateTime(recordTimeTemp[j]).Hour - Convert.ToDateTime(recordTimeTemp[j - 1]).Hour == 0
&&
Convert.ToDateTime(recordTimeTemp[j]).Minute - Convert.ToDateTime(recordTimeTemp[j - 1]).Minute < 5)
{
continue;
}
}
recordTime += date.Year + "年" + date.Month + "月" + date.Day + "日" + recordTimeTemp[j] + " ";
}
}
}
}
else
{
for (int j = 0; j < recordTimeTemp.Length; j++)
{
if (recordTimeTemp[j] != "")
{
if (j != 0)
{
if (recordTimeTemp[j - 1] == recordTimeTemp[j])
{
continue;
}
if (Convert.ToDateTime(recordTimeTemp[j]).Hour - Convert.ToDateTime(recordTimeTemp[j - 1]).Hour == 0 &&
Convert.ToDateTime(recordTimeTemp[j]).Minute - Convert.ToDateTime(recordTimeTemp[j - 1]).Minute < 5)
{
continue;
}
}
recordTime += date.Year + "年" + date.Month + "月" + date.Day + "日" + recordTimeTemp[j] + " ";
}
}
}
}
else
{
for (int j = 0; j < recordTimeTemp.Length; j++)
{
if (recordTimeTemp[j] != "")
{
if (j != 0)
{
if (recordTimeTemp[j - 1] == recordTimeTemp[j])
{
continue;
}
if (Convert.ToDateTime(recordTimeTemp[j]).Hour - Convert.ToDateTime(recordTimeTemp[j - 1]).Hour == 0 &&
Convert.ToDateTime(recordTimeTemp[j]).Minute - Convert.ToDateTime(recordTimeTemp[j - 1]).Minute < 5)
{
continue;
}
}
recordTime += date.Year + "年" + date.Month + "月" + date.Day + "日" + recordTimeTemp[j] + " ";
}
}
}
HR_AttendanceMachineDataList machineDataList = new HR_AttendanceMachineDataList();
machineDataList.Date = date;
machineDataList.RecordTime = recordTime;
machineDataList.WorkID = workID;
machineDataList.Remark = "";
lstMachineDate.Add(machineDataList);
}
#endregion
m_attendanceMachineServer.InsertAttendanceMachine(lstMachineDate);
MessageDialog.ShowPromptMessage("导入成功!");
}
RefreshDataGridView();
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Columns["单据号"].Visible = false;
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
private void btn_Import_Click(object sender, EventArgs e)
{
//string error = "";
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(error);
return;
}
if (!dtTemp.Columns.Contains("图号型号"))
{
MessageDialog.ShowPromptMessage("无【图号型号】列");
}
if (!dtTemp.Columns.Contains("物品名称"))
{
MessageDialog.ShowPromptMessage("无【物品名称】列");
}
if (!dtTemp.Columns.Contains("规格"))
{
MessageDialog.ShowPromptMessage("无【规格】列");
}
if (!dtTemp.Columns.Contains("基数"))
{
MessageDialog.ShowPromptMessage("无【基数】列");
}
if (!dtTemp.Columns.Contains("一次性整台份发料"))
{
MessageDialog.ShowPromptMessage("无【一次性整台份发料】列");
}
m_listDebitSchedule = new List <View_S_DebitSchedule>();
foreach (DataRow dr in dtTemp.Rows)
{
View_S_DebitSchedule tempLnq = new View_S_DebitSchedule();
int goodsID = UniversalFunction.GetGoodsID(dr["图号型号"].ToString(), dr["物品名称"].ToString(), dr["规格"].ToString());
if (goodsID != 0)
{
tempLnq.物品ID = goodsID;
foreach (View_S_DebitSchedule item in m_listDebitSchedule)
{
if (item.物品ID == tempLnq.物品ID)
{
MessageDialog.ShowPromptMessage(UniversalFunction.GetGoodsMessage(tempLnq.物品ID)
+ "已存在一条记录，不能插入重复记录");
}
}
}
else
{
MessageDialog.ShowPromptMessage("图号：" + dr["图号型号"].ToString()
+ " 名称:" + dr["物品名称"].ToString() + " 规格:" + dr["规格"].ToString() + " 不存在于系统中");
return;
}
if (dr["基数"] == null || Convert.ToInt32(dr["基数"]) == 0)
{
MessageDialog.ShowPromptMessage("图号：" + dr["图号型号"].ToString()
+ " 名称:" + dr["物品名称"].ToString() + " 规格:" + dr["规格"].ToString() + " 【基数】不符合要求,请重新检查");
}
else
{
tempLnq.基数 = Convert.ToDecimal(dr["基数"]);
}
if (dr["一次性整台份发料"] == null)
{
MessageDialog.ShowPromptMessage("图号：" + dr["图号型号"].ToString()
+ " 名称:" + dr["物品名称"].ToString() + " 规格:" + dr["规格"].ToString() + " 【一次性整台份发料】不符合要求,请重新检查");
}
else
{
tempLnq.一次性整台份发料 = dr["一次性整台份发料"].ToString().Trim() == "是" ? true : false;
}
tempLnq.单据号 = txtSDBNo.Text;
tempLnq.规格 = dr["规格"].ToString();
tempLnq.图号型号 = dr["图号型号"].ToString();
tempLnq.物品名称 = dr["物品名称"].ToString();
tempLnq.总成编码 = txtEditionCode.Text;
tempLnq.适用范围 = cmbApplicable.Text;
m_listDebitSchedule.Add(tempLnq);
}
RefreshDataGridView(m_listDebitSchedule);
MessageDialog.ShowPromptMessage("导入完成");
}