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.CustomerName = txt_customerName.Text.Trim();
obj.CustomerCode = txt_customerCode.Text.Trim();
obj.Contact = txt_contract.Text.Trim();
obj.ContactNumber = txt_contractNum.Text.Trim();
obj.Email = txt_email.Text.Trim();
obj.ShippingAddress = txt_address.Text.Trim();
if (opetrationType == OperationType.Add)
{
obj.CustomerID = Guid.NewGuid().ToString();
obj.Creator = PubUtils.uContext.UserName;
obj.CreateTime = DateTime.Now;
if (Bll_SysdatMPNCustomer.Insert(obj))
{
this.DialogResult = DialogResult.OK;
obj = new SysdatMPNCustomer();
this.Close();
}
else
{
new PubUtils().ShowNoteNGMsg("添加失败", 2, grade.OrdinaryError);
return;
}
}
else if (opetrationType == OperationType.Edit)
{
if (Bll_SysdatMPNCustomer.Update(obj))
{
this.DialogResult = DialogResult.OK;
obj = new SysdatMPNCustomer();
this.Close();
}
else
{
new PubUtils().ShowNoteNGMsg("修改失败", 2, grade.OrdinaryError);
return;
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">SysdatMPNCustomer表实体</param>
/// <returns></returns>
public static bool Update(SysdatMPNCustomer model)
{
string sqlcmd = @"
update SysdatMPNCustomer set
CustomerID=@CustomerID,
CustomerCode=@CustomerCode,
CustomerName=@CustomerName,
Creator=@Creator,
CreateTime=@CreateTime,
Contact=@Contact,
ContactNumber=@ContactNumber,
Email=@Email,
ShippingAddress=@ShippingAddress
where CustomerID=@CustomerID" ;
CmdParameter[] cps = new CmdParameter[] {
new CmdParameter {
ParameterName = "CustomerID", Value = model.CustomerID
},
new CmdParameter {
ParameterName = "CustomerCode", Value = model.CustomerCode
},
new CmdParameter {
ParameterName = "CustomerName", Value = model.CustomerName
},
new CmdParameter {
ParameterName = "Creator", Value = model.Creator
},
new CmdParameter {
ParameterName = "CreateTime", Value = model.CreateTime
},
new CmdParameter {
ParameterName = "Contact", Value = model.Contact
},
new CmdParameter {
ParameterName = "ContactNumber", Value = model.ContactNumber
},
new CmdParameter {
ParameterName = "Email", Value = model.Email
},
new CmdParameter {
ParameterName = "ShippingAddress", Value = model.ShippingAddress
}
};
return(NMS.ExecTransql(PubUtils.uContext, sqlcmd, cps));
}
/// <summary>
/// 增加
/// </summary>
/// <param name="model">SysdatMPNCustomer表实体</param>
/// <returns></returns>
public static bool Insert(SysdatMPNCustomer model)
{
string sqlcmd = @"insert into SysdatMPNCustomer(CustomerID,CustomerCode,CustomerName,Creator,CreateTime,Contact,ContactNumber,Email,ShippingAddress)
values (@CustomerID,@CustomerCode,@CustomerName,@Creator,@CreateTime,@Contact,@ContactNumber,@Email,@ShippingAddress)";
CmdParameter[] cps = new CmdParameter[] {
new CmdParameter {
ParameterName = "CustomerID", Value = model.CustomerID
},
new CmdParameter {
ParameterName = "CustomerCode", Value = model.CustomerCode
},
new CmdParameter {
ParameterName = "CustomerName", Value = model.CustomerName
},
new CmdParameter {
ParameterName = "Creator", Value = model.Creator
},
new CmdParameter {
ParameterName = "CreateTime", Value = model.CreateTime
},
new CmdParameter {
ParameterName = "Contact", Value = model.Contact
},
new CmdParameter {
ParameterName = "ContactNumber", Value = model.ContactNumber
},
new CmdParameter {
ParameterName = "Email", Value = model.Email
},
new CmdParameter {
ParameterName = "ShippingAddress", Value = model.ShippingAddress
}
};
return(NMS.ExecTransql(PubUtils.uContext, sqlcmd, cps));
}
