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); }