/// <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;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_sysmenu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_sys_sysmenu(");
strSql.Append("menuName,menuOrder,imgUrl,addName,addTime)");
strSql.Append(" values (");
strSql.Append("@menuName,@menuOrder,@imgUrl,@addName,@addTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@menuName", SqlDbType.NVarChar,10),
new SqlParameter("@menuOrder", SqlDbType.Int,4),
new SqlParameter("@imgUrl", SqlDbType.NVarChar,50),
new SqlParameter("@addName", SqlDbType.NVarChar,10),
new SqlParameter("@addTime", SqlDbType.DateTime)};
parameters[0].Value = model.menuName;
parameters[1].Value = model.menuOrder;
parameters[2].Value = model.imgUrl;
parameters[3].Value = model.addName;
parameters[4].Value = model.addTime;
object obj = Test_DBUtility.SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <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_sysmenu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_sys_sysmenu set ");
strSql.Append("menuName=@menuName,");
strSql.Append("menuOrder=@menuOrder,");
strSql.Append("imgUrl=@imgUrl,");
strSql.Append("addName=@addName,");
strSql.Append("addTime=@addTime");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@menuName", SqlDbType.NVarChar,10),
new SqlParameter("@menuOrder", SqlDbType.Int,4),
new SqlParameter("@imgUrl", SqlDbType.NVarChar,50),
new SqlParameter("@addName", SqlDbType.NVarChar,10),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.menuName;
parameters[1].Value = model.menuOrder;
parameters[2].Value = model.imgUrl;
parameters[3].Value = model.addName;
parameters[4].Value = model.addTime;
parameters[5].Value = model.id;
int rows = Test_DBUtility.SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
return rows > 0;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_sys_userinfo(");
strSql.Append("userName,password,trueName,currentScore,totalScore,sex,province,city,isBusiness,registNumber,department,position,phone,address,addTime)");
strSql.Append(" values (");
strSql.Append("@userName,@password,@trueName,@currentScore,@totalScore,@sex,@province,@city,@isBusiness,@registNumber,@department,@position,@phone,@address,@addTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@userName", SqlDbType.NVarChar,10),
new SqlParameter("@password", SqlDbType.NVarChar,40),
new SqlParameter("@trueName", SqlDbType.NVarChar,15),
new SqlParameter("@currentScore", SqlDbType.Int,4),
new SqlParameter("@totalScore", SqlDbType.Int,4),
new SqlParameter("@sex", SqlDbType.Bit,1),
new SqlParameter("@province", SqlDbType.NVarChar,10),
new SqlParameter("@city", SqlDbType.NVarChar,10),
new SqlParameter("@isBusiness", SqlDbType.Bit,1),
new SqlParameter("@registNumber", SqlDbType.NVarChar,18),
new SqlParameter("@department", SqlDbType.NVarChar,10),
new SqlParameter("@position", SqlDbType.NVarChar,10),
new SqlParameter("@phone", SqlDbType.NVarChar,11),
new SqlParameter("@address", SqlDbType.NVarChar,100),
new SqlParameter("@addTime", SqlDbType.DateTime)};
parameters[0].Value = model.userName;
parameters[1].Value = model.password;
parameters[2].Value = model.trueName;
parameters[3].Value = model.currentScore;
parameters[4].Value = model.totalScore;
parameters[5].Value = model.sex;
parameters[6].Value = model.province;
parameters[7].Value = model.city;
parameters[8].Value = model.isBusiness;
parameters[9].Value = model.registNumber;
parameters[10].Value = model.department;
parameters[11].Value = model.position;
parameters[12].Value = model.phone;
parameters[13].Value = model.address;
parameters[14].Value = model.addTime;
object obj = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_admin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_sys_admin(");
strSql.Append("count,password,loginIP,loginTime,telephone,email,sex,birthday,createTime,roleid,adminTag,AccountState,PowerLeave)");
strSql.Append(" values (");
strSql.Append("@count,@password,@loginIP,@loginTime,@telephone,@email,@sex,@birthday,@createTime,@roleid,@adminTag,@AccountState,@PowerLeave)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@count", SqlDbType.NVarChar,10),
new SqlParameter("@password", SqlDbType.NVarChar,40),
new SqlParameter("@loginIP", SqlDbType.NVarChar,15),
new SqlParameter("@loginTime", SqlDbType.DateTime),
new SqlParameter("@telephone", SqlDbType.NVarChar,11),
new SqlParameter("@email", SqlDbType.NVarChar,30),
new SqlParameter("@sex", SqlDbType.Bit,1),
new SqlParameter("@birthday", SqlDbType.DateTime),
new SqlParameter("@createTime", SqlDbType.DateTime),
new SqlParameter("@roleid", SqlDbType.TinyInt,1),
new SqlParameter("@adminTag", SqlDbType.TinyInt,1),
new SqlParameter("@AccountState", SqlDbType.TinyInt,1),
new SqlParameter("@PowerLeave", SqlDbType.NVarChar,5)};
parameters[0].Value = model.count;
parameters[1].Value = model.password;
parameters[2].Value = model.loginIP;
parameters[3].Value = model.loginTime;
parameters[4].Value = model.telephone;
parameters[5].Value = model.email;
parameters[6].Value = model.sex;
parameters[7].Value = model.birthday;
parameters[8].Value = model.createTime;
parameters[9].Value = model.roleid;
parameters[10].Value = model.adminTag;
parameters[11].Value = model.AccountState;
parameters[12].Value = model.PowerLeave;
object obj = Test_DBUtility.SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_admin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_sys_admin set ");
strSql.Append("count=@count,");
strSql.Append("telephone=@telephone,");
strSql.Append("email=@email,");
strSql.Append("sex=@sex,");
strSql.Append("birthday=@birthday,");
strSql.Append("createTime=@createTime,");
strSql.Append("roleid=@roleid,");
strSql.Append("adminTag=@adminTag,");
strSql.Append("AccountState=@AccountState,");
strSql.Append("PowerLeave=@PowerLeave");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@count", SqlDbType.NVarChar,10),
new SqlParameter("@telephone", SqlDbType.NVarChar,11),
new SqlParameter("@email", SqlDbType.NVarChar,30),
new SqlParameter("@sex", SqlDbType.Bit,1),
new SqlParameter("@birthday", SqlDbType.DateTime),
new SqlParameter("@createTime", SqlDbType.DateTime),
new SqlParameter("@roleid", SqlDbType.TinyInt,1),
new SqlParameter("@adminTag", SqlDbType.TinyInt,1),
new SqlParameter("@AccountState", SqlDbType.TinyInt,1),
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@PowerLeave", SqlDbType.NVarChar,5)};
parameters[0].Value = model.count;
parameters[1].Value = model.telephone;
parameters[2].Value = model.email;
parameters[3].Value = model.sex;
parameters[4].Value = model.birthday;
parameters[5].Value = model.createTime;
parameters[6].Value = model.roleid;
parameters[7].Value = model.adminTag;
parameters[8].Value = model.AccountState;
parameters[9].Value = model.id;
parameters[10].Value = model.PowerLeave;
int rows = Test_DBUtility.SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
return rows > 0;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_sys_role(");
strSql.Append("roleName,pageId,addUser,addTime)");
strSql.Append(" values (");
strSql.Append("@roleName,@pageId,@addUser,@addTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@roleName", SqlDbType.NVarChar,10),
new SqlParameter("@pageId", SqlDbType.NVarChar,150),
new SqlParameter("@addUser", SqlDbType.NVarChar,15),
new SqlParameter("@addTime", SqlDbType.DateTime)};
parameters[0].Value = model.roleName;
parameters[1].Value = model.pageId;
parameters[2].Value = model.addUser;
parameters[3].Value = model.addTime;
object obj = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
return obj == null ? 0 : Convert.ToInt32(obj);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_sysfiles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_sys_sysfiles set ");
strSql.Append("classId=@classId,");
strSql.Append("fielsName=@fielsName,");
strSql.Append("filesUrl=@filesUrl,");
strSql.Append("describe=@describe,");
strSql.Append("showLeft=@showLeft,");
strSql.Append("addTime=@addTime,");
strSql.Append("addUserId=@addUserId,");
strSql.Append("addUser=@addUser,");
strSql.Append("filesOrder=@filesOrder");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@classId", SqlDbType.Int,4),
new SqlParameter("@fielsName", SqlDbType.NChar,10),
new SqlParameter("@filesUrl", SqlDbType.NVarChar,50),
new SqlParameter("@describe", SqlDbType.NVarChar,20),
new SqlParameter("@showLeft", SqlDbType.Bit,1),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@addUserId", SqlDbType.Int,4),
new SqlParameter("@addUser", SqlDbType.NVarChar,15),
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@filesOrder", SqlDbType.Int,4)};
parameters[0].Value = model.classId;
parameters[1].Value = model.fielsName;
parameters[2].Value = model.filesUrl;
parameters[3].Value = model.describe;
parameters[4].Value = model.showLeft;
parameters[5].Value = model.addTime;
parameters[6].Value = model.addUserId;
parameters[7].Value = model.addUser;
parameters[8].Value = model.id;
parameters[9].Value = model.filesOrder;
int rows = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
return rows > 0;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_sysfiles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_sys_sysfiles(");
strSql.Append("classId,fielsName,filesUrl,describe,showLeft,addTime,addUserId,addUser,filesOrder)");
strSql.Append(" values (");
strSql.Append("@classId,@fielsName,@filesUrl,@describe,@showLeft,@addTime,@addUserId,@addUser,@filesOrder)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@classId", SqlDbType.Int,4),
new SqlParameter("@fielsName", SqlDbType.NChar,10),
new SqlParameter("@filesUrl", SqlDbType.NVarChar,50),
new SqlParameter("@describe", SqlDbType.NVarChar,20),
new SqlParameter("@showLeft", SqlDbType.Bit,1),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@addUserId", SqlDbType.Int,4),
new SqlParameter("@addUser", SqlDbType.NVarChar,15),
new SqlParameter("@filesOrder", SqlDbType.Int,4)
};
parameters[0].Value = model.classId;
parameters[1].Value = model.fielsName;
parameters[2].Value = model.filesUrl;
parameters[3].Value = model.describe;
parameters[4].Value = model.showLeft;
parameters[5].Value = model.addTime;
parameters[6].Value = model.addUserId;
parameters[7].Value = model.addUser;
parameters[8].Value = model.filesOrder;
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_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_sys_role set ");
strSql.Append("roleName=@roleName,");
strSql.Append("pageId=@pageId,");
strSql.Append("addUser=@addUser,");
strSql.Append("addTime=@addTime");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@roleName", SqlDbType.NVarChar,10),
new SqlParameter("@pageId", SqlDbType.NVarChar,150),
new SqlParameter("@addUser", SqlDbType.NVarChar,15),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.roleName;
parameters[1].Value = model.pageId;
parameters[2].Value = model.addUser;
parameters[3].Value = model.addTime;
parameters[4].Value = model.id;
int rows = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
return rows > 0;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_sys_userinfo set ");
strSql.Append("userName=@userName,");
strSql.Append("trueName=@trueName,");
strSql.Append("currentScore=@currentScore,");
strSql.Append("totalScore=@totalScore,");
strSql.Append("sex=@sex,");
strSql.Append("province=@province,");
strSql.Append("city=@city,");
strSql.Append("isBusiness=@isBusiness,");
strSql.Append("registNumber=@registNumber,");
strSql.Append("department=@department,");
strSql.Append("position=@position,");
strSql.Append("phone=@phone,");
strSql.Append("address=@address");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@userName", SqlDbType.NVarChar,10),
new SqlParameter("@trueName", SqlDbType.NVarChar,15),
new SqlParameter("@currentScore", SqlDbType.Int,4),
new SqlParameter("@totalScore", SqlDbType.Int,4),
new SqlParameter("@sex", SqlDbType.Bit,1),
new SqlParameter("@province", SqlDbType.NVarChar,10),
new SqlParameter("@city", SqlDbType.NVarChar,10),
new SqlParameter("@isBusiness", SqlDbType.Bit,1),
new SqlParameter("@registNumber", SqlDbType.NVarChar,18),
new SqlParameter("@department", SqlDbType.NVarChar,10),
new SqlParameter("@position", SqlDbType.NVarChar,10),
new SqlParameter("@phone", SqlDbType.NVarChar,11),
new SqlParameter("@address", SqlDbType.NVarChar,100),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.userName;
parameters[1].Value = model.trueName;
parameters[2].Value = model.currentScore;
parameters[3].Value = model.totalScore;
parameters[4].Value = model.sex;
parameters[5].Value = model.province;
parameters[6].Value = model.city;
parameters[7].Value = model.isBusiness;
parameters[8].Value = model.registNumber;
parameters[9].Value = model.department;
parameters[10].Value = model.position;
parameters[11].Value = model.phone;
parameters[12].Value = model.address;
parameters[13].Value = model.ID;
int rows = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
return rows > 0;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_admin model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_admin model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_paramcenter model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_userinfo model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_distribution model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_distribution model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_sysmenu model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_sysmenu model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_userinfo model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_sysfiles model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_sysfiles model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_paramcenter model)
{
return dal.Add(model);
}
