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 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();
}
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 DataBind()
{
dtType = BLL_Bllb_StorageDoc_tbsd.QueryDocType("where TYPE_CODE in('18','19')");//暂时只有发料单
DataRow dr = dtType.NewRow();
dr["TYPE_NAME"] = string.Empty;
dr["TYPE_CODE"] = "-1";
dtType.Rows.InsertAt(dr, 0);
cbo_Type.DataSource = dtType;
cbo_Type.DisplayMember = "TYPE_NAME";
cbo_Type.ValueMember = "TYPE_CODE";
cbo_Type.SelectedIndex = 0;
}
private void dgv_StorageMaterial_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgv_StorageMaterial.CurrentCell == null || dgv_StorageMaterial.CurrentCell.RowIndex == -1)
{
return;
}
dgvStorageDetail.DataSource = null;
string queryWhere = string.Format(@" where a.S_Doc_NO='{0}' and a.MaterialCode='{1}'",
SqlInput.ChangeNullToString(dgv_StorageMaterial.Rows[dgv_StorageMaterial.CurrentCell.RowIndex].Cells[S_Doc_NO_Material.Name].Value),
SqlInput.ChangeNullToString(dgv_StorageMaterial.Rows[dgv_StorageMaterial.CurrentCell.RowIndex].Cells[MaterialCode.Name].Value));
dtStorageDetail = BLL_Bllb_StorageDoc_tbsd.QueryStorageDetail(queryWhere);
dgvStorageDetail.DataSource = dtStorageDetail;
}
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;
}
}
private void cbo_Type_SelectionChangeCommitted(object sender, EventArgs e)
{
txtDocNO.Text = string.Empty;
string var_head = string.Empty;
if (cbo_Type.SelectedValue.ToString() == "-1")
{
return;
}
if (dtType.Rows.Count > 0)
{
var_head = (from h in dtType.AsEnumerable() where h.Field <string>("TYPE_CODE") == cbo_Type.SelectedValue.ToString() select h.Field <string>("TYPE_HEAD")).Distinct().ToList().FirstOrDefault();
}
if (cbo_Type.SelectedValue.ToString() != "-1")
{
DataTable dtFlow = BLL_Bllb_StorageDoc_tbsd.GetStorageDocFlow(cbo_Type.SelectedValue.ToString(), var_head.Trim());
txtDocNO.Text = string.Format("{0}{1}", var_head.Trim(), dtFlow.Rows[0]["flow"].ToString());
}
}
private void DataBindType()
{
dtType = BLL_Bllb_StorageDoc_tbsd.QueryDocType(string.Empty);
DataRow dr = dtType.NewRow();
dr["TYPE_NAME"] = string.Empty;
dr["TYPE_CODE"] = "-1";
dtType.Rows.InsertAt(dr, 0);
cbo_Type.DataSource = dtType;
cbo_Type.DisplayMember = "TYPE_NAME";
cbo_Type.ValueMember = "TYPE_CODE";
cbo_Type.SelectedIndex = 0;
S_Doc_Type.DataSource = dtType;
S_Doc_Type.DisplayMember = "TYPE_NAME";
S_Doc_Type.ValueMember = "TYPE_CODE";
//DataTable dtUser = user_bll.Select();
//Creator.DataSource = dtUser;
//Creator.DisplayMember = "UserName";
//Creator.ValueMember = "UserID";
//Creator_Detail.DataSource = dtUser;
//Creator_Detail.DisplayMember = "UserName";
//Creator_Detail.ValueMember = "UserID";
}
private void QueryData()
{
try
{
StringBuilder strbild = new StringBuilder(" where a.S_Doc_Type IN('18','19') ");
if (!string.IsNullOrEmpty(txt_Doc_NO.Text.Trim()))
{
strbild.AppendFormat(" and a.S_Doc_NO='{0}'", txt_Doc_NO.Text.Trim());
}
if (!string.IsNullOrEmpty(dtp_TimeMin.Text.Trim()))
{
strbild.AppendFormat(" and a.Create_Time>=CONVERT(DATETIME,'{0}')", dtp_TimeMin.Text.Trim());
}
if (cbo_Type.SelectedValue.ToString() != "-1")
{
strbild.AppendFormat(" and a.S_Doc_Type='{0}'", cbo_Type.SelectedValue.ToString());
}
if (!string.IsNullOrEmpty(dtp_TimeMax.Text.Trim()))
{
strbild.AppendFormat(" and a.Create_Time<=CONVERT(DATETIME,'{0}')", dtp_TimeMax.Text.Trim());
}
if (!string.IsNullOrEmpty(txtBeforeDoc.Text.Trim()))
{
strbild.AppendFormat(" and a.Before_Doc_No='{0}'", txtBeforeDoc.Text.Trim());
}
dt_StorageDoc = BLL_Bllb_StorageDoc_tbsd.QueryData(strbild.ToString());
dgv_StorageDoc.DataSource = dt_StorageDoc;
dgv_StorageMaterial.DataSource = null;
dgvStorageDetail.DataSource = null;
}
catch
{
CIT.Client.MsgBox.Error("请输入正确的时间格式=>yyyy-mm-dd");
return;
}
}
private void InsertToTempDgv()
{
string msg = string.Empty;
if (!ValidateInput(out msg))
{
MsgBox.Error(msg);
return;
}
string head = BLL_Bllb_POMain_tbpm.GetDoctypeHead(cbo_TypeCode.SelectedValue.ToString()).Rows[0]["TYPE_HEAD"].ToString().Trim();
string flow = BLL_Bllb_StorageDoc_tbsd.GetFlow(cbo_TypeCode.SelectedValue.ToString(), head).Rows[0][1].ToString();
string pocode = head + flow;
DataRow dr = dtDoc.NewRow();
dr["S_Doc_NO"] = pocode;
dr["Source_Storage"] = cmbStorage.SelectedValue.ToString();
dr["S_Doc_Type"] = cbo_TypeCode.SelectedValue.ToString();
dr["EmployeeCode"] = PubUtils.uContext.UserID;
dr["MaterialCode"] = txtMaterialCode.Text.Trim();
dr["Quantity"] = txtQuantity.Text.Trim();
dtDoc.Rows.Add(dr);
txtMaterialCode.Clear();
txtQuantity.Clear();
}
