Esempio n. 1
0
        internal DataTable SearchJV(UpdateJournalVoucherModel objUJVModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPUpdateJournalVoucher";
                ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUJVModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUJVModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objUJVModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUJVModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", objUJVModel.VchType);
                ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUJVModel.DocNo);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtUJV     = new DataTable();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtUJV);
                dtUJV.TableName = "success";
            }
            catch (Exception)
            {
                dtUJV           = new DataTable();
                dtUJV.TableName = "error";
                return(dtUJV);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtUJV);
        }
        internal DataTable FillIWareHouseName(ItemOpenningStockModel ObjopenStockModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPMasters";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@DataInd", ObjopenStockModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjopenStockModel.OrgID);
                // ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjopenStockModel.BrID);
                //ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjopenStockModel.YrCD);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtopenStock           = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtopenStock);
                dtopenStock.TableName = "success";
            }
            catch (Exception)
            {
                dtopenStock           = new DataTable();
                dtopenStock.TableName = "error";
                return(dtopenStock);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtopenStock);
        }
 internal DataTable CheckBudgetAmount(NewBudgetAmountModel ObjNewBudgetAmountModel)
 {
     try
     {
         ClsCon.cmd = new SqlCommand();
         ClsCon.cmd.CommandType = CommandType.StoredProcedure;
         ClsCon.cmd.CommandText = "SPBudgetAmount";
         ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjNewBudgetAmountModel.Ind);
         ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjNewBudgetAmountModel.OrgID);
         ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjNewBudgetAmountModel.BrID);
         ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjNewBudgetAmountModel.YrCode);
         ClsCon.cmd.Parameters.AddWithValue("@SectionCD", ObjNewBudgetAmountModel.SectionCD);
         ClsCon.cmd.Parameters.AddWithValue("@SubSectionCD", ObjNewBudgetAmountModel.SubSectionCD);
         ClsCon.cmd.Parameters.AddWithValue("@BudgetHeadCD", ObjNewBudgetAmountModel.BudgetHeadCD);
         con = ClsCon.SqlConn();
         ClsCon.cmd.Connection = con;
         dtBudgetAmount = new DataTable();
         ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
         ClsCon.da.Fill(dtBudgetAmount);
         dtBudgetAmount.TableName = "success";
     }
     catch (Exception)
     {
         dtBudgetAmount = new DataTable();
         dtBudgetAmount.TableName = "error";
         return dtBudgetAmount;
     }
     finally
     {
         con.Close();
         con.Dispose();
         ClsCon.da.Dispose();
         ClsCon.cmd.Dispose();
     }
     return dtBudgetAmount;
 }
Esempio n. 4
0
        internal DataSet BindAll(CompositionSalesModel ObjCompositionSalesModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPSaleVoucher";
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjCompositionSalesModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCompositionSalesModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjCompositionSalesModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjCompositionSalesModel.VchType);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dsSales   = new DataSet();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dsSales);
                dsSales.DataSetName = "success";
            }
            catch (Exception)
            {
                dsSales             = new DataSet();
                dsSales.DataSetName = "error";
                return(dsSales);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dsSales);
        }
        internal DataTable Filllocation(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPMasters";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdPVModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdPVModel.YrCD);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtUpdPV   = new DataTable();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtUpdPV);
                dtUpdPV.TableName = "success";
            }
            catch (Exception)
            {
                dtUpdPV           = new DataTable();
                dtUpdPV.TableName = "error";
                return(dtUpdPV);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtUpdPV);
        }
        internal DataSet BindItemAndUnitDDL(UpdateStockTransferModel objUpdSTModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPUpdateStockTransfer";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSTModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSTModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSTModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@TransferFromWarehouseID", objUpdSTModel.WarehouseID);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dsUpdStockTransfer    = new DataSet();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dsUpdStockTransfer, "SuccessDataSet");
                dsUpdStockTransfer.DataSetName = "success";
            }
            catch (Exception)
            {
                dsUpdStockTransfer             = new DataSet();
                dsUpdStockTransfer.DataSetName = "error";
                return(dsUpdStockTransfer);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dsUpdStockTransfer);
        }
        internal DataSet BindAll(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPPurchaseVoucherChange";
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdPVModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdPVModel.VchType);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dsUpdPV   = new DataSet();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dsUpdPV);
                dsUpdPV.DataSetName = "success";
            }
            catch (Exception)
            {
                dsUpdPV             = new DataSet();
                dsUpdPV.DataSetName = "error";
                return(dsUpdPV);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dsUpdPV);
        }
Esempio n. 8
0
        internal DataTable LoadSalesTo(CompositionSalesModel ObjCompositionSalesModel) // FillDropDownSalesTo
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPMasters";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@DataInd", ObjCompositionSalesModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCompositionSalesModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjCompositionSalesModel.YrCD);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtSales   = new DataTable();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtSales);
                dtSales.TableName = "success";
            }
            catch (Exception)
            {
                dtSales           = new DataTable();
                dtSales.TableName = "error";
                return(dtSales);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtSales);
        }
Esempio n. 9
0
        internal DataTable UpdateShippingInfo(UpdateAccounHeadModel objUAHModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPUpdateAccountHead";
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objUAHModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUAHModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objUAHModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@UserID", objUAHModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IPAddress", objUAHModel.IP);
                ClsCon.cmd.Parameters.AddWithValue("@TblAccPOS", objUAHModel.DtAccPOS);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtUpdAccountHead      = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtUpdAccountHead);
                dtUpdAccountHead.TableName = "success";
            }
            catch (Exception)
            {
                dtUpdAccountHead           = new DataTable();
                dtUpdAccountHead.TableName = "error";
                return(dtUpdAccountHead);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtUpdAccountHead);
        }
Esempio n. 10
0
        internal DataTable SaveAdvance(AdvanceLiabilityModel ObjALModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SpAdvanceLiability";
                ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjALModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjALModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjALModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YRCD", ObjALModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@YearID", ObjALModel.YearID);
                ClsCon.cmd.Parameters.AddWithValue("@MonthID", ObjALModel.MonthID);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtAdvanceLia          = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtAdvanceLia);
                dtAdvanceLia.TableName = "success";
            }
            catch (Exception)
            {
                dtAdvanceLia           = new DataTable();
                dtAdvanceLia.TableName = "error";
                return(dtAdvanceLia);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtAdvanceLia);
        }
        internal DataTable InvoiceSeries(UpdateSalesReturnModel objUpdSRModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPMasters";
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdSRModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdSRModel.VchType);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtUpdSalesReturn      = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtUpdSalesReturn);
                dtUpdSalesReturn.TableName = "success";
            }
            catch (Exception)
            {
                dtUpdSalesReturn           = new DataTable();
                dtUpdSalesReturn.TableName = "error";
                return(dtUpdSalesReturn);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtUpdSalesReturn);
        }
Esempio n. 12
0
        internal DataSet CheckGSTIN_Number(PurchaseModel ObjPurchaseModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPSearchByAccount";
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@AccCode", ObjPurchaseModel.AccCode);


                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dsStatePanNoList      = new DataSet();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dsStatePanNoList);
                dsStatePanNoList.DataSetName = "success";
            }
            catch (Exception)
            {
                dsStatePanNoList             = new DataSet();
                dsStatePanNoList.DataSetName = "error";
                return(dsStatePanNoList);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dsStatePanNoList);
        }
Esempio n. 13
0
        internal DataTable FillItemName(PurchaseModel ObjPurchaseModel) //fill GistnNo
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPMasters";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@DataInd", ObjPurchaseModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtPurchase            = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtPurchase);
                dtPurchase.TableName = "success";
            }
            catch (Exception)
            {
                dtPurchase           = new DataTable();
                dtPurchase.TableName = "error";
                return(dtPurchase);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtPurchase);
        }
        internal DataSet BindAll(OldBalanceModel objOldBalance)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SpOldBalanceEntry";
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objOldBalance.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objOldBalance.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objOldBalance.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objOldBalance.YrCD);


                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dsOldBalance          = new DataSet();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dsOldBalance);
                dsOldBalance.DataSetName = "success";
            }
            catch (Exception)
            {
                dsOldBalance             = new DataSet();
                dsOldBalance.DataSetName = "error";
                return(dsOldBalance);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dsOldBalance);
        }
        internal DataSet DisplayPVItemRecord(RCMLiabilityModel objRCMLiaModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPRCMLiability";
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objRCMLiaModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objRCMLiaModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@MonthID", objRCMLiaModel.MonthID);
                ClsCon.cmd.Parameters.AddWithValue("@YearID", objRCMLiaModel.YearID);
                //ClsCon.cmd.Parameters.AddWithValue("@YearCode", objRCMLiaModel.YearCode);
                ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objRCMLiaModel.GSTIN);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dsRCMLiability        = new DataSet();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dsRCMLiability);
                dsRCMLiability.DataSetName = "success";
            }
            catch (Exception)
            {
                dsRCMLiability             = new DataSet();
                dsRCMLiability.DataSetName = "error";
                return(dsRCMLiability);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dsRCMLiability);
        }
        internal DataTable FillGistnNo(UpdDebitNoteModel objUpdDNModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPSearchByAccount";
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdDNModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdDNModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdDNModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdDNModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUpdDNModel.AccCode);


                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtDebitNote           = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtDebitNote);
                dtDebitNote.TableName = "success";
            }
            catch (Exception)
            {
                dtDebitNote           = new DataTable();
                dtDebitNote.TableName = "error";
                return(dtDebitNote);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtDebitNote);
        }
Esempio n. 17
0
        internal DataTable CheckGSTIN_Number(MasterModel ObjMM)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPSearchByAccount";
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjMM.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjMM.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjMM.BrID);
                //ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjMM.accco);


                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtStatePanNoList      = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtStatePanNoList);
                dtStatePanNoList.TableName = "success";
            }
            catch (Exception)
            {
                dtStatePanNoList           = new DataTable();
                dtStatePanNoList.TableName = "error";
                return(dtStatePanNoList);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtStatePanNoList);
        }
Esempio n. 18
0
        internal DataTable FillHeadName(SalesReturnModel objSalesRModel) //HeadName in Othertable
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPMasters";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@DataInd", objSalesRModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSalesRModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objSalesRModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSalesRModel.YrCD);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtSalesReturn         = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtSalesReturn);
                dtSalesReturn.TableName = "success";
            }
            catch (Exception)
            {
                dtSalesReturn           = new DataTable();
                dtSalesReturn.TableName = "error";
                return(dtSalesReturn);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtSalesReturn);
        }
Esempio n. 19
0
        internal DataTable UpdateClientInfo(UpdateAccounHeadModel objUAHModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPUpdateAccountHead";
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objUAHModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUAHModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objUAHModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUAHModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUAHModel.AccCode);
                ClsCon.cmd.Parameters.AddWithValue("@AccName", objUAHModel.AccName);
                ClsCon.cmd.Parameters.AddWithValue("@AccNameHindi", objUAHModel.AccNameHindi);
                ClsCon.cmd.Parameters.AddWithValue("@MainGroupID", objUAHModel.MainGroupID);
                ClsCon.cmd.Parameters.AddWithValue("@SubGroupID", objUAHModel.SubGroupID);
                ClsCon.cmd.Parameters.AddWithValue("@AccGroupID", objUAHModel.AccGroupID);
                ClsCon.cmd.Parameters.AddWithValue("@AccSubGroupID", objUAHModel.AccSubGroupID);
                ClsCon.cmd.Parameters.AddWithValue("@Address", objUAHModel.Address);
                ClsCon.cmd.Parameters.AddWithValue("@City", objUAHModel.City);
                ClsCon.cmd.Parameters.AddWithValue("@StateID", objUAHModel.StateID);
                ClsCon.cmd.Parameters.AddWithValue("@PinCode", objUAHModel.PinCode);
                ClsCon.cmd.Parameters.AddWithValue("@PanNo", objUAHModel.PanNo);
                ClsCon.cmd.Parameters.AddWithValue("@MobileNo", objUAHModel.MobileNo);
                ClsCon.cmd.Parameters.AddWithValue("@LandlineNo", objUAHModel.LandlineNo);
                ClsCon.cmd.Parameters.AddWithValue("@Email", objUAHModel.Email);
                ClsCon.cmd.Parameters.AddWithValue("@ContactPerson", objUAHModel.ContactPerson);
                ClsCon.cmd.Parameters.AddWithValue("@DrOpBalance", objUAHModel.DrOpBalance);
                ClsCon.cmd.Parameters.AddWithValue("@CrOpBalance", objUAHModel.CrOpBalance);
                ClsCon.cmd.Parameters.AddWithValue("@CategoryID", objUAHModel.CategoryID);
                ClsCon.cmd.Parameters.AddWithValue("@ISDApplicable", objUAHModel.ISDApplicable);
                ClsCon.cmd.Parameters.AddWithValue("@TDSApplicable", objUAHModel.TDSApplicable);
                ClsCon.cmd.Parameters.AddWithValue("@RCMApplicable", objUAHModel.RCMApplicable);
                ClsCon.cmd.Parameters.AddWithValue("@TCSApplicable", objUAHModel.TCSApplicable);
                ClsCon.cmd.Parameters.AddWithValue("@MerchantID", objUAHModel.MerchantID);
                ClsCon.cmd.Parameters.AddWithValue("@BankName", objUAHModel.BankName);
                ClsCon.cmd.Parameters.AddWithValue("@BranchName", objUAHModel.BranchName);
                ClsCon.cmd.Parameters.AddWithValue("@IFSCCode", objUAHModel.IFSCCode);
                ClsCon.cmd.Parameters.AddWithValue("@BankAccountNo", objUAHModel.BankAccountNo);
                ClsCon.cmd.Parameters.AddWithValue("@UserID", objUAHModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IPAddress", objUAHModel.IP);
                ClsCon.cmd.Parameters.AddWithValue("@CompositionOpted", objUAHModel.CompositionOpted);
                ClsCon.cmd.Parameters.AddWithValue("@ReffPartyCode", objUAHModel.ReffPartyCode);
                ClsCon.cmd.Parameters.AddWithValue("@IsSubDealer", objUAHModel.IsSubDealer);
                ClsCon.cmd.Parameters.AddWithValue("@DiscountRate", objUAHModel.DiscountRate);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", objUAHModel.BrokerageRate);
                ClsCon.cmd.Parameters.AddWithValue("@TblAccTerms", objUAHModel.TblAccTerms);
                ClsCon.cmd.Parameters.AddWithValue("@TaxCalcForSEZParty", objUAHModel.TaxCalcForSEZParty);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageLimit", objUAHModel.BrokerageLimit);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageType", objUAHModel.BrokerageType);
                ClsCon.cmd.Parameters.AddWithValue("@Remark", objUAHModel.Remark);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtUpdAccountHead      = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtUpdAccountHead);
                dtUpdAccountHead.TableName = "success";
            }
            catch (Exception)
            {
                dtUpdAccountHead           = new DataTable();
                dtUpdAccountHead.TableName = "error";
                return(dtUpdAccountHead);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtUpdAccountHead);
        }
Esempio n. 20
0
        internal DataTable SavePurchase(PurchaseModel ObjPurchaseModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPPurchaseVoucherChange";

                ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjPurchaseModel.VchType);
                ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjPurchaseModel.EntryType);
                ClsCon.cmd.Parameters.AddWithValue("@User", ObjPurchaseModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IP", ObjPurchaseModel.IP);
                ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjPurchaseModel.ByCashSale);
                ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjPurchaseModel.PartyName);
                ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjPurchaseModel.PartyGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjPurchaseModel.PartyAddress);
                ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjPurchaseModel.WareHouseID);
                ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjPurchaseModel.PONo);
                ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillNo", ObjPurchaseModel.PurchaseBillNo);
                ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillDate", ObjPurchaseModel.PurchaseBillDate);
                ClsCon.cmd.Parameters.AddWithValue("@GRNNo", ObjPurchaseModel.GRNNo);
                ClsCon.cmd.Parameters.AddWithValue("@DocDate", ObjPurchaseModel.VoucherDate);
                ClsCon.cmd.Parameters.AddWithValue("@CCCode", ObjPurchaseModel.CCCode);
                ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", ObjPurchaseModel.IDARefNo);//ida Ref No.
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageID", ObjPurchaseModel.BrokerageID);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", ObjPurchaseModel.BrokerageRate);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageGSTIN", ObjPurchaseModel.BrokerageGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageAmount", ObjPurchaseModel.BrokerageAmount);
                ClsCon.cmd.Parameters.AddWithValue("@TblPurchase", ObjPurchaseModel.DtPurchase);
                ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseItems", ObjPurchaseModel.DtItems);
                ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseSundries", ObjPurchaseModel.DtSundries);
                ClsCon.cmd.Parameters.AddWithValue("@TblAdvanceDetail", ObjPurchaseModel.DtAdjAdvance);
                ClsCon.cmd.Parameters.AddWithValue("@DeptID", ObjPurchaseModel.DeptID);
                ClsCon.cmd.Parameters.AddWithValue("@SubDeptID", ObjPurchaseModel.SubDeptID);
                ClsCon.cmd.Parameters.AddWithValue("@IsFinal", ObjPurchaseModel.IsFinal);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtPurchase            = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtPurchase);
                dtPurchase.TableName = "success";
            }
            catch (Exception)
            {
                dtPurchase           = new DataTable();
                dtPurchase.TableName = "error";
                return(dtPurchase);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtPurchase);
        }
        internal DataTable UpdateSaleVoucher(UpdateSalesModel ObjSalesModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPUpdateSaleVoucher";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjSalesModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjSalesModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjSalesModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjSalesModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjSalesModel.VchType);
                ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjSalesModel.EntryType);
                ClsCon.cmd.Parameters.AddWithValue("@User", ObjSalesModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IP", ObjSalesModel.IP);


                ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjSalesModel.ByCashSale);
                ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjSalesModel.PartyName);
                ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjSalesModel.PartyGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjSalesModel.PartyAddress);
                ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjSalesModel.WareHouseID);
                ClsCon.cmd.Parameters.AddWithValue("@TransName", ObjSalesModel.TransName);
                ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjSalesModel.PONo);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", ObjSalesModel.InvoiceSeries);

                ClsCon.cmd.Parameters.AddWithValue("@DocNo", ObjSalesModel.DocNo);

                ClsCon.cmd.Parameters.AddWithValue("@TblSale", ObjSalesModel.DtSales);
                ClsCon.cmd.Parameters.AddWithValue("@TblItems", ObjSalesModel.DtItems);
                ClsCon.cmd.Parameters.AddWithValue("@TblSundries", ObjSalesModel.DtSundries);

                ClsCon.cmd.Parameters.AddWithValue("@CCCode", ObjSalesModel.CCCode);

                ClsCon.cmd.Parameters.AddWithValue("@BrokerageID", ObjSalesModel.BrokerageID);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", ObjSalesModel.BrokerageRate);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageGSTIN", ObjSalesModel.BrokerageGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageAmount", ObjSalesModel.BrokerageAmount);


                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtSales   = new DataTable();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtSales);
                dtSales.TableName = "success";
            }
            catch (Exception)
            {
                dtSales           = new DataTable();
                dtSales.TableName = "error";
                return(dtSales);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtSales);
        }
        internal DataTable SaveCashSalesVoucher(CashSaleReturnModel objCashSalesReturnModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SpCashSaleReturnVoucher";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objCashSalesReturnModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objCashSalesReturnModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objCashSalesReturnModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objCashSalesReturnModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", objCashSalesReturnModel.VchType);
                ClsCon.cmd.Parameters.AddWithValue("@EntryType", objCashSalesReturnModel.EntryType);
                ClsCon.cmd.Parameters.AddWithValue("@User", objCashSalesReturnModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IP", objCashSalesReturnModel.IP);

                ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", objCashSalesReturnModel.ByCashSale);
                ClsCon.cmd.Parameters.AddWithValue("@PartyName", objCashSalesReturnModel.PartyName);
                ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", objCashSalesReturnModel.PartyGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", objCashSalesReturnModel.PartyAddress);
                ClsCon.cmd.Parameters.AddWithValue("@PartyMobileNo", objCashSalesReturnModel.PartyMobileNo);
                ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", objCashSalesReturnModel.WareHouseID);
                ClsCon.cmd.Parameters.AddWithValue("@TransName", objCashSalesReturnModel.TransName);
                ClsCon.cmd.Parameters.AddWithValue("@PONo", objCashSalesReturnModel.PONo);
                ClsCon.cmd.Parameters.AddWithValue("@PayMode", objCashSalesReturnModel.PayMode);
                ClsCon.cmd.Parameters.AddWithValue("@PayModeRemark", objCashSalesReturnModel.PayModeRemark);

                ClsCon.cmd.Parameters.AddWithValue("@CCCode", objCashSalesReturnModel.CCCode);

                ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", objCashSalesReturnModel.InvoiceSeries);
                ClsCon.cmd.Parameters.AddWithValue("@PartyState", objCashSalesReturnModel.PartyState);


                //if (objCashSalesReturnModel.ds.Tables["DtCashSales"].Rows.Count > 0)
                //{
                //    ClsCon.cmd.Parameters.AddWithValue("@TblSale", objCashSalesReturnModel.ds.Tables["DtCashSales"]);
                //}

                //if (objCashSalesReturnModel.ds.Tables["DtItems"].Rows.Count > 0)
                //{
                //    ClsCon.cmd.Parameters.AddWithValue("@TblItems", objCashSalesReturnModel.ds.Tables["DtItems"]);
                //}


                //if (objCashSalesReturnModel.ds.Tables["DtSundries"].Rows.Count > 0)
                //{
                //    ClsCon.cmd.Parameters.AddWithValue("@TblSundries", objCashSalesReturnModel.ds.Tables["DtSundries"]);
                //}

                //if (objCashSalesReturnModel.ds.Tables["DtAdjAdvance"].Rows.Count > 0)
                //{
                //    ClsCon.cmd.Parameters.AddWithValue("@TblAdvanceDetail", objCashSalesReturnModel.ds.Tables["DtAdjAdvance"]);
                //}


                ClsCon.cmd.Parameters.AddWithValue("@TblSale", objCashSalesReturnModel.DtCashSales);
                ClsCon.cmd.Parameters.AddWithValue("@TblItems", objCashSalesReturnModel.DtItems);
                ClsCon.cmd.Parameters.AddWithValue("@TblSundries", objCashSalesReturnModel.DtSundries);
                // ClsCon.cmd.Parameters.AddWithValue("@TblAdvanceDetail", objCashSalesReturnModel.DtAdjAdvance);


                ClsCon.cmd.Parameters.AddWithValue("@BrokerageID", objCashSalesReturnModel.BrokerageID);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", objCashSalesReturnModel.BrokerageRate);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageGSTIN", objCashSalesReturnModel.BrokerageGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageAmount", objCashSalesReturnModel.BrokerageAmount);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtCashSalesReturn     = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtCashSalesReturn);
                dtCashSalesReturn.TableName = "success";
            }
            catch (Exception)
            {
                dtCashSalesReturn           = new DataTable();
                dtCashSalesReturn.TableName = "error";
                return(dtCashSalesReturn);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtCashSalesReturn);
        }
Esempio n. 23
0
        internal DataTable SaveSalesVoucher(CompositionSalesModel ObjCompositionSalesModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPSaleVoucher";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjCompositionSalesModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCompositionSalesModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjCompositionSalesModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjCompositionSalesModel.VchType);
                ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjCompositionSalesModel.EntryType);
                ClsCon.cmd.Parameters.AddWithValue("@User", ObjCompositionSalesModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IP", ObjCompositionSalesModel.IP);


                ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjCompositionSalesModel.ByCashSale);
                ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjCompositionSalesModel.PartyName);
                ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjCompositionSalesModel.PartyGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjCompositionSalesModel.PartyAddress);
                ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjCompositionSalesModel.WareHouseID);
                ClsCon.cmd.Parameters.AddWithValue("@TransName", ObjCompositionSalesModel.TransName);
                ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjCompositionSalesModel.PONo);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", ObjCompositionSalesModel.InvoiceSeries);

                //for bank
                ClsCon.cmd.Parameters.AddWithValue("@PartyBank", ObjCompositionSalesModel.PartyBank);
                ClsCon.cmd.Parameters.AddWithValue("@PartyIFSC", ObjCompositionSalesModel.PartyIFSC);


                ClsCon.cmd.Parameters.AddWithValue("@TblSale", ObjCompositionSalesModel.DtSales);
                ClsCon.cmd.Parameters.AddWithValue("@TblItems", ObjCompositionSalesModel.DtItems);
                ClsCon.cmd.Parameters.AddWithValue("@TblSundries", ObjCompositionSalesModel.DtSundries);
                ClsCon.cmd.Parameters.AddWithValue("@TblAdvanceDetail", ObjCompositionSalesModel.DtAdjAdvance);


                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtSales   = new DataTable();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtSales);
                dtSales.TableName = "success";
            }
            catch (Exception)
            {
                dtSales           = new DataTable();
                dtSales.TableName = "error";
                return(dtSales);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtSales);
        }
Esempio n. 24
0
        internal DataTable SaveSalesReturnVoucher(SalesReturnModel objSalesRModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPSalesReturnVoucher";

                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.Parameters.AddWithValue("@Ind", objSalesRModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSalesRModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objSalesRModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSalesRModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", objSalesRModel.VchType);
                ClsCon.cmd.Parameters.AddWithValue("@EntryType", objSalesRModel.EntryType);
                ClsCon.cmd.Parameters.AddWithValue("@User", objSalesRModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IP", objSalesRModel.IP);


                ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", objSalesRModel.ByCashSale);
                ClsCon.cmd.Parameters.AddWithValue("@PartyName", objSalesRModel.PartyName);
                ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", objSalesRModel.PartyGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", objSalesRModel.PartyAddress);
                ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", objSalesRModel.WareHouseID);
                ClsCon.cmd.Parameters.AddWithValue("@TransName", objSalesRModel.TransName);
                ClsCon.cmd.Parameters.AddWithValue("@PONo", objSalesRModel.PONo);
                ClsCon.cmd.Parameters.AddWithValue("@DocDate", objSalesRModel.DocDate);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", objSalesRModel.InvoiceSeries);

                ClsCon.cmd.Parameters.AddWithValue("@CCCode", objSalesRModel.CCCode);


                ClsCon.cmd.Parameters.AddWithValue("@OrgVoucherNo", objSalesRModel.OrgVoucherNo);
                ClsCon.cmd.Parameters.AddWithValue("@OrgVoucherDate", objSalesRModel.OrgVoucherDate);


                //ClsCon.cmd.Parameters.AddWithValue("@TblSale", JsonConvert.DeserializeObject<DataTable>(objSalesRModel.DtSales));
                //ClsCon.cmd.Parameters.AddWithValue("@TblItems", JsonConvert.DeserializeObject<DataTable>(objSalesRModel.DtItems));
                //ClsCon.cmd.Parameters.AddWithValue("@TblSundries", JsonConvert.DeserializeObject<DataTable>(objSalesRModel.DtSundries));

                ClsCon.cmd.Parameters.AddWithValue("@TblSale", objSalesRModel.DtSales);
                ClsCon.cmd.Parameters.AddWithValue("@TblItems", objSalesRModel.DtItems);
                ClsCon.cmd.Parameters.AddWithValue("@TblSundries", objSalesRModel.DtSundries);


                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtSalesReturn         = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtSalesReturn);
                dtSalesReturn.TableName = "success";
            }
            catch (Exception)
            {
                dtSalesReturn           = new DataTable();
                dtSalesReturn.TableName = "error";
                return(dtSalesReturn);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtSalesReturn);
        }
Esempio n. 25
0
        internal DataTable UpdatePV(UpdatePurchaseVoucherModel objUpdPVModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPUpdatePurchaseVoucher";

                ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdPVModel.YrCD);
                ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdPVModel.VchType);
                ClsCon.cmd.Parameters.AddWithValue("@EntryType", objUpdPVModel.EntryType);
                ClsCon.cmd.Parameters.AddWithValue("@User", objUpdPVModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IP", objUpdPVModel.IP);

                ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", objUpdPVModel.ByCashSale);
                ClsCon.cmd.Parameters.AddWithValue("@PartyName", objUpdPVModel.PartyName);
                ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", objUpdPVModel.PartyGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", objUpdPVModel.PartyAddress);
                ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", objUpdPVModel.WareHouseID);
                ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUpdPVModel.AccCode);
                ClsCon.cmd.Parameters.AddWithValue("@PONo", objUpdPVModel.PONo);
                ClsCon.cmd.Parameters.AddWithValue("@PODate", objUpdPVModel.PODate);
                ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillNo", objUpdPVModel.PurchaseBillNo);
                ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillDate", objUpdPVModel.PurchaseBillDate);
                ClsCon.cmd.Parameters.AddWithValue("@GRNNo", objUpdPVModel.GRNNo);
                ClsCon.cmd.Parameters.AddWithValue("@GRNDate", objUpdPVModel.GRNDate);
                ClsCon.cmd.Parameters.AddWithValue("@PurchaseSaleRecordID", objUpdPVModel.PurchaseSaleRecordID);
                ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdPVModel.VoucherNo);
                ClsCon.cmd.Parameters.AddWithValue("@DocDate", objUpdPVModel.VoucherDate);
                ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdPVModel.CCCode);
                ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", objUpdPVModel.IDARefNo);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageID", objUpdPVModel.BrokerageID);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", objUpdPVModel.BrokerageRate);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageGSTIN", objUpdPVModel.BrokerageGSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@BrokerageAmount", objUpdPVModel.BrokerageAmount);
                ClsCon.cmd.Parameters.AddWithValue("@DeptID", objUpdPVModel.DeptID);
                ClsCon.cmd.Parameters.AddWithValue("@SubDeptID", objUpdPVModel.SubDeptID);
                ClsCon.cmd.Parameters.AddWithValue("@IsAudit", objUpdPVModel.IsAudit);
                ClsCon.cmd.Parameters.AddWithValue("@IsSendToAudit", objUpdPVModel.IsSendToAudit);
                ClsCon.cmd.Parameters.AddWithValue("@BankPayVoucherInd", objUpdPVModel.BankPayVoucherInd);

                ClsCon.cmd.Parameters.AddWithValue("@TblPurchase", objUpdPVModel.DtUpdPurchase);
                ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseItems", objUpdPVModel.DtUpdItems);
                ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseSundries", objUpdPVModel.DtUpdSundries);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtUpdPV   = new DataTable();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtUpdPV);
                dtUpdPV.TableName = "success";
            }
            catch (Exception)
            {
                dtUpdPV           = new DataTable();
                dtUpdPV.TableName = "error";
                return(dtUpdPV);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtUpdPV);
        }
Esempio n. 26
0
        internal DataTable UpdateCompanyProfile(UpdateProfileCreationModel objUPCModel)
        {
            try
            {
                ClsCon.cmd             = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPUpdateClientProfile";

                ClsCon.cmd.Parameters.AddWithValue("@Ind", objUPCModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@CompanyID", objUPCModel.CompanyID);
                ClsCon.cmd.Parameters.AddWithValue("@CompName", objUPCModel.CompName);
                ClsCon.cmd.Parameters.AddWithValue("@ShortName", objUPCModel.ShortName);
                ClsCon.cmd.Parameters.AddWithValue("@OrgType", objUPCModel.OrgType);
                ClsCon.cmd.Parameters.AddWithValue("@BusiNature", objUPCModel.BusiNature);
                ClsCon.cmd.Parameters.AddWithValue("@BusiType", objUPCModel.BusiType);
                ClsCon.cmd.Parameters.AddWithValue("@Addr", objUPCModel.Addr);
                ClsCon.cmd.Parameters.AddWithValue("@City", objUPCModel.City);
                ClsCon.cmd.Parameters.AddWithValue("@State", objUPCModel.State);
                ClsCon.cmd.Parameters.AddWithValue("@Pin", objUPCModel.Pin);

                ClsCon.cmd.Parameters.AddWithValue("@Phone", objUPCModel.Phone);
                ClsCon.cmd.Parameters.AddWithValue("@Fax", objUPCModel.Fax);
                ClsCon.cmd.Parameters.AddWithValue("@EMail", objUPCModel.EMail);
                ClsCon.cmd.Parameters.AddWithValue("@PAN", objUPCModel.PAN);
                ClsCon.cmd.Parameters.AddWithValue("@TAN", objUPCModel.TAN);
                ClsCon.cmd.Parameters.AddWithValue("@CIN", objUPCModel.CIN);
                ClsCon.cmd.Parameters.AddWithValue("@IECode", objUPCModel.IECode);
                ClsCon.cmd.Parameters.AddWithValue("@ExportCtg", objUPCModel.ExportCtg);
                ClsCon.cmd.Parameters.AddWithValue("@ContactName", objUPCModel.ContactName);
                ClsCon.cmd.Parameters.AddWithValue("@ContactDesg", objUPCModel.ContactDesg);

                ClsCon.cmd.Parameters.AddWithValue("@ContactEmail", objUPCModel.ContactEmail);
                ClsCon.cmd.Parameters.AddWithValue("@ContactMobile", objUPCModel.ContactMobile);
                ClsCon.cmd.Parameters.AddWithValue("@AltPerson", objUPCModel.AltPerson);
                ClsCon.cmd.Parameters.AddWithValue("@AltPersonDesg", objUPCModel.AltPersonDesg);
                ClsCon.cmd.Parameters.AddWithValue("@AltPersonEmail", objUPCModel.AltPersonEmail);
                ClsCon.cmd.Parameters.AddWithValue("@AltMobile", objUPCModel.AltMobile);
                ClsCon.cmd.Parameters.AddWithValue("@Composition", objUPCModel.Composition);
                ClsCon.cmd.Parameters.AddWithValue("@CompositionDate", objUPCModel.CompositionDate);
                ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUPCModel.GSTIN);
                ClsCon.cmd.Parameters.AddWithValue("@RegDate", objUPCModel.RegDate);

                ClsCon.cmd.Parameters.AddWithValue("@RegAddr", objUPCModel.RegAddr);
                ClsCon.cmd.Parameters.AddWithValue("@RegCity", objUPCModel.RegCity);
                ClsCon.cmd.Parameters.AddWithValue("@RegState", objUPCModel.RegState);
                ClsCon.cmd.Parameters.AddWithValue("@RegPin", objUPCModel.RegPin);
                ClsCon.cmd.Parameters.AddWithValue("@RegAuthPerson", objUPCModel.RegAuthPerson);
                ClsCon.cmd.Parameters.AddWithValue("@RegAuthDesg", objUPCModel.RegAuthDesg);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceNoSeries", objUPCModel.InvoiceNoSeries);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceOnPrePrinted", objUPCModel.InvoiceOnPrePrinted);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceNo", objUPCModel.InvoiceNo);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUPCModel.YrCD);

                ClsCon.cmd.Parameters.AddWithValue("@User", objUPCModel.User);
                ClsCon.cmd.Parameters.AddWithValue("@IP", objUPCModel.IP);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCaption1", objUPCModel.InvoiceCaption1);
                ClsCon.cmd.Parameters.AddWithValue("@InvoicePrint1", objUPCModel.InvoicePrint1);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCaption2", objUPCModel.InvoiceCaption2);
                ClsCon.cmd.Parameters.AddWithValue("@InvoicePrint2", objUPCModel.InvoicePrint2);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCaption3", objUPCModel.InvoiceCaption3);
                ClsCon.cmd.Parameters.AddWithValue("@InvoicePrint3", objUPCModel.InvoicePrint3);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCaption4", objUPCModel.InvoiceCaption4);
                ClsCon.cmd.Parameters.AddWithValue("@InvoicePrint4", objUPCModel.InvoicePrint4);

                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCaption5", objUPCModel.InvoiceCaption5);
                ClsCon.cmd.Parameters.AddWithValue("@InvoicePrint5", objUPCModel.InvoicePrint5);
                ClsCon.cmd.Parameters.AddWithValue("@CompanyLogo", objUPCModel.CompanyLogo);
                ClsCon.cmd.Parameters.AddWithValue("@ReportFormat", objUPCModel.ReportFormat);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCopyNo", objUPCModel.InvoiceCopyNo);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCopy1Header", objUPCModel.InvoiceCopy1Header);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCopy2Header", objUPCModel.InvoiceCopy2Header);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCopy3Header", objUPCModel.InvoiceCopy3Header);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCopy4Header", objUPCModel.InvoiceCopy4Header);
                ClsCon.cmd.Parameters.AddWithValue("@InvoiceCopy5Header", objUPCModel.InvoiceCopy5Header);

                ClsCon.cmd.Parameters.AddWithValue("@CompositionCategoryID", objUPCModel.CompositionCategoryID);
                ClsCon.cmd.Parameters.AddWithValue("@CompositionTaxRate", objUPCModel.CompositionTaxRate);
                ClsCon.cmd.Parameters.AddWithValue("@StcokMaintaneByMinorUnit", objUPCModel.StcokMaintaneByMinorUnit);
                ClsCon.cmd.Parameters.AddWithValue("@CompanyType", objUPCModel.CompanyType);
                ClsCon.cmd.Parameters.AddWithValue("@TurnoverID", objUPCModel.TurnoverID);
                ClsCon.cmd.Parameters.AddWithValue("@TurnoverDescription", objUPCModel.TurnoverDescription);
                ClsCon.cmd.Parameters.AddWithValue("@PrintHSNSACCode", objUPCModel.PrintHSNSACCode);
                ClsCon.cmd.Parameters.AddWithValue("@BankName", objUPCModel.BankName);
                ClsCon.cmd.Parameters.AddWithValue("@IFSCCode", objUPCModel.IFSCCode);
                ClsCon.cmd.Parameters.AddWithValue("@AccountNumber", objUPCModel.AccountNumber);

                ClsCon.cmd.Parameters.AddWithValue("@ColumnNumber", objUPCModel.ColumnNumber);
                ClsCon.cmd.Parameters.AddWithValue("@HeadingColumn1", objUPCModel.HeadingColumn1);
                ClsCon.cmd.Parameters.AddWithValue("@HeadingColumn2", objUPCModel.HeadingColumn2);
                ClsCon.cmd.Parameters.AddWithValue("@HeadingColumn3", objUPCModel.HeadingColumn3);
                ClsCon.cmd.Parameters.AddWithValue("@HeadingColumn4", objUPCModel.HeadingColumn4);
                ClsCon.cmd.Parameters.AddWithValue("@HeadingColumn5", objUPCModel.HeadingColumn5);
                ClsCon.cmd.Parameters.AddWithValue("@BudgetAmount", objUPCModel.BudgetAmount);
                ClsCon.cmd.Parameters.AddWithValue("@UnRegistered", objUPCModel.UnRegistered);
                ClsCon.cmd.Parameters.AddWithValue("@SSIsTaken", objUPCModel.SSIsTaken);
                ClsCon.cmd.Parameters.AddWithValue("@BSObtain", objUPCModel.BSObtain);
                ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUPCModel.CCCode);
                ClsCon.cmd.Parameters.AddWithValue("@BudgetConcept", objUPCModel.BudgetConcept);
                ClsCon.cmd.Parameters.AddWithValue("@BankPayChqSeriesInd", objUPCModel.BankPayChqSeriesInd);
                ClsCon.cmd.Parameters.AddWithValue("@TblTerms", objUPCModel.DtTerms);
                ClsCon.cmd.Parameters.AddWithValue("@TblSeries", objUPCModel.DtSeries);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtUpdProfileCreation  = new DataTable();
                ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtUpdProfileCreation);
                dtUpdProfileCreation.TableName = "success";
            }
            catch (Exception)
            {
                dtUpdProfileCreation           = new DataTable();
                dtUpdProfileCreation.TableName = "error";
                return(dtUpdProfileCreation);
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return(dtUpdProfileCreation);
        }
Esempio n. 27
0
        /// <summary>
        /// 读取菜单中的信息.
        /// </summary>
        /// <param name="treeV">TreeView控件</param>
        public void frm_show(int n)
        {
            switch (n)//通过标识调用各子窗体
            {
            case 0: break;

            case 1:
            {
                frmPeopleInfo fp = new frmPeopleInfo(); //实例化一个frmPeopleInfo窗体
                fp.strID = "want";                      //设置窗体中的公共变量
                fp.Text  = "求租人员信息";                    //设置窗体的名称
                fp.ShowDialog();                        //用模试对话框打开窗体
                fp.Dispose();                           //释放窗体的所有资原
                break;
            }

            case 2:
            {
                frmPeopleInfo fp = new frmPeopleInfo();
                fp.strID = "lend";
                fp.Text  = "出租人员信息设置";
                fp.ShowDialog();
                fp.Dispose();
                break;
            }

            case 3:
            {
                frmPeopleList fp = new frmPeopleList();
                fp.ShowDialog();
                fp.Dispose();
                break;
            }

            case 4:
            {
                frmSelect fs = new frmSelect();
                fs.ShowDialog();
                fs.Dispose();
                break;
            }

            case 5:
            {
                frmStateHouse fs = new frmStateHouse();
                fs.ShowDialog();
                fs.Dispose();
                break;
            }

            case 6:
            {
                frmIntend fi = new frmIntend();
                fi.ShowDialog();
                fi.Dispose();
                break;
            }

            case 7:
            {
                frmEmploeey fe = new frmEmploeey();
                fe.ShowDialog();
                fe.Dispose();
                break;
            }

            case 8:
            {
                frmEmpleeyAll fe = new frmEmpleeyAll();
                fe.ShowDialog();
                fe.Dispose();
                break;
            }

            case 9:
            {
                frmType ft = new frmType();
                ft.ShowDialog();
                ft.Dispose();
                break;
            }

            case 10:
            {
                frmFloor ff = new frmFloor();
                ff.ShowDialog();
                ff.Dispose();
                break;
            }

            case 11:
            {
                frmSeat fs = new frmSeat();
                fs.ShowDialog();
                fs.Dispose();
                break;
            }

            case 12:
            {
                frmFitment ff = new frmFitment();
                ff.ShowDialog();
                ff.Dispose();
                break;
            }

            case 13:
            {
                frmFavor ff = new frmFavor();
                ff.ShowDialog();
                ff.Dispose();
                break;
            }

            case 14:
            {
                frmMothed fm = new frmMothed();
                fm.ShowDialog();
                fm.Dispose();
                break;
            }

            case 15:
            {
                frmMoney fm = new frmMoney();
                fm.ShowDialog();
                fm.Dispose();
                break;
            }

            case 16:
            {
                frmMoneyRemark fmr = new frmMoneyRemark();
                fmr.ShowDialog();
                fmr.Dispose();
                break;
            }

            case 17:
            {
                frmBargin fb = new frmBargin();
                fb.ShowDialog();
                fb.Dispose();
                break;
            }

            case 21:
            {
                //打开记事本
                System.Diagnostics.Process.Start("notepad.exe");
                break;
            }

            case 22:
            {
                //打开计算器
                System.Diagnostics.Process.Start("calc.exe");
                break;
            }

            case 23:
            {
                //打开WORD文档
                System.Diagnostics.Process.Start("WINWORD.EXE");
                break;
            }

            case 24:
            {
                //打开EXCEL文件
                System.Diagnostics.Process.Start("EXCEL.EXE");
                break;
            }

            case 25:
            {
                frmChangYouSelfPwd fcy = new frmChangYouSelfPwd();
                fcy.M_str_Name = this.tspname.Text.ToString();
                fcy.ShowDialog();
                fcy.Dispose();
                break;
            }

            case 26:
            {
                if (MessageBox.Show("确认退出系统吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    Application.Exit();        //关闭当前工程
                }
                break;
            }

            case 27:
            {
                frmStock fs = new frmStock();
                fs.ShowDialog();
                fs.Dispose();
                break;
            }

            case 28:
            {
                frmRestore fr = new frmRestore();
                fr.ShowDialog();
                fr.Dispose();
                break;
            }

            case 29:
            {
                ClsCon con = new ClsCon(); //实例化一个ClsCon公共类
                con.ConDatabase();         //连接数据库
                //调用一个清理出租人和房源之间的垃极信息
                //如当出租人来要出租房时可是没有给出他房源信息这时出租人信息就没有用了
                try
                {
                    SqlCommand cmd = new SqlCommand(); //实例化一个SqlCommand类
                    cmd.Connection = con.conn;         //与数据库建立关系统
                    cmd.Connection.Open();             //打开数据库的连接
                    cmd.CommandText = "proc_clear";    //存储过程的名
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.ExecuteNonQuery();             //执行存储过程
                    con.closeCon();                    //关闭数据库的连接
                    MessageBox.Show("恭喜已清除!!!");
                }
                catch (Exception ey)
                {
                    MessageBox.Show(ey.Message);
                }
                break;
            }

            case 30:
            {
                //打开帮助对话框
                MessageBox.Show("\t你可以到明日科技网站\t\n\n\t  得到你想知道的\n\t    谢谢使用!!");
                break;
            }
            }
        }
        internal DataTable SaveBudgetAmount(NewBudgetAmountModel ObjNewBudgetAmountModel)
        {
            try
            {
                ClsCon.cmd = new SqlCommand();
                ClsCon.cmd.CommandType = CommandType.StoredProcedure;
                ClsCon.cmd.CommandText = "SPBudgetAmount";
                ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjNewBudgetAmountModel.Ind);
                ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjNewBudgetAmountModel.OrgID);
                ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjNewBudgetAmountModel.BrID);
                ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjNewBudgetAmountModel.YrCode);
                ClsCon.cmd.Parameters.AddWithValue("@SectionCD", ObjNewBudgetAmountModel.SectionCD);
                ClsCon.cmd.Parameters.AddWithValue("@SubSectionCD", ObjNewBudgetAmountModel.SubSectionCD);
                ClsCon.cmd.Parameters.AddWithValue("@BudgetHeadCD", ObjNewBudgetAmountModel.BudgetHeadCD);
                ClsCon.cmd.Parameters.AddWithValue("@SecCode", ObjNewBudgetAmountModel.SecCode);

                ClsCon.cmd.Parameters.AddWithValue("@ActualUptoBudgetAmtDr", ObjNewBudgetAmountModel.ActualUptoBudgetAmtDr);
                ClsCon.cmd.Parameters.AddWithValue("@ActualUptoBudgetAmtCr ", ObjNewBudgetAmountModel.ActualUptoBudgetAmtCr);

                ClsCon.cmd.Parameters.AddWithValue("@Prop2BudgetAmtDr", ObjNewBudgetAmountModel.Prop2BudgetAmtDr);
                ClsCon.cmd.Parameters.AddWithValue("@Prop2BudgetAmtCr", ObjNewBudgetAmountModel.Prop2BudgetAmtCr);

                ClsCon.cmd.Parameters.AddWithValue("@Sanc2BudgetAmtDr", ObjNewBudgetAmountModel.Sanc2BudgetAmtDr);
                ClsCon.cmd.Parameters.AddWithValue("@Sanc2BudgetAmtCr", ObjNewBudgetAmountModel.Sanc2BudgetAmtCr);

                ClsCon.cmd.Parameters.AddWithValue("@PropLastQtrBudgetAmtDr", ObjNewBudgetAmountModel.PropLastQtrBudgetAmtDr);
                ClsCon.cmd.Parameters.AddWithValue("@PropLastQtrBudgetAmtCr", ObjNewBudgetAmountModel.PropLastQtrBudgetAmtCr);

                ClsCon.cmd.Parameters.AddWithValue("@PropBudgetAmtDr", ObjNewBudgetAmountModel.PropBudgetAmtDr);
                ClsCon.cmd.Parameters.AddWithValue("@PropBudgetAmtCr", ObjNewBudgetAmountModel.PropBudgetAmtCr);

                ClsCon.cmd.Parameters.AddWithValue("@PropBudgetCapitalAmtCr", ObjNewBudgetAmountModel.PropBudgetCapitalAmtCr);
                ClsCon.cmd.Parameters.AddWithValue("@PropBudgetCapitalAmtDr", ObjNewBudgetAmountModel.PropBudgetCapitalAmtDr);

                ClsCon.cmd.Parameters.AddWithValue("@PropBudgetRevenueAmtCr", ObjNewBudgetAmountModel.PropBudgetRevenueAmtCr);
                ClsCon.cmd.Parameters.AddWithValue("@PropBudgetRevenueAmtDr", ObjNewBudgetAmountModel.PropBudgetRevenueAmtDr);

                ClsCon.cmd.Parameters.AddWithValue("@UserID", ObjNewBudgetAmountModel.UserID);
                ClsCon.cmd.Parameters.AddWithValue("@IPAddr", ObjNewBudgetAmountModel.IP);

                con = ClsCon.SqlConn();
                ClsCon.cmd.Connection = con;
                dtBudgetAmount = new DataTable();
                ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
                ClsCon.da.Fill(dtBudgetAmount);
                dtBudgetAmount.TableName = "success";
            }
            catch (Exception)
            {
                dtBudgetAmount = new DataTable();
                dtBudgetAmount.TableName = "error";
                return dtBudgetAmount;
            }
            finally
            {
                con.Close();
                con.Dispose();
                ClsCon.da.Dispose();
                ClsCon.cmd.Dispose();
            }
            return dtBudgetAmount;
        }