public DataSet GetPurchaseStructure(int PurchaseMasterId)
{
DataSet ds = new DataSet();
Smartworks.ColumnField[] getPurchaseInvoice = new Smartworks.ColumnField[1];
getPurchaseInvoice[0] = new Smartworks.ColumnField("@PurchaseMasterId", PurchaseMasterId);
ds = dataAccess.getDataSetByStoredProcedure("sp_GetPurchaseInvoiceStructure", getPurchaseInvoice);
return(ds);
}
public DataSet GetSalesReturnStructure(int SalesReturnId)
{
DataSet ds = new DataSet();
Smartworks.ColumnField[] getSales = new Smartworks.ColumnField[1];
getSales[0] = new Smartworks.ColumnField("@SalesReturnId", SalesReturnId);
ds = dataAccess.getDataSetByStoredProcedure("sp_GetSalesReturnStructure", getSales);
return(ds);
}
public DataSet GetPackingListStructureBySOId(int SOrderId)
{
DataSet ds = new DataSet();
Smartworks.ColumnField[] getPackingList = new Smartworks.ColumnField[1];
getPackingList[0] = new Smartworks.ColumnField("@SOrderId", SOrderId);
ds = dataAccess.getDataSetByStoredProcedure("sp_GetPackingListStructureBySOId", getPackingList);
return(ds);
}
public DataSet GetPromotionStructure(int PromotionId)
{
DataSet ds = new DataSet();
Smartworks.ColumnField[] getPromotion = new Smartworks.ColumnField[1];
getPromotion[0] = new Smartworks.ColumnField("@PromotionId", PromotionId);
ds = dataAccess.getDataSetByStoredProcedure("sp_GetPromotionStructure", getPromotion);
return(ds);
}
public DataSet GetPurchaseOrderStructure(int POrderId)
{
DataSet ds = new DataSet();
Smartworks.ColumnField[] getPO = new Smartworks.ColumnField[1];
getPO[0] = new Smartworks.ColumnField("@POrderId", POrderId);
ds = dataAccess.getDataSetByStoredProcedure("sp_GetPurchaseOrderStructure", getPO);
return(ds);
}
public DataSet GetRequisitionStructure(int RequisitionId)
{
DataSet ds = new DataSet();
Smartworks.ColumnField[] getREQ = new Smartworks.ColumnField[1];
getREQ[0] = new Smartworks.ColumnField("@StockReqMasterId", RequisitionId);
ds = dataAccess.getDataSetByStoredProcedure("sp_GetRequisitionStructure", getREQ);
return(ds);
}
public DataSet GetWarehouseTrasnferStructure(int warehouseId)
{
DataSet ds = new DataSet();
Smartworks.ColumnField[] gWarehouseStructure = new Smartworks.ColumnField[1];
gWarehouseStructure[0] = new Smartworks.ColumnField("@WTMasterId", warehouseId);
ds = dataAccess.getDataSetByStoredProcedure("sp_GetWarehouseTransferStructure", gWarehouseStructure);
return(ds);
}
public DataSet GetVoucherStructure(int VoucherMasterId)
{
DataSet ds = new DataSet();
Smartworks.ColumnField[] gVouchar = new Smartworks.ColumnField[1];
gVouchar[0] = new Smartworks.ColumnField("@VoucherMasterId", VoucherMasterId);
ds = dataAccess.getDataSetByStoredProcedure("sp_GetAccountStructure", gVouchar);
return(ds);
}
private void frmSearch_Load(object sender, EventArgs e)
{
try
{
dset = dataAccess.getDataSetByStoredProcedure(ProcedureName, SearchParameterField);
gridControl1.DataSource = dset.Tables[0];
foreach (DevExpress.XtraGrid.Columns.GridColumn col in gridView1.Columns)
{
col.OptionsFilter.AutoFilterCondition = DevExpress.XtraGrid.Columns.AutoFilterCondition.Contains;
}
}
catch (System.Data.SqlClient.SqlException ex)
{
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message, Messages.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}