void Run(HttpContext context) { string GetType = this.TypeName; string GetMethod = this.MethodName; Eastcom.Model.v_Sys_User_Info model = Eastcom.BLL.SessionConfig.GetUserInfo(); Eastcom.Model.Sys_User_Info UserModel = new Eastcom.BLL.Sys_User_Info().GetModel(model.UserID); if (model == null) { throw new Exception("操作超时"); } string returnValue = ""; /*受理*/ if (GetMethod == "Accept")//受理操作 { if (UserModel == null) { returnValue = @"{""Data"":"""",""Message"":""操作超时"",""IsError"":true}"; } else { } returnValue = @"{""Data"":"""",""Message"":""密码修改失败"",""IsError"":true}"; context.Response.Write(returnValue); context.ApplicationInstance.CompleteRequest(); return; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Eastcom.Model.v_Sys_User_Info GetModel(int UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserID,UserName,RealName,NickName,Pwd,FK_UnitID,UserArea,Sex,Age,Email,Tel,QQ,Address,Birth,Contact,Remark,FK_CreateID,CreateTime,FK_EditID,EditTime,State,IsDel,UserMangerArea,角色名,角色ID,最大角色权重,性别,创建者名,修改者名,账户状态,所在地区 from v_Sys_User_Info "); strSql.Append(" where UserID=@UserID "); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameters[0].Value = UserID; Eastcom.Model.v_Sys_User_Info model = new Eastcom.Model.v_Sys_User_Info(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Eastcom.Model.v_Sys_User_Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into v_Sys_User_Info("); strSql.Append("UserID,UserName,RealName,NickName,Pwd,FK_UnitID,UserArea,Sex,Age,Email,Tel,QQ,Address,Birth,Contact,Remark,FK_CreateID,CreateTime,FK_EditID,EditTime,State,IsDel,UserMangerArea,角色名,角色ID,最大角色权重,性别,创建者名,修改者名,账户状态,所在地区)"); strSql.Append(" values ("); strSql.Append("@UserID,@UserName,@RealName,@NickName,@Pwd,@FK_UnitID,@UserArea,@Sex,@Age,@Email,@Tel,@QQ,@Address,@Birth,@Contact,@Remark,@FK_CreateID,@CreateTime,@FK_EditID,@EditTime,@State,@IsDel,@UserMangerArea,@角色名,@角色ID,@最大角色权重,@性别,@创建者名,@修改者名,@账户状态,@所在地区)"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@RealName", SqlDbType.VarChar, 50), new SqlParameter("@NickName", SqlDbType.VarChar, 50), new SqlParameter("@Pwd", SqlDbType.VarChar, 100), new SqlParameter("@FK_UnitID", SqlDbType.Int, 4), new SqlParameter("@UserArea", SqlDbType.Int, 4), new SqlParameter("@Sex", SqlDbType.TinyInt, 1), new SqlParameter("@Age", SqlDbType.TinyInt, 1), new SqlParameter("@Email", SqlDbType.VarChar, 100), new SqlParameter("@Tel", SqlDbType.VarChar, 50), new SqlParameter("@QQ", SqlDbType.VarChar, 50), new SqlParameter("@Address", SqlDbType.VarChar, 100), new SqlParameter("@Birth", SqlDbType.SmallDateTime), new SqlParameter("@Contact", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.VarChar, 1000), new SqlParameter("@FK_CreateID", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@FK_EditID", SqlDbType.Int, 4), new SqlParameter("@EditTime", SqlDbType.DateTime), new SqlParameter("@State", SqlDbType.TinyInt, 1), new SqlParameter("@IsDel", SqlDbType.TinyInt, 1), new SqlParameter("@UserMangerArea", SqlDbType.VarChar, 50), new SqlParameter("@角色名", SqlDbType.VarChar, 4000), new SqlParameter("@角色ID", SqlDbType.VarChar, 4000), new SqlParameter("@最大角色权重", SqlDbType.Int, 4), new SqlParameter("@性别", SqlDbType.VarChar, 500), new SqlParameter("@创建者名", SqlDbType.VarChar, 50), new SqlParameter("@修改者名", SqlDbType.VarChar, 50), new SqlParameter("@账户状态", SqlDbType.VarChar, 500), new SqlParameter("@所在地区", SqlDbType.VarChar, 500) }; parameters[0].Value = model.UserID; parameters[1].Value = model.UserName; parameters[2].Value = model.RealName; parameters[3].Value = model.NickName; parameters[4].Value = model.Pwd; parameters[5].Value = model.FK_UnitID; parameters[6].Value = model.UserArea; parameters[7].Value = model.Sex; parameters[8].Value = model.Age; parameters[9].Value = model.Email; parameters[10].Value = model.Tel; parameters[11].Value = model.QQ; parameters[12].Value = model.Address; parameters[13].Value = model.Birth; parameters[14].Value = model.Contact; parameters[15].Value = model.Remark; parameters[16].Value = model.FK_CreateID; parameters[17].Value = model.CreateTime; parameters[18].Value = model.FK_EditID; parameters[19].Value = model.EditTime; parameters[20].Value = model.State; parameters[21].Value = model.IsDel; parameters[22].Value = model.UserMangerArea; parameters[23].Value = model.角色名; parameters[24].Value = model.角色ID; parameters[25].Value = model.最大角色权重; parameters[26].Value = model.性别; parameters[27].Value = model.创建者名; parameters[28].Value = model.修改者名; parameters[29].Value = model.账户状态; parameters[30].Value = model.所在地区; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Eastcom.Model.v_Sys_User_Info DataRowToModel(DataRow row) { Eastcom.Model.v_Sys_User_Info model = new Eastcom.Model.v_Sys_User_Info(); if (row != null) { if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = int.Parse(row["UserID"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["RealName"] != null) { model.RealName = row["RealName"].ToString(); } if (row["NickName"] != null) { model.NickName = row["NickName"].ToString(); } if (row["Pwd"] != null) { model.Pwd = row["Pwd"].ToString(); } if (row["FK_UnitID"] != null && row["FK_UnitID"].ToString() != "") { model.FK_UnitID = int.Parse(row["FK_UnitID"].ToString()); } if (row["UserArea"] != null && row["UserArea"].ToString() != "") { model.UserArea = int.Parse(row["UserArea"].ToString()); } if (row["Sex"] != null && row["Sex"].ToString() != "") { model.Sex = int.Parse(row["Sex"].ToString()); } if (row["Age"] != null && row["Age"].ToString() != "") { model.Age = int.Parse(row["Age"].ToString()); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["Tel"] != null) { model.Tel = row["Tel"].ToString(); } if (row["QQ"] != null) { model.QQ = row["QQ"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["Birth"] != null && row["Birth"].ToString() != "") { model.Birth = DateTime.Parse(row["Birth"].ToString()); } if (row["Contact"] != null) { model.Contact = row["Contact"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["FK_CreateID"] != null && row["FK_CreateID"].ToString() != "") { model.FK_CreateID = int.Parse(row["FK_CreateID"].ToString()); } if (row["CreateTime"] != null && row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["FK_EditID"] != null && row["FK_EditID"].ToString() != "") { model.FK_EditID = int.Parse(row["FK_EditID"].ToString()); } if (row["EditTime"] != null && row["EditTime"].ToString() != "") { model.EditTime = DateTime.Parse(row["EditTime"].ToString()); } if (row["State"] != null && row["State"].ToString() != "") { model.State = int.Parse(row["State"].ToString()); } if (row["IsDel"] != null && row["IsDel"].ToString() != "") { model.IsDel = int.Parse(row["IsDel"].ToString()); } if (row["UserMangerArea"] != null && row["UserMangerArea"].ToString() != "") { model.UserMangerArea = row["UserMangerArea"].ToString(); } if (row["角色名"] != null) { model.角色名 = row["角色名"].ToString(); } if (row["角色ID"] != null) { model.角色ID = row["角色ID"].ToString(); } if (row["最大角色权重"] != null && row["最大角色权重"].ToString() != "") { model.最大角色权重 = int.Parse(row["最大角色权重"].ToString()); } if (row["性别"] != null) { model.性别 = row["性别"].ToString(); } if (row["创建者名"] != null) { model.创建者名 = row["创建者名"].ToString(); } if (row["修改者名"] != null) { model.修改者名 = row["修改者名"].ToString(); } if (row["账户状态"] != null) { model.账户状态 = row["账户状态"].ToString(); } if (row["所在地区"] != null) { model.所在地区 = row["所在地区"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eastcom.Model.v_Sys_User_Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update v_Sys_User_Info set "); strSql.Append("UserID=@UserID,"); strSql.Append("UserName=@UserName,"); strSql.Append("RealName=@RealName,"); strSql.Append("NickName=@NickName,"); strSql.Append("Pwd=@Pwd,"); strSql.Append("FK_UnitID=@FK_UnitID,"); strSql.Append("UserArea=@UserArea,"); strSql.Append("Sex=@Sex,"); strSql.Append("Age=@Age,"); strSql.Append("Email=@Email,"); strSql.Append("Tel=@Tel,"); strSql.Append("QQ=@QQ,"); strSql.Append("Address=@Address,"); strSql.Append("Birth=@Birth,"); strSql.Append("Contact=@Contact,"); strSql.Append("Remark=@Remark,"); strSql.Append("FK_CreateID=@FK_CreateID,"); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("FK_EditID=@FK_EditID,"); strSql.Append("EditTime=@EditTime,"); strSql.Append("State=@State,"); strSql.Append("IsDel=@IsDel,"); strSql.Append("UserMangerArea=@UserMangerArea,"); strSql.Append("角色名=@角色名,"); strSql.Append("角色ID=@角色ID,"); strSql.Append("最大角色权重=@最大角色权重,"); strSql.Append("性别=@性别,"); strSql.Append("创建者名=@创建者名,"); strSql.Append("修改者名=@修改者名,"); strSql.Append("账户状态=@账户状态,"); strSql.Append("所在地区=@所在地区"); strSql.Append(" where UserID=@UserID "); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@RealName", SqlDbType.VarChar, 50), new SqlParameter("@NickName", SqlDbType.VarChar, 50), new SqlParameter("@Pwd", SqlDbType.VarChar, 100), new SqlParameter("@FK_UnitID", SqlDbType.Int, 4), new SqlParameter("@UserArea", SqlDbType.Int, 4), new SqlParameter("@Sex", SqlDbType.TinyInt, 1), new SqlParameter("@Age", SqlDbType.TinyInt, 1), new SqlParameter("@Email", SqlDbType.VarChar, 100), new SqlParameter("@Tel", SqlDbType.VarChar, 50), new SqlParameter("@QQ", SqlDbType.VarChar, 50), new SqlParameter("@Address", SqlDbType.VarChar, 100), new SqlParameter("@Birth", SqlDbType.SmallDateTime), new SqlParameter("@Contact", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.VarChar, 1000), new SqlParameter("@FK_CreateID", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@FK_EditID", SqlDbType.Int, 4), new SqlParameter("@EditTime", SqlDbType.DateTime), new SqlParameter("@State", SqlDbType.TinyInt, 1), new SqlParameter("@IsDel", SqlDbType.TinyInt, 1), new SqlParameter("@UserMangerArea", SqlDbType.VarChar, 50), new SqlParameter("@角色名", SqlDbType.VarChar, 4000), new SqlParameter("@角色ID", SqlDbType.VarChar, 4000), new SqlParameter("@最大角色权重", SqlDbType.Int, 4), new SqlParameter("@性别", SqlDbType.VarChar, 500), new SqlParameter("@创建者名", SqlDbType.VarChar, 50), new SqlParameter("@修改者名", SqlDbType.VarChar, 50), new SqlParameter("@账户状态", SqlDbType.VarChar, 500), new SqlParameter("@所在地区", SqlDbType.VarChar, 500) }; parameters[0].Value = model.UserID; parameters[1].Value = model.UserName; parameters[2].Value = model.RealName; parameters[3].Value = model.NickName; parameters[4].Value = model.Pwd; parameters[5].Value = model.FK_UnitID; parameters[6].Value = model.UserArea; parameters[7].Value = model.Sex; parameters[8].Value = model.Age; parameters[9].Value = model.Email; parameters[10].Value = model.Tel; parameters[11].Value = model.QQ; parameters[12].Value = model.Address; parameters[13].Value = model.Birth; parameters[14].Value = model.Contact; parameters[15].Value = model.Remark; parameters[16].Value = model.FK_CreateID; parameters[17].Value = model.CreateTime; parameters[18].Value = model.FK_EditID; parameters[19].Value = model.EditTime; parameters[20].Value = model.State; parameters[21].Value = model.IsDel; parameters[22].Value = model.UserMangerArea; parameters[23].Value = model.角色名; parameters[24].Value = model.角色ID; parameters[25].Value = model.最大角色权重; parameters[26].Value = model.性别; parameters[27].Value = model.创建者名; parameters[28].Value = model.修改者名; parameters[29].Value = model.账户状态; parameters[30].Value = model.所在地区; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
void Run(HttpContext context) { string GetType = this.TypeName; string GetMethod = this.MethodName; string GetLoginPasswordName = this.LoginPasswordName; string GetOldPasswordName = this.OldPasswordName; Eastcom.Model.v_Sys_User_Info model = Eastcom.BLL.SessionConfig.GetUserInfo(); Eastcom.Model.Sys_User_Info UserModel = new Eastcom.BLL.Sys_User_Info().GetModel(model.UserID); string returnValue = ""; if (GetMethod == "GetMyFavorite") { return; } if (GetMethod == "ChangePassword") { if (model == null) { returnValue = @"{""Data"":"""",""Message"":""操作超时"",""IsError"":true}"; } else { if (Eastcom.Common.DeseEncode.DESEncryptMethod(GetOldPasswordName) != UserModel.Pwd) { returnValue = @"{""Data"":"""",""Message"":""密码错误"",""IsError"":true}"; } else { UserModel.Pwd = Eastcom.Common.DeseEncode.DESEncryptMethod(GetLoginPasswordName); if (new Eastcom.BLL.Sys_User_Info().Update(UserModel)) { returnValue = @"{""Data"":"""",""Message"":""密码修改成功""}"; } else { returnValue = @"{""Data"":"""",""Message"":""密码修改失败"",""IsError"":true}"; } } } context.Response.Write(returnValue); context.ApplicationInstance.CompleteRequest(); return; } /*受理*/ if (GetMethod == "Accept")//受理操作 { //if (UserModel == null) //{ // returnValue = @"{""Data"":"""",""Message"":""操作超时"",""IsError"":true}"; //} //else //{ // if (TypeName == "Public") //Public // { // BTSMng.Model.Public_Complaint_Info Model = new Model.Public_Complaint_Info(); // Model = new BLL.Public_Complaint_Info().GetModel(CommonClass.StringHander.Common.GetInt(GetID)); // Model.预处理受理人 = UserModel.RealName; // Model.预处理受理时间 = DateTime.Now; // if (new BLL.Public_Complaint_Info().Update(Model)) // returnValue = string.Format(@"{{""Data"":{{""userName"":""{0}"",""OperDataTime"":""{1}""}},""Message"":""受理成功"",""IsError"":false}}", UserModel.RealName, Model.预处理受理时间.ToString()); // else // returnValue = @"{""Data"":"""",""Message"":""受理失败"",""IsError"":true}"; // } // else if (TypeName == "InSite") //Public // { // BTSMng.Model.InSite_Complaint_Info Model = new Model.InSite_Complaint_Info(); // Model = new BLL.InSite_Complaint_Info().GetModelBy_FK(Common.GetInt(this.GetID), false); // // Model = new BLL.InSite_Complaint_Info().GetModel(CommonClass.StringHander.Common.GetInt(GetID)); // //InterNetComplaint.Model.InSite_Complaint_Info model = new Model.InSite_Complaint_Info(); // //model = bll.GetModelBy_FK(Common.GetInt(this.id), false);//Fk_Id // Model.现场处理受理人 = UserModel.RealName; // Model.现场处理受理时间 = DateTime.Now; // if (new BLL.InSite_Complaint_Info().Update(Model)) // returnValue = string.Format(@"{{""Data"":{{""userName"":""{0}"",""OperDataTime"":""{1}""}},""Message"":""受理成功"",""IsError"":false}}", UserModel.RealName, Model.现场处理受理时间.ToString()); // else // returnValue = @"{""Data"":"""",""Message"":""受理失败"",""IsError"":true}"; // } // else if (TypeName == "Optimization") //Public // { // InterNetComplaint.Model.Optimization_Info Model = new Model.Optimization_Info(); // //Model = new BLL.Optimization_Info().GetModel(CommonClass.StringHander.Common.GetInt(GetID)); // Model = new BLL.Optimization_Info().GetModelBy_FK(Common.GetInt(this.GetID), false); // Model.优化处理受理人 = UserModel.RealName; // Model.优化处理受理时间 = DateTime.Now; // if (new BLL.Optimization_Info().Update(Model)) // returnValue = string.Format(@"{{""Data"":{{""userName"":""{0}"",""OperDataTime"":""{1}""}},""Message"":""受理成功"",""IsError"":false}}", UserModel.RealName, Model.优化处理受理人.ToString()); // else // returnValue = @"{""Data"":"""",""Message"":""受理失败"",""IsError"":true}"; // } // else // returnValue = @"{""Data"":"""",""Message"":""受理失败"",""IsError"":true}"; //} context.Response.Write(returnValue); context.ApplicationInstance.CompleteRequest(); return; } }