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