/// <summary>
/// 批量导入银行美容活动用户规则
/// </summary>
/// <param name="conn"></param>
/// <param name="table"></param>
/// <returns></returns>
internal bool BatchImportBankMRActivityUsers(SqlConnection conn, IEnumerable <BankMRActivityUser> list)
{
var dt = new DataTable {
TableName = "Tuhu_groupon.dbo.BankMRActivityUsers"
};
dt.Columns.Add(new DataColumn("ActivityRoundId", typeof(int)));
dt.Columns.Add(new DataColumn("BankCardNum", typeof(string)));
dt.Columns.Add(new DataColumn("Mobile", typeof(string)));
dt.Columns.Add(new DataColumn("OtherNum", typeof(string)));
dt.Columns.Add(new DataColumn("LimitCount", typeof(int)));
dt.Columns.Add(new DataColumn("DayLimit", typeof(int)));
dt.Columns.Add(new DataColumn("BatchCode", typeof(string)));
list?.ToList().ForEach(item =>
{
var row = dt.NewRow();
row["ActivityRoundId"] = item.ActivityRoundId;
row["BankCardNum"] = item.BankCardNum;
row["Mobile"] = item.Mobile;
row["OtherNum"] = item.OtherNum;
row["LimitCount"] = item.LimitCount;
row["DayLimit"] = item.DayLimit;
row["BatchCode"] = item.BatchCode;
dt.Rows.Add(row);
});
return(BankMRActivityDal.BatchImportBankMRActivityUsers(conn, dt));
}
/// <summary>
/// 批量导入银行活动白名单
/// </summary>
/// <param name="conn"></param>
/// <param name="list"></param>
/// <returns></returns>
internal bool BatchImportBankActivityWhiteUsers(SqlConnection conn, IEnumerable <BankActivityWhiteUsers> list)
{
var dt = new DataTable {
TableName = "Tuhu_groupon.dbo.BankActivityWhiteUsers"
};
dt.Columns.Add(new DataColumn("GroupConfigId", typeof(int)));
dt.Columns.Add(new DataColumn("CardNum", typeof(string)));
dt.Columns.Add(new DataColumn("Mobile", typeof(string)));
list?.ToList().ForEach(item =>
{
var row = dt.NewRow();
row["GroupConfigId"] = item.GroupConfigId;
row["CardNum"] = item.CardNum;
row["Mobile"] = item.Mobile;
dt.Rows.Add(row);
});
return(BankMRActivityDal.BatchImportBankMRActivityUsers(conn, dt));
}