private void 单据审批确认ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lbDJZT.Text == "等待处理结果")
{
if (Convert.ToDecimal(txtDeclareCount.Text) !=
(decimal)NudSQE_BHG.Value
+ (decimal)NudSQE_HG.Value)
{
MessageBox.Show("【合格数 + 不合格数 = 挑返数】 请重新确认", "提示");
return;
}
DataForMessage();
View_S_CheckOutInDepotBill bill = m_serverCheckOutInDepot.GetBill(m_lnqReturn.InDepotBillID);
m_msgPromulgator.PassFlowMessage(m_lnqReturn.DJH,
string.Format("【入库单号】：{0} 【图号型号】：{1} 【物品名称】：{2} 【规格】：{3}【供货单位】：{4}【批次号】：{5} ※※※ 等待【{6}】处理",
bill.入库单号, bill.图号型号, bill.物品名称, bill.规格, bill.供货单位, bill.批次号, CE_RoleEnum.SQE组员.ToString()),
CE_RoleEnum.SQE组员.ToString(), true);
}
else
{
MessageBox.Show("请重新确认单据状态", "提示");
}
PositioningRecord(m_lnqReturn.DJH);
}
/// <summary>
/// 获得报检单中的信息
/// </summary>
/// <param name="djh">单据号</param>
/// <returns>返回获得报检单的信息</returns>
public View_S_CheckOutInDepotBill GetCheckInDepotBill(string djh)
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
if (djh.Substring(0, 3).ToString() != "BJD" &&
djh.Substring(0, 3).ToString() != "HJD" &&
djh.Substring(0, 3).ToString() != "FJD")
{
string strSql = "select * from View_S_CheckOutInDepotBill as a inner join " +
" S_IsolationManageBill as b on a.物品ID = b.GoodsID and a.批次号 = " +
" b.BatchNo where b.DJH = '" + djh + "'";
DataTable dt = GlobalObject.DatabaseServer.QueryInfo(strSql);
if (dt.Rows.Count > 0)
{
return((from a in dataContxt.View_S_CheckOutInDepotBill
where a.入库单号 == dt.Rows[0]["入库单号"].ToString()
select a).Single());
}
else
{
strSql = "select e.物品名称 as GoodsName,e.图号型号 as GoodsCode,e.规格 as Spec,e.物品类别 as GoodsType,b.BatchNo, " +
" d.Date,d.Provider,b.GoodsID,d.StorageID from S_MessMessageFeedback as a " +
" inner join S_IsolationManageBill as b on a.IndepotBillID = b.DJH " +
" inner join S_Stock as d on b.GoodsID = d.GoodsID and b.BatchNo = d.BatchNo " +
" inner join View_F_GoodsPlanCost as e on e.序号 = b.GoodsID where b.DJH = '" + djh + "'";
dt = GlobalObject.DatabaseServer.QueryInfo(strSql);
View_S_CheckOutInDepotBill lnqCheck = new View_S_CheckOutInDepotBill();
lnqCheck.图号型号 = dt.Rows[0]["GoodsCode"].ToString();
lnqCheck.物品名称 = dt.Rows[0]["GoodsName"].ToString();
lnqCheck.规格 = dt.Rows[0]["Spec"].ToString();
lnqCheck.批次号 = dt.Rows[0]["BatchNo"].ToString();
lnqCheck.仓库 = dt.Rows[0]["GoodsType"].ToString();
lnqCheck.到货日期 = (DateTime)dt.Rows[0]["Date"];
lnqCheck.订单号 = "";
lnqCheck.供货单位 = dt.Rows[0]["Provider"].ToString();
lnqCheck.物品ID = Convert.ToInt32(dt.Rows[0]["GoodsID"]);
lnqCheck.库房代码 = dt.Rows[0]["StorageID"].ToString();
return(lnqCheck);
}
}
else
{
return((from a in dataContxt.View_S_CheckOutInDepotBill
where a.入库单号 == djh
select a).Single());
}
}
private void 检验结果提交ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lbDJZT.Text == "等待检验结果")
{
if (Convert.ToDecimal(txtDeclareCount.Text) !=
(decimal)NudQC_BF.Value
+ (decimal)NudQC_HG.Value
+ (decimal)NudQC_RB.Value
+ (decimal)NudQC_TH.Value)
{
MessageBox.Show("【合格数 + 让步数 + 退货数 + 报废数 = 挑返数】 请重新确认", "提示");
return;
}
View_S_CheckOutInDepotBill bill = m_serverCheckOutInDepot.GetBill(m_lnqReturn.InDepotBillID);
DataForMessage();
#region 发送知会消息
List <string> noticeRoles = new List <string>();
noticeRoles.Add(CE_RoleEnum.检验员.ToString());
noticeRoles.Add(CE_RoleEnum.采购员.ToString());
noticeRoles.Add(CE_RoleEnum.SQE组员.ToString());
m_msgPromulgator.EndFlowMessage(dataGridView1.CurrentRow.Cells["单据号"].Value.ToString(),
string.Format("{0} 号挑选返工返修单已经处理完毕",
dataGridView1.CurrentRow.Cells["单据号"].Value.ToString()),
noticeRoles, null);
StringBuilder sb = new StringBuilder();
sb.AppendFormat("{0} 号报检入库单已经进行挑返, 等待仓库入库, ", txtBill_ID.Text);
sb.AppendFormat("此单据涉及物品：(图号[{0}]，名称[{1}]，规格[{2}]", txtCode.Text, txtName.Text, txtSpec.Text);
m_msgPromulgatorInDept.PassFlowMessage(m_lnqReturn.InDepotBillID, sb.ToString(),
m_msgPromulgator.GetRoleStringForStorage(bill.库房代码).ToString(), true);
#endregion 发送知会消息
}
else
{
MessageBox.Show("请重新确认单据状态", "提示");
}
PositioningRecord(m_lnqReturn.DJH);
}
private void 处理结果ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lbDJZT.Text == "等待审批确认")
{
DataForMessage();
View_S_CheckOutInDepotBill bill = m_serverCheckOutInDepot.GetBill(m_lnqReturn.InDepotBillID);
m_msgPromulgator.PassFlowMessage(m_lnqReturn.DJH,
string.Format("【入库单号】：{0} 【图号型号】：{1} 【物品名称】：{2} 【规格】：{3}【供货单位】：{4}【批次号】：{5} ※※※ 等待【{6}】处理",
bill.入库单号, bill.图号型号, bill.物品名称, bill.规格, bill.供货单位, bill.批次号, CE_RoleEnum.检验员.ToString()),
CE_RoleEnum.检验员.ToString(), true);
}
else
{
MessageBox.Show("请重新确认单据状态", "提示");
}
PositioningRecord(m_lnqReturn.DJH);
}
public 质量信息反馈单(string strDJH)
{
InitializeComponent();
if (strDJH != "")
{
m_lnqMess = m_serverMess.GetData(strDJH);
m_lnqViewCheck = m_serverMess.GetCheckInDepotBill(m_lnqMess.InDepotBillID);
}
else
{
m_blFlag = true;
txtDJH.Text = "系统自动生成";
txtName.Enabled = true;
txtBatchNo.Enabled = true;
groupBox4.Text = groupBox6.Text;
groupBox6.Text = "";
}
}
private void 编制单据提交ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lbDJZT.Text == "新建单据")
{
GetAllTheMaessage();
if (m_lnqReturn.ReturnReason.ToString().Trim() == "" ||
m_lnqReturn.ReturnManHour.ToString().Trim() == "" ||
m_lnqReturn.ReturnMeansAndAsk.ToString().Trim() == "")
{
MessageBox.Show("请完整填写挑返信息", "提示");
return;
}
if (m_serverCheckReturnRepair.SubmitBill(m_lnqReturn, out m_err))
{
MessageBox.Show("提交成功！", "提示");
View_S_CheckOutInDepotBill bill = m_serverCheckOutInDepot.GetBill(m_lnqReturn.InDepotBillID);
m_msgPromulgator.PassFlowMessage(m_lnqReturn.DJH,
string.Format("【入库单号】：{0} 【图号型号】：{1} 【物品名称】：{2} 【规格】：{3}【供货单位】：{4}【批次号】：{5} ※※※ 等待【{6}】处理",
bill.入库单号, bill.图号型号, bill.物品名称, bill.规格, bill.供货单位, bill.批次号, CE_RoleEnum.采购员.ToString()),
CE_RoleEnum.采购员.ToString(), true);
}
else
{
MessageDialog.ShowErrorMessage(m_err);
}
RefreshDataGirdView(m_serverCheckReturnRepair.GetAllBill(checkBillDateAndStatus1.cmbBillStatus.Text,
checkBillDateAndStatus1.dtpStartTime.Value, checkBillDateAndStatus1.dtpEndTime.Value));
}
else
{
MessageBox.Show("请重新确认单据状态", "提示");
}
PositioningRecord(m_lnqReturn.DJH);
}
void txtBatchNo_OnCompleteSearch()
{
if (txtName.Tag == null)
{
MessageDialog.ShowPromptMessage("请选择物品名称");
return;
}
string strDJH = m_serverCheckOutInDepot.GetBillNo(
Convert.ToInt32(txtName.Tag), txtBatchNo.Text);
if (strDJH != "")
{
txtBatchNo.Text = txtBatchNo.DataResult["批次号"].ToString();
m_lnqMess.InDepotBillID = strDJH;
m_lnqViewCheck = m_serverMess.GetCheckInDepotBill(m_lnqMess.InDepotBillID);
ShowAllMessage();
ShowElesMessage();
}
txtDJZT.Text = "等待STA验证";
txtDJH.Text = m_serverMess.GetBillID();
}
private void dataGridView1_CellEnter(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.RowCount == 0)
{
return;
}
#region 挑返单信息
lbCJ.Text = dataGridView1.CurrentRow.Cells["创建人"].Value.ToString();
lbBZ.Text = dataGridView1.CurrentRow.Cells["编制人"].Value.ToString();
lbSH.Text = dataGridView1.CurrentRow.Cells["审核人"].Value.ToString();
lbCLJG.Text = dataGridView1.CurrentRow.Cells["处理人"].Value.ToString();
lbJYJG.Text = dataGridView1.CurrentRow.Cells["检验人"].Value.ToString();
NudQC_BF.Value = (decimal)dataGridView1.CurrentRow.Cells["QC报废数"].Value;
NudQC_HG.Value = (decimal)dataGridView1.CurrentRow.Cells["QC合格数"].Value;
NudQC_RB.Value = (decimal)dataGridView1.CurrentRow.Cells["QC让步数"].Value;
NudQC_TH.Value = (decimal)dataGridView1.CurrentRow.Cells["QC退货数"].Value;
NudSQE_BHG.Value = (decimal)dataGridView1.CurrentRow.Cells["采购工程师不合格数"].Value;
NudSQE_HG.Value = (decimal)dataGridView1.CurrentRow.Cells["采购工程师合格数"].Value;
NudSQE_TFGS.Value = (decimal)dataGridView1.CurrentRow.Cells["SQE工时"].Value;
lbDJZT.Text = dataGridView1.CurrentRow.Cells["单据状态"].Value.ToString();
m_strDJH = dataGridView1.CurrentRow.Cells["单据号"].Value.ToString();
lbDJH.Text = m_strDJH;
m_drSQE["挑返原因"] = dataGridView1.CurrentRow.Cells["挑返原因"].Value.ToString();
m_drSQE["挑返方法及要求"] = dataGridView1.CurrentRow.Cells["挑返方法及要求"].Value.ToString();
m_drSQE["挑返损耗及工时"] = dataGridView1.CurrentRow.Cells["挑返损耗及工时"].Value.ToString();
#endregion
#region 获取报检单信息
View_S_CheckOutInDepotBill bill = m_serverCheckOutInDepot.GetBill(dataGridView1.CurrentRow.Cells["关联入库单号"].Value.ToString());
if (bill == null)
{
return;
}
txtBill_ID.Text = bill.入库单号;
txtOrderFormNumber.Text = bill.订单号;
txtBatchNo.Text = bill.批次号;
if (bill.供方批次号 != null)
{
txtProviderBatchNo.Text = bill.供方批次号;
}
else
{
txtProviderBatchNo.Text = "";
}
if (!GlobalObject.GeneralFunction.IsNullOrEmpty(bill.备注))
{
txtRemark.Text = bill.备注;
}
else
{
txtRemark.Text = "";
}
txtDeclareCount.Text = bill.报检数量.ToString();
txtName.Text = bill.物品名称;
txtCode.Text = bill.图号型号;
txtCode.Tag = bill.物品ID;
txtSpec.Text = bill.规格;
lbdw.Text = bill.单位;
txtMaterialType.Text = bill.仓库;
txtProvider.Text = bill.供货单位;
txtStorage.Text = UniversalFunction.GetStorageName(bill.库房代码.ToString());
#endregion
}