public void DeleteBlack(string ids)
{
using (DeleteAction action = new DeleteAction(this.Entity))
{
action.SqlWhere(SmsBlackphoneInfo.Columns.ID, ids, ConditionEnum.And, RelationEnum.In);
action.Excute();
}
}
public void ClearBlack(int EnterpriseID)
{
using (DeleteAction action = new DeleteAction(this.Entity))
{
action.SqlWhere(SmsBlackphoneInfo.Columns.EnterpriseID, EnterpriseID);
action.Excute();
}
}
public int DelGroup(int groupId)
{
using (DeleteAction action = new DeleteAction(this.Entity))
{
action.SqlWhere(SmsContactgroupInfo.Columns.ID, groupId);
return(action.Excute().ReturnCode);
}
}
public void ClearKeyword(int EnterpriseID)
{
using (DeleteAction action = new DeleteAction(this.Entity))
{
action.SqlWhere(SmsContentfilterkeyInfo.Columns.EnterpriseID, EnterpriseID);
action.Excute();
}
}
public void DeleteKeyword(string ids)
{
using (DeleteAction action = new DeleteAction(this.Entity))
{
action.SqlWhere(SmsContentfilterkeyInfo.Columns.ID, ids, ConditionEnum.And, RelationEnum.In);
action.Excute();
}
}
public void deleteMt(int mtid)
{
using (DeleteAction action = new DeleteAction(new SmsBatchWaitInfo()))
{
action.SqlWhere(SmsBatchWaitInfo.Columns.ID, mtid);
action.Excute();
}
}
public void ImportList(List <SmsContactInfo> contacts, int groupid)
{
if (contacts.Count > 0)
{
using (TradAction action = new TradAction())
{
List <string> sqls = new List <string>();
foreach (var filterkey in contacts)
{
InserAction inserAction = new InserAction(filterkey);
sqls.Add(inserAction.CreateSql(OperateEnum.Insert));
}
action.ExecuteSqlTran(sqls);
}
string ids = "";
using (SelectAction action = new SelectAction(this.Entity))
{
action.SqlClomns = " min(id) as id ";
action.SqlGroupBy("Mobile,EnterpriseID,GroupID HAVING COUNT(1)>1");
action.SqlWhere("EnterpriseID", contacts[0].EnterpriseId);
if (groupid > 0)
{
action.SqlWhere("GroupID", groupid);
}
action.SqlPageParms(-1);
List <SmsBlackphoneInfo> idlist = action.QueryPage <SmsBlackphoneInfo>(0);
foreach (SmsBlackphoneInfo info in idlist)
{
ids += info.ID + ",";
}
}
using (DeleteAction taction = new DeleteAction(this.Entity))
{
taction.SqlWhere(SmsBlackphoneInfo.Columns.ID, ids.TrimEnd(','), ConditionEnum.And,
RelationEnum.In);
taction.SqlWhere(SmsBlackphoneInfo.Columns.EnterpriseID, contacts[0].EnterpriseId);
taction.Excute();
}
}
}
