protected void btnSave_Click(object sender, EventArgs e)
{
if (clientcode.Text.Trim() != null && clientcode.Text.Trim() != "")
{
HP_Client model = new HP_Client();
HPClientDAL dal = new HPClientDAL();
if (clientcode.Text.Trim() != null && clientcode.Text.Trim() != "")
{
model.ClientCode = clientcode.Text;
}
model.ID = strID;
model.IsDel = 0;
if (dal.IsExist(clientcode.Text))
{
MessageBox.Show(this, "该信息已经存在，请不要重复添加！"); return;
}
if (dal.UpdateHPClient(model))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
else
{
MessageBox.Show(this, "名称不能为空！");
return;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (clientcode.Text.Trim() != null && clientcode.Text.Trim() != "")
{
HP_Client model = new HP_Client();
HPClientDAL dal = new HPClientDAL();
if (clientcode.Text.Trim() != null && clientcode.Text.Trim() != "")
{
model.ClientCode = clientcode.Text;
}
model.ID = Guid.NewGuid().ToString("N").ToUpper();
model.IsDel = 0;
model.SiteCode = Session["strSiteCode"].ToString();
if (dal.IsExist(clientcode.Text))
{
MessageBox.Show(this, "该信息已经存在，请不要重复添加！"); return;
}
if (dal.AddHPClient(model))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
else
{
MessageBox.Show(this, "名称不能为空！");
return;
}
}
void ShowInfo()
{
HPClientDAL dal = new HPClientDAL();
DataSet ds = dal.GetHpClientDetail(strID);
HP_Client model = DataConvert.DataRowToModel <HP_Client>(ds.Tables[0].Rows[0]);
clientcode.Text = model.ClientCode;
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
}
}
/// <summary>
/// 添加打印码
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddHPClient(HP_Client model)
{
string sql = @"INSERT INTO [Hp_client] ([ID],[SiteCode],[ClientCode],[IsDel])
VALUES (@ID,@SiteCode,@ClientCode,@IsDel)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@SiteCode", model.SiteCode),
new System.Data.SqlClient.SqlParameter("@ClientCode", model.ClientCode),
new System.Data.SqlClient.SqlParameter("@IsDel", model.IsDel)
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新打印码信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateHPClient(HP_Client model)
{
string safesql = " update Hp_client set ";
if (model.SiteCode != null && model.SiteCode != "")
{
safesql += " SiteCode='" + model.SiteCode + "',";
}
if (model.ClientCode != null && model.ClientCode != "")
{
safesql += " ClientCode='" + model.ClientCode + "',";
}
safesql += " IsDel=" + (model.IsDel == 1?1:0) + " where ID='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
