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