/// <summary>
/// 校验附料盘
/// </summary>
/// <returns></returns>
private bool CheckFSn(out string result_sn)
{
result_sn = string.Empty;
if (txtMsn.Text == txtFsn.Text)
{
new PubUtils().ShowNoteNGMsg("附料盘与主料盘不能相同", 1, grade.OrdinaryError);
return(false);
}
string serialnumber = txtFsn.Text;
DataTable dtval = Bll_Bllb_StockInfo_tbsi.ValidateSN(serialnumber);
if (dtval.Rows.Count == 0)
{
new PubUtils().ShowNoteNGMsg("料盘编码不在库或数量为0", 1, grade.OrdinaryError);
return(false);
}
if (materialcode != dtval.Rows[0]["MaterialCode"].ToString())
{
new PubUtils().ShowNoteNGMsg("主料盘与该料盘的料号不一致", 1, grade.OrdinaryError);
return(false);
}
if (trv_node.Nodes.Find(result_sn, true).Length > 0)
{
new PubUtils().ShowNoteNGMsg("该料盘编码已存在", 1, grade.OrdinaryError);
return(false);
}
result_sn = dtval.Rows[0]["SerialNumber"].ToString();
dicTrvSn.Add(result_sn, SqlInput.ChangeNullToInt(dtval.Rows[0]["Qty"], 0));
currentQty += SqlInput.ChangeNullToInt(dtval.Rows[0]["Qty"], 0);
lblTotal.Text = currentQty.ToString();
return(true);
}
/// <summary>
/// 根据仓库、库区查询库位
/// </summary>
private void GetLocation()
{
string strWhere = " Where 1=1";
if (cbo_stockName.SelectedValue.ToString() != string.Empty)
{
strWhere += string.Format(" AND a.Storage_SN='{0}'", cbo_stockName.SelectedValue.ToString());
}
if (Common.Helper.SqlInput.ChangeNullToString(cbo_area.SelectedValue) != string.Empty)
{
strWhere += string.Format(" AND a.Area_SN='{0}'", cbo_area.SelectedValue.ToString());
}
DataTable dt_location = Bll_Bllb_StockInfo_tbsi.QueryLocation(strWhere);
if (dt_location.Rows.Count > 0)
{
DataRow dr_location = dt_location.NewRow();
dr_location["Location_Name"] = "";
dr_location["Location_SN"] = "";
dt_location.Rows.InsertAt(dr_location, 0);
cbo_location.DataSource = dt_location;
cbo_location.DisplayMember = "Location_Name";
cbo_location.ValueMember = "Location_SN";
}
else
{
cbo_location.DataSource = null;//若查不到库位则清空库位数据源
}
}
/// <summary>
/// 点仓库带出库区
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cbo_stockName_SelectionChangeCommitted(object sender, EventArgs e)
{
string strWhere = " Where 1=1";
if (cbo_stockName.SelectedValue.ToString() != string.Empty)
{
strWhere += string.Format(" AND a.Storage_SN='{0}'", cbo_stockName.SelectedValue.ToString());
}
DataTable dt_storage = Bll_Bllb_StockInfo_tbsi.QueryStorage(strWhere);
if (dt_storage.Rows.Count > 0)//若查到库区则带出库区
{
DataRow dr_area = dt_storage.NewRow();
dr_area["Area_Name"] = "";
dr_area["Area_SN"] = "";
dt_storage.Rows.InsertAt(dr_area, 0);
cbo_area.DataSource = dt_storage;
cbo_area.DisplayMember = "Area_Name";
cbo_area.ValueMember = "Area_SN";
GetLocation();
}
else//若查不出库区，则清空库区，再用仓库查询库位
{
cbo_area.DataSource = null;
cbo_location.DataSource = null;
GetLocation();//
}
}
private void GetQty()
{
if (dgv_MaterialMoveAdd.CurrentRow.Cells["MaterialCode"].EditedFormattedValue != null || dgv_MaterialMoveAdd.CurrentRow.Cells["MaterialCode"].EditedFormattedValue.ToString() != string.Empty)
{
dgv_MaterialMoveAdd.CurrentRow.Cells["StorageQTY"].Value = Bll_Bllb_StockInfo_tbsi.GetQty(cbo_SourceStorage.SelectedValue.ToString(), dgv_MaterialMoveAdd.CurrentRow.Cells["MaterialCode"].EditedFormattedValue.ToString());
StorageQTY.ReadOnly = true;
if (dgv_MaterialMoveAdd.CurrentRow.Cells["StorageQTY"].Value.ToString() == "0")//库存数量如果是0，带出计划数量0
{
dgv_MaterialMoveAdd.CurrentRow.Cells["Plan_Qty"].Value = 0;
}
}
}
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;
}
}
}
/// <summary>
/// 检验主料盘
/// </summary>
/// <returns></returns>
private bool CheckMSn()
{
string serialNumber = txtMsn.Text;
DataTable dt_MainMaterial = Bll_Bllb_StockInfo_tbsi.ValidateSN(serialNumber);
if (dt_MainMaterial.Rows.Count == 0)
{
new PubUtils().ShowNoteNGMsg("主料号不在库或数量为0", 1, grade.OrdinaryError);
return(false);
}
materialcode = dt_MainMaterial.Rows[0]["MaterialCode"].ToString();
currentQty += SqlInput.ChangeNullToInt(dt_MainMaterial.Rows[0]["QTY"], 0);
lblTotal.Text = currentQty.ToString();
return(true);
}
/// <summary>
/// 合盘
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_combine_Click(object sender, EventArgs e)
{
if (txtMsn.Text == string.Empty || txtMsn.ReadOnly == false || trv_node.Nodes.Count == 0)
{
return;
}
if (Bll_Bllb_StockInfo_tbsi.Update_Combine_Action(dicTrvSn, txtMsn.Text.Trim(), materialcode))
{
new PubUtils().ShowNoteOKMsg("合盘成功");
trv_node.Nodes.Clear();
txtFsn.Text = string.Empty;
txtMsn.ReadOnly = false;
txtMsn.Text = string.Empty;
lblTotal.Text = string.Empty;
txtFsn.Focus();
}
}
private void btnExport_Click(object sender, EventArgs e)
{
try
{
string filepath = string.Empty;
SaveFileDialog sd = new SaveFileDialog();
sd.Title = "保存EXECL文件";
sd.Filter = "*.xls|*.xls";
sd.FilterIndex = 1;
if (sd.ShowDialog() != DialogResult.OK)
{
return;
}
filepath = sd.FileName;
if (File.Exists(filepath))
{
File.Delete(filepath);
}
StringBuilder strbid = new StringBuilder("AND 1=1 ");
if (cbo_stockName.SelectedValue.ToString() != string.Empty)
{
strbid.AppendFormat(" AND a.Storage_SN='{0}'", cbo_stockName.SelectedValue.ToString());
}
if (!string.IsNullOrEmpty(txt_materialCode.Text))
{
strbid.AppendFormat(" AND a.MaterialCode='{0}'", txt_materialCode.Text.Trim());
}
if (!string.IsNullOrEmpty(txt_serialNumber.Text))
{
strbid.AppendFormat(" AND a.SerialNumber='{0}'", txt_serialNumber.Text.Trim());
}
if (!string.IsNullOrEmpty(txtLocation.Text.Trim()))
{
strbid.AppendFormat(" AND d.Location_Name='{0}'", txtLocation.Text.Trim());
}
DataTable dt_export = Bll_Bllb_StockInfo_tbsi.QueryExportDetailAll(strbid.ToString());
Common.Helper.ExcelHelper.TableToExcel(dt_export, filepath);
new PubUtils().ShowNoteOKMsg("导出成功");
}
catch
{
new PubUtils().ShowNoteNGMsg("导出失败", 2, grade.OrdinaryError);
}
}
private void Query()
{
string strWhere = "";
if (cbo_stockName.SelectedValue.ToString() != string.Empty)
{
strWhere += string.Format(" AND a.Storage_SN='{0}'", cbo_stockName.SelectedValue.ToString());
}
if (txt_materialCode.Text != string.Empty)
{
strWhere += string.Format(" And a.MaterialCode='{0}'", txt_materialCode.Text.Trim());
}
if (txt_serialNumber.Text != string.Empty)
{
strWhere += string.Format(" And a.SerialNumber='{0}'", txt_serialNumber.Text.Trim());
}
if (!string.IsNullOrEmpty(txtLocation.Text.Trim()))
{
strWhere += string.Format(" And d.Location_Name='{0}'", txtLocation.Text.Trim());
}
DataTable dt_Stock = Bll_Bllb_StockInfo_tbsi.SelectAll(strWhere);
dgv_Stock.DataSource = dt_Stock;
}
private void Query()
{
#region 所选项汇总 如：只选择仓库就对仓库汇总，只选择仓库库区就对仓库库区汇总
//StringBuilder strGroup = new StringBuilder();
//string querywhere = string.Empty;
//string querycolumn = ",b.Storage_Name";
//strGroup.Append("b.Storage_Name");
//if (cbo_stockName.SelectedValue.ToString() != string.Empty)
//{
// querywhere += string.Format(" AND b.Storage_Name='{0}'", cbo_stockName.Text.ToString());
//}
//if (SqlInput.ChangeNullToString(cbo_area.SelectedValue) != string.Empty)
//{
// querywhere += string.Format(" AND c.Area_Name='{0}'", cbo_area.Text.ToString());
// querycolumn += string.Format(",c.Area_Name");
// strGroup.Append(",c.Area_Name");
//}
//if (SqlInput.ChangeNullToString(cbo_location.SelectedValue) != string.Empty)
//{
// querywhere += string.Format(" AND d.Location_Name='{0}'", cbo_location.Text.ToString());
// querycolumn += string.Format(",d.Location_Name");
// strGroup.Append(",d.Location_Name");
//}
//if (txt_materialCode.Text.Trim() != string.Empty)
//{
// querywhere += string.Format(" AND a.MaterialCode='{0}'", txt_materialCode.Text.Trim());
//}
//querycolumn += string.Format(",a.MaterialCode");
//strGroup.Append(",a.MaterialCode");
//DataTable dt_Stock = Bll_Bllb_StockInfo_tbsi.SelectAll(querywhere, querycolumn, strGroup.ToString());
//if (!dt_Stock.Columns.Contains("Area_Name"))
// dt_Stock.Columns.Add("Area_Name");
//if (!dt_Stock.Columns.Contains("Location_Name"))
// dt_Stock.Columns.Add("Location_Name");
//if (!dt_Stock.Columns.Contains("MaterialCode"))
// dt_Stock.Columns.Add("MaterialCode");
//if (!dt_Stock.Columns.Contains("QTY"))
// dt_Stock.Columns.Add("QTY");
//dtSource = dt_Stock.Copy();
//dgv_stockAll.DataSource = dtSource;
#endregion
#region 仓库库区库位料号都带出来
string strWhere = " Where 1=1 ";
if (cbo_stockName.SelectedValue.ToString() != string.Empty)
{
strWhere += string.Format(" AND b.Storage_Name='{0}' ", cbo_stockName.Text);
}
if (SqlInput.ChangeNullToString(cbo_area.SelectedValue) != string.Empty)
{
strWhere += string.Format(" AND c.Area_Name='{0}'", cbo_area.Text);
}
if (SqlInput.ChangeNullToString(cbo_location.SelectedValue) != string.Empty)
{
strWhere += string.Format(" AND d.Location_Name='{0}'", cbo_location.Text);
}
if (txt_materialCode.Text.Trim() != string.Empty)
{
strWhere += string.Format(" AND a.MaterialCode='{0}'", txt_materialCode.Text.Trim());
}
DataTable dt = Bll_Bllb_StockInfo_tbsi.SelectStock(strWhere);
dgv_stockAll.DataSource = dt;
#endregion
}
/// <summary>
/// 导出EXCEL
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
try
{
string filepath = string.Empty;
SaveFileDialog sd = new SaveFileDialog();
sd.Title = "保存EXECL文件";
sd.Filter = "*.xls|*.xls";
sd.FilterIndex = 1;
if (sd.ShowDialog() != DialogResult.OK)
{
return;
}
filepath = sd.FileName;
if (File.Exists(filepath))
{
File.Delete(filepath);
}
#region 注释掉 只导出所选项
//string querywhere = string.Empty;
//string querycolumn = ",b.Storage_Name as '仓库'";
//StringBuilder strGroup = new StringBuilder();
//strGroup.Append("b.Storage_Name");
//if (cbo_stockName.SelectedValue.ToString() != string.Empty)
//{
// querywhere += string.Format(" AND b.Storage_Name='{0}'", cbo_stockName.Text.ToString());
//}
//if (SqlInput.ChangeNullToString(cbo_area.SelectedValue) != string.Empty)
//{
// querywhere += string.Format(" AND c.Area_Name='{0}'", cbo_area.Text.ToString());
// querycolumn += string.Format(",c.Area_Name as '库区'");
// strGroup.Append(",c.Area_Name");
//}
//if (SqlInput.ChangeNullToString(cbo_location.SelectedValue) != string.Empty)
//{
// querywhere += string.Format(" AND d.Location_Name='{0}'", cbo_location.Text.ToString());
// querycolumn += string.Format(",d.Location_Name as '库位'");
// strGroup.Append(",d.Location_Name");
//}
//if (txt_materialCode.Text.Trim() != string.Empty)
//{
// querywhere += string.Format(" AND a.MaterialCode='{0}'", txt_materialCode.Text.Trim());
//}
//querycolumn += string.Format(",a.MaterialCode as '料号'");
//strGroup.Append(",a.MaterialCode");
//DataTable dt_all = Bll_Bllb_StockInfo_tbsi.QueryExportAll(querywhere, querycolumn, strGroup.ToString());
//dt_all.Columns["QTY"].SetOrdinal(dt_all.Columns.Count - 1);
#endregion
#region 仓库、库区、库位、料号导出
string strWhere = " Where 1=1";
if (cbo_stockName.SelectedValue.ToString() != string.Empty)
{
strWhere += string.Format(" AND b.Storage_Name='{0}' ", cbo_stockName.Text);
}
if (SqlInput.ChangeNullToString(cbo_area.SelectedValue) != string.Empty)
{
strWhere += string.Format(" AND c.Area_Name='{0}'", cbo_area.Text);
}
if (SqlInput.ChangeNullToString(cbo_location.SelectedValue) != string.Empty)
{
strWhere += string.Format(" AND d.Location_Name='{0}'", cbo_location.Text);
}
if (txt_materialCode.Text.Trim() != string.Empty)
{
strWhere += string.Format("AND a.MaterialCode='{0}'", txt_materialCode.Text.Trim());
}
DataTable dt_all = Bll_Bllb_StockInfo_tbsi.StockExportAll(strWhere);
#endregion
Common.Helper.ExcelHelper.TableToExcel(dt_all, filepath);
new PubUtils().ShowNoteOKMsg("导出成功");
}
catch
{
new PubUtils().ShowNoteNGMsg("导出失败", 2, grade.OrdinaryError);
}
}
private void btn_ok_Click(object sender, EventArgs e)
{
T_Bllb_StorageDoc_tbsd SC = new T_Bllb_StorageDoc_tbsd();
T_Bllb_StorageDocMaterial_tsdm SCD = new T_Bllb_StorageDocMaterial_tsdm();
bool isSucess = false;
if (_IsAddOrEdit == false)//新增
{
if (txt_DOC_NO.Text != string.Empty)
{
SC.S_Doc_NO = txt_DOC_NO.Text.Trim();//单据号
}
if (cbo_SourceStorage.SelectedValue.ToString() != string.Empty)
{
SC.Source_Storage = cbo_SourceStorage.SelectedValue.ToString();//原仓库
}
if (cbo_TargetStorage.SelectedValue.ToString() != string.Empty)
{
SC.Target_Storage = cbo_TargetStorage.SelectedValue.ToString();//目的仓库
}
if (txt_memo.Text != string.Empty)
{
SC.Memo = txt_memo.Text.Trim();//备注
}
if (cbo_SourceStorage.SelectedValue.ToString() == cbo_TargetStorage.SelectedValue.ToString())
{
new PubUtils().ShowNoteNGMsg("原仓库不能跟目的仓库相同", 2, grade.OrdinaryError);
return;
}
lstMaterial.Clear();
foreach (DataGridViewRow row in dgv_MaterialMoveAdd.Rows)
{
if (!ValiMaterialCode(row))
{
return;
}
SCD.S_Doc_NO = txt_DOC_NO.Text.Trim();
SCD.RowNumber = SqlInput.ChangeNullToInt(row.Cells["RowNumber"].Value, 0); //行号
SCD.MaterialCode = SqlInput.ChangeNullToString(row.Cells["MaterialCode"].Value); //料号
row.Cells["StorageQTY"].Value = Bll_Bllb_StockInfo_tbsi.GetQty(cbo_SourceStorage.SelectedValue.ToString(), SqlInput.ChangeNullToString(row.Cells["MaterialCode"].Value));
SCD.QTY = SqlInput.ChangeNullToInt(row.Cells["StorageQTY"].Value, 0); //库存量
SCD.Plan_Qty = SqlInput.ChangeNullToInt(row.Cells["Plan_Qty"].Value, 0); //计划数量
lstMaterial.Add(SCD);
SCD = new T_Bllb_StorageDocMaterial_tsdm();
}
if (lstMaterial.Count > 0)
{
if (Bll_Bllb_StorageDoc_tbsd.InsertDoc(SC))
{
isSucess = Bll_Bllb_StorageDocMaterial_tsdm.InsertMaterial(lstMaterial);
}
}
}
else//修改
{
lstMaterial.Clear();
foreach (DataGridViewRow row in dgv_MaterialMoveAdd.Rows)
{
if (!ValiMaterialCode(row))
{
return;
}
SCD.S_Doc_NO = txt_DOC_NO.Text.Trim();
SCD.RowNumber = SqlInput.ChangeNullToInt(row.Cells["RowNumber"].Value, 0); //行号
SCD.MaterialCode = SqlInput.ChangeNullToString(row.Cells["MaterialCode"].Value); //料号
row.Cells["StorageQTY"].Value = Bll_Bllb_StockInfo_tbsi.GetQty(cbo_SourceStorage.SelectedValue.ToString(), SqlInput.ChangeNullToString(row.Cells["MaterialCode"].Value));
SCD.QTY = SqlInput.ChangeNullToInt(row.Cells["StorageQTY"].Value, 0); //库存量
SCD.Plan_Qty = SqlInput.ChangeNullToInt(row.Cells["Plan_Qty"].Value, 0); //计划数量
lstMaterial.Add(SCD);
SCD = new T_Bllb_StorageDocMaterial_tsdm();
}
if (lstMaterial.Count > 0)
{
string strWhere = string.Format("S_Doc_NO ='{0}'", txt_DOC_NO.Text.Trim());
if (Bll_Bllb_StorageDocMaterial_tsdm.DeleteMaterial(strWhere))
{
isSucess = Bll_Bllb_StorageDocMaterial_tsdm.InsertMaterial(lstMaterial);
}
}
}
if (isSucess)
{
new PubUtils().ShowNoteOKMsg("保存成功！");
this.result = DialogResult.OK;
this.Close();
}
}
