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