/// <summary>
/// 返回下拉列表
/// </summary>
/// <param name="vSql"></param>
/// <returns></returns>
public List <LH_Policy> Select_List()
{
var helper = new OracleDBHelper();
var list = helper.Select <LH_Policy>(@"SELECT DISTINCT HEADID,POLICYNAME,ORDERTYPE,ORDERSUBTYPE,PRODCHANNEL,DEPTNAME from LH_POLICY");
return(list);
}
public List <LH_Policy> GetPolicies(ICPOBILL_PolicyDTO header)
{
//检查传入参数是否合法
CheckNull(header);
var helper = new OracleDBHelper();
var sql =
@"SELECT DISTINCT HEADID,POLICYNAME,ORDERTYPE,ORDERSUBTYPE,PRODCHANNEL,DEPTNAME from LH_POLICY WHERE 1=1 ";
//选择订单类型为常规订单的，如果用户要选择促销政策头ID的话则需要同时判断：订单所属公司（事业部）、厂家账号（经销商账号）、销售渠道、业务类型、五项头字段信息来取促销政策头ID信息
string where = $@"AND ORDERTYPE='{header.OrderType}' AND DEPTNAME LIKE '%{header.BrandName}%'
AND ORDERSUBTYPE='{header.OrderSubType}' AND PRODCHANNEL='{header.Channel}' AND ACCTCODES LIKE '%{header.Account}%'";
sql += where;
var policies = helper.Select <LH_Policy>(sql);
return(policies);
}