/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.Params model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Params("); strSql.Append("ParamID,ParamName,ParamValue,Remark,IsShow,IsEdit)"); strSql.Append(" values ("); strSql.Append("@ParamID,@ParamName,@ParamValue,@Remark,@IsShow,@IsEdit)"); SqlParameter[] parameters = { new SqlParameter("@ParamID", SqlDbType.Int, 4), new SqlParameter("@ParamName", SqlDbType.VarChar, 50), new SqlParameter("@ParamValue", SqlDbType.VarChar, 500), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@IsShow", SqlDbType.Bit, 1), new SqlParameter("@IsEdit", SqlDbType.Bit, 1) }; parameters[0].Value = model.ParamID; parameters[1].Value = model.ParamName; parameters[2].Value = model.ParamValue; parameters[3].Value = model.Remark; parameters[4].Value = model.IsShow; parameters[5].Value = model.IsEdit; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int ParamID) { WebDemo.BLL.WebDemo.Params bll = new WebDemo.BLL.WebDemo.Params(); WebDemo.Model.WebDemo.Params model = bll.GetModel(ParamID); this.lblParamID.Text = model.ParamID.ToString(); this.txtParamName.Text = model.ParamName; this.txtParamValue.Text = model.ParamValue; this.txtRemark.Text = model.Remark; this.chkIsShow.Checked = model.IsShow; this.chkIsEdit.Checked = model.IsEdit; }
private void ShowInfo(int ParamID) { WebDemo.BLL.WebDemo.Params bll = new WebDemo.BLL.WebDemo.Params(); WebDemo.Model.WebDemo.Params model = bll.GetModel(ParamID); this.lblParamID.Text = model.ParamID.ToString(); this.lblParamName.Text = model.ParamName; this.lblParamValue.Text = model.ParamValue; this.lblRemark.Text = model.Remark; this.lblIsShow.Text = model.IsShow?"是":"否"; this.lblIsEdit.Text = model.IsEdit?"是":"否"; }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Params DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.Params model = new WebDemo.Model.WebDemo.Params(); if (row != null) { if (row["ParamID"] != null && row["ParamID"].ToString() != "") { model.ParamID = int.Parse(row["ParamID"].ToString()); } if (row["ParamName"] != null) { model.ParamName = row["ParamName"].ToString(); } if (row["ParamValue"] != null) { model.ParamValue = row["ParamValue"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["IsShow"] != null && row["IsShow"].ToString() != "") { if ((row["IsShow"].ToString() == "1") || (row["IsShow"].ToString().ToLower() == "true")) { model.IsShow = true; } else { model.IsShow = false; } } if (row["IsEdit"] != null && row["IsEdit"].ToString() != "") { if ((row["IsEdit"].ToString() == "1") || (row["IsEdit"].ToString().ToLower() == "true")) { model.IsEdit = true; } else { model.IsEdit = false; } } } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtParamID.Text)) { strErr += "ParamID格式错误!\\n"; } if (this.txtParamName.Text.Trim().Length == 0) { strErr += "ParamName不能为空!\\n"; } if (this.txtParamValue.Text.Trim().Length == 0) { strErr += "ParamValue不能为空!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "备注不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int ParamID = int.Parse(this.txtParamID.Text); string ParamName = this.txtParamName.Text; string ParamValue = this.txtParamValue.Text; string Remark = this.txtRemark.Text; bool IsShow = this.chkIsShow.Checked; bool IsEdit = this.chkIsEdit.Checked; WebDemo.Model.WebDemo.Params model = new WebDemo.Model.WebDemo.Params(); model.ParamID = ParamID; model.ParamName = ParamName; model.ParamValue = ParamValue; model.Remark = Remark; model.IsShow = IsShow; model.IsEdit = IsEdit; WebDemo.BLL.WebDemo.Params bll = new WebDemo.BLL.WebDemo.Params(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.Params model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Params set "); strSql.Append("ParamName=@ParamName,"); strSql.Append("ParamValue=@ParamValue,"); strSql.Append("Remark=@Remark,"); strSql.Append("IsShow=@IsShow,"); strSql.Append("IsEdit=@IsEdit"); strSql.Append(" where ParamID=@ParamID "); SqlParameter[] parameters = { new SqlParameter("@ParamName", SqlDbType.VarChar, 50), new SqlParameter("@ParamValue", SqlDbType.VarChar, 500), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@IsShow", SqlDbType.Bit, 1), new SqlParameter("@IsEdit", SqlDbType.Bit, 1), new SqlParameter("@ParamID", SqlDbType.Int, 4) }; parameters[0].Value = model.ParamName; parameters[1].Value = model.ParamValue; parameters[2].Value = model.Remark; parameters[3].Value = model.IsShow; parameters[4].Value = model.IsEdit; parameters[5].Value = model.ParamID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Params GetModel(int ParamID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ParamID,ParamName,ParamValue,Remark,IsShow,IsEdit from Params "); strSql.Append(" where ParamID=@ParamID "); SqlParameter[] parameters = { new SqlParameter("@ParamID", SqlDbType.Int, 4) }; parameters[0].Value = ParamID; WebDemo.Model.WebDemo.Params model = new WebDemo.Model.WebDemo.Params(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }