public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select * From " + xCVSMT.table;
dt = conn.selectData(sql, "kfc_po");
return(dt);
}
public Boolean selectDupPk(String Org_id, String sub_id)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCSUVINV.table + " Where " + xCSUVINV.ORGANIZATION_ID + "='" + Org_id + "' and " + xCSUVINV.SUBINVENTORY_ID + "='" + sub_id + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String LEDGER_ID)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCGLG.table + " Where " + xCGLG.LEDGER_ID + "=" + LEDGER_ID;
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String RegistrationId, String BranchNumber)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCGl.table + " Where " + xCGl.REGISTRATION_ID + "=" + RegistrationId + " AND " + xCGl.BRANCH_NUMBER + " = '" + BranchNumber + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String InvoiceId)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCAP.table + " Where " + xCAP.INVOICE_ID + "=" + InvoiceId;
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String TaxRateId, String TaxRateCode)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCTxC.table + " Where " + xCTxC.TAX_RATE_ID + "='" + TaxRateId + "' and " + xCTxC.TAX_RATE_CODE + "='" + TaxRateCode + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String LocId, String LocDetailsId)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCGlC.table + " Where " + xCGlC.LOCATION_ID + " = " + LocId + " and " + xCGlC.LOCATION_DETAILS_ID + " = " + LocDetailsId;
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String lookupType, String lookupCode)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCAP.table + " Where " + xCAP.LOOKUP_TYPE + "='" + lookupType + "' and " + xCAP.LOOKUP_CODE + "='" + lookupCode + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String SupSiteSpkId, String VendorSiteId)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCSup.table + " Where " + xCSup.VENDOR_SITE_SPK_ID + "='" + SupSiteSpkId + "' and " + xCSup.VENDOR_SITE_ID + "= '" + VendorSiteId + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String CodeCombinationId)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCGlC.table + " Where " + xCGlC.CODE_COMBINATION_ID + " = " + CodeCombinationId;
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String ORGANIZATION_ID, String SUBINVENTORY_ID, String INVENTORY_LOCATION_ID)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCLoca.table + " Where " + xCLoca.ORGANIZATION_ID + "='" + ORGANIZATION_ID + "' and " + xCLoca.SUBINVENTORY_ID + "='" + SUBINVENTORY_ID + "' and " + xCLoca.INVENTORY_LOCATION_ID + "='" + INVENTORY_LOCATION_ID + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String UOM_CODE)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCUOM.table + " Where " + xCUOM.UOM_CODE + "='" + UOM_CODE + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String ledgerId, String periodName)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCGlP.table + " Where " + xCGlP.LEDGER_ID + "='" + ledgerId + "' and " + xCGlP.PERIOD_NAME + "='" + periodName + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String ORGANIZATION_ID)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCOrg.table + " Where " + xCOrg.ORGANIZATION_ID + "='" + ORGANIZATION_ID + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String po_header_id, String po_line_id)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCPoR.table + " Where " + xCPoR.PO_HEADER_ID + "='" + po_header_id + "' and " + xCPoR.PO_LINE_ID + "='" + po_line_id + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String PO_HEADER_ID, String PO_Line_ID, String ITEM_ID)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCBlKL.table + " Where " + xCBlKL.PO_HEADER_ID + "='" + PO_HEADER_ID + "' and " +
xCBlKL.PO_LINE_ID + "='" + PO_Line_ID + "' and " + xCBlKL.ITEM_ID + "='" + ITEM_ID + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String POCUMENT_BU, String AGREEMENT_NUMBER, String PO_HEADER_ID)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCBlKH.table + " Where " + xCBlKH.POCUMENT_BU + "='" + POCUMENT_BU + "' and " +
xCBlKH.AGREEMENT_NUMBER + "='" + AGREEMENT_NUMBER + "' and " + xCBlKH.PO_HEADER_ID + "='" + PO_HEADER_ID + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String Org_id, String item_id)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
//DateTime dat = Convert.ToDateTime(last_upd);
sql = "Select count(1) as cnt From " + xCITEM.table + " Where " + xCITEM.ORGANIZATION_ID + "='" + Org_id + "' and " +
xCITEM.INVENTORY_ITEM_ID + "='" + item_id + "'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}
public Boolean selectDupPk(String LEDGER_ID, String COST_ORG_ID, String COST_BOOK_ID, String PERIOD_NUM, String PERIOD_YEAR)
{
String sql = "";
Boolean chk = false;
DataTable dt = new DataTable();
sql = "Select count(1) as cnt From " + xCCSTCv.table + " Where " + xCCSTCv.LEDGER_ID + "='" + LEDGER_ID + "'" +
" and " + xCCSTCv.COST_ORG_ID + "='" + COST_ORG_ID + "'" +
" and " + xCCSTCv.COST_BOOK_ID + "='" + COST_BOOK_ID + "'" +
" and " + xCCSTCv.PERIOD_NUM + "='" + PERIOD_NUM + "'" +
" and " + xCCSTCv.PERIOD_YEAR + "='" + PERIOD_YEAR +
"'";
dt = conn.selectData(sql, "kfc_po");
if (dt.Rows.Count >= 1)
{
chk = true;
}
return(chk);
}