/// <summary>
/// 更新信息
/// </summary>
public void SaveData()
{
var json = Request["data"];
var areaData = Request["areaData"];
var roleValue = Request["roleValue"];
var provinceData = areaData.Split('|')[0];
var cityData = areaData.Split('|')[1];
var area = areaData.Split('|')[2];
var rows = (ArrayList)PluSoft.Utils.JSON.Decode(json);
var bll = new Sys.BLL.UserInfo();
Sys.Model.UserInfo model;
foreach (Hashtable row in rows)
{
var id = row["ID"] != null ? row["ID"].ToString() : "";
//根据记录状态，进行不同的增加、删除、修改操作
var state = row["_state"] != null ? row["_state"].ToString() : "";
if (state == "added" || id == "") //新增：id为空，或_state为added
{
model = new Sys.Model.UserInfo();
model.UserName = row["UserName"].ToString();
model.RealName = row["RealName"].ToString();
model.CompanyName = row["CompanyName"].ToString();
model.ProvinceId = Utils.StrToInt(row["ProvinceId"], 0);
model.ProvinceName = provinceData.Split(':')[1];
model.CityId = Utils.StrToInt(row["CityId"], 0);
model.CityName = cityData.Split(':')[1];
model.AreaId = Utils.StrToInt(row["AreaId"], 0);
model.AreaName = area.Split(':')[1];
model.Address = row["Address"].ToString();
model.RoleId = Utils.StrToInt(row["RoleId"], 0);
model.TypeKey = row["TypeKey"].ToString();
model.TypeValue = roleValue.Split(':')[1];
model.CreateTime = DateTime.Now;
var result = new Sys.BLL.UserInfo().Add(model, Utils.MD5(row["Password"].ToString()));
}
else if (state == "modified" || state == "") //更新：_state为空或modified
{
model = bll.GetModel(Utils.StrToInt(row["ID"], 0));
if (model != null)
{
model.UserName = row["UserName"].ToString();
model.RealName = row["RealName"].ToString();
model.CompanyName = row["CompanyName"].ToString();
model.ProvinceId = Utils.StrToInt(row["ProvinceId"], 0);
model.ProvinceName = provinceData.Split(':')[1];
model.CityId = Utils.StrToInt(row["CityId"], 0);
model.CityName = cityData.Split(':')[1];
model.AreaId = Utils.StrToInt(row["AreaId"], 0);
model.AreaName = area.Split(':')[1];
model.Address = row["Address"].ToString();
model.RoleId = Utils.StrToInt(row["RoleId"], 0);
model.TypeKey = row["TypeKey"].ToString();
model.TypeValue = roleValue.Split(':')[1];
bll.Update(model);
}
}
}
}
/// <summary>
/// 订单人员分配
/// </summary>
public void GetUserInfoByArea()
{
var condition = "1=1";
if (!string.IsNullOrEmpty(Request["proId"]))
{
condition += " and ProvinceId=" + Request["proId"];
}
if (!string.IsNullOrEmpty(Request["cityId"]))
{
condition += " and CityId=" + Request["cityId"];
}
if (!string.IsNullOrEmpty(Request["areaId"]))
{
condition += " and AreaId=" + Request["areaId"];
}
var dt = new Sys.BLL.UserInfo().GetList(condition).Tables[0];
List <Sys.Model.DicModel> lis = new List <Sys.Model.DicModel>();
foreach (DataRow row in dt.Rows)
{
lis.Add(new DicModel()
{
Key = row["UserName"].ToString(), Value = row["RealName"].ToString()
});
}
var json = PluSoft.Utils.JSON.Encode(lis);
Response.Write(json);
}
/// <summary>
/// 查询具体的信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public void GetView()
{
var id = PageRequest.GetInt("id", 0);
var dt = new Sys.BLL.UserInfo().GetUserInfoById(id);
var data = MyDBUtils.DataTable2ArrayList(dt);
var user = data.Count > 0 ? (Hashtable)data[0] : null;
var json = PluSoft.Utils.JSON.Encode(user);
Response.Write(json);
Response.End();
}
public void PasswordUpdateInit()
{
var id = PageRequest.GetInt("id", 0);
var model = new Sys.BLL.UserInfo().GetModel(id);
var json = string.Empty;
if (model != null)
{
json = PluSoft.Utils.JSON.Encode(model);
}
Response.Write(json);
}
/// <summary>
/// 查询
/// </summary>
public void SearchData()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
var userType = PageRequest.GetString("userType");
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1) + 1;
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " u." + sortField + " " + sortOrder;
}
else
{
order += " u.createtime desc";
}
var strWhere = "1=1";
if (!string.IsNullOrEmpty(userType))
{
strWhere += " and u.RoleId=" + userType;
}
if (!string.IsNullOrEmpty(key))
{
strWhere += " and charIndex('" + key + "',u.UserName) > 0";
}
if (pageSize == 1)
{
pageSize = 100;
}
var dt = new Sys.BLL.UserInfo().GetListForMoreTable(pageSize, pageIndex, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
var total = new Sys.BLL.Common().GetCount("UserInfo u", strWhere);
result["total"] = total;
//JSON
var json = PluSoft.Utils.JSON.Encode(result);
Response.Write(json);
}
public void StatusInit()
{
var id = PageRequest.GetInt("id", 0);
var model = new Sys.BLL.UserInfo().GetModel(id);
var json = string.Empty;
if (model != null)
{
var userId = model.UserId;
var memberModel = new Sys.BLL.Member().GetModel(userId);
json = PluSoft.Utils.JSON.Encode(memberModel);
}
Response.Write(json);
}
/// <summary>
/// 注册
/// </summary>
/// <param name="dicParams"></param>
/// <returns></returns>
public Dictionary <string, object> Register(Dictionary <string, object> dicParams)
{
Dictionary <string, object> dicResult = new Dictionary <string, object>();
var dt = JsonHelper.JsonToDataTable(dicParams["user_info"].ToString());
if (dt != null && dt.Rows.Count > 0)
{
var row = dt.Rows[0];
var dtUser = new Sys.BLL.Account().GetUserInfoByUserLoginId(row["USERLOGINID"].ToString());
if (dtUser != null && dtUser.Rows.Count > 0)
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "手机号重复，不能注册！");
return(dicResult);
}
var modelUserInfo = new Sys.Model.UserInfo()
{
UserName = row["USERLOGINID"].ToString(),
RealName = row["USERNAME"].ToString(),
CompanyName = row["CompanyName"].ToString(),
ProvinceId = !string.IsNullOrEmpty(row["ProvinceId"].ToString()) ? Convert.ToInt32(row["ProvinceId"].ToString()) : 0,
ProvinceName = row["ProvinceName"].ToString(),
CityId = !string.IsNullOrEmpty(row["CityId"].ToString()) ? Convert.ToInt32(row["CityId"].ToString()) : 0,
CityName = row["CityName"].ToString(),
AreaId = !string.IsNullOrEmpty(row["AreaId"].ToString()) ? Convert.ToInt32(row["AreaId"].ToString()) : 0,
AreaName = row["AreaName"].ToString(),
Address = row["Address"].ToString(),
contact = row["contact"].ToString(),
TypeKey = row["TypeKey"].ToString(),
TypeValue = row["TypeValue"].ToString(),
RoleId = !string.IsNullOrEmpty(row["RoleId"].ToString()) ? Convert.ToInt32(row["RoleId"].ToString()) : 0,
};
var result = new Sys.BLL.UserInfo().Add(modelUserInfo, Utils.MD5(row["PASSWORD"].ToString()));
if (result > 0)
{
dicResult.Add("response_id", 1);
dicResult.Add("response_msg", "注册成功！");
}
else
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "注册失败！");
}
}
return(dicResult);
}