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