/// <summary>
/// 删除评论
/// </summary>
/// <param name="id"></param>
public void DeleteComment(string id)
{
Comments c = new Comments();
c.ID = id;
Assistant.Delete(c);
}
/// <summary>
/// 删除一个类型
/// </summary>
/// <param name="id"></param>
public void DeleteAdviceType(string id)
{
AdviceType at = GetAdviceType(id);
Assistant.Delete(at);
SaveToConfigFile();
}
/// <summary>
/// 删除短信发送历史
/// </summary>
/// <param name="logID">短信发送历史ID</param>
public void DeleteMessage(string id)
{
ShortMessage l = new ShortMessage();
l.ID = id;
Assistant.Delete(l);
}
/// <summary>
/// 删除日志
/// </summary>
/// <param name="logID">日志ID</param>
public void DeleteLog(string id)
{
Log l = new Log();
l.ID = id;
Assistant.Delete(l);
}
/// <summary>
/// 删除帐户（同时删除权限以及联盟和邮箱帐号等）
/// </summary>
/// <param name="accountID">用户ID</param>
public void DeleteAccont(string accountID)
{
We7Helper.AssertNotNull(Assistant, "AccountHelper.Assistant");
We7Helper.AssertNotNull(accountID, "DeleteAccont.accountID");
//利用事务进行帐户的相关权限删除
//IDatabase db = Assistant.GetDatabases()["We7.CMS.Common"];
//IConnection ic = Assistant.GetConnections()[db];
IConnection ic = Assistant.CreateConnetion(typeof(Account), true);//上边连接无效，此方法为重构方法
//ic.IsTransaction = true;
try
{
//删除Permissions
Criteria c = new Criteria(CriteriaType.Equals, "OwnerID", accountID);
Assistant.DeleteList <Permission>(ic, c);
//删除AccountRole
Criteria ca = new Criteria(CriteriaType.Equals, "AccountID", accountID);
Assistant.DeleteList <AccountRole>(ic, ca);
//最后删除当前帐户
Account act = new Account();
act.ID = accountID;
Assistant.Delete(ic, act);
OnUserDeleted(act);
ic.Commit();
}
catch (Exception)
{
try { ic.Rollback(); }
catch (Exception)
{ }
}
finally { ic.Dispose(); }
}
/// <summary>
/// 删除链接
/// </summary>
/// <param name="logID">链接ID</param>
public void DeleteLink(string id)
{
Link l = new Link();
l.ID = id;
Assistant.Delete(l);
}
public void DelFavorite(string id)
{
Favorite f = new Favorite();
f.FavoriteID = id;
Assistant.Delete(f);
}
/// <summary>
/// 删除积分记录
/// </summary>
/// <param name="id"></param>
public void DelPoint(string id)
{
Point f = new Point();
f.ID = id;
Assistant.Delete(f);
}
/// <summary>
/// 删除一个部门信息
/// </summary>
/// <param name="departmentID">部门ID</param>
public void DeleteDepartment(string departmentID)
{
List <Department> sub = GetDepartments(string.Empty, departmentID, string.Empty, new string[] { "ID", "ParentID" });
foreach (Department d in sub)
{
DeleteDepartment(d.ID);
}
Criteria c = new Criteria(CriteriaType.Equals, "DepartmentID", departmentID);
if (Assistant.Count <Account>(c) > 0)
{
List <Account> list = Assistant.List <Account>(c, null);
if (list != null)
{
foreach (Account a in list)
{
DeleteAccont(a.ID);
}
}
}
Department dpt = new Department();
dpt.ID = departmentID;
Assistant.Delete(dpt);
}
/// <summary>
/// 删除一条统计信息
/// </summary>
/// <param name="id"></param>
public void DeleteStatistics(string id)
{
Statistics s = GetStatistics(id);
if (s != null)
{
Assistant.Delete(s);
}
}
public void DeleteMapping(string id)
{
ChannelModuleMapping mapping = GetMapping(id);
if (mapping != null)
{
Assistant.Delete(mapping);
}
}
/// <summary>
/// 删除一条统计信息
/// </summary>
/// <param name="id"></param>
public void DeletePageVisitor(string id)
{
PageVisitor s = GetPageVisitor(id);
if (s != null)
{
Assistant.Delete(s);
}
}
public void DeleteCategory(Category cat)
{
List <Category> children = GetCategoryByParentID(cat.ID);
foreach (Category c in children)
{
DeleteCategory(c);
}
Assistant.Delete(cat);
CacheRecord.Release();
}
/// <summary>
/// 删除一个附件
/// </summary>
/// <param name="attachmentID">附件ID</param>
public void DeleteAttachment(string attachmentID)
{
Attachment a = GetAttachment(attachmentID);
string file = HttpContext.Current.Server.MapPath(a.FilePath + "/" + a.FileName);
if (File.Exists(file))
{
File.Delete(file);
}
Assistant.Delete(a);
}
public ActionResult DeleteAssistants(AssistantData[] assistants, int userId, int companyId)
{
var res = ActionResult.NoAction;
foreach (var assistant in assistants)
{
res = Assistant.Delete(assistant.AssistantId, assistant.LearningId, companyId, userId);
}
return(res);
}
/// <summary>
/// 删除一个用户的角色关联
/// </summary>
/// <param name="accountID">用户ID</param>
/// <param name="roleID">角色ID</param>
public void UnassignAccountRole(string accountID, string roleID)
{
List <AccountRole> roles = this.GetAccountRoles(accountID);
foreach (AccountRole role in roles)
{
if (role.RoleID == roleID)
{
Assistant.Delete(role);
return;
}
}
}
/// <summary>
/// 删除角色（同时删除权限）
/// </summary>
/// <param name="roleID">角色ID</param>
public void DeleteRole(string roleID)
{
We7Helper.AssertNotNull(Assistant, "AccountHelper.Assistant");
We7Helper.AssertNotNull(roleID, "DeleteRole.roleID");
//利用事务进行帐户的相关权限删除
IDatabase db = Assistant.GetDatabases()["We7.CMS.Common"];
//IConnection ic = Assistant.GetConnections()[db];请注意别用此获去IC
IConnection ic = db.DbDriver.CreateConnection(db.ConnectionString);
ic.IsTransaction = true;
try
{
//删除Permissions
Criteria c = new Criteria(CriteriaType.Equals, "OwnerID", roleID);
try
{
Assistant.DeleteList <Permission>(ic, c);
}
catch (Exception)
{
}
//删除AccountRole
Criteria cr = new Criteria(CriteriaType.Equals, "RoleID", roleID);
try
{
Assistant.DeleteList <AccountRole>(ic, cr);
}
catch (Exception)
{
}
//最后删除当前角色
Role r = new Role();
r.ID = roleID;
Assistant.Delete(ic, r);
ic.Commit();
}
catch (Exception ex)
{
ic.Rollback();
throw ex;
}
finally { ic.Dispose(); }
}
/// <summary>
/// 删除一条投票（及选项，回答，统计）
/// </summary>
/// <param name="vote"></param>
#region bool DeleteVote(Vote vote)
public bool DeleteVote(Vote vote)
{
try
{
string voteID = vote.ID;
bool flag = Assistant.Delete(vote);
if (flag)
{
Criteria criteria = new Criteria(CriteriaType.Equals, "VoteID", voteID);
Assistant.DeleteList <VoteEntry>(criteria);
Assistant.DeleteList <VoteAnswer>(criteria);
Assistant.DeleteList <VoteAnswerStat>(criteria);
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 删除帐户（同时删除权限以及联盟和邮箱帐号等）
/// </summary>
/// <param name="ic">连接</param>
/// <param name="accountID">用户ID</param>
public void DeleteAccont(IConnection ic, string accountID)
{
We7Helper.AssertNotNull(Assistant, "AccountHelper.Assistant");
We7Helper.AssertNotNull(accountID, "DeleteAccont.accountID");
//利用事务进行帐户的相关权限删除
try
{
//删除Permissions
Criteria c = new Criteria(CriteriaType.Equals, "OwnerID", accountID);
try
{
Assistant.DeleteList <Permission>(ic, c);
}
catch (Exception)
{
}
//删除AccountRole
Criteria ca = new Criteria(CriteriaType.Equals, "AccountID", accountID);
try
{
Assistant.DeleteList <AccountRole>(ic, ca);
}
catch (Exception)
{
}
//最后删除当前帐户
Account act = new Account();
act.ID = accountID;
Assistant.Delete(ic, act);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Delete(string tablename, object obj)
{
return(Assistant.Delete(obj, tablename));
}
public ActionResult DeleteAssistant(int assistantId, int learningId, int companyId, int userId)
{
return(Assistant.Delete(assistantId, learningId, companyId, userId));
}
/// <summary>
/// 删除一条投票选项
/// </summary>
/// <param name="voteEntry"></param>
#region bool DeleteVoteEntry(VoteEntry voteEntry)
public bool DeleteVoteEntry(VoteEntry voteEntry)
{
return(Assistant.Delete(voteEntry));
}
/// <summary>
/// 删除一个回复
/// </summary>
/// <param name="id"></param>
public void DeleteAdviceReply(string id)
{
AdviceReply ar = GetAdviceReply(id);
Assistant.Delete(ar);
}
