public DataTable GetPlanDetailList(PlanDetailSearchData data)
{
string sql = "SELECT V.* FROM V_PLANPURCHASE V ";
string where = "";
if (data.YEAR != 0)
where += (where == "" ? "" : " AND ") + "V.YEAR = " + data.YEAR.ToString() + " ";
if (data.MONTH != 0)
where += (where == "" ? "" : " AND ") + "V.MONTH = " + data.MONTH.ToString() + " ";
if (data.PRODUCTNAME != "")
where += (where == "" ? "" : " AND ") + "UPPER(V.PRODUCTNAME) LIKE '%" + data.PRODUCTNAME.ToUpper() + "%' ";
if (data.PRODUCTGROUP != 0)
where += (where == "" ? "" : " AND ") + "V.PGROUP = " + data.PRODUCTGROUP.ToString() + " ";
if (data.PRODUCTTYPE != 0)
where += (where == "" ? "" : " AND ") + "V.PTYPE = " + data.PRODUCTTYPE.ToString() + " ";
sql += (where == "" ? "" : "WHERE " + where) + " ORDER BY PLAN, PRODUCTNAME ";
return OracleDB.ExecListCmd(sql);
}
private PlanDetailSearchData GetSearchData()
{
PlanDetailSearchData data = new PlanDetailSearchData();
data.YEAR = Convert.ToDouble(this.txtYear.Text == "" ? "0" : this.txtYear.Text);
data.PRODUCTGROUP = Convert.ToDouble(this.cmbProductGroup.SelectedItem.Value);
data.PRODUCTTYPE = Convert.ToDouble(this.cmbProductType.SelectedItem.Value);
data.PRODUCTNAME = this.txtProductKey.Text.Trim();
data.MONTH = Convert.ToDouble(this.cmbMonth.SelectedItem.Value);
return data;
}
public DataTable GetPlanDetailList(PlanDetailSearchData data)
{
return PlanObj.GetPlanDetailList(data);
}