public bool DeleteUser(T_User t_User)
{
return(mapper.Update("DeleteT_User", t_User) > 0);
}
public bool ChangeUserPwd(T_User t_User)
{
return(mapper.Update("UpdateT_User_PWD", t_User) > 0);
}
public static void ModifyT_User(T_User t_User)
{
T_UserService.ModifyT_User(t_User);
}
//执行DAL中的 泛型方法
public int InsertUser(T_User user)
{
DaoTemplate dao = new DaoTemplate();
return(dao.CallMethod <T_User>(new Func <T_User, int>(dao.AddObject), user));
}
public ApiResultModel AddFeedback(FeedbackModel model)
{
ApiResultModel resultModel = new ApiResultModel();
try
{
//根据用户Id查找业主
IUserBLL ownerBll = BLLFactory <IUserBLL> .GetBLL("UserBLL");
T_User owner = ownerBll.GetEntity(u => u.Id == model.UserId && u.DelFlag == ConstantParam.DEL_FLAG_DEFAULT);
//如果业主不存在
if (owner != null)
{
//如果验证Token不通过或已过期
if (DateTime.Now > owner.TokenInvalidTime || model.Token != owner.Token)
{
resultModel.result = APIMessage.TOKEN_INVALID;
return(resultModel);
}
//更新最近登录时间和Token失效时间
owner.LatelyLoginTime = DateTime.Now;
owner.TokenInvalidTime = DateTime.Now.AddDays(Convert.ToInt32(PropertyUtils.GetConfigParamValue("TokenInvalid")));
ownerBll.Update(owner);
//意见反馈信息上传
T_Feedback feedback = new T_Feedback()
{
UserId = model.UserId,
UploadTime = DateTime.Now,
Content = model.Content
};
//意见反馈 图片保存目录
string directory = HttpContext.Current.Server.MapPath(ConstantParam.FEEDBACK);
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
//意见反馈 图片上传
if (!string.IsNullOrEmpty(model.PicList))
{
var fileName = DateTime.Now.ToFileTime().ToString() + ".zip";
string filepath = Path.Combine(directory, fileName);
using (FileStream fs = new FileStream(filepath, FileMode.Create))
{
using (BinaryWriter bw = new BinaryWriter(fs))
{
byte[] datas = Convert.FromBase64String(model.PicList);
bw.Write(datas);
bw.Close();
}
}
//图片集保存路径
feedback.Img = PropertyUtils.UnZip(filepath, directory, ConstantParam.FEEDBACK);
}
//保存意见反馈
IFeedbackBLL feedbackBll = BLLFactory <IFeedbackBLL> .GetBLL("FeedbackBLL");
feedbackBll.Save(feedback);
}
else
{
resultModel.Msg = APIMessage.NO_USER;
}
}
catch
{
resultModel.Msg = APIMessage.REQUEST_EXCEPTION;
}
return(resultModel);
}
public static T_User AddT_User(T_User t_User)
{
return(T_UserService.AddT_User(t_User));
}
public bool DeleteUser(T_User t_User)
{
return(userDAO.DeleteUser(t_User));
}
// POST: api/User
public IHttpActionResult Post([FromBody] T_User entity)
{
Service.Add(entity);
Service.SaveChanges();
return(Json(entity));
}
public ApiResultModel CreateWeixinPayTrade(DetailSearchModel model)
{
ApiResultModel resultModel = new ApiResultModel();
try
{
//根据用户ID查找业主
IUserBLL ownerBll = BLLFactory <IUserBLL> .GetBLL("UserBLL");
T_User owner = ownerBll.GetEntity(u => u.Id == model.UserId && u.DelFlag == ConstantParam.DEL_FLAG_DEFAULT);
//如果业主存在
if (owner != null)
{
//如果验证Token不通过或已过期
if (DateTime.Now > owner.TokenInvalidTime || model.Token != owner.Token)
{
resultModel.Msg = APIMessage.TOKEN_INVALID;
return(resultModel);
}
//更新最近登录时间和Token失效时间
owner.LatelyLoginTime = DateTime.Now;
owner.TokenInvalidTime = DateTime.Now.AddDays(Convert.ToInt32(PropertyUtils.GetConfigParamValue("TokenInvalid")));
ownerBll.Update(owner);
//生成微信支付订单
IHouseUserExpenseDetailsBLL expenseDetailsBLL = BLLFactory <IHouseUserExpenseDetailsBLL> .GetBLL("HouseUserExpenseDetailsBLL");
var record = expenseDetailsBLL.GetEntity(e => e.Id == model.Id);
if (record != null)
{
//获取物业缴费账户信息
T_PropertyAccount wxAccount = null;
if (record.BuildDoorId != null)
{
wxAccount = record.BuildDoor.BuildUnit.Build.PropertyPlace.PropertyAccounts.Where(
a => a.AccountType == ConstantParam.PROPERTY_ACCOUNT_WeChat).FirstOrDefault();
}
else
{
wxAccount = record.BuildCompany.PropertyPlace.PropertyAccounts.Where(
a => a.AccountType == ConstantParam.PROPERTY_ACCOUNT_WeChat).FirstOrDefault();
}
if (wxAccount == null)
{
resultModel.Msg = "该用户所属物业未设置账户信息";
return(resultModel);
}
//获取物业账户信息
string WeixinAppId = wxAccount.Number;
string WeixinMchId = wxAccount.MerchantNo;
string WeixinPayKey = wxAccount.AccountKey;
//生成预订单
string result = CreateTradePost(record, WeixinAppId, WeixinMchId, WeixinPayKey);
//如果请求失败
if (result == null)
{
resultModel.Msg = APIMessage.WEIXIN_YUORDER_FAIL;
return(resultModel);
}
//解析返回结果
XmlDocument doc = new XmlDocument();
doc.LoadXml(result);
string return_code = doc.GetElementsByTagName("return_code")[0].InnerText;
//如果返回成功
if (return_code == "SUCCESS")
{
string result_code = doc.GetElementsByTagName("result_code")[0].InnerText;
if (result_code == "SUCCESS")
{
//预支付交易会话标识
string prepayid = doc.GetElementsByTagName("prepay_id")[0].InnerText;
//随机字符串
string str = "1234567890abcdefghijklmnopqrstuvwxyz";
Random r = new Random();
string PayRandomStr = "";
for (int i = 0; i < 32; i++)
{
PayRandomStr += str[r.Next(str.Length)].ToString();
}
//时间戳
var timestamp = Convert.ToInt64(DateTime.Now.Subtract(DateTime.Parse("1970-1-1")).TotalMilliseconds / 10000) * 10;
//签名字符串
string PaySignStr = "appid=" + WeixinAppId + "&noncestr=" + PayRandomStr + "&package=Sign=WXPay&partnerid="
+ WeixinMchId + "&prepayid=" + prepayid + "×tamp=" + timestamp + "&key=" + WeixinPayKey;
resultModel.result = new
{
appid = WeixinAppId,
partnerid = WeixinMchId,
package = "Sign=WXPay",
prepayid = prepayid,
noncestr = PayRandomStr,
timestamp = timestamp,
sign = PropertyUtils.GetMD5Str(PaySignStr.ToString()).ToUpper()
};
}
else
{
string err_code_des = doc.GetElementsByTagName("err_code_des")[0].InnerText;
resultModel.Msg = err_code_des;
}
}
else
{
string return_msg = doc.GetElementsByTagName("return_msg")[0].InnerText;
resultModel.Msg = return_msg;
}
}
else
{
resultModel.Msg = APIMessage.EXPENSE_RECORD_NOEXIST;
}
}
else
{
resultModel.Msg = APIMessage.NO_USER;
}
}
catch
{
resultModel.Msg = APIMessage.REQUEST_EXCEPTION;
}
return(resultModel);
}
public ApiResultModel ExpenseRecordDetail([FromUri] DetailSearchModel model)
{
ApiResultModel resultModel = new ApiResultModel();
try
{
//根据用户ID查找业主
IUserBLL ownerBll = BLLFactory <IUserBLL> .GetBLL("UserBLL");
T_User owner = ownerBll.GetEntity(u => u.Id == model.UserId && u.DelFlag == ConstantParam.DEL_FLAG_DEFAULT);
//如果业主存在
if (owner != null)
{
//如果验证Token不通过或已过期
if (DateTime.Now > owner.TokenInvalidTime || model.Token != owner.Token)
{
resultModel.Msg = APIMessage.TOKEN_INVALID;
return(resultModel);
}
//更新最近登录时间和Token失效时间
owner.LatelyLoginTime = DateTime.Now;
owner.TokenInvalidTime = DateTime.Now.AddDays(Convert.ToInt32(PropertyUtils.GetConfigParamValue("TokenInvalid")));
ownerBll.Update(owner);
IHouseUserExpenseDetailsBLL expenseDetailsBLL = BLLFactory <IHouseUserExpenseDetailsBLL> .GetBLL("HouseUserExpenseDetailsBLL");
var record = expenseDetailsBLL.GetEntity(e => e.Id == model.Id);
if (record != null)
{
//返回详细数据
resultModel.result = new
{
RecordId = record.Id,
ExpenseTypeName = record.PropertyExpenseType.Name,
ExpenseDateDes = record.ExpenseDateDes,
Expense = record.Expense,
PayedTime = record.PayedDate != null?record.PayedDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : "",
PaymentType = record.PaymentType != null ? (record.PaymentType.Value == 1 ? "前台缴费" : "在线缴费") : "",
PlaceName = record.BuildCompanyId == null ? record.BuildDoor.BuildUnit.Build.PropertyPlace.Name : record.BuildCompany.PropertyPlace.Name,
Door = record.BuildCompanyId == null ? record.BuildDoor.BuildUnit.Build.BuildName + record.BuildDoor.BuildUnit.UnitName
+ record.BuildDoor.DoorName : record.BuildCompany.Name,
OwnerName = record.BuildDoor != null && record.BuildDoor.HouseUsers.Count > 0 ? record.BuildDoor.HouseUsers.FirstOrDefault().Name : "",
Tel = record.BuildDoor != null ? (record.BuildDoor.HouseUsers.Count > 0 ? record.BuildDoor.HouseUsers.FirstOrDefault().Phone : "") : record.BuildCompany.Phone,
};
}
else
{
resultModel.Msg = APIMessage.EXPENSE_RECORD_NOEXIST;
}
}
else
{
resultModel.Msg = APIMessage.NO_USER;
}
}
catch
{
resultModel.Msg = APIMessage.REQUEST_EXCEPTION;
}
return(resultModel);
}
public ActionResult List()
{
int page = 1;
if (!String.IsNullOrEmpty(Request["p"]))
{
page = Convert.ToInt32(Request["p"]);
}
String search_criteria = "";
if (!String.IsNullOrEmpty(Request.QueryString["s"]))
{
search_criteria = Request.QueryString["s"];
}
int total;
T_Task entity = new T_Task();
if (!String.IsNullOrEmpty(Request.QueryString["status"]))
{
entity.statusId = Int32.Parse(Request.QueryString["status"]);
}
List <T_Task> entitys =
entityDao.Search(entity, page, this.pageSize, search_criteria, T_Task.Columns.statusId, AscDesc.ASC, out total);
T_Task_StatusDAO sdao = new T_Task_StatusDAO();
T_UserDAO udao = new T_UserDAO();
T_TaskDAO tdao = new T_TaskDAO();
String uid = Convert.ToString(Session["uid"]);
T_User q = udao.GetByModel(new T_User()
{
id = uid
});
Session["username"] = q.name;
Session["dept"] = q.dept;
Session["roleid"] = q.roleId;
ViewBag.total = total;
ViewBag.pageSize = this.pageSize;
ViewBag.status = sdao.GetAllByModel(null);
ViewBag.list = entitys;
return(View(entitys));
if (String.IsNullOrWhiteSpace(uid))
{
return(Fail("没有足够的参数"));
}
else
{
T_TaskDAO taskdao = new T_TaskDAO();
T_Task task = new T_Task()
{
};
List <T_Task> tasklist = taskdao.GetAllByModel(task);
T_Task_StatusDAO statusdao = new T_Task_StatusDAO();
T_Task_Status status = new T_Task_Status()
{
};
List <T_Task_Status> statuslist = statusdao.GetAllByModel(status);
ViewBag.uid = Session["uid"];
ViewBag.list = tasklist;
ViewBag.statuslist = statuslist;
return(View());
}
}
public JsonResult doDistribute()
{
String uid = Convert.ToString(Session["uid"]);
var title = Request["title"];
var userid = Request["userid"];
var name = Request["name"];
var content = Request["content"];
var starttime = Request["starttime"];
var endtime = Request["endtime"];
if (String.IsNullOrWhiteSpace(content) || String.IsNullOrWhiteSpace(name) || String.IsNullOrWhiteSpace(userid) || String.IsNullOrWhiteSpace(title))
{
return(Fail("参数不完整，请填写完毕再提交。"));
}
else
{
T_TaskDAO taskdao = new T_TaskDAO();
T_Task task = new T_Task()
{
id = Convert.ToInt32(title)
};
task = taskdao.GetByModel(task);
task.beginTime = Convert.ToDateTime(starttime);
task.endTime = Convert.ToDateTime(endtime);
task.statusId = 3;
if (taskdao.Update(task) > 0)
{
T_Task_UserDAO taskuserdao = new T_Task_UserDAO();
T_Task_User taskuser = new T_Task_User()
{
userId = userid, taskId = task.id, descr = content
};
if (taskuserdao.Add(taskuser) > 0)
{
T_Task_HistoryDAO historydao = new T_Task_HistoryDAO();
T_Task_History history = new T_Task_History()
{
taskId = task.id, descr = "分配任务"
};
history = historydao.GetByModel(history);
if (history == null)
{
T_UserDAO userdao = new T_UserDAO();
T_User user = new T_User()
{
id = uid
};
user = userdao.GetByModel(user);
history = new T_Task_History()
{
taskId = task.id, userName = user.name, descr = "分配任务", content = "任务已分配。"
};
if (historydao.Add(history) > 0)
{
return(Success("已成功分发任务给" + name, null));
}
else
{
return(Fail("已分配，但未记录到任务历史中。"));
}
}
else
{
return(Success("已成功分发任务给" + name, null));
}
}
else
{
return(Fail("任务还没成功分配给" + name));
}
}
else
{
return(Fail("任务还没成功分配给" + name));
}
}
}
public UserVM()
{
TemData = new T_User();
}
public LoginVM()
{
TemData = new T_User();
}
public bool InsertOrUpdateUser(T_User t_User)
{
return(userDAO.InsertOrUpdateUser(t_User));
}
//增加
public bool Add(T_User u)
{
user.T_User.Add(u);
return(user.SaveChanges() > 0);
}
public bool UpdateLoginTime(T_User t_User)
{
return(userDAO.UpdateLoginTime(t_User));
}
// PUT: api/User/5
public IHttpActionResult Put([FromUri] int id, [FromBody] T_User entity)
{
Service.Update(entity);
Service.SaveChanges();
return(Json(entity));
}
public bool ResetPwd(T_User t_User)
{
t_User.LoginPwd = MD5Util.getEncryptedPwd(Tool.getAppSetting("DefaultPWD"));
return(userDAO.ChangeUserPwd(t_User));
}
/// <summary>
/// 保存用户信息
/// </summary>
/// <param name="form">用户对象</param>
public string UpdUserInfo(T_User form)
{
bool result = false;
string msg = string.Empty;
List <T_User> info = new List <T_User>();
info = new CompanySvc().GetUserInfo("", form.LoginName);
if (string.IsNullOrEmpty(form.C_GUID))
{
form.C_GUID = Session["MasterCompanyGuid"].ToString();
if (info.Count.Equals(0))
{
result = new CompanySvc().UpdUserInfo(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
}
else
{
msg = Common.Resource.RolePermission.LoginName + General.Resource.Common.Exist;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
else
{
if (info.Count.Equals(0))
{
result = new CompanySvc().UpdUserInfo(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
else
{
if (info.FirstOrDefault().C_GUID == form.C_GUID & info.FirstOrDefault().U_GUID == form.U_GUID)
{
result = new CompanySvc().UpdUserInfo(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
result = false;
msg = Common.Resource.RolePermission.LoginName + General.Resource.Common.Exist;
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}",
result.ToString().ToLower(), msg));
}
}
}
//增加
public bool Add(T_User u)
{
return(userdal.Add(u));
}
public static void DeleteT_User(T_User t_User)
{
T_UserService.DeleteT_User(t_User);
}
//更新
public bool Updata(T_User u)
{
return(userdal.Updata(u));
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="user">用户对象</param>
public void AddUser(T_User user)
{
base.Add(user);
}
public bool Edit(T_User u)
{
return(userdal.Edit(u));
}
public int AddUser(T_User user)
{
db.Users.Add(user);
return(db.SaveChanges());
}
public Response Put1(int id, [FromBody] T_User data) //update student record using userid
{
if (data != null)
{
T_User findentry = dalobj.T_User.Find(id);
try
{
if (findentry != null)
{
if (data.Name != null)
{
findentry.Name = data.Name;
}
if (data.Gender != null)
{
findentry.Gender = data.Gender;
}
if (data.DOB != null)
{
findentry.DOB = data.DOB;
}
if (data.Email != null)
{
findentry.Email = data.Email;
}
if (data.Password != null)
{
findentry.Password = data.Password;
}
if (data.MobileNo != null)
{
findentry.MobileNo = data.MobileNo;
}
if (data.Class != null)
{
findentry.Class = data.Class;
}
if (data.Street != null)
{
findentry.Street = data.Street;
}
if (data.City != null)
{
findentry.City = data.City;
}
if (data.State != null)
{
findentry.State = data.State;
}
if (data.Country != null)
{
findentry.Country = data.Country;
}
if (data.PostalCode != null)
{
findentry.PostalCode = data.PostalCode;
}
if (data.IsOnline != false)
{
findentry.IsOnline = data.IsOnline;
}
if (data.IsLocked != false)
{
findentry.IsLocked = data.IsLocked;
}
if (data.Role_id != null)
{
findentry.Role_id = data.Role_id;
}
dalobj.SaveChanges();
response.Status = "Record successfully updated.";
response.Err = null;
response.Data = null;
return(response);
}
}
catch (Exception ex)
{
response.Status = "Failed!";
response.Err = ex.InnerException;
response.Data = null;
return(response);
}
}
else
{
response.Data = null;
response.Status = "Empty Fields";
response.Err = null;
}
return(response);
}
public bool UpdateLoginTime(T_User t_User)
{
return(mapper.Update("UpdateT_User_LastLoginTime", t_User) > 0);
}
/// <summary>
/// 更新用户
/// </summary>
/// <param name="roleID">角色标识</param>
/// <param name="roleName">角色名称</param>
/// <returns></returns>
public bool UpdUser(T_User user)
{
return(APIRequest <bool>("/api/ApiUser/UpdateUser?accountid=" + accID
, user, HttpMethod.Post.Method));
}
protected void RegisterOnlineUser(T_User user)
{
T_Online online = tOnlineService.GetTOnlineByUserCode(user.UserCode);
bool flag = false;
// 如果不存在，就创建一条新的记录
if (online == null)
{
online = new T_Online();
flag = true;
}
DateTime now = DateTime.Now;
//online.T_User = user;
online.IPAdddress = Request.UserHostAddress;
online.LoginTime = now;
online.UpdateTime = now;
online.UserCode = user.UserCode;
tOnlineService.Save(online, flag);
// 记录本次更新时间
Session[SK_ONLINE_UPDATE_TIME] = now;
}
public bool SignOut()
{
_cachedUser = null;
FormsAuthentication.SignOut();
return(true);
}
