/// <summary> /// 更新一条数据 /// </summary> public bool Update(Test_Model.sys_paramcenter model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_sys_paramcenter set "); strSql.Append("name=@name,"); strSql.Append("value=@value,"); strSql.Append("typeTag=@typeTag,"); strSql.Append("addUserId=@addUserId,"); strSql.Append("addUserName=@addUserName,"); strSql.Append("addTime=@addTime"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@value", SqlDbType.Int, 4), new SqlParameter("@typeTag", SqlDbType.NVarChar, 10), new SqlParameter("@addUserId", SqlDbType.Int, 4), new SqlParameter("@addUserName", SqlDbType.NVarChar, 15), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.value; parameters[2].Value = model.typeTag; parameters[3].Value = model.addUserId; parameters[4].Value = model.addUserName; parameters[5].Value = model.addTime; parameters[6].Value = model.id; int rows = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters); return(rows > 0); }
protected void btnCon_Click(object sender, EventArgs e) { string _name = this.txtName.Value.Trim(); string _value = this.txtValue.Value.Trim(); string _typetag = this.txtTypeTag.Value.Trim(); if (string.IsNullOrEmpty(_name) || string.IsNullOrEmpty(_typetag)) FinalMessage("请确认所填信息的完整性", "Add_SysParam.aspx", 1); if (Tools.RequestCheck.CheckKeyWord(_name) || Tools.RequestCheck.CheckKeyWord(_typetag)) FinalMessage("参数名或类型标记含有非法字符", "Add_SysParam.aspx", 1); if (!Tools.Validator.IsPositiveInt(_value)) FinalMessage("参数参数值应为正数", "Add_SysParam.aspx", 1); Test_Model.sys_paramcenter modelparma = new Test_Model.sys_paramcenter(); modelparma.name = _name; modelparma.value = Tools.StringHelp.GetInt(_value); modelparma.typeTag = Tools.StringHelp.CutStirngNormal(_typetag, 10, 0); modelparma.addUserId = Tools.StringHelp.GetInt(adminGetId); modelparma.addUserName = adminGetCount; modelparma.addTime = DateTime.Now; Test_BUL.sys_paramcenter bulparam = new Test_BUL.sys_paramcenter(); if (bulparam.Add(modelparma) > 0) Response.Redirect("Manage_SysParam.aspx"); else FinalMessage("保存失败", "Add_SysParam.aspx", 1); }
/// <summary> /// 得到一个对象实体 /// </summary> public Test_Model.sys_paramcenter GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,value,typeTag,addUserId,addUserName,addTime from tb_sys_paramcenter "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Test_Model.sys_paramcenter model = new Test_Model.sys_paramcenter(); DataSet ds = SqlHelper.ExecuteDataSet(connectionString, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["name"] != null) { model.name = ds.Tables[0].Rows[0]["name"].ToString(); } if (ds.Tables[0].Rows[0]["value"].ToString() != "") { model.value = int.Parse(ds.Tables[0].Rows[0]["value"].ToString()); } if (ds.Tables[0].Rows[0]["typeTag"] != null) { model.typeTag = ds.Tables[0].Rows[0]["typeTag"].ToString(); } if (ds.Tables[0].Rows[0]["addUserId"].ToString() != "") { model.addUserId = int.Parse(ds.Tables[0].Rows[0]["addUserId"].ToString()); } if (ds.Tables[0].Rows[0]["addUserName"] != null) { model.addUserName = ds.Tables[0].Rows[0]["addUserName"].ToString(); } if (ds.Tables[0].Rows[0]["addTime"].ToString() != "") { model.addTime = DateTime.Parse(ds.Tables[0].Rows[0]["addTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 获取数据 /// </summary> protected void GetData() { if (!Tools.Validator.IsNumber(ID)) FinalMessage("url参数解析错误", "Manage_SysParam.aspx", 1); if (Tools.RequestCheck.CheckKeyWord(ID)) FinalMessage("url参数含有非法关键词", "Manage_SysParam.aspx", 1); modelparma = bulparam.GetModel(Tools.StringHelp.GetInt(ID)); if (modelparma == null) FinalMessage("您查看的数据不存在", "Manage_SysParam.aspx", 1); this.txtName.Value = modelparma.name.Trim(); this.txtValue.Value = modelparma.value.ToString().Trim(); this.txtTypeTag.Value = modelparma.typeTag.Trim(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Test_Model.sys_paramcenter model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_sys_paramcenter("); strSql.Append("name,value,typeTag,addUserId,addUserName,addTime)"); strSql.Append(" values ("); strSql.Append("@name,@value,@typeTag,@addUserId,@addUserName,@addTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@value", SqlDbType.Int, 4), new SqlParameter("@typeTag", SqlDbType.NVarChar, 10), new SqlParameter("@addUserId", SqlDbType.Int, 4), new SqlParameter("@addUserName", SqlDbType.NVarChar, 15), new SqlParameter("@addTime", SqlDbType.DateTime) }; parameters[0].Value = model.name; parameters[1].Value = model.value; parameters[2].Value = model.typeTag; parameters[3].Value = model.addUserId; parameters[4].Value = model.addUserName; parameters[5].Value = model.addTime; object obj = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Test_Model.sys_paramcenter model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Test_Model.sys_paramcenter model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Test_Model.sys_paramcenter GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,value,typeTag,addUserId,addUserName,addTime from tb_sys_paramcenter "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = id; Test_Model.sys_paramcenter model = new Test_Model.sys_paramcenter(); DataSet ds = SqlHelper.ExecuteDataSet(connectionString, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["name"] != null) { model.name = ds.Tables[0].Rows[0]["name"].ToString(); } if (ds.Tables[0].Rows[0]["value"].ToString() != "") { model.value = int.Parse(ds.Tables[0].Rows[0]["value"].ToString()); } if (ds.Tables[0].Rows[0]["typeTag"] != null) { model.typeTag = ds.Tables[0].Rows[0]["typeTag"].ToString(); } if (ds.Tables[0].Rows[0]["addUserId"].ToString() != "") { model.addUserId = int.Parse(ds.Tables[0].Rows[0]["addUserId"].ToString()); } if (ds.Tables[0].Rows[0]["addUserName"] != null) { model.addUserName = ds.Tables[0].Rows[0]["addUserName"].ToString(); } if (ds.Tables[0].Rows[0]["addTime"].ToString() != "") { model.addTime = DateTime.Parse(ds.Tables[0].Rows[0]["addTime"].ToString()); } return model; } else { return null; } }