private void btnOK_Click(object sender, EventArgs e)
{
string varMsg = string.Empty;
if (!ValidateInput(out varMsg))
{
new PubUtils().ShowNoteNGMsg(varMsg, 2, grade.OrdinaryError);
return;
}
obj_tbmr = new T_Bllb_MaterialRelation_Tbmr();
obj_tbmr.LocalMaterialCode = txtLocalMaterial.Text.Trim();
obj_tbmr.SupplyMaterialCode = txtSupplyMaterial.Text.Trim();
obj_tbmr.Supply = txtSupply.Text.Trim();
obj_tbmr.Remark = txtRemark.Text.Trim();
if (_operationType == OperationType.Add)
{
obj_tbmr.TBMR_ID = Guid.NewGuid().ToString();
if (BLL_Bllb_MaterialRelation_Tbmr.Insert(obj_tbmr))
{
ClearControl();
new PubUtils().ShowNoteOKMsg("新增成功");
}
}
else if (_operationType == OperationType.Edit)
{
obj_tbmr.TBMR_ID = TBMR_ID;
if (BLL_Bllb_MaterialRelation_Tbmr.Update(obj_tbmr))
{
new PubUtils().ShowNoteOKMsg("编辑成功");
this.DialogResult = DialogResult.OK;
}
}
}
private void tol_del_Click(object sender, EventArgs e)
{
if (dgvData.CurrentRow == null || dgvData.CurrentRow.Index == -1)
{
new PubUtils().ShowNoteNGMsg("请先选中行", 2, grade.OrdinaryError);
return;
}
if (BLL_Bllb_MaterialRelation_Tbmr.Delete(string.Format(" WHERE TBMR_ID='{0}'", SqlInput.ChangeNullToString(dgvData.Rows[dgvData.CurrentCell.RowIndex].Cells["TBMR_ID"].Value))))
{
Query();
new PubUtils().ShowNoteOKMsg("删除成功");
}
}
private void Query()
{
StringBuilder strBuilder = new StringBuilder(" where 1=1 ");
if (!string.IsNullOrEmpty(txtLocalMaterial.Text.Trim()))
{
strBuilder.AppendFormat(" AND LocalMaterialCode='{0}'", txtLocalMaterial.Text.Trim());
}
if (!string.IsNullOrEmpty(txtSupplyMaterial.Text.Trim()))
{
strBuilder.AppendFormat(" AND SupplyMaterialCode='{0}'", txtSupplyMaterial.Text.Trim());
}
if (!string.IsNullOrEmpty(txtSupply.Text.Trim()))
{
strBuilder.AppendFormat(" AND Supply='{0}'", txtSupply.Text.Trim());
}
DataTable dt = BLL_Bllb_MaterialRelation_Tbmr.Query(strBuilder.ToString());
dgvData.DataSource = dt;
}
private bool ValidateInput(out string msg)
{
if (string.IsNullOrEmpty(txtLocalMaterial.Text.Trim()))
{
msg = "本厂料号必填";
return(false);
}
if (string.IsNullOrEmpty(txtSupplyMaterial.Text.Trim()))
{
msg = "供应商料号必填";
return(false);
}
//if (string.IsNullOrEmpty(txtSupply.Text.Trim()))
//{
// msg = "供应商编码错误";
// return false;
//}
if (BLL_Material.Select(string.Format("MaterialCode='{0}'", txtLocalMaterial.Text.Trim())).Rows.Count == 0)
{
msg = "本厂料号错误";
return(false);
}
//if (Bll_MdcDatSuppliesManage.Query(string.Format(" where SupplierCode='{0}'", txtSupply.Text.Trim())).Rows.Count == 0)
//{
// msg = "供应商代码错误";
// return false;
//}
if (BLL_Bllb_MaterialRelation_Tbmr.Query(string.Format("WHERE SupplyMaterialCode='{0}' {1}", txtSupplyMaterial.Text.Trim(),
TBMR_ID == string.Empty ? string.Empty : string.Format("AND TBMR_ID<>'{0}'", TBMR_ID))).Rows.Count > 0)
{
msg = "供应商料号已存在";
return(false);
}
msg = "OK";
return(true);
}
