public ActionResult AddGroup(string Groupname) { DataAccess.Tnsmtp_Contactgroup tnsmtp_Contactgroup = new DataAccess.Tnsmtp_Contactgroup(); tnsmtp_Contactgroup.Groupname = Groupname; tnsmtp_Contactgroup.Userid = SysUser.UserId; tnsmtp_Contactgroup.Status = (int)Entites.Status.正常; if (!tnsmtp_Contactgroup.Insert()) { return(FailResult()); } return(SuccessResult()); }
/// <summary> /// 添加联系人表数据 /// </summary> /// <returns></returns> private bool AddContactTable(Tnsmtp_EmailMap model) { DataAccess.Tnsmtp_Contact tnsmtp_Contact = new DataAccess.Tnsmtp_Contact(); tnsmtp_Contact.ReferenceTransactionFrom(this.Transaction); if (tnsmtp_Contact.SelectByEmail(model.Userid, model.Inmail)) { model.RecId = tnsmtp_Contact.ContactId; } if (!model.RecId.HasValue) { #region 如果用户没有 "常用联系人" 这个组则添加这个组 DataAccess.Tnsmtp_Contactgroup tnsmtp_Contactgroup = new DataAccess.Tnsmtp_Contactgroup(); tnsmtp_Contactgroup.ReferenceTransactionFrom(this.Transaction); if (!tnsmtp_Contactgroup.SelectByGroupName(model.Userid, "常用联系人")) { tnsmtp_Contactgroup.Groupname = "常用联系人"; tnsmtp_Contactgroup.Userid = model.Userid; tnsmtp_Contactgroup.Status = 0; if (!tnsmtp_Contactgroup.Insert()) { Alert("添加常用联系人分组失败"); return(false); } } #endregion #region 添加联系人 tnsmtp_Contact.ContactName = model.Inmail; tnsmtp_Contact.Email = model.Inmail; tnsmtp_Contact.Gid = tnsmtp_Contactgroup.Gid; tnsmtp_Contact.Status = 0; tnsmtp_Contact.UserId = model.Userid; tnsmtp_Contact.CateId = 1; if (!tnsmtp_Contact.Insert()) { Alert("添加常用联系人失败"); return(false); } #endregion } return(true); }
public bool Import(DataTable dt, int userid) { if (dt.Rows.Count <= 0) { Alert("没有数据!"); return(false); } RemoveEmpty(dt); BeginTransaction(); for (int i = 0; i < dt.Rows.Count; i++) { DataAccess.Tnsmtp_Contact tnsmtp_Contact = new DataAccess.Tnsmtp_Contact(); tnsmtp_Contact.ReferenceTransactionFrom(this.Transaction); tnsmtp_Contact.ContactName = dt.Rows[i]["name"].ToString(); tnsmtp_Contact.Email = dt.Rows[i]["email"].ToString(); int gid = 0; int.TryParse(dt.Rows[i]["gid"].ToString(), out gid); DataAccess.Tnsmtp_Contactgroup tnsmtp_Contactgroup = new DataAccess.Tnsmtp_Contactgroup(); if (!tnsmtp_Contactgroup.SelectByPK(gid)) { Rollback(); Alert("联系人小组ID不正确小组ID:" + gid); return(false); } tnsmtp_Contact.Gid = gid; tnsmtp_Contact.Status = 0; tnsmtp_Contact.UserId = userid; if (!tnsmtp_Contact.Insert()) { Rollback(); Alert("插入数据失败:" + tnsmtp_Contact.ContactName); return(false); } } Commit(); return(true); }
public ActionResult UpdateGroup(int Gid, string Groupname) { DataAccess.Tnsmtp_Contactgroup tnsmtp_Contactgroup = new DataAccess.Tnsmtp_Contactgroup(); if (!tnsmtp_Contactgroup.SelecByUserid(SysUser.UserId, Gid)) { return(FailResult("查询失败!")); } tnsmtp_Contactgroup.Groupname = Groupname; if (!tnsmtp_Contactgroup.Update()) { return(FailResult("修改失败!")); } return(SuccessResult("修改成功")); }
public ActionResult DeleteGroup(int Gid) { DataAccess.Tnsmtp_Contactgroup tnsmtp_Contactgroup = new DataAccess.Tnsmtp_Contactgroup(); if (!tnsmtp_Contactgroup.SelecByUserid(SysUser.UserId, Gid)) { return(FailResult("删除失败!")); } tnsmtp_Contactgroup.Status = 1; if (!tnsmtp_Contactgroup.Update()) { return(FailResult("删除失败!")); } return(SuccessResult()); }