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); } }