public static bool InsertCompanyUserSmsRecord(SqlConnection conn, CompanyUserSmsRecord record)
{
var sql = @"INSERT Tuhu_groupon..CompanyUserSmsRecord
( Type ,
BatchCode ,
SmsTemplateId ,
SmsMsg ,
SentTime ,
Status ,
CreatedUser
)
VALUES ( @Type ,
@BatchCode ,
@SmsTemplateId ,
@SmsMsg ,
@SentTime ,
@Status ,
@CreatedUser
)";
var parameters = new[]
{
new SqlParameter("@Type", record.Type),
new SqlParameter("@BatchCode", record.BatchCode),
new SqlParameter("@SmsTemplateId", record.SmsTemplateId),
new SqlParameter("@SmsMsg", record.SmsMsg),
new SqlParameter("@SentTime", record.SentTime),
new SqlParameter("@Status", record.Status),
new SqlParameter("@CreatedUser", record.CreatedUser)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0);
}
public bool InsertCompanyUserSmsRecord(CompanyUserSmsRecord record)
{
bool result = false;
try
{
result = TuhuGrouponDbScopeManager.Execute(conn => handler.InsertCompanyUserSmsRecord(conn, record));
}
catch (Exception ex)
{
Logger.Error("GetProductsByPackageId", ex);
}
return(result);
}
internal bool InsertCompanyUserSmsRecord(SqlConnection conn, CompanyUserSmsRecord record)
{
return(DalBeautyCode.InsertCompanyUserSmsRecord(conn, record));
}
