//屏蔽注册、登录时间 Edited By Liangsx 2011-01-24
public bool Update(BasUser model)
{
bool blFlag;
try
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update bas_user ");
strb.Append(" Set ");
strb.Append("orgid = " + Hi.Common.Utils.IsNull(model.OrgId, "0") + ",");
strb.Append("orgname = '" + model.OrgName + "',");
strb.Append("usercode = '" + model.UserCode + "',");
//strb.Append("userpassword = '******',");
strb.Append("realname = '" + model.RealName + "',");
strb.Append("sex = '" + model.Sex + "',");
strb.Append("usertelephone = '" + model.UserTelephone + "',");
strb.Append("email = '" + model.Email + "',");
strb.Append("qq = '" + model.Qq + "',");
//strb.Append("regtime = '" + model.Regtime + "',");
strb.Append("address = '" + model.Address + "',");
strb.Append("IsLocked = " + model.IsLocked + ",");
//strb.Append("lastloginip = '" + model.Lastloginip + "',");
//strb.Append("logintimes = " + model.Logintimes + ",");
//strb.Append("lastlogintime = '" + model.Lastlogintime + "',");
strb.Append("remark = '" + model.Remark + "'");
strb.Append(" where userid = " + model.UserId.ToString());
blFlag = DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false;
}
catch (Exception ex)
{
throw ex;
}
return(blFlag);
}
public bool Add(Org model)
{
if (model == null)
{
return(false);
}
StringBuilder strb = new StringBuilder();
strb.Append(" Insert Into bas_org ");
strb.Append(" ( ");
//strb.Append("id, ");
strb.Append("org_name, ");
strb.Append("link_name, ");
strb.Append("link_tel, ");
strb.Append("link_mobile ");
strb.Append(" )");
strb.Append(" Values( ");
//strb.Append("" + model.Id + ", ");
strb.Append("'" + model.OrgName + "', ");
strb.Append("'" + model.LinkName + "', ");
strb.Append("'" + model.LinkTel + "', ");
strb.Append("'" + model.LinkMobile + "' ");
strb.Append(" )");
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool ParamDelete(string id)
{
StringBuilder strb = new StringBuilder();
strb.Append(" delete from bas_param where id=" + id + " and enable_flag<>'2'");
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool ParamAdd(BasParam model)
{
StringBuilder strb = new StringBuilder();
strb.Append(" Insert Into bas_param ");
strb.Append(" ( ");
//strb.Append("id, ");
strb.Append("parent_id, ");
strb.Append("grade, ");
strb.Append("code, ");
strb.Append("title, ");
//strb.Append("enumvalue, ");
strb.Append("remark, ");
strb.Append("sort, ");
strb.Append("enable_flag ");
strb.Append(" )");
strb.Append(" Values( ");
//strb.Append("" + model.Id + ", ");
strb.Append("" + model.ParentId + ", ");
strb.Append("'" + model.Grade + "', ");
strb.Append("'" + model.Code + "', ");
strb.Append("'" + model.Title + "', ");
strb.Append("'" + model.Remark + "', ");
strb.Append("'" + model.Sort + "', ");
strb.Append("'" + model.EnableFlag + "' ");
strb.Append(" )");
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
public bool Add(BasUser model)
{
if (model == null)
{
return(false);
}
StringBuilder strb = new StringBuilder();
strb.Append(" Insert Into bas_user ");
strb.Append(" ( ");
//strb.Append("userid, ");//主键是自动增长列，请屏蔽赋值
strb.Append("orgid, ");
strb.Append("orgname,");
strb.Append("usercode, ");
strb.Append("userpassword, ");
strb.Append("realname, ");
strb.Append("sex, ");
strb.Append("usertelephone, ");
strb.Append("email, ");
strb.Append("qq, ");
strb.Append("regtime, ");
strb.Append("address, ");
strb.Append("islocked, ");
// strb.Append("lastloginip, ");
// strb.Append("logintimes, ");
// strb.Append("lastlogintime, ");
strb.Append("remark ");
strb.Append(" )");
strb.Append(" Values( ");
//strb.Append("'" + model.Userid + "', ");
strb.Append("" + Hi.Common.Utils.IsNull(model.OrgId, "0") + ", ");
strb.Append("'" + model.OrgName + "', ");
strb.Append("'" + model.UserCode + "', ");
strb.Append("'" + model.UserPassword + "', ");
strb.Append("'" + model.RealName + "', ");
strb.Append("'" + model.Sex + "', ");
strb.Append("'" + model.UserTelephone + "', ");
strb.Append("'" + model.Email + "', ");
strb.Append("'" + model.Qq + "', ");
strb.Append("'" + model.Regtime + "', ");
strb.Append("'" + model.Address + "', ");
strb.Append("" + model.IsLocked + ", ");
//strb.Append("'" + model.Lastloginip + "', ");
// strb.Append("" + model.Logintimes + ", ");
// strb.Append("'" + model.Lastlogintime + "', ");
strb.Append("'" + model.Remark + "' ");
strb.Append(" )");
try
{
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
catch
{
return(false);
}
}
public int Add(BasLog model)
{
try
{
return(DataBase.ExecuteNonQuery(""));
}
catch
{
return(-1);
}
}
public bool AddRole(BasRole model)
{
try
{
int count = DataBase.ExecuteNonQuery("");
return(count > -1 ? true : false);
}
catch
{
return(false);
}
}
public int DeleteBasLogSql(string id)
{
int num = -1;
string sql = "delete from bas_log_sql where id=" + id;
try
{
num = DataBase.ExecuteNonQuery(sql);
}
catch (Exception exception)
{
throw exception;
}
return(num);
}
public bool Update(Org model)
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update bas_org ");
strb.Append(" Set ");
//strb.Append("id = " + model.Id + ",");
strb.Append("org_name = '" + model.OrgName + "',");
strb.Append("link_name = '" + model.LinkName + "',");
strb.Append("link_tel = '" + model.LinkTel + "',");
strb.Append("link_mobile = '" + model.LinkMobile + "'");
strb.Append(" where id = " + model.Id);
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
public bool UpdateRole(BasRole model)
{
bool blFlag = false;
int num;
try
{
num = DataBase.ExecuteNonQuery("");
}
catch (Exception exception)
{
throw exception;
}
blFlag = (num > 0 ? true : false);
return(blFlag);
}
public bool DeleteRole(string id)
{
bool blFlag = false;
int num = -1;
string sql = "delete from bas_role where id=" + id + " and id not in (select role_id from bas_module_role )";
try
{
num = DataBase.ExecuteNonQuery(sql);
}
catch (Exception exception)
{
throw exception;
}
blFlag = (num > 0 ? true : false);
return(blFlag);
}
public int Delete(string filter)
{
int num = -1;
string sql = "delete from " + this.tableName;
if (!string.IsNullOrEmpty(filter.Trim()))
{
sql = sql + " where " + filter;
}
try
{
num = DataBase.ExecuteNonQuery(sql);
}
catch (Exception exception)
{
throw exception;
}
return(num);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool ParamUpdate(BasParam model)
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update bas_param ");
strb.Append(" Set ");
//strb.Append("id = " + model.Id + ",");
strb.Append("parent_id = " + model.ParentId + ",");
strb.Append("grade = '" + model.Grade + "',");
strb.Append("code = '" + model.Code + "',");
strb.Append("title = '" + model.Title + "',");
strb.Append("remark = '" + model.Remark + "',");
strb.Append("sort = '" + model.Sort + "',");
strb.Append("enable_flag = '" + model.EnableFlag + "'");
strb.Append(" where id = " + model.Id);
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
/// <summary>
/// 重设密码
/// </summary>
/// <param name="UserID">用户ID</param>
/// <param name="newPassword">新密码</param>
/// <returns></returns>
public bool ResetPassword(string UserID, string newPassword)
{
try
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update bas_user ");
strb.Append(" Set ");
strb.Append("userpassword = '******'");
strb.Append(" where userid = " + UserID);
DataBase.ExecuteNonQuery(strb.ToString());
}
catch
{
return(false);
}
return(true);
}
public bool UpdateLogin(BasUser model)
{
try
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update bas_user ");
strb.Append(" Set ");
strb.Append("lastloginip = '" + model.LastLoginIp + "',");
strb.Append("logintimes = " + model.LoginTimes + ",");
strb.Append("lastlogintime = '" + model.LastLoginTime + "'");
strb.Append(" where userid = " + model.UserId.ToString());
DataBase.ExecuteNonQuery(strb.ToString());
}
catch
{
return(false);
}
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool BasModuleUpdate(BasModule model)
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update Bas_Module ");
strb.Append(" Set ");
//strb.Append("module_id = " + model.ModuleId + ",");
strb.Append("module_father = " + model.ModuleFather + ",");
strb.Append("module_code = '" + model.ModuleCode + "',");
strb.Append("module_name = '" + model.ModuleName + "',");
strb.Append("module_icon = '" + model.ModuleIcon + "',");
strb.Append("module_width = " + model.ModuleWidth + ",");
strb.Append("module_height = " + model.ModuleHeight + ",");
strb.Append("module_url = '" + model.ModuleUrl + "',");
strb.Append("module_sort = '" + model.ModuleSort + "',");
strb.Append("enable_flag = '" + model.EnableFlag + "',");
strb.Append("toolbar_flag = '" + model.ToolbarFlag + "',");
strb.Append("module_purview = '" + model.ModulePurview + "'");
strb.Append(" where module_id = " + model.ModuleId);
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
public bool Delete(string id)
{
bool blFlag = false;
int num = -1;
string sql = "delete from bas_org where id=" + id;
string count = DataBase.ExecuteScalarToStr("select count(*) from bas_user where orgid=" + id);
if (Hi.Common.Utils.StrToInt(count) > 0)
{
return(false);
}
try
{
num = DataBase.ExecuteNonQuery(sql);
}
catch (Exception exception)
{
throw exception;
}
blFlag = (num > 0 ? true : false);
return(blFlag);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool BasModuleAdd(BasModule model)
{
StringBuilder strb = new StringBuilder();
strb.Append(" Insert Into Bas_Module ");
strb.Append(" ( ");
//strb.Append("module_id, ");
strb.Append("module_father, ");
strb.Append("module_code, ");
strb.Append("module_name, ");
strb.Append("module_icon, ");
strb.Append("module_width, ");
strb.Append("module_height, ");
strb.Append("module_url, ");
strb.Append("module_sort, ");
strb.Append("enable_flag, ");
strb.Append("toolbar_flag, ");
strb.Append("module_purview ");
strb.Append(" )");
strb.Append(" Values( ");
//strb.Append("" + model.ModuleId + ", ");
strb.Append("" + model.ModuleFather + ", ");
strb.Append("'" + model.ModuleCode + "', ");
strb.Append("'" + model.ModuleName + "', ");
strb.Append("'" + model.ModuleIcon + "', ");
strb.Append("" + model.ModuleWidth + ", ");
strb.Append("" + model.ModuleHeight + ", ");
strb.Append("'" + model.ModuleUrl + "', ");
strb.Append("'" + model.ModuleSort + "', ");
strb.Append("'" + model.EnableFlag + "', ");
strb.Append("'" + model.ToolbarFlag + "', ");
strb.Append("'" + model.ModulePurview + "' ");
strb.Append(" )");
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
/// <summary>
/// 更新用户操作权限
/// </summary>
/// <param name="user_id"></param>
/// <param name="strPurview"></param>
/// <returns></returns>
public bool UpdatePurview(string user_id, string strPurview)
{
string strSql = "update bas_user set purview='" + strPurview + "' where userid=" + user_id;
return(DataBase.ExecuteNonQuery(strSql) > 0 ? true : false);
}
public bool Delete(string user_id)
{
return(DataBase.ExecuteNonQuery("select from bas_user where userid=" + user_id) > 0 ? true : false);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool BasModuleDelete(string id)
{
string strSql = "delete from Bas_Module where module_id =" + id + " and module_id not in (select module_id from bas_module_role ) ";
return(DataBase.ExecuteNonQuery(strSql) > 0 ? true : false);
}