/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
//public string CheckPageInfo(string type, string userid, string uname, string upwd, string realname, string umobile, string empcode, string remark, string status, string cname, string ccode, string scope, string stocode, string sigmonthmoney, string sigstocode,string buscode, string utype, out string spansid)
public bool CheckPageInfo(string type, string userid, string uname, string upwd, string realname, string umobile, string remark, string status, string cname, string ccode)
{
bool rel = false;
try
{
Entity = new AdminsEntity();
Entity.userid = StringHelper.StringToInt(userid);
Entity.uname = uname;
Entity.upwd = OEncryp.Encrypt(upwd);
Entity.realname = realname;
Entity.umobile = umobile;
Entity.remark = remark;
Entity.status = status;
Entity.cname = cname;
Entity.ccode = ccode;
rel = true;
}
catch (Exception)
{
}
return(rel);
}
private void CheckUser(string username, string password)
{
bllAdmins bll = new bllAdmins();
string userpwd = OEncryp.Encrypt(password);
AdminsEntity adminEntity = bll.GetEntitySigInfo(" WHERE uname='" + username + "' AND upwd='" + userpwd + "'");
if (adminEntity.userid > 0)
{
LoginedUserEntity loginedUser = new LoginedUserEntity(adminEntity.userid.ToString(), adminEntity.upwd, adminEntity.uname, adminEntity.umobile);
DataTable dtPermission = bll.GetPermissionInfo(loginedUser.GUID, loginedUser.UserID, loginedUser.UserID);
if (dtPermission != null && dtPermission.Rows.Count > 0)
{
loginedUser.Permission = dtPermission;
loginedUser.SetLoginCookie();
//string appJson = JsonHelper.ObjectToJSON(loginedUser);
Context.Cache.Insert("logincache_" + loginedUser.UserID, loginedUser);
loginedUser.SetLoginCookie();
Response.Redirect("index.html");
}
else
{
Message.InnerHtml = "您的帐号无效，请联系管理员！";
}
}
else
{
Message.InnerHtml = "用户或密码错误！";
}
}
/// <summary>
/// 更新一条数据
/// </summary>
//public DataTable Update(string GUID, string UID, string userid, string uname, string upwd, string realname, string umobile, string empcode, string remark, string status, string cname, string ccode, string role, string scope, string stocode, string sigmonthmoney, string sigstocode,string buscode,string utype, operatelogEntity entity)
public void Update(string GUID, string UID, AdminsEntity UEntity, string role)
{
//更新数据
int result = dal.Update(UEntity, role);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private AdminsEntity SetEntityInfo(DataRow dr)
{
AdminsEntity Entity = new AdminsEntity();
Entity.userid = StringHelper.StringToLong(dr["userid"].ToString());
Entity.strcode = dr["strcode"].ToString();
Entity.uname = dr["uname"].ToString();
Entity.upwd = dr["upwd"].ToString();
Entity.realname = dr["realname"].ToString();
Entity.umobile = dr["umobile"].ToString();
Entity.remark = dr["remark"].ToString();
Entity.status = dr["status"].ToString();
return(Entity);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref AdminsEntity Entity, string role)
{
StringBuilder sql = new StringBuilder();
sql.Append("IF NOT EXISTS(Select 1 from[dbo].[admins] Where uname = '" + Entity.uname + "')");
sql.Append(" BEGIN");
sql.Append(" BEGIN TRAN tran1");
sql.Append(" declare @userid bigint;");
sql.Append(" set @userid = 0;");
sql.Append(" declare @result bigint;");
sql.Append(" set @result = 0;");
sql.Append(" declare @empid varchar(8);");
sql.Append(" set @empid = '';");
sql.Append(" exec[dbo].[p_GetEmpID] @empid output;");
sql.Append(" declare @stocode varchar(8);");
sql.Append(" set @stocode = '';");
sql.Append(" declare @realname varchar(64);");
sql.Append(" set @realname = '';");
sql.Append(" declare @mescode varchar(64);");
sql.Append(" set @mescode = '';");
sql.Append(" declare @PY varchar(64);select top 1 @realname=cname,@PY=dbo.fn_GetPy(cname) from Employee where ecode=@empcode;");
sql.Append(" INSERT INTO[admins]([buscode],[strcode],[uname],[upwd],[realname],[umobile],[empcode],[remark],[status],[cuser],[ctime],[uuser],[utime], isdelete, scope, stocode, empid,msigmoney,PY)");
sql.Append(" VALUES('" + Entity.buscode + "', '', '" + Entity.uname + "', '" + Entity.upwd + "',@realname, '" + Entity.umobile + "', @empcode, '" + Entity.remark + "', '" + Entity.status + "', getdate(), null, NULL, null, @PY);");
sql.Append(" SET @userid = SCOPE_IDENTITY();");
sql.Append(" insert into userrole([userid], roleid, ctime) select @userid, col, getdate() from[dbo].[fn_StringSplit]('" + role + "', ',') where len(col)> 0;");
sql.Append(" IF(@@ERROR = 0)");
sql.Append(" BEGIN");
sql.Append(" COMMIT TRAN tran1;");
sql.Append(" set @result=0;");
sql.Append(" END");
sql.Append(" ELSE");
sql.Append(" BEGIN");
sql.Append(" ROLLBACK TRAN tran1;");
sql.Append(" set @result=-1;");
sql.Append(" END");
sql.Append(" END");
sql.Append(" ELSE");
sql.Append(" BEGIN");
sql.Append(" set @result= 1;");
sql.Append(" select @result;");
sql.Append("END");
intReturn = 0;
intReturn = DBHelper.ExecuteNonQuery(sql.ToString());
return(intReturn);
}
//保存数据
protected void Save_btn_Click(object sender, EventArgs e)
{
string role = hidroleid.Value.TrimEnd(',');
if (role.Length == 0)
{
Script(Page, "pcLayerMsg('选择角色！');");
return;
}
//获取页面信息
string username = txt_uname.Text;
string pwd = txt_pwd.Text;
string umobile = "";
string status = ddl_status.SelectedValue;
string descr = txt_descr.Text;
DataTable dt = new DataTable();
if (hidId.Value.Length == 0)//添加信息
{
bll.Add("0", "0", id, username, pwd, "", umobile, descr, status, base.LoginedUser.Name, LoginedUser.UserID.ToString(), role);
hidId.Value = id;
this.PageTitle.Operate = "修改";
}
else//修改信息
{
string uid = hidId.Value.ToString();
AdminsEntity UEntity = bll.GetEntitySigInfo("where userid=" + uid);
UEntity.uname = username;
UEntity.upwd = pwd;
UEntity.umobile = umobile;
UEntity.remark = descr;
bll.Update("0", "0", UEntity, role);
Context.Cache.Remove("RoleInfo_BackWeb_" + hidId.Value);
}
//显示结果
if (ShowResult(bll.oResult.Code, bll.oResult.Msg, errormessage))
{
SetPage(hidId.Value);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(AdminsEntity Entity, string role)
{
StringBuilder sql = new StringBuilder();
sql.Append(" BEGIN");
sql.Append(" BEGIN TRAN tran1");
sql.Append(" declare @userid bigint;");
sql.Append(" set @userid = " + Entity.userid + ";");
sql.Append(" declare @result bigint;");
sql.Append(" set @result = 0;");
sql.Append(" declare @stocode varchar(8);");
sql.Append(" set @stocode = '';");
sql.Append(" declare @realname varchar(64);");
sql.Append(" set @realname = '';");
sql.Append(" declare @mescode varchar(64);");
sql.Append(" set @mescode = '';");
sql.Append(" declare @PY varchar(64);select top 1 @realname=cname,@PY=dbo.fn_GetPy(cname) from Employee where ecode=@empcode;");
sql.Append(" UPDATE [dbo].[admins] SET[uname] = '" + Entity.uname + "',[realname]=@realname,[umobile]='" + Entity.umobile + "',[remark]= '" + Entity.remark + "',[status]='" + Entity.status + "',[utime]=GETDATE(),PY=@PY WHERE userid=" + Entity.userid + ";");
sql.Append(" DELETE FROM userrole where userid=" + Entity.userid + "; ");
sql.Append(" insert into userrole([userid], roleid, ctime) select @userid, col, getdate() from[dbo].[fn_StringSplit]('" + role + "', ',') where len(col)> 0;");
sql.Append(" IF(@@ERROR = 0)");
sql.Append(" BEGIN");
sql.Append(" COMMIT TRAN tran1;");
sql.Append(" set @result=0;");
sql.Append(" END");
sql.Append(" ELSE");
sql.Append(" BEGIN");
sql.Append(" ROLLBACK TRAN tran1;");
sql.Append(" set @result=-1;");
sql.Append(" END");
sql.Append(" END");
sql.Append(" select @result;");
intReturn = 0;
intReturn = DBHelper.ExecuteNonQuery(sql.ToString());
return(intReturn);
}
