private void btn_ok_Click(object sender, EventArgs e)
{
string varMsg = string.Empty;
if (!CheckData(out varMsg))
{
new PubUtils().ShowNoteNGMsg(varMsg, 2, grade.OrdinaryError);
return;
}
obj.SupplierCode = txt_suppliesCode.Text.Trim();
obj.SupplierName = txt_suppliesName.Text.Trim();
if (opetrationType == OperationType.Add)
{
if (Bll_MdcDatSuppliesManage.Query(string.Format("where SupplierCode='{0}'", SqlInput.InputString(txt_suppliesCode.Text.Trim()))).Rows.Count > 0)
{
new PubUtils().ShowNoteNGMsg("供应商代码已存在", 2, grade.OrdinaryError);
return;
}
if (Bll_MdcDatSuppliesManage.Insert(obj))
{
this.DialogResult = DialogResult.OK;
obj = new MdcDatSuppliesManage();
this.Close();
}
else
{
new PubUtils().ShowNoteNGMsg("添加失败", 2, grade.OrdinaryError);
return;
}
}
else if (opetrationType == OperationType.Edit)
{
if (!txt_suppliesCode.Text.Trim().Equals(oldSupplierCode))
{
if (Bll_MdcDatSuppliesManage.Query(string.Format("where SupplierCode='{0}'", SqlInput.InputString(txt_suppliesCode.Text.Trim()))).Rows.Count > 0)
{
new PubUtils().ShowNoteNGMsg("供应商代码已存在", 2, grade.OrdinaryError);
return;
}
}
if (Bll_MdcDatSuppliesManage.Update(obj, oldSupplierCode))
{
this.DialogResult = DialogResult.OK;
obj = new MdcDatSuppliesManage();
this.Close();
}
else
{
new PubUtils().ShowNoteNGMsg("修改失败", 2, grade.OrdinaryError);
return;
}
}
}
/// <summary>
/// 增加
/// </summary>
/// <param name="model">MdcDatSuppliesManage表实体</param>
/// <returns></returns>
public static bool Insert(MdcDatSuppliesManage model)
{
string sqlcmd = @"insert into MdcDatSuppliesManage(SupplierName,SupplierCode)values (@SupplierName,@SupplierCode)";
CmdParameter[] cps = new CmdParameter[] {
new CmdParameter {
ParameterName = "SupplierName", Value = model.SupplierName
},
new CmdParameter {
ParameterName = "SupplierCode", Value = model.SupplierCode
},
};
return(NMS.ExecTransql(PubUtils.uContext, sqlcmd, cps));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">MdcDatSuppliesManage表实体</param>
/// <returns></returns>
public static bool Update(MdcDatSuppliesManage model, string oldSupplierCode)
{
string sqlcmd = @"
update MdcDatSuppliesManage set
SupplierName=@SupplierName,
SupplierCode=@SupplierCode
where SupplierCode=@oldSupplierCode" ;
CmdParameter[] cps = new CmdParameter[] {
new CmdParameter {
ParameterName = "SupplierName", Value = model.SupplierName
},
new CmdParameter {
ParameterName = "SupplierCode", Value = model.SupplierCode
},
new CmdParameter {
ParameterName = "oldSupplierCode", Value = oldSupplierCode
}
};
return(NMS.ExecTransql(PubUtils.uContext, sqlcmd, cps));
}
