private void dgv_Material_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
string strWhere = string.Format(" where S_Doc_NO='{0}' and MaterialCode='{1}'", dgv_Material.Rows[e.RowIndex].Cells[S_Doc_NO2.Name].Value.ToString(), dgv_Material.Rows[e.RowIndex].Cells[MaterialCode2.Name].Value.ToString());
dgv_Detail.DataSource = Bll_Bllb_StorageDocDetail_tbsdd.QuerySDocDetail(strWhere);
}
private void txt_Begin_LocationSN_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
//if (Bll_Bllb_StorageDocDetail_tbsdd.IsReturn(txt_Begin_LocationSN.Text.Trim()).Rows.Count > 0)
//{
// new PubUtils().ShowNoteNGMsg("物料SN已退料", 1, grade.OrdinaryError);
// return;
//}
//校验物料SN是否在库
string check_IsInStock = string.Format(" Where SerialNumber='{0}' and Lock_Flag='7'", txt_Begin_LocationSN.Text.Trim());
DataTable dt_isInStock = Bll_Bllb_StockInfo_tbsi.QueryStock(check_IsInStock);
if (dt_isInStock.Rows.Count > 0)
{
sfcNo = SqlInput.ChangeNullToString(dt_isInStock.Rows[0]["SfcNo"]);
//输入物料SN生成退料单据号
dt_return_doc = Bll_Bllb_StorageDocDetail_tbsdd.Create_Return_Doc(txt_Begin_LocationSN.Text.Trim());
if (dt_return_doc.Rows[0]["Result"].ToString() == "0")
{
new PubUtils().ShowNoteNGMsg("物料SN不在发料单中", 1, grade.OrdinaryError);
return;
}
_s_doc_no = dt_return_doc.Rows[0]["S_Doc_NO"].ToString();
_before_Doc_NO = dt_return_doc.Rows[0]["Before_Doc_NO"].ToString();//发料单
_materialCode = dt_return_doc.Rows[0]["MaterialCode"].ToString();
//_iqc_doc = Bll_Bllb_IQCDoc_tbid.GetIqcDocByMaterialCode(_materialCode, _before_Doc_NO);//输入料号生成退料送检单(屏蔽生成送检单)
DataTable DIP_Qty = Bll_Bllb_StorageDocDetail_tbsdd.Query_SN_Qty(txt_Begin_LocationSN.Text.Trim(), _materialCode);
if (DIP_Qty.Rows.Count > 0)
{
txt_Qty.Text = DIP_Qty.Rows[0]["Qty"].ToString();
txt_Qty.Focus();
txt_Qty.ReadOnly = false;
}
else
{
DataTable SMT_Qty = Bll_Bllb_StockInfo_tbsi.Query_SN_Qty(txt_Begin_LocationSN.Text.Trim(), _materialCode);
if (SMT_Qty.Rows.Count > 0)
{
txt_Qty.Text = SMT_Qty.Rows[0]["Qty"].ToString();
txt_Qty.Focus();
txt_Qty.ReadOnly = false;
}
}
}
else
{
new PubUtils().ShowNoteNGMsg("物料状态不对或物料SN错误", 2, grade.OrdinaryError);
return;
}
}
}
private void txt_Qty_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
if (txt_Begin_LocationSN.Text == string.Empty)
{
new PubUtils().ShowNoteNGMsg("物料SN不能为空", 2, grade.OrdinaryError);
return;
}
if (!(int.TryParse(txt_Qty.Text.Trim(), out _qty)))
{
new PubUtils().ShowNoteNGMsg("数量只能为数字", 2, grade.OrdinaryError);
return;
}
//DataTable dt_Return_Doc = Bll_Bllb_StorageDocDetail_tbsdd.Create_Return_Doc(txt_Begin_LocationSN.Text.Trim());
//_s_doc_no = dt_Return_Doc.Rows[0]["S_DOC_NO"].ToString();
if (dt_return_doc.Rows[0]["Flag"].ToString() == "0")//如果根据发料单当天存在退料单且没关闭则不用新增退料单
{
if (Bll_Bllb_StorageDocDetail_tbsdd.Insert_Return_Doc(_s_doc_no, _materialCode, _qty, txt_Begin_LocationSN.Text.Trim(), _iqc_doc, _before_Doc_NO))
{
Bll_Bllb_StorageDocDetail_tbsdd.Write_Material_Log(txt_Begin_LocationSN.Text.Trim(), _materialCode, _qty, sfcNo);
new PubUtils().ShowNoteOKMsg("退料成功");
}
}
else if (dt_return_doc.Rows[0]["Flag"].ToString() == "1")
{
if (Bll_Bllb_StorageDocDetail_tbsdd.Insert_S_Doc_No(_s_doc_no, _before_Doc_NO, _materialCode, _qty, txt_Begin_LocationSN.Text.Trim(), _iqc_doc))
{
Bll_Bllb_StorageDocDetail_tbsdd.Write_Material_Log(txt_Begin_LocationSN.Text.Trim(), _materialCode, _qty, sfcNo);
new PubUtils().ShowNoteOKMsg("退料成功");
}
}
txt_Begin_LocationSN.SelectAll();
txt_Begin_LocationSN.Focus();
//打印条码 注释掉
#region
//DataTable dt_storageInfo = Bll_Bllb_StockInfo_tbsi.QueryStockMatr(txt_Begin_LocationSN.Text.Trim());
//string matrCode = string.Empty;
//string dateCode = string.Empty;
//string supplierCode = string.Empty;
//if (dt_storageInfo.Rows.Count > 0)
//{
// matrCode = SqlInput.ChangeNullToString( dt_storageInfo.Rows[0]["MaterialCode"]);
// dateCode = SqlInput.ChangeNullToString(dt_storageInfo.Rows[0]["DateCode"]);
// supplierCode = SqlInput.ChangeNullToString(dt_storageInfo.Rows[0]["MPN"]);
//}
//Model.Model_MaterialBarCode bar = new Model.Model_MaterialBarCode();
//Dictionary<string, string> dic = new Dictionary<string, string>();
//bar.QRCODE = txt_Begin_LocationSN.Text.Trim();//物料SN
//dic.Add("QRCODE", bar.QRCODE);
//bar.QTY = txt_Qty.Text.Trim();//数量
//dic.Add("QTY", bar.QTY);
//bar.MaterialCode = matrCode;//料号
//dic.Add("MaterialCode", bar.MaterialCode);
//bar.BEGIN_DATE = dateCode;//Datecode
//dic.Add("BEGIN_DATE", bar.BEGIN_DATE);
//bar.MPN = supplierCode;//供应商料号
//dic.Add("MPN", bar.MPN);
//Common.BLL.Bll_Print.PrintTemplet("安费诺来料打印", dic);
//bar = new Model_MaterialBarCode();
#endregion
txt_Qty.Text = string.Empty;
txt_Qty.ReadOnly = true;
txt_Begin_LocationSN.Text = string.Empty;
}
}
