private void QueryData()
{
StringBuilder strwhereBuilder = new StringBuilder(" where 1=1 ");
if (!string.IsNullOrEmpty(txt_S_Doc_NO.Text.Trim()))
{
strwhereBuilder.AppendFormat(" and S_Doc_NO ='{0}'", txt_S_Doc_NO.Text.Trim());
}
if (cbo_S_Doc_NO_Type.SelectedValue.ToString() != "-1")
{
strwhereBuilder.AppendFormat(" and S_Doc_Type='{0}'", cbo_S_Doc_NO_Type.SelectedValue.ToString());
}
if (!string.IsNullOrEmpty(txt_LotNo.Text.Trim()))
{
strwhereBuilder.AppendFormat(" and LotNo='{0}' ", txt_LotNo.Text.Trim());
}
if (!string.IsNullOrEmpty(txt_PO.Text.Trim()))
{
strwhereBuilder.AppendFormat(" and PO='{0}' ", txt_PO.Text.Trim());
}
if (!string.IsNullOrEmpty(txt_Arrival_NO.Text.Trim()))
{
strwhereBuilder.AppendFormat(" and Arrival_NO='{0}' ", txt_Arrival_NO.Text.Trim());
}
DataTable dt_Doc_Tbsd = BLL_Bllb_StorageDoc_tbsd.Query(strwhereBuilder.ToString());
dgv_Doc_Tbsd.DataSource = dt_Doc_Tbsd;
}
private void tol_del_Click(object sender, EventArgs e)
{
if (dgv_DocCollect.CurrentCell == null || dgv_DocCollect.CurrentCell.RowIndex == -1)
{
new PubUtils().ShowNoteNGMsg("请先选中行", 2, grade.OrdinaryError);
return;
}
DataGridViewRow dgvr = dgv_DocCollect.Rows[dgv_DocCollect.CurrentCell.RowIndex];
string s_doc_no = SqlInput.ChangeNullToString(dgvr.Cells["S_Doc_NO"].Value);
DataTable dt = BLL_Bllb_StorageDoc_tbsd.Query("where S_Doc_NO='" + s_doc_no + "'");
if (dt.Rows.Count > 0)
{
if (SqlInput.ChangeNullToString(dt.Rows[0]["Status"]) != "1")
{
new PubUtils().ShowNoteNGMsg("仅开立中的单据可以删除!", 2, grade.OrdinaryError);
return;
}
}
if (BLL_Bllb_StorageDoc_tbsd.Delete("where S_Doc_NO='" + s_doc_no + "'") == true)
{
Query();
new PubUtils().ShowNoteOKMsg("删除成功");
}
}
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;
}
}