public void SetData(SearchProductData data)
{
this.txtCode.Text = data.CODE;
this.txtName.Text = data.NAME;
this.cmbProductGroup.SelectedValue = data.PRODUCTGROUP.ToString();
this.cmbProductType.SelectedValue = data.PRODUCTTYPE.ToString();
}
private SearchProductData GetSearchData()
{
SearchProductData data = new SearchProductData();
data.CODE = this.txtBarcode.Text.Trim();
data.PRODUCTTYPE = Convert.ToDouble(this.cmbProductType.SelectedItem.Value);
data.PRODUCTGROUP = Convert.ToDouble(this.cmbProductGroup.SelectedItem.Value);
data.NAME = this.txtProductName.Text.Trim();
return data;
}
private SearchProductData GetData()
{
SearchProductData data = new SearchProductData();
data.CODE = this.txtCode.Text.Trim();
data.NAME = this.txtName.Text.Trim();
data.PRODUCTGROUP = Convert.ToDouble(this.cmbProductGroup.SelectedValue);
data.PRODUCTTYPE = Convert.ToDouble(this.cmbProductType.SelectedValue);
data.WAREHOUSE = Convert.ToDouble(this.txtWarehouse.Text == "" ? "0" : this.txtWarehouse.Text);
data.TYPE = Constz.ProductType.Type.FG.Code;
return data;
}
public static DataTable GetProductList(SearchProductData data)
{
string where = " ACTIVE = '1' ";
if (data.CODE.Trim() != "")
where += (where == "" ? "" : "AND ") + "(UPPER(BARCODE) = '" + data.CODE.Trim().ToUpper() + "' OR UPPER(ABBNAME) = '" + data.CODE.Trim().ToUpper() + "' )";
if (data.NAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(PNAME) LIKE '%" + data.NAME.Trim().ToUpper() + "%' ";
if (data.PRODUCTGROUP != 0)
where += (where == "" ? "" : "AND ") + "PGLOID = " + data.PRODUCTGROUP.ToString() + " ";
if (data.PRODUCTTYPE != 0)
where += (where == "" ? "" : "AND ") + "PTLOID = " + data.PRODUCTTYPE.ToString() + " ";
if (data.WAREHOUSE != 0)
where += (where == "" ? "" : "AND ") + "WAREHOUSE = " + data.WAREHOUSE.ToString() + " ";
if (data.ZONE != 0)
where += (where == "" ? "" : "AND ") + "ZONE = " + data.ZONE.ToString() + " ";
if (data.TYPE.Trim() != "")
where += (where == "" ? "" : "AND ") + "TYPE = '" + data.TYPE + "' ";
string sql = "SELECT DISTINCT LOID, BARCODE, PNAME, NAME PRODUCTGROUP, TNAME PRODUCTTYPE ";
sql += "FROM V_PRODUCT_LIST_REQUISITION ";
sql += (where == "" ? "" : "WHERE " + where);
sql += "ORDER BY BARCODE ";
return OracleDB.ExecListCmd(sql);
}
public static DataTable GetProductPRList(SearchProductData data)
{
string where = "";
if (data.NAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(PDNAME) LIKE '%" + data.NAME.Trim().ToUpper() + "%' ";
if (data.PRODUCTGROUP != 0)
where += (where == "" ? "" : "AND ") + "PRODUCTGROUP = " + data.PRODUCTGROUP.ToString() + " ";
if (data.PRODUCTTYPE != 0)
where += (where == "" ? "" : "AND ") + "PRODUCTTYPE = " + data.PRODUCTTYPE.ToString() + " ";
if (data.CODE.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(CODE) LIKE '%" + data.CODE.Trim().ToUpper() + "%' ";
string sql = "SELECT LOID, CODE, PDNAME, PGNAME, PTNAME FROM V_PRODUCT_PR_LIST ";
sql += (where == "" ? "" : "WHERE ") + where;
sql += "ORDER BY PGNAME, PDNAME ";
return OracleDB.ExecListCmd(sql);
}
public static DataTable GetProductShopList(SearchProductData data)
{
string where = "";
if (data.CODE.Trim() != "")
where += (where == "" ? "" : "AND ") + "(UPPER(BARCODE) = '" + data.CODE.Trim().ToUpper() + "' OR UPPER(ABBNAME) = '" + data.CODE.Trim().ToUpper() + "' )";
if (data.NAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(NAME) LIKE '%" + data.NAME.Trim().ToUpper() + "%' ";
if (data.PRODUCTGROUP != 0)
where += (where == "" ? "" : "AND ") + "PRODUCTGROUP = " + data.PRODUCTGROUP.ToString() + " ";
if (data.PRODUCTTYPE != 0)
where += (where == "" ? "" : "AND ") + "PRODUCTTYPE = " + data.PRODUCTTYPE.ToString() + " ";
string sql = "SELECT LOID, BARCODE, NAME PNAME, GNAME PRODUCTGROUP, PTNAME PRODUCTTYPE FROM V_PRODUCT_LIST ";
sql += (where == "" ? "" : "WHERE ") + where;
sql += "ORDER BY NAME ";
return OracleDB.ExecListCmd(sql);
}
public static DataTable GetProductMasterList(SearchProductData data)
{
string where = " ACTIVE = '1' ";
if (data.CODE.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(BARCODE) LIKE '%" + data.CODE.Trim().ToUpper() + "%' ";
if (data.NAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(PNAME) LIKE '%" + data.NAME.Trim().ToUpper() + "%' ";
if (data.PRODUCTGROUP != 0)
where += (where == "" ? "" : "AND ") + "PRODUCTGROUP = " + data.PRODUCTGROUP.ToString() + " ";
if (data.PRODUCTTYPE != 0)
where += (where == "" ? "" : "AND ") + "PRODUCTTYPE = " + data.PRODUCTTYPE.ToString() + " ";
if (data.TYPE.Trim() != "")
where += (where == "" ? "" : "AND ") + "TYPE = '" + data.TYPE + "' ";
string sql = "SELECT DISTINCT PRODUCTMASTER LOID, BARCODE, PRODUCTNAME PNAME, GNAME PRODUCTGROUP, PTNAME PRODUCTTYPE ";
sql += "FROM V_PRODUCT_LIST ";
sql += (where == "" ? "" : "WHERE " + where);
sql += "ORDER BY BARCODE ";
return OracleDB.ExecListCmd(sql);
}
public DataTable GetProductMasterList(SearchProductData data)
{
return SearchDAL.GetProductMasterList(data);
}
public DataTable GetProductReserveList(SearchProductData data)
{
return SearchDAL.GetProductReserveList(data);
}
