private void FrmMaterialMoveAdd_Load(object sender, EventArgs e)
{
string strSql = string.Format(" select Storage_SN,Storage_Name from T_Bllb_Storage_tbs");
DataTable dt_Storage = NMS.QueryDataTable(PubUtils.uContext, strSql);
cbo_SourceStorage.DataSource = dt_Storage;
cbo_SourceStorage.DisplayMember = "Storage_Name";
cbo_SourceStorage.ValueMember = "Storage_SN";
string strTarget = string.Format(" select Storage_SN,Storage_Name from T_Bllb_Storage_tbs");
DataTable dt_TargetS = NMS.QueryDataTable(PubUtils.uContext, strTarget);
cbo_TargetStorage.DataSource = dt_TargetS;
cbo_TargetStorage.DisplayMember = "Storage_Name";
cbo_TargetStorage.ValueMember = "Storage_SN";
txt_DOC_NO.Text = Bll_Bllb_StorageDoc_tbsd.Get_MaterialMove_Doc();
if (_IsAddOrEdit)
{
txt_DOC_NO.Text = Doc.S_Doc_NO; //单据号
cbo_SourceStorage.Text = Doc.Source_Storage; //原仓库
cbo_TargetStorage.Text = Doc.Target_Storage; //目的仓库
txt_memo.Text = Doc.Memo; //备注
string materialCode = DocM.MaterialCode; //料号
//string strWhere = string.Format("Where b.S_Doc_NO ='{0}' AND Storage_SN='{1}' AND a.MaterialCode='{2}'", txt_DOC_NO.Text.Trim(), cbo_SourceStorage.SelectedValue, materialCode);
////dt_MaterialMove = Bll_Bllb_StorageDocMaterial_tsdm.Select(strWhere);
//DataTable dt = Bll_Bllb_StorageDocMaterial_tsdm.Select(strWhere);
// if (dt.Rows.Count > 0)
//{
// dgv_MaterialMoveAdd.DataSource = dt;
// dgv_MaterialMoveAdd.ClearSelection();
//}
//else
//{
// string strcmd = string.Format("S_Doc_NO='{0}' AND MaterialCode='{1}'", txt_DOC_NO.Text.Trim(),materialCode);
// dt_MaterialMove = Bll_Bllb_StorageDocMaterial_tsdm.Query(strcmd);
// dgv_MaterialMoveAdd.DataSource = dt_MaterialMove;
// dgv_MaterialMoveAdd.ClearSelection();
//}
string strcmd = string.Format("S_Doc_NO='{0}' ", txt_DOC_NO.Text.Trim());
dt_MaterialMove = Bll_Bllb_StorageDocMaterial_tsdm.Query(strcmd);
dgv_MaterialMoveAdd.DataSource = dt_MaterialMove;
dgv_MaterialMoveAdd.ClearSelection();
txt_DOC_NO.ReadOnly = true;
cbo_SourceStorage.Enabled = false;
cbo_TargetStorage.Enabled = false;
txt_memo.ReadOnly = true;
GetQty();
}
}
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();
}
}
