/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.Emp_Authority model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Emp_Authority("); strSql.Append("auth_code,auth_name,auth_remark"); strSql.Append(") values ("); strSql.Append("@auth_code,@auth_name,@auth_remark"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@auth_code", SqlDbType.VarChar,50) , new SqlParameter("@auth_name", SqlDbType.NVarChar,50) , new SqlParameter("@auth_remark", SqlDbType.NVarChar,50) }; parameters[0].Value = model.auth_code; parameters[1].Value = model.auth_name; parameters[2].Value = model.auth_remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(AutekInfo.Model.View_Emp_Role model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into View_Emp_Role("); strSql.Append("role_code,role_name,role_describe,emp_id,emp_cnname,m_emp_role_id,role_id"); strSql.Append(") values ("); strSql.Append("@role_code,@role_name,@role_describe,@emp_id,@emp_cnname,@m_emp_role_id,@role_id"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@role_code", SqlDbType.VarChar,50) , new SqlParameter("@role_name", SqlDbType.NVarChar,50) , new SqlParameter("@role_describe", SqlDbType.NVarChar,500) , new SqlParameter("@emp_id", SqlDbType.Int,4) , new SqlParameter("@emp_cnname", SqlDbType.NVarChar,100) , new SqlParameter("@m_emp_role_id", SqlDbType.Int,4) , new SqlParameter("@role_id", SqlDbType.Int,4) }; parameters[0].Value = model.role_code; parameters[1].Value = model.role_name; parameters[2].Value = model.role_describe; parameters[3].Value = model.emp_id; parameters[4].Value = model.emp_cnname; parameters[5].Value = model.m_emp_role_id; parameters[6].Value = model.role_id; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
//public bool Exists() //{ // StringBuilder strSql=new StringBuilder(); // strSql.Append("select count(1) from M_Emp_Role"); // strSql.Append(" where "); // SqlParameter[] parameters = { // new SqlParameter("@m_emp_role_id", SqlDbType.Int,4) // }; // parameters[0].Value = m_emp_role_id; // return DbHelperSQL.Exists(strSql.ToString(),parameters); //} /// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.M_Emp_Role model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into M_Emp_Role("); strSql.Append("emp_id,role_id"); strSql.Append(") values ("); strSql.Append("@emp_id,@role_id"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@emp_id", SqlDbType.Int,4) , new SqlParameter("@role_id", SqlDbType.Int,4) }; parameters[0].Value = model.emp_id; parameters[1].Value = model.role_id; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.M_Menu_Auth model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into M_Menu_Auth("); strSql.Append("auth_id,menu_options"); strSql.Append(") values ("); strSql.Append("@auth_id,@menu_options"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@auth_id", SqlDbType.Int,4) , new SqlParameter("@menu_options", SqlDbType.VarChar,500) }; parameters[0].Value = model.auth_id; parameters[1].Value = model.menu_options; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.Menu_Options model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Menu_Options("); strSql.Append("menu_id,option_code,option_name,option_desc"); strSql.Append(") values ("); strSql.Append("@menu_id,@option_code,@option_name,@option_desc"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@menu_id", SqlDbType.Int,4) , new SqlParameter("@option_code", SqlDbType.VarChar,50) , new SqlParameter("@option_name", SqlDbType.NVarChar,50) , new SqlParameter("@option_desc", SqlDbType.NVarChar,100) }; parameters[0].Value = model.menu_id; parameters[1].Value = model.option_code; parameters[2].Value = model.option_name; parameters[3].Value = model.option_desc; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(AutekInfo.Model.Emp_Account model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Emp_Account("); strSql.Append("loginid,pwd,status,lastloginip,lastlogindate,sysstatus,updater,updatedata"); strSql.Append(") values ("); strSql.Append("@loginid,@pwd,@status,@lastloginip,@lastlogindate,@sysstatus,@updater,@updatedata"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@loginid", SqlDbType.NVarChar,50) , new SqlParameter("@pwd", SqlDbType.VarChar,50) , new SqlParameter("@status", SqlDbType.VarChar,100) , new SqlParameter("@lastloginip", SqlDbType.VarChar,50) , new SqlParameter("@lastlogindate", SqlDbType.DateTime) , new SqlParameter("@sysstatus", SqlDbType.Int,4) , new SqlParameter("@updater", SqlDbType.Int,4) , new SqlParameter("@updatedata", SqlDbType.DateTime) }; parameters[0].Value = model.loginid; parameters[1].Value = model.pwd; parameters[2].Value = model.status; parameters[3].Value = model.lastloginip; parameters[4].Value = model.lastlogindate; parameters[5].Value = model.sysstatus; parameters[6].Value = model.updater; parameters[7].Value = model.updatedata; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.Emp_Dept model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Emp_Dept("); strSql.Append("dept_name,dept_code,dept_pid,dept_order"); strSql.Append(") values ("); strSql.Append("@dept_name,@dept_code,@dept_pid,@dept_order"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@dept_name", SqlDbType.NVarChar,50) , new SqlParameter("@dept_code", SqlDbType.NVarChar,50) , new SqlParameter("@dept_pid", SqlDbType.Int,4) , new SqlParameter("@dept_order", SqlDbType.Int,4) }; parameters[0].Value = model.dept_name; parameters[1].Value = model.dept_code; parameters[2].Value = model.dept_pid; parameters[3].Value = model.dept_order; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.View_Employee_Info model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into View_Employee_Info("); strSql.Append("emp_dept,emp_insti,emp_comp,emp_worknum,emp_cnname,emp_entrydate,emp_email,emp_age,emp_identity,emp_workarea,emp_phone,emp_title,emp_sex"); strSql.Append(") values ("); strSql.Append("@emp_dept,@emp_insti,@emp_comp,@emp_worknum,@emp_cnname,@emp_entrydate,@emp_email,@emp_age,@emp_identity,@emp_workarea,@emp_phone,@emp_title,@emp_sex"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@emp_dept", SqlDbType.NVarChar,100) , new SqlParameter("@emp_insti", SqlDbType.NVarChar,100) , new SqlParameter("@emp_comp", SqlDbType.NVarChar,100) , new SqlParameter("@emp_worknum", SqlDbType.NVarChar,100) , new SqlParameter("@emp_cnname", SqlDbType.NVarChar,100) , new SqlParameter("@emp_entrydate", SqlDbType.DateTime) , new SqlParameter("@emp_email", SqlDbType.NVarChar,100) , new SqlParameter("@emp_age", SqlDbType.NVarChar,100) , new SqlParameter("@emp_identity", SqlDbType.NVarChar,100) , new SqlParameter("@emp_workarea", SqlDbType.NVarChar,100) , new SqlParameter("@emp_phone", SqlDbType.NVarChar,100) , new SqlParameter("@emp_title", SqlDbType.NVarChar,100) , new SqlParameter("@emp_sex", SqlDbType.NVarChar,100) }; parameters[0].Value = model.emp_dept; parameters[1].Value = model.emp_insti; parameters[2].Value = model.emp_comp; parameters[3].Value = model.emp_worknum; parameters[4].Value = model.emp_cnname; parameters[5].Value = model.emp_entrydate; parameters[6].Value = model.emp_email; parameters[7].Value = model.emp_age; parameters[8].Value = model.emp_identity; parameters[9].Value = model.emp_workarea; parameters[10].Value = model.emp_phone; parameters[11].Value = model.emp_title; parameters[12].Value = model.emp_sex; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(AutekInfo.Model.View_BaseAccount model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into View_BaseAccount("); strSql.Append("loginid,pwd,status,lastloginip,lastlogindate,sysstatus,updater,updatedata,emp_dept,emp_id,emp_cnname,role_name,role_code"); strSql.Append(") values ("); strSql.Append("@loginid,@pwd,@status,@lastloginip,@lastlogindate,@sysstatus,@updater,@updatedata,@emp_dept,@emp_id,@emp_cnname,@role_name,@role_code"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@loginid", SqlDbType.NVarChar,50) , new SqlParameter("@pwd", SqlDbType.VarChar,50) , new SqlParameter("@status", SqlDbType.VarChar,100) , new SqlParameter("@lastloginip", SqlDbType.VarChar,50) , new SqlParameter("@lastlogindate", SqlDbType.DateTime) , new SqlParameter("@sysstatus", SqlDbType.Int,4) , new SqlParameter("@updater", SqlDbType.Int,4) , new SqlParameter("@updatedata", SqlDbType.DateTime) , new SqlParameter("@emp_dept", SqlDbType.NVarChar,100) , new SqlParameter("@emp_id", SqlDbType.Int,4) , new SqlParameter("@emp_cnname", SqlDbType.NVarChar,100) , new SqlParameter("@role_name", SqlDbType.NVarChar,50) , new SqlParameter("@role_code", SqlDbType.VarChar,50) }; parameters[0].Value = model.loginid; parameters[1].Value = model.pwd; parameters[2].Value = model.status; parameters[3].Value = model.lastloginip; parameters[4].Value = model.lastlogindate; parameters[5].Value = model.sysstatus; parameters[6].Value = model.updater; parameters[7].Value = model.updatedata; parameters[8].Value = model.emp_dept; parameters[9].Value = model.emp_id; parameters[10].Value = model.emp_cnname; parameters[11].Value = model.role_name; parameters[12].Value = model.role_code; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.View_Menu_Option model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into View_Menu_Option("); strSql.Append("menu_name,menu_isshow,menu_option_name,menu_option_code,menu_pid,menu_sort"); strSql.Append(") values ("); strSql.Append("@menu_name,@menu_isshow,@menu_option_name,@menu_option_code,@menu_pid,@menu_sort"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@menu_name", SqlDbType.NVarChar,100) , new SqlParameter("@menu_isshow", SqlDbType.Bit,1) , new SqlParameter("@menu_option_name", SqlDbType.VarChar,4000) , new SqlParameter("@menu_option_code", SqlDbType.VarChar,4000) , new SqlParameter("@menu_pid", SqlDbType.Int,4) , new SqlParameter("@menu_sort", SqlDbType.Int,4) }; parameters[0].Value = model.menu_name; parameters[1].Value = model.menu_isshow; parameters[2].Value = model.menu_option_name; parameters[3].Value = model.menu_option_code; parameters[4].Value = model.menu_pid; parameters[5].Value = model.menu_sort; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.View_Role_Auths model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into View_Role_Auths("); strSql.Append("role_code,role_name,role_describe,authids,authnames"); strSql.Append(") values ("); strSql.Append("@role_code,@role_name,@role_describe,@authids,@authnames"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@role_code", SqlDbType.VarChar,50) , new SqlParameter("@role_name", SqlDbType.NVarChar,50) , new SqlParameter("@role_describe", SqlDbType.NVarChar,500) , new SqlParameter("@authids", SqlDbType.VarChar,4000) , new SqlParameter("@authnames", SqlDbType.VarChar,4000) }; parameters[0].Value = model.role_code; parameters[1].Value = model.role_name; parameters[2].Value = model.role_describe; parameters[3].Value = model.authids; parameters[4].Value = model.authnames; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.M_Menu_Auth model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update M_Menu_Auth set "); strSql.Append(" auth_id = @auth_id , "); strSql.Append(" menu_options = @menu_options "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) , new SqlParameter("@auth_id", SqlDbType.Int,4) , new SqlParameter("@menu_options", SqlDbType.VarChar,500) }; parameters[0].Value = model.id; parameters[1].Value = model.auth_id; parameters[2].Value = model.menu_options; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.Menu_Options model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Menu_Options set "); strSql.Append(" menu_id = @menu_id , "); strSql.Append(" option_code = @option_code , "); strSql.Append(" option_name = @option_name , "); strSql.Append(" option_desc = @option_desc "); strSql.Append(" where option_id=@option_id "); SqlParameter[] parameters = { new SqlParameter("@option_id", SqlDbType.Int,4) , new SqlParameter("@menu_id", SqlDbType.Int,4) , new SqlParameter("@option_code", SqlDbType.VarChar,50) , new SqlParameter("@option_name", SqlDbType.NVarChar,50) , new SqlParameter("@option_desc", SqlDbType.NVarChar,100) }; parameters[0].Value = model.option_id; parameters[1].Value = model.menu_id; parameters[2].Value = model.option_code; parameters[3].Value = model.option_name; parameters[4].Value = model.option_desc; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.Emp_Dept model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.Emp_Dept model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.Employee_Info model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.M_Emp_Role model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update M_Emp_Role set "); strSql.Append(" emp_id = @emp_id , "); strSql.Append(" role_id = @role_id "); strSql.Append(" where m_emp_role_id=@m_emp_role_id "); SqlParameter[] parameters = { new SqlParameter("@m_emp_role_id", SqlDbType.Int,4) , new SqlParameter("@emp_id", SqlDbType.Int,4) , new SqlParameter("@role_id", SqlDbType.Int,4) }; parameters[0].Value = model.m_emp_role_id; parameters[1].Value = model.emp_id; parameters[2].Value = model.role_id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.M_Menu_Auth model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.View_Emp_Role model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.Emp_Dept model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Emp_Dept set "); strSql.Append(" dept_name = @dept_name , "); strSql.Append(" dept_code = @dept_code , "); strSql.Append(" dept_pid = @dept_pid , "); strSql.Append(" dept_order = @dept_order "); strSql.Append(" where dept_id=@dept_id "); SqlParameter[] parameters = { new SqlParameter("@dept_id", SqlDbType.Int,4) , new SqlParameter("@dept_name", SqlDbType.NVarChar,50) , new SqlParameter("@dept_code", SqlDbType.NVarChar,50) , new SqlParameter("@dept_pid", SqlDbType.Int,4) , new SqlParameter("@dept_order", SqlDbType.Int,4) }; parameters[0].Value = model.dept_id; parameters[1].Value = model.dept_name; parameters[2].Value = model.dept_code; parameters[3].Value = model.dept_pid; parameters[4].Value = model.dept_order; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.M_Menu_Auth model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.Menu_Options model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.Emp_Authority model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Emp_Authority set "); strSql.Append(" auth_code = @auth_code , "); strSql.Append(" auth_name = @auth_name , "); strSql.Append(" auth_remark = @auth_remark "); strSql.Append(" where auth_id=@auth_id "); SqlParameter[] parameters = { new SqlParameter("@auth_id", SqlDbType.Int,4) , new SqlParameter("@auth_code", SqlDbType.VarChar,50) , new SqlParameter("@auth_name", SqlDbType.NVarChar,50) , new SqlParameter("@auth_remark", SqlDbType.NVarChar,50) }; parameters[0].Value = model.auth_id; parameters[1].Value = model.auth_code; parameters[2].Value = model.auth_name; parameters[3].Value = model.auth_remark; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.Emp_Account model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Emp_Account set "); strSql.Append(" loginid = @loginid , "); strSql.Append(" pwd = @pwd , "); strSql.Append(" status = @status , "); strSql.Append(" lastloginip = @lastloginip , "); strSql.Append(" lastlogindate = @lastlogindate , "); strSql.Append(" sysstatus = @sysstatus , "); strSql.Append(" updater = @updater , "); strSql.Append(" updatedata = @updatedata "); strSql.Append(" where loginid=@loginid "); SqlParameter[] parameters = { new SqlParameter("@loginid", SqlDbType.NVarChar,50) , new SqlParameter("@pwd", SqlDbType.VarChar,50) , new SqlParameter("@status", SqlDbType.VarChar,100) , new SqlParameter("@lastloginip", SqlDbType.VarChar,50) , new SqlParameter("@lastlogindate", SqlDbType.DateTime) , new SqlParameter("@sysstatus", SqlDbType.Int,4) , new SqlParameter("@updater", SqlDbType.Int,4) , new SqlParameter("@updatedata", SqlDbType.DateTime) }; parameters[0].Value = model.loginid; parameters[1].Value = model.pwd; parameters[2].Value = model.status; parameters[3].Value = model.lastloginip; parameters[4].Value = model.lastlogindate; parameters[5].Value = model.sysstatus; parameters[6].Value = model.updater; parameters[7].Value = model.updatedata; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.View_Menu_Option model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update View_Menu_Option set "); strSql.Append(" menu_name = @menu_name , "); strSql.Append(" menu_isshow = @menu_isshow , "); strSql.Append(" menu_option_name = @menu_option_name , "); strSql.Append(" menu_option_code = @menu_option_code , "); strSql.Append(" menu_pid = @menu_pid , "); strSql.Append(" menu_sort = @menu_sort "); strSql.Append(" where menu_id=@menu_id "); SqlParameter[] parameters = { new SqlParameter("@menu_id", SqlDbType.Int,4) , new SqlParameter("@menu_name", SqlDbType.NVarChar,100) , new SqlParameter("@menu_isshow", SqlDbType.Bit,1) , new SqlParameter("@menu_option_name", SqlDbType.VarChar,4000) , new SqlParameter("@menu_option_code", SqlDbType.VarChar,4000) , new SqlParameter("@menu_pid", SqlDbType.Int,4) , new SqlParameter("@menu_sort", SqlDbType.Int,4) }; parameters[0].Value = model.menu_id; parameters[1].Value = model.menu_name; parameters[2].Value = model.menu_isshow; parameters[3].Value = model.menu_option_name; parameters[4].Value = model.menu_option_code; parameters[5].Value = model.menu_pid; parameters[6].Value = model.menu_sort; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.View_Emp_Role model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update View_Emp_Role set "); strSql.Append(" role_code = @role_code , "); strSql.Append(" role_name = @role_name , "); strSql.Append(" role_describe = @role_describe , "); strSql.Append(" emp_id = @emp_id , "); strSql.Append(" emp_cnname = @emp_cnname , "); strSql.Append(" m_emp_role_id = @m_emp_role_id , "); strSql.Append(" role_id = @role_id "); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@role_code", SqlDbType.VarChar,50) , new SqlParameter("@role_name", SqlDbType.NVarChar,50) , new SqlParameter("@role_describe", SqlDbType.NVarChar,500) , new SqlParameter("@emp_id", SqlDbType.Int,4) , new SqlParameter("@emp_cnname", SqlDbType.NVarChar,100) , new SqlParameter("@m_emp_role_id", SqlDbType.Int,4) , new SqlParameter("@role_id", SqlDbType.Int,4) }; parameters[0].Value = model.role_code; parameters[1].Value = model.role_name; parameters[2].Value = model.role_describe; parameters[3].Value = model.emp_id; parameters[4].Value = model.emp_cnname; parameters[5].Value = model.m_emp_role_id; parameters[6].Value = model.role_id; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AutekInfo.Model.Emp_Roles model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.Menu_Options model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(AutekInfo.Model.View_Emp_Role model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AutekInfo.Model.Employee_Info model) { return dal.Update(model); }