finsubject.cs

财务凭证管理系统主要由【系统管理】、【凭证管理】、【科目信息】、【账目查询】和【报表】等模块组成。进入该系统后

using System;
using System.Collections.Generic;
using System.Text;
using property.model.GetConnection;
using property.model.SubjectInfo;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace property.control.Subject
{
    class FinSubject
    {
        SqlCommand cmd = null;
        SqlConnection con = null;
        GetConnection getcon = new GetConnection();
        SubInfo info = new SubInfo();
        DataSet ds = new DataSet();
        public string P_str_select;
        public string P_str_dr;
        #region //条件查找
        public string GetFindSubject(SubInfo info, string P_str_subject, object DatGrid)
        {
            string P_str_result=null;
          
            try { 
                    switch(P_str_subject)
                    {
                        case "科目编号":
                            P_str_select="select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subPage 总账页码 from tb_subjectInfo where subId='"+info.getsubId()+"'";
                             P_str_dr = "select count(*) from tb_subjectInfo  where subId='" + info.getsubId() + "'";
                            break;
                        case"科目名称":
                             P_str_select="select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subPage 总账页码 from tb_subjectInfo where subName='"+info.getsubName()+"'";
                             P_str_dr = "select count(*) from tb_subjectInfo where subName='" + info.getsubName() + "'";
                            break;
                        case"科目简拼":
                              P_str_select="select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subPage 总账页码 from tb_subjectInfo where subGkb='"+info.getsubGkb()+"'";
                              P_str_dr = "select count(*) from tb_subjectInfo where subGkb='" + info.getsubGkb() + "'";
                            break;
                        case"全部浏览":
                            P_str_select = "select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subPage 总账页码 from tb_subjectInfo";
                            P_str_dr = "select count(*) from tb_subjectInfo ";
                            break;
                    }// end block switch
                
                    con=getcon.GetCon();
                    cmd =new SqlCommand();
                    cmd.CommandText = P_str_dr;
                    cmd.Connection=con;
                    int P_int_suID=(int)cmd.ExecuteScalar();
                    cmd.Connection.Close();
                    con.Close();
                    if (P_int_suID!= 0)
                    {
                          con = getcon.GetCon();
                          SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
                           da.Fill(ds, "tb_subjectInfo");
                             if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
                             {
                                 DataGridView dg = (DataGridView)DatGrid;
                                 dg.DataSource = ds.Tables[0].DefaultView;
                             } // end block   
                          P_str_result="OK";
                    
                    }// end block 
                    else
                    { P_str_result="NO";}// end block 
            
                    return  P_str_result;
            
            }catch(Exception e)
            {
                P_str_result = "Error";

                return P_str_result;
            }
        }// end block GetFindSubject(SubInfo info)
        #endregion
        #region  //查找用于查找打印
        public string GetFindSujbectMoney(SubInfo info, string P_str_subject, object DatGrid)
        {

            string P_str_result = null;

            try
            {
                switch (P_str_subject)
                {
                    case "科目编号":
                        P_str_select = "select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subMoney as 原始资金,subPage 总账页码 from tb_subjectInfo where subId='" + info.getsubId() + "'";
                        P_str_dr = "select count(*) from tb_subjectInfo  where subId='" + info.getsubId() + "'";
                        break;
                    case "科目名称":
                        P_str_select = "select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subMoney as 原始资金,subPage 总账页码 from tb_subjectInfo where subName='" + info.getsubName() + "'";
                        P_str_dr = "select count(*) from tb_subjectInfo where subName='" + info.getsubName() + "'";
                        break;

                    case "全部浏览":
                        P_str_select = "select subId as 科目编号,subGkb as 拼音简码,subName as 科目名称,subMoney as 原始资金,subPage 总账页码 from tb_subjectInfo";
                        P_str_dr = "select count(*) from tb_subjectInfo ";
                        break;
                }// end block switch

                con = getcon.GetCon();
                cmd = new SqlCommand();
                cmd.CommandText = P_str_dr;
                cmd.Connection = con;
                int P_int_suID = (int)cmd.ExecuteScalar();
                cmd.Connection.Close();
                con.Close();
                if (P_int_suID != 0)
                {
                    con = getcon.GetCon();
                    SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
                    da.Fill(ds, "tb_subjectInfo");
                    if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
                    {
                        DataGridView dg = (DataGridView)DatGrid;
                        dg.DataSource = ds.Tables[0].DefaultView;
                    } // end block   
                    P_str_result = "OK";

                }// end block 
                else
                { P_str_result = "NO"; }// end block 

                return P_str_result;

            }
            catch (Exception e)
            {
                P_str_result = "Error";

                return P_str_result;
            }
            
        
        
        
        }// end block 
        #endregion
        #region 总账查询
        public string GetsubjectZhangmu(int P_int_subid, object DatGrid,string str_table)
        {
            string P_str_result = null;
            string p_str_info = str_table;
            try
            {
                if (p_str_info == "subjectId")
                {
                    P_str_dr = "select count(*) from tb_warrantInfo where subId='" + P_int_subid + "'";
                }// end if 
                if (p_str_info == "warrId")
                {
                    P_str_dr = "select count(*) from tb_warrantInfo where warrantId ='" + P_int_subid + "'";
                }
               
                con = getcon.GetCon();
                cmd = new SqlCommand();
                cmd.CommandText = P_str_dr;
                cmd.Connection = con;
                int P_int_suID = (int)cmd.ExecuteScalar();
                cmd.Connection.Close();
                con.Close();
                if (P_int_suID != 0)
                {
                    con = getcon.GetCon();
                    
                    //select a.subid as 科目编号,a.subName as 科目名称 ,a.subMoney as 初期余额,b.subLendmoney as 借方金额  ,b.subGoodsMoney as 贷方金额 ,b.warrantDate  as 凭证日期,b.subRemark as 备注,((a.subMoney+b.subLendmoney)-b.subGoodsMoney)as 资金余额 from tb_subjectInfo a,tb_warrantInfo b where (a.subId=b.subid and b.subRemark is not null) 
                    if (p_str_info == "subjectId")
                    {
                        P_str_select = "select a.subid as 科目编号,a.subName as 科目名称 ,a.subMoney as 初期余额,b.subLendmoney as 借方金额  ,b.subGoodsMoney as 贷方金额 ,b.warrantDate  as 凭证日期,b.subRemark as 备注,((a.subMoney+b.subLendmoney)-b.subGoodsMoney)as 资金余额 from tb_subjectInfo a,tb_warrantInfo b where (a.subId=b.subid and b.subRemark is not null) and a.subId='" + P_int_subid + "'";
                    }// end if 
                    if (p_str_info == "warrId")
                    {
                        P_str_select = "select a.subid as 科目编号,a.subName as 科目名称 ,a.subMoney as 初期余额,b.subLendmoney as 借方金额  ,b.subGoodsMoney as 贷方金额 ,b.warrantDate  as 凭证日期,b.subRemark as 备注,((a.subMoney+b.subLendmoney)-b.subGoodsMoney)as 资金余额 from tb_subjectInfo a,tb_warrantInfo b where (a.subId=b.subid and b.subRemark is not null) and b.warrantId='" + P_int_subid + "'";
                    }
                    if (p_str_info == "One")
                    {
                        P_str_select = "select a.subid as 科目编号,a.subName as 科目名称 ,a.subMoney as 初期余额,b.subLendmoney as 借方金额  ,b.subGoodsMoney as 贷方金额 ,b.warrantDate  as 凭证日期,b.subRemark as 备注,((a.subMoney+b.subLendmoney)-b.subGoodsMoney)as 资金余额 from tb_subjectInfo a,tb_warrantInfo b where a.subId=b.subid and b.subRemark is not null";
                    }
                    SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
                    da.Fill(ds, "tb_subjectInfo");
                    if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
                    {
                        DataGridView dg = (DataGridView)DatGrid;
                        dg.DataSource = ds.Tables[0].DefaultView;
                    } // end block   
                    P_str_result = "OK";

                }// end block 
                else
                { P_str_result = "NO"; }// end block 

                return P_str_result;

            }
            catch (Exception e)
            {
                P_str_result = "Error";

                return P_str_result;
            }
            
        
        
        }
        #endregion
        #region
        public string GetsubjectZhangmu( object DatGrid)
        {
            string P_str_result = null;

            try
            {
                P_str_dr = "select count(*) from tb_warrantInfo";
                con = getcon.GetCon();
                cmd = new SqlCommand();
                cmd.CommandText = P_str_dr;
                cmd.Connection = con;
                int P_int_suID = (int)cmd.ExecuteScalar();
                cmd.Connection.Close();
                con.Close();
                if (P_int_suID != 0)
                {
                    con = getcon.GetCon();
                    P_str_select = "select a.subid as 科目编号,a.subName as 科目名称 ,a.subMoney as 初期余额,b.subLendmoney as 借方金额  ,b.subGoodsMoney as 贷方金额 ,b.warrantDate  as 凭证日期,b.subRemark as 备注,((a.subMoney+b.subLendmoney)-b.subGoodsMoney)as 资金余额 from tb_subjectInfo a,tb_warrantInfo b where (a.subId=b.subid and b.subRemark is not null)";
                    SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
                    da.Fill(ds, "tb_subjectInfo");
                    if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
                    {
                        DataGridView dg = (DataGridView)DatGrid;
                        dg.DataSource = ds.Tables[0].DefaultView;
                    } // end block   
                    this.con.Close();
                    cmd.Connection.Close();
                    P_str_result = "OK";

                }// end block 
                else
                {
                    con = getcon.GetCon();
                    P_str_select = "select a.subid as 科目编号,a.subName as 科目名称 ,a.subMoney as 初期余额,b.subLendmoney as 借方金额  ,b.subGoodsMoney as 贷方金额 ,b.warrantDate  as 凭证日期,b.subRemark as 备注,((a.subMoney+b.subLendmoney)-b.subGoodsMoney)as 资金余额 from tb_subjectInfo a,tb_warrantInfo b where a.subid=b.subid";
                    SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
                    da.Fill(ds, "tb_subjectInfo");
                    if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
                    {
                        DataGridView dg = (DataGridView)DatGrid;
                        dg.DataSource = ds.Tables[0].DefaultView;
                    } // end block   
                    this.con.Close();
                    cmd.Connection.Close();
                    P_str_result = "NO";
                }// end block 

                return P_str_result;

            }
            catch (Exception e)
            {
                P_str_result = "Error";

                return P_str_result;
            }// end block cacth  
        }
        #endregion
        public string GetsubjectZhangmu(object DatGrid,string b)
        {
            string P_str_result = null;
    
            try
            {
                P_str_dr = "select count(*) from V_money";
                con = getcon.GetCon();
                cmd = new SqlCommand();
                cmd.CommandText = P_str_dr;
                cmd.Connection = con;
                int P_int_suID = (int)cmd.ExecuteScalar();
                cmd.Connection.Close();
                con.Close();
                if (P_int_suID != 0)
                {
                    con = getcon.GetCon();
                    P_str_select = "select subid as 科目编号,subName as 科目名称 ,subMoney as 初期余额,subLendmoney as 借方金额  ,subRemark as 备注,subGoodsMoney as 贷方金额 ,Expr1 as 资金余额 from V_money";
                    SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
                    da.Fill(ds, "tb_subjectInfo");
                    if (DatGrid.GetType().ToString() == "System.Windows.Forms.DataGridView")
                    {
                        DataGridView dg = (DataGridView)DatGrid;
                        dg.DataSource = ds.Tables[0].DefaultView;
                    } // end block   
                    P_str_result = "OK"; 
                }// end block 
                else
                { P_str_result = "NO"; }// end block 

                return P_str_result;

            }
            catch (Exception e)
            {
                P_str_result = "Error";

                return P_str_result;
            }// end block if 
        }
        public DataSet GetFindSujbectMoney()
        {
            string P_str_select = null;
            con = getcon.GetCon();
             P_str_select = "select * from V_money";
            SqlDataAdapter da = new SqlDataAdapter(P_str_select, con);
            da.Fill(ds, "tb_subjectInfo");
            return ds; 
        }// end block 
    }// end block lass FinSubject
}