private void txtAssociatedBillNo_Click(object sender, EventArgs e)
{
if (cmbSiteSource.SelectedIndex == 2)
{
FormQueryInfo frm = QueryInfoDialog.GetFeedBackBill("", "");
frm.ShowDialog();
if ((string)frm.GetDataItem("反馈单号") != null)
{
txtAssociatedBillNo.ReadOnly = true;
txtAssociatedBillNo.Text = (string)frm.GetDataItem("反馈单号");
txtApplicant.Tag = m_personnerServer.GetPersonnelViewInfoByName((string)frm.GetDataItem("反馈人"));
txtApplicant.Text = (string)frm.GetDataItem("反馈人");
dtpxtApplicant.Value = (DateTime)frm.GetDataItem("反馈日期");
txtBugDescribe.Text = (string)frm.GetDataItem("故障说明");
txtBugDescribe.ReadOnly = true;
txtApplicant.Enabled = false;
dtpxtApplicant.Enabled = false;
}
}
else
{
txtAssociatedBillNo.ReadOnly = false;
}
}
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 财务toolStripButton_Click(object sender, EventArgs e)
{
if (m_marketPartBillServer.GetDataByBillNo(m_billNo).Rows[0]["单据状态"].ToString() == "等待财务审核" ||
m_marketPartBillServer.GetDataByBillNo(m_billNo).Rows[0]["单据状态"].ToString() == "已完成")
{
if (txtClient.Text.Trim() != "" && txtClient.Text.Trim() != "全部" && txtClient.Text.Trim() != "其它")
{
if (Convert.ToDecimal(txtLowestPrice.Text) > numSellUnitPrice.Value)
{
MessageDialog.ShowPromptMessage("请重新填写销售价格！");
return;
}
for (int i = 0; i < m_listMarketPart.Count; i++)
{
for (int j = 0; j < dataGridView1.Rows.Count; j++)
{
if (m_listMarketPart[i].GoodsID == dataGridView1.Rows[j].Cells["GoodsID"].Value.ToString() &&
m_listMarketPart[i].批次号 == dataGridView1.Rows[j].Cells["批次号"].Value.ToString() &&
m_listMarketPart[i].供应商 == dataGridView1.Rows[j].Cells["供应商"].Value.ToString())
{
m_listMarketPart[i].备注 = m_listMarketPart[i].备注 + " " + txtRemark.Text;
m_listMarketPart[i].销售单价 = numSellUnitPrice.Value;
m_listMarketPart[i].主机厂代码 = tbsOutCode.Text;
m_listMarketPart[i].主机厂物品名称 = txtOutName.Text;
m_listMarketPart[i].最低定价 = Convert.ToDecimal(txtLowestPrice.Text);
m_listMarketPart[i].供应商 = txtprovider.Text.Trim();
}
}
}
S_MarketingPartBill bill = new S_MarketingPartBill();
bill.ClientID = txtClient.Tag.ToString();
bill.Remark = txtMainRemark.Text;
bill.CW_Auditor = BasicInfo.LoginID;
bill.CW_AuditTime = ServerTime.Time;
bill.Status = "已完成";
bill.BillNo = m_billNo;
bill.AssociatedBillNo = txtAssociated.Text;
if (!m_marketPartBillServer.UpdateData(bill, m_listMarketPart, "财务", out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
return;
}
else
{
MessageDialog.ShowPromptMessage("审核成功！");
}
List <string> noticeUser = new List <string>();
noticeUser.Add(m_personnerArchiveServer.GetPersonnelViewInfoByName(txtRecorder.Text));
m_billMessageServer.EndFlowMessage(m_billNo,
string.Format("{0} 号销售清单已经处理完毕", m_billNo),
null, noticeUser);
}
else
{
MessageDialog.ShowPromptMessage("客户不正确，请重新选择！");
return;
}
}
else
{
MessageDialog.ShowPromptMessage("请确认单据状态！");
return;
}
this.Close();
}