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