private void btn_save_Click(object sender, EventArgs e)
{
if (dgv_doc.Rows.Count == 0)
{
MsgBox.Error("记录行为0，无需保存!");
return;
}
List <T_Bllb_StorageDoc_tbsd> List_tbsd = new List <T_Bllb_StorageDoc_tbsd>();
T_Bllb_StorageDoc_tbsd model_tbsd = new T_Bllb_StorageDoc_tbsd();
model_tbsd.S_Doc_NO = dtDoc.Rows[0]["S_Doc_NO"].ToString();
model_tbsd.Source_Storage = dtDoc.Rows[0]["Source_Storage"].ToString();
model_tbsd.S_Doc_Type = dtDoc.Rows[0]["S_Doc_Type"].ToString();
model_tbsd.Creator = PubUtils.uContext.UserID;
List_tbsd.Add(model_tbsd);
List <T_Bllb_StorageDocMaterial_tsdm> List_tbdm = new List <T_Bllb_StorageDocMaterial_tsdm>();
T_Bllb_StorageDocMaterial_tsdm model_tsdm = new T_Bllb_StorageDocMaterial_tsdm();
foreach (DataRow dr in dtDoc.Rows)
{
model_tsdm.S_Doc_NO = dr["S_Doc_NO"].ToString();
model_tsdm.MaterialCode = dr["MaterialCode"].ToString();
model_tsdm.Plan_Qty = Convert.ToInt32(dr["Quantity"].ToString());
List_tbdm.Add(model_tsdm);
model_tsdm = new T_Bllb_StorageDocMaterial_tsdm();
}
if (BLL_Bllb_StorageDoc_tbsd.SaveStorageDoc(List_tbsd, List_tbdm))
{
model_tbsd = new T_Bllb_StorageDoc_tbsd();
this.DialogResult = DialogResult.OK;
}
this.Close();
}
/// <summary>
/// 新增物料调拨
/// </summary>
/// <param name="SC"></param>
/// <param name="SCD"></param>
/// <returns></returns>
public static bool InsertDoc(T_Bllb_StorageDoc_tbsd SC)
{
string strSql = string.Format(@"insert into T_Bllb_StorageDoc_tbsd(S_Doc_NO,Source_Storage,Target_Storage,Memo,Creator,Create_Time) Values('{0}','{1}','{2}','{3}','{4}',getdate())
update T_Bllb_StorageDoc_tbsd set S_Doc_Type=6 where S_Doc_NO='{0}'", SC.S_Doc_NO, SC.Source_Storage, SC.Target_Storage, SC.Memo, PubUtils.uContext.UserID);
return(NMS.ExecTransql(PubUtils.uContext, strSql));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (dgvData.Rows.Count == 0)
{
new CIT.MES.PubUtils().ShowNoteNGMsg("记录行为零，无需保存", 2, CIT.MES.grade.OrdinaryError);
return;
}
while (true)//校验单据是否已被占用
{
if (BLL_Bllb_StorageDoc_tbsd.Query(string.Format(" WHERE S_Doc_NO='{0}'", txtDocNO.Text.Trim())).Rows.Count > 0)
{
cbo_Type_SelectionChangeCommitted(null, null);
continue;
}
else
{
break;
}
}
var stroage_doc = new T_Bllb_StorageDoc_tbsd()
{
S_Doc_NO = txtDocNO.Text.Trim(),
S_Doc_Type = cbo_Type.SelectedValue.ToString(),
Creator = PubUtils.uContext.UserID,
Before_Doc_NO = txtBeforeDoc.Text.Trim(),
PLCode = _PLCode,
WoCode = _WoCode,
SfcNo = _SfcNo,
Source_Storage = "SAA003"
};
var listStorageMaterial = (from u in dtScan.AsEnumerable()
select new T_Bllb_StorageDocMaterial_tsdm()
{
MaterialCode = u.Field <string>("MaterialCode"),
S_Doc_NO = txtDocNO.Text.Trim(),
Plan_Qty = Convert.ToInt32(u.Field <string>("QTY")),
RowNumber = Convert.ToInt32(u.Field <string>("RowNumber"))
}).Distinct().ToList();
if (BLL_Bllb_StorageDoc_tbsd.InsertFinishStorageDoc(stroage_doc, listStorageMaterial))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
new PubUtils().ShowNoteNGMsg("开立单据失败", 2, grade.OrdinaryError);
return;
}
}
/// <summary>
/// 开立单据
/// </summary>
/// <param name="model_doc"></param>
/// <param name="listMaterial"></param>
/// <returns></returns>
public static bool InsertStorageDocWithMaterial(T_Bllb_StorageDoc_tbsd model_doc, List <T_Bllb_StorageDocMaterial_tsdm> listMaterial)
{
StringBuilder strbild = new StringBuilder();
strbild.AppendFormat(@"INSERT INTO T_Bllb_StorageDoc_tbsd( S_Doc_NO ,S_Doc_Type ,Create_Time ,Creator,Before_Doc_No,PLCode,WoCode,SfcNo )
VALUES ( '{0}' ,'{1}',GETDATE(),'{2}','{3}','{4}','{5}','{6}')", model_doc.S_Doc_NO, model_doc.S_Doc_Type, model_doc.Creator, model_doc.Before_Doc_NO, model_doc.PLCode, model_doc.WoCode, model_doc.SfcNo);
foreach (T_Bllb_StorageDocMaterial_tsdm model_material in listMaterial)
{
strbild.AppendFormat(@"
INSERT INTO T_Bllb_StorageDocMaterial_tsdm( S_Doc_NO, MaterialCode, Plan_Qty,RowNumber,Ver ) VALUES ( '{0}', '{1}', '{2}','{3}','{4}' )",
model_material.S_Doc_NO, model_material.MaterialCode, model_material.Plan_Qty, model_material.RowNumber, model_material.Ver);
}
return(CIT.Wcf.Utils.NMS.ExecTransql(CIT.MES.PubUtils.uContext, strbild.ToString()));
}
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();
}
}
public static DataTable Select_S_Doc(T_Bllb_StorageDoc_tbsd s_Doc)
{
string strSql = string.Format("select * from T_Bllb_StorageDoc_tbsd where S_Doc_NO='{0}'", s_Doc.S_Doc_NO);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
