public void AddBatchAmount(SmsBatchAmountInfo info)
{
using (InserAction action = new InserAction(info))
{
action.Excute();
}
}
public int AddGroup(SmsContactgroupInfo entity)
{
using (InserAction inserAction = new InserAction(entity))
{
inserAction.ExcuteIdentity();
return(inserAction.ReturnCode);
}
}
public int AddEnterprise(SmsEnterpriseInfo info)
{
using (InserAction insert = new InserAction(info))
{
insert.ExcuteIdentity();
return(insert.ReturnCode);
}
}
public int AddBatch(SmsBatchInfo info)
{
using (InserAction action = new InserAction(info))
{
action.ExcuteIdentity();
return(action.ReturnCode);
}
}
/// <summary>
/// linq方式指定条件插入
/// </summary>
public void AddDemo2()
{
using (InserAction action = new InserAction(Entity))
{
action.Cast <cms_user>()
.SqlValue(u => u.username == "wangjun" && u.password == "123456")
.UnCast().Excute();
}
}
/// <summary>
/// 按照指定的条件插入
/// </summary>
public void AddDemo1()
{
using (InserAction action = new InserAction(Entity))
{
action.SqlKeyValue(cms_user.Columns.username, "wangjun");
action.SqlKeyValue(cms_user.Columns.password, "123456");
action.Excute();
}
}
/// <summary>
/// 实体对象直接插入
/// </summary>
public void AddDemo()
{
cms_user user = new cms_user();
user.username = "******";
user.password = "******";
user.phone = "13800138000";
using (InserAction action = new InserAction(user))
action.Excute();
}
public void AddList(List <SmsBatchDetailsInfo> infos)
{
using (TradAction action = new TradAction())
{
List <string> sqls = new List <string>();
foreach (var info in infos)
{
InserAction inserAction = new InserAction(info);
sqls.Add(inserAction.CreateSql(OperateEnum.Insert));
}
action.ExecuteSqlTran(sqls);
}
}
public void AddList(List <SmsMoInfo> molists)
{
using (TradAction action = new TradAction())
{
List <string> sqls = new List <string>();
foreach (var mo in molists)
{
InserAction inserAction = new InserAction(mo);
sqls.Add(inserAction.CreateSql(OperateEnum.Insert));
}
action.ExecuteSqlTran(sqls);
}
}
public void AddList(List <SmsEnterpriseCfgInfo> infos)
{
StringBuilder stringBuilder = new StringBuilder();
foreach (SmsEnterpriseCfgInfo smsEnterpriseCfgInfo in infos)
{
stringBuilder.AppendLine("delete from sms_enterprise_cfg where EnterpriseID=" + smsEnterpriseCfgInfo.EnterpriseID + " and CfgKey='" + smsEnterpriseCfgInfo.CfgKey + "';");
using (InserAction action = new InserAction(smsEnterpriseCfgInfo))
{
stringBuilder.AppendLine(action.CreateSql(OperateEnum.Insert));
}
}
TradAction taction = new TradAction();
taction.Excute(stringBuilder.ToString());
}
/// <summary>
/// 批量插入
/// </summary>
public void AddDemo3()
{
using (InserAction action = new InserAction(new NullEntity()))
{
action.Cast().InsertList(() => new List <BaseEntity>()
{
new cms_user()
{
username = "******", password = "******"
},
new TestUser()
{
}
});
}
}
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();
}
}
}
