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