Ejemplo n.º 1
0
 /// <summary>
 /// 根据条件查询销售订单信息
 /// </summary>
 /// <param name="C_SFPJ">是否已经评价</param>
 /// <param name="N_STATUS">订单状态</param>
 /// <param name="N_EXEC_STATUS">订单执行状态2人工确认完成</param>
 /// <param name="N_SFPW">是否排产完0未排完1已排完 NULL未排((N_WGT-N_ROLL_PROD_WGT-N_LINE_MATCH_WGT)=0&&(N_WGT-N_SMS_PROD_WGT-N_SLAB_MATCH_WGT)=0)</param>
 /// <param name="C_ORDER_NO">订单号</param>
 /// <param name="C_CON_NO">合同号</param>
 /// <param name="C_AREA">销售区域</param>
 /// <param name="C_STL_GRD">钢种</param>
 /// <param name="C_STD_CODE">执行标准</param>
 /// <param name="C_SPEC">规格</param>
 /// <param name="D_SPEC_MIN">规格最小</param>
 /// <param name="D_SPEC_MAX">规格最大</param>
 /// <param name="C_LINE_NO">产线号</param>
 /// <param name="C_CCM_NO">连铸号</param>
 /// <param name="C_CUST_NAME">客户名称</param>
 /// <param name="C_SALE_CHANNEL">销售类型</param>
 /// <param name="C_PRO_USE">产品用途</param>
 /// <param name="C_RH">是否真空</param>
 /// <param name="C_HL">是否缓冷</param>
 ///  <param name="C_JQ_MIN">交货日期最小值</param>
 ///  <param name="C_JQ_MAX">交货日期最大值</param>
 /// <returns>销售订单列表</returns>
 public DataSet GetListByWhere(string C_SFPJ, int?N_STATUS, int?N_EXEC_STATUS, int?N_SFPW, string C_ORDER_NO, string C_CON_NO, string C_AREA, string C_STL_GRD, string C_STD_CODE, string C_SPEC, double?D_SPEC_MIN, double?D_SPEC_MAX, string C_LINE_NO, string C_CCM_NO, string C_CUST_NAME, string C_SALE_CHANNEL, string C_PRO_USE, string C_RH, string C_HL, string C_JQ_MIN, string C_JQ_MAX)
 {
     return(dal.GetListByWhere(C_SFPJ, N_STATUS, N_EXEC_STATUS, N_SFPW, C_ORDER_NO, C_CON_NO, C_AREA, C_STL_GRD, C_STD_CODE, C_SPEC, D_SPEC_MIN, D_SPEC_MAX, C_LINE_NO, C_CCM_NO, C_CUST_NAME, C_SALE_CHANNEL, C_PRO_USE, C_RH, C_HL, C_JQ_MIN, C_JQ_MAX));
 }