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