private SearchProductPlanData GetSearchData()
{
SearchProductPlanData data = new SearchProductPlanData();
data.PLAN = Convert.ToDouble(Request["plan"] == null ? "0" : Request["plan"]);
data.PRODUCTTYPE = Convert.ToDouble(this.cmbProductType.SelectedItem.Value);
data.PRODUCTGROUP = Convert.ToDouble(this.cmbProductGroup.SelectedItem.Value);
data.PRODUCTNAME = this.txtProductName.Text.Trim();
return data;
}
public static DataTable GetProductPlanList(SearchProductPlanData data)
{
string where = "PT.TYPE = '" + Constz.ProductType.Type.FG.Code + "' ";
if (data.PLAN != 0)
where += (where == "" ? "" : "AND ") + "P.LOID NOT IN (SELECT PRODUCT FROM PLANORDER WHERE PLAN = " + data.PLAN.ToString() + ") ";
if (data.PRODUCTTYPE != 0)
where += (where == "" ? "" : "AND ") + "PRODUCTTYPE = " + data.PRODUCTTYPE.ToString() + " ";
if (data.PRODUCTGROUP != 0)
where += (where == "" ? "" : "AND ") + "PRODUCTGROUP = " + data.PRODUCTGROUP.ToString() + " ";
if (data.PRODUCTNAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "P.NAME LIKE '%" + data.PRODUCTNAME.Trim() + "%' ";
string sql = "SELECT P.LOID, P.BARCODE, P.NAME, PG.NAME PRODUCTGROUP, PT.NAME PRODUCTTYPE ";
sql += "FROM PRODUCT P INNER JOIN PRODUCTGROUP PG ON PG.LOID = P.PRODUCTGROUP AND P.ACTIVE = '" + Constz.ActiveStatus.Active + "' AND P.ISDEFAULT = 'Y' ";
sql += "INNER JOIN PRODUCTTYPE PT ON PT.LOID = PG.PRODUCTTYPE ";
sql += (where == "" ? "" : "WHERE " + where);
sql += "ORDER BY P.BARCODE, P.NAME ";
return OracleDB.ExecListCmd(sql);
}
public DataTable GetProductPlanList(SearchProductPlanData data)
{
return SearchDAL.GetProductPlanList(data);
}
