public DataTable GetABTestDetail()
{
string sql = @"SELECT *
FROM [Configuration].[dbo].[ABTestConfig] WITH ( NOLOCK )
WHERE IsDelete =0";
return(db.ExecuteDataTable(new SqlCommand(sql)));
}
public DataTable GetCouponInfoValidate(Guid guid)
{
using (SqlCommand cmd = new SqlCommand(@" SELECT PKID AS GetRuleID,GetRuleGUID AS GetRuleGUID,
CASE Term WHEN NULL THEN 1 ELSE 0 END AS VerificationMode,
Term AS ValidDays,
ValiStartDate AS ValidStartDateTime,
ValiEndDate AS ValidEndDateTime,
SupportUserRange AS UserType,
[Description] AS[Description],
Discount,
MinMoney,
SingleQuantity,
Quantity FROM Activity.dbo.tbl_GetCouponRules (NOLOCK) WHERE GetRuleGUID=@GetRuleGUID "))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@GetRuleGUID", guid);
return(db.ExecuteDataTable(cmd));
}
}
public DataTable GetDataTable()
{
string sql = "SELECT * FROM configuration.dbo.SE_FlagshipStoreConfig (NOLOCK) ";
return(db.ExecuteDataTable(new SqlCommand(sql)));
}
public DataTable GetDataTable()
{
string sql = "select * from [Configuration].[dbo].[CarProductFlagshipStoreConfig] with (nolock) ";
return(db.ExecuteDataTable(new SqlCommand(sql)));
}