/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_message GetModel(int m_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select m_id, m_sender, m_receiver, m_type, m_time, m_state, m_content, m_topid "); strSql.Append(" from jmp_message "); strSql.Append(" where m_id=@m_id"); SqlParameter[] parameters = { new SqlParameter("@m_id", SqlDbType.Int, 4) }; parameters[0].Value = m_id; JMP.MDL.jmp_message model = new JMP.MDL.jmp_message(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["m_id"].ToString() != "") { model.m_id = int.Parse(ds.Tables[0].Rows[0]["m_id"].ToString()); } if (ds.Tables[0].Rows[0]["m_sender"].ToString() != "") { model.m_sender = int.Parse(ds.Tables[0].Rows[0]["m_sender"].ToString()); } model.m_receiver = ds.Tables[0].Rows[0]["m_receiver"].ToString(); if (ds.Tables[0].Rows[0]["m_type"].ToString() != "") { model.m_type = int.Parse(ds.Tables[0].Rows[0]["m_type"].ToString()); } if (ds.Tables[0].Rows[0]["m_time"].ToString() != "") { model.m_time = DateTime.Parse(ds.Tables[0].Rows[0]["m_time"].ToString()); } if (ds.Tables[0].Rows[0]["m_state"].ToString() != "") { model.m_state = int.Parse(ds.Tables[0].Rows[0]["m_state"].ToString()); } model.m_content = ds.Tables[0].Rows[0]["m_content"].ToString(); if (ds.Tables[0].Rows[0]["m_topid"].ToString() != "") { model.m_topid = int.Parse(ds.Tables[0].Rows[0]["m_topid"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 添加或修改消息 /// </summary> /// <param name="mo"></param> /// <returns></returns> public JsonResult InserOrUpdatemessage(JMP.MDL.jmp_message mo) { object retJson = new { success = 0, msg = "操作失败" }; mo.m_sender = UserInfo.UserId; JMP.BLL.jmp_message mebll = new JMP.BLL.jmp_message(); string[] sta = Request["m_receiver"].Split(','); if (mo.m_id > 0) { JMP.MDL.jmp_message mod = mebll.GetModel(mo.m_id); var modClone = mod.Clone(); mod.m_receiver = mo.m_receiver; mod.m_content = mo.m_content; //mo.m_state = mod.m_state; //mo.m_type = mod.m_type; //mo.m_time = mod.m_time; string sm = "";//日志说明 if (mebll.Update(mod)) { Logger.ModifyLog("修改消息", modClone, mo); retJson = new { success = 1, msg = "修改成功" }; } else { retJson = new { success = 0, msg = "修改失败" }; } } else { mo.m_time = DateTime.Now; mo.m_state = 0; mo.m_type = 1; StringBuilder strSql = new StringBuilder(); for (int i = 0; i < sta.Length; i++) { strSql.Append("insert into jmp_message(m_sender,m_receiver,m_type,m_time,m_state,m_content,m_topid) values ('" + mo.m_sender + "','" + sta[i] + "','1','" + DateTime.Now + "','0','" + mo.m_content + "','0') "); } int cg = mebll.AdminAdd(strSql); if (cg > 0) { Logger.CreateLog("发送消息", mo); retJson = new { success = 1, msg = "发送成功" }; } else { retJson = new { success = 0, msg = "发送失败" }; } } return(Json(retJson)); }
public ActionResult message() { int m_id = string.IsNullOrEmpty(Request["m_id"]) ? 0 : Int32.Parse(Request["m_id"]); JMP.MDL.jmp_message mo = new JMP.MDL.jmp_message(); JMP.BLL.jmp_message mebll = new JMP.BLL.jmp_message(); string type = string.IsNullOrEmpty(Request["type"]) ? "dd" : Request["type"]; if (m_id > 0) { mo = mebll.GetModel(m_id); } ViewBag.type = type; ViewBag.mo = mo; return(View()); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update jmp_message set "); strSql.Append(" m_sender = @m_sender , "); strSql.Append(" m_receiver = @m_receiver , "); strSql.Append(" m_type = @m_type , "); strSql.Append(" m_time = @m_time , "); strSql.Append(" m_state = @m_state , "); strSql.Append(" m_content = @m_content , "); strSql.Append(" m_topid = @m_topid "); strSql.Append(" where m_id=@m_id "); SqlParameter[] parameters = { new SqlParameter("@m_id", SqlDbType.Int, 4), new SqlParameter("@m_sender", SqlDbType.Int, 4), new SqlParameter("@m_receiver", SqlDbType.NVarChar, -1), new SqlParameter("@m_type", SqlDbType.Int, 4), new SqlParameter("@m_time", SqlDbType.DateTime), new SqlParameter("@m_state", SqlDbType.Int, 4), new SqlParameter("@m_content", SqlDbType.NVarChar, -1), new SqlParameter("@m_topid", SqlDbType.Int, 4) }; parameters[0].Value = model.m_id; parameters[1].Value = model.m_sender; parameters[2].Value = model.m_receiver; parameters[3].Value = model.m_type; parameters[4].Value = model.m_time; parameters[5].Value = model.m_state; parameters[6].Value = model.m_content; parameters[7].Value = model.m_topid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获得数据列表 /// </summary> public List <JMP.MDL.jmp_message> DataTableToList(DataTable dt) { List <JMP.MDL.jmp_message> modelList = new List <JMP.MDL.jmp_message>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { JMP.MDL.jmp_message model; for (int n = 0; n < rowsCount; n++) { model = new JMP.MDL.jmp_message(); if (dt.Rows[n]["m_id"].ToString() != "") { model.m_id = int.Parse(dt.Rows[n]["m_id"].ToString()); } if (dt.Rows[n]["m_sender"].ToString() != "") { model.m_sender = int.Parse(dt.Rows[n]["m_sender"].ToString()); } model.m_receiver = dt.Rows[n]["m_receiver"].ToString(); if (dt.Rows[n]["m_type"].ToString() != "") { model.m_type = int.Parse(dt.Rows[n]["m_type"].ToString()); } if (dt.Rows[n]["m_time"].ToString() != "") { model.m_time = DateTime.Parse(dt.Rows[n]["m_time"].ToString()); } if (dt.Rows[n]["m_state"].ToString() != "") { model.m_state = int.Parse(dt.Rows[n]["m_state"].ToString()); } model.m_content = dt.Rows[n]["m_content"].ToString(); if (dt.Rows[n]["m_topid"].ToString() != "") { model.m_topid = int.Parse(dt.Rows[n]["m_topid"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_message("); strSql.Append("m_sender,m_receiver,m_type,m_time,m_state,m_content,m_topid"); strSql.Append(") values ("); strSql.Append("@m_sender,@m_receiver,@m_type,@m_time,@m_state,@m_content,@m_topid"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@m_sender", SqlDbType.Int, 4), new SqlParameter("@m_receiver", SqlDbType.NVarChar, -1), new SqlParameter("@m_type", SqlDbType.Int, 4), new SqlParameter("@m_time", SqlDbType.DateTime), new SqlParameter("@m_state", SqlDbType.Int, 4), new SqlParameter("@m_content", SqlDbType.NVarChar, -1), new SqlParameter("@m_topid", SqlDbType.Int, 4) }; parameters[0].Value = model.m_sender; parameters[1].Value = model.m_receiver; parameters[2].Value = model.m_type; parameters[3].Value = model.m_time; parameters[4].Value = model.m_state; parameters[5].Value = model.m_content; parameters[6].Value = model.m_topid; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 消息回复 /// </summary> /// <returns></returns> public JsonResult ReplyMessageUser(JMP.MDL.jmp_message mo) { object retJson = new { success = 0, msg = "操作失败" }; mo.m_time = DateTime.Now; mo.m_state = 0; mo.m_type = 3; mo.m_sender = UserInfo.UserId; JMP.BLL.jmp_message mebll = new JMP.BLL.jmp_message(); int cg = mebll.Add(mo); if (cg > 0) { Logger.OperateLog("回复消息", mo.m_content); retJson = new { success = 1, msg = "发送成功" }; } else { retJson = new { success = 0, msg = "发送失败" }; } return(Json(retJson)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_message model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_message model) { return(dal.Add(model)); }
public JsonResult UpdateUser(JMP.MDL.jmp_user jmpuser) { object obj = new { success = 0, msg = "更新失败!" }; JMP.BLL.jmp_user userBll = new JMP.BLL.jmp_user(); JMP.MDL.jmp_user oldUser = userBll.GetModel(jmpuser.u_id); var oldUserColne = oldUser.Clone(); oldUser.u_category = jmpuser.u_category;//类别 oldUser.u_email = jmpuser.u_email; oldUser.u_realname = jmpuser.u_realname; oldUser.u_password = DESEncrypt.Encrypt(jmpuser.u_password); oldUser.u_phone = jmpuser.u_phone; oldUser.u_qq = jmpuser.u_qq; oldUser.u_address = jmpuser.u_address; oldUser.u_account = jmpuser.u_account; oldUser.u_name = jmpuser.u_name; oldUser.u_bankname = jmpuser.u_bankname; oldUser.u_idnumber = jmpuser.u_idnumber; oldUser.FrozenMoney = jmpuser.FrozenMoney; oldUser.BusinessEntity = jmpuser.BusinessEntity; oldUser.RegisteredAddress = jmpuser.RegisteredAddress; oldUser.relation_type = jmpuser.relation_type; oldUser.relation_person_id = jmpuser.relation_person_id; oldUser.u_photof = string.IsNullOrEmpty(jmpuser.u_photof) ? "" : jmpuser.u_photof; oldUser.u_licence = string.IsNullOrEmpty(jmpuser.u_licence) ? "" : jmpuser.u_licence; try { if (oldUser.u_category == 0) { oldUser.u_photo = string.IsNullOrEmpty(jmpuser.u_photo) ? "" : jmpuser.u_photo; } else { oldUser.u_blicense = string.IsNullOrEmpty(jmpuser.u_blicense) ? "" : jmpuser.u_blicense; oldUser.u_photo = string.IsNullOrEmpty(jmpuser.u_photo) ? " " : jmpuser.u_photo; oldUser.u_blicensenumber = jmpuser.u_blicensenumber; } if (string.IsNullOrEmpty(oldUser.u_qq)) { oldUser.u_qq = " "; } if (string.IsNullOrEmpty(oldUser.u_address)) { oldUser.u_address = " "; } bool flag = userBll.Update(oldUser); obj = new { success = flag ? 1 : 0, msg = flag ? "更新成功!" : "更新失败!" }; //写日志 if (flag) { Logger.ModifyLog("修改开发者", oldUserColne, jmpuser); //审核状态改变是发送私信和邮件给用户 if (jmpuser.u_auditstate != oldUserColne.u_auditstate) { JMP.BLL.jmp_message messbll = new JMP.BLL.jmp_message(); JMP.MDL.jmp_message j_mess = new JMP.MDL.jmp_message(); string tipmsg = string.Empty; #region 组装私信实体 j_mess.m_sender = UserInfo.UserId; j_mess.m_receiver = oldUser.u_id.ToString(); j_mess.m_type = 1; j_mess.m_time = DateTime.Now; j_mess.m_state = 0; switch (jmpuser.u_auditstate) { case -1: tipmsg = "你的账号审核未通过!"; break; case 0: tipmsg = "你的账号正在审核中,如有疑问请联系我们!"; break; case 1: tipmsg = "你的账号审核通过!"; break; } j_mess.m_content = tipmsg; j_mess.m_topid = oldUser.u_topid; #endregion //发送私信 if (jmpuser.u_auditstate == 1) { //更改审核状态为通过时,才发送私信 int record = messbll.Add(j_mess); if (record > 0) { Logger.CreateLog("发送私信给用户", j_mess); } } #region 发送邮件 //StringBuilder MailContent = new StringBuilder(); //MailContent.Append("亲爱的开发者:<br/>"); //MailContent.Append(" 您好!" + tipmsg); //MailContent.Append(" 如果你没有用该邮件账号注册过聚米支付平台的账号,请忽视本邮件!"); //MailContent.Append("亲爱的开发者:<br/>"); //bool isSend = MailHelper.SendText("*****@*****.**", "聚米网络科技", jmpuser.u_email, "重置密码", MailContent.ToString(), "smtp.adjumi.com", "*****@*****.**", ""); //if (isSend) //{ // string tmsg = string.Format("用户{0}({1})发送邮件至用户邮箱{2},邮件内容为:{3}", UserInfo.UserName, UserInfo.UserId, jmpuser.u_email, tipmsg); // AddLocLog.AddLog(int.Parse(UserInfo.UserId), 3, RequestHelper.GetClientIp(), "发送邮件给用户" + jmpuser.u_id, tmsg); //} #endregion } } } catch (Exception ex) { Logger.OperateLog("修改开发者报错" + jmpuser.u_id, ex.ToString()); obj = new { success = 0, msg = "更新出错了!" }; } return(Json(obj)); }
/// <summary> /// 修改代理商 /// </summary> /// <returns></returns> public JsonResult UpdateAgents(JMP.MDL.CoAgent jmpagent) { object obj = new { success = 0, msg = "更新失败!" }; JMP.BLL.CoAgent userBll = new JMP.BLL.CoAgent(); JMP.MDL.CoAgent oldUser = userBll.GetModel(jmpagent.Id); var oldUserClone = oldUser.Clone(); oldUser.Classify = jmpagent.Classify; oldUser.OwnerId = jmpagent.OwnerId; oldUser.OwnerName = jmpagent.OwnerName; oldUser.LoginName = jmpagent.LoginName; oldUser.Password = DESEncrypt.Encrypt(jmpagent.Password); oldUser.DisplayName = jmpagent.DisplayName; oldUser.EmailAddress = jmpagent.EmailAddress; oldUser.MobilePhone = jmpagent.MobilePhone; oldUser.QQ = jmpagent.QQ; oldUser.Website = jmpagent.Website; oldUser.ContactAddress = jmpagent.ContactAddress; oldUser.IDCardNumber = jmpagent.IDCardNumber; oldUser.BusinessLicenseNumber = jmpagent.BusinessLicenseNumber; oldUser.BankAccount = jmpagent.BankAccount; oldUser.BankAccountName = jmpagent.BankAccountName; oldUser.BankFullName = jmpagent.BankFullName; try { if (oldUser.Classify == 0) { oldUser.PersonalPhotoPath = string.IsNullOrEmpty(jmpagent.PersonalPhotoPath) ? "" : jmpagent.PersonalPhotoPath; } else { oldUser.BusinessLicensePhotoPath = string.IsNullOrEmpty(jmpagent.BusinessLicensePhotoPath) ? "" : jmpagent.BusinessLicensePhotoPath; oldUser.PersonalPhotoPath = string.IsNullOrEmpty(jmpagent.PersonalPhotoPath) ? " " : jmpagent.PersonalPhotoPath; } if (string.IsNullOrEmpty(jmpagent.QQ)) { oldUser.QQ = " "; } if (string.IsNullOrEmpty(jmpagent.ContactAddress)) { oldUser.ContactAddress = " "; } bool flag = userBll.Update(oldUser); obj = new { success = flag ? 1 : 0, msg = flag ? "更新成功!" : "更新失败!" }; //写日志 if (flag) { Logger.ModifyLog("修改代理商", oldUserClone, jmpagent); //审核状态改变是发送私信和邮件给用户 if (jmpagent.AuditState != oldUserClone.AuditState) { JMP.BLL.jmp_message messbll = new JMP.BLL.jmp_message(); JMP.MDL.jmp_message j_mess = new JMP.MDL.jmp_message(); string tipmsg = string.Empty; #region 组装私信实体 j_mess.m_sender = UserInfo.UserId; j_mess.m_receiver = oldUser.Id.ToString(); j_mess.m_type = 1; j_mess.m_time = DateTime.Now; j_mess.m_state = 0; switch (jmpagent.AuditState) { case -1: tipmsg = "你的账号审核未通过!"; break; case 0: tipmsg = "你的账号正在审核中,如有疑问请联系我们!"; break; case 1: tipmsg = "你的账号审核通过!"; break; } j_mess.m_content = tipmsg; #endregion //发送私信 if (jmpagent.AuditState == 1) { //更改审核状态为通过时,才发送私信 int record = messbll.Add(j_mess); if (record > 0) { Logger.CreateLog("发送私信给用户", j_mess); } } } } } catch (Exception ex) { Logger.OperateLog("修改代理商报错" + jmpagent.Id, ex.ToString()); obj = new { success = 0, msg = "更新出错了!" }; } return(Json(obj)); }