if (P_int_inst == 1)
                {
                    P_str_result = "deleteOk"; 
                }// end block if 
                else
                {
                    P_str_result = "deleteNO";
                }// end blcok if 
                cmd.Connection.Close();
                con.Close();
                return P_str_result;
            }// end block try
            catch (Exception e)
            {
                P_str_result = "deleteError";
                return P_str_result;
            }// end blokc catch
        
        
        }// ened block 
        #endregion
        #region//幫定DataGridView 控件 public void GetDatGridView(object Dataview)
        public void GetDatGridView(object Dataview)
        {
            if (Dataview.GetType().ToString() == "System.Windows.Forms.DataGridView")
            {
                DataGridView ve = (DataGridView)Dataview;
                ve.DataSource = this.GetWarrSet().Tables[0].DefaultView;
            }//
        
        }// end block if 
        #endregion
        #region//返DataSet 數據集 public DataSet GetWarrSet()
        public DataSet GetWarrSet()//用于查找沒有審察的記錄
        {
            con = getcon.GetCon();
            SqlDataAdapter da = new SqlDataAdapter("select b.warrantId as 憑證編號,a.subName as 科目名稱,b.warrantDate as 憑證日期 ,b.subLendmoney as 借方金額 ,b.subGoodsMoney  as 貸方金額  ,b.subEquation as 平衡關系 ,b.subRemark as 備注 from tb_subjectInfo a,tb_warrantInfo b where a.subId=b.subid and subEquation is null and (subLendmoney=0 or subGoodsMoney=0)", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "tb_warrantInfo");
            return ds;
        }// end block 
        #endregion
        #region//單條審察通過  public string GetShengwarr(int WarrID)
        public string GetShengwarr(int WarrID)
        {
            string P_str_result = null;
            try
            {
                con = getcon.GetCon();
                cmd = new SqlCommand();
                string P_str_update = "update tb_warrantInfo set subEquation='審核已通過' where  warrantId in(select warrantId from tb_warrantInfo where subEquation is null and (subLendmoney=0 or subGoodsMoney=0))and warrantId='" + WarrID + "'";
                cmd.CommandText = P_str_update;
                cmd.Connection = con;
                int P_int_inst = cmd.ExecuteNonQuery();
                if (P_int_inst == 1)
                {
                    P_str_result = "updateOk"; 
                }
                else
                {
                    P_str_result = "updateNO";
                }// end blcok if 
                cmd.Connection.Close();
                con.Close();
                return P_str_result;
            }// end block try
            catch (Exception e)
            {
                P_str_result = "updateError";
                return P_str_result;
            }// end blokc catch
            
        }
        #endregion
        #region//批量審察通過  public string GetShengwarr()
        public string GetShengwarr()
        {
            string P_str_result = null;
            try
            {
                con = getcon.GetCon();
                cmd = new SqlCommand();
                string P_str_update = "update tb_warrantInfo set subEquation='審核已通過' where  warrantId in(select warrantId from tb_warrantInfo where subEquation is null and (subLendmoney=0 or subGoodsMoney=0))";
                cmd.CommandText = P_str_update;
                cmd.Connection = con;
                int P_int_inst = cmd.ExecuteNonQuery();
                if (P_int_inst !=0)
                {
                    P_str_result = "updateOk";
                }
                else
                {
                    P_str_result = "updateNO";
                }// end blcok if 
                cmd.Connection.Close();
                con.Close();
                return P_str_result;
            }// end block try
            catch (Exception e)
            {
                P_str_result = "updateError";
                return P_str_result;
            }// end blokc catch

        }
        #endregion
        #region//查找是否有要審察的記錄 public int GetCount()
        public int GetCount()
        {
            int P_int_count;
            con = getcon.GetCon();
            cmd = new SqlCommand();
            string P_str_select = "select count(*) from tb_warrantInfo where subEquation is null and (subLendmoney=0 or subGoodsMoney=0)";
            cmd.CommandText = P_str_select;
            cmd.Connection = con;
            int P_int_result =(int)cmd.ExecuteScalar();
            con.Close();
            cmd.Connection.Close();
            if (P_int_result != 0)//有記錄
            { P_int_count=1; }// end block if 
            else//沒有
            { P_int_count=0; }
            return P_int_count;
        
        }// end 
        #endregion
        #region //數據幫定憑證時間 public void GetWarDate()
        public void GetWarDate(object Cmb)
        {
            if (Cmb.GetType().ToString() == "System.Windows.Forms.ComboBox")
            {
                con = getcon.GetCon();
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter("select distinct(warrantDate) from tb_warrantInfo",con);
                da.Fill(ds, "tb_warrantInfo");
                DataGridView dv = (DataGridView)Cmb;
                dv.DataSource = ds.Tables[0].DefaultView;
            }//
        }// end block if 
        #endregion
        #region //數據幫定憑證編號 public void GetWarID(object Cmb)
        public void GetWarID(object ct)
        {
            try
            {
                if (ct.GetType().ToString() == "System.Windows.Forms.ComboBox")
                {
                    ComboBox bo = (ComboBox)ct;
                    bo.Items.Clear();
                    con = getcon.GetCon();
                    string P_str_select = "select distinct(warrantId) from tb_warrantInfo";
                    cmd = new SqlCommand(P_str_select, con);

                    SqlDataReader dr = cmd.ExecuteReader();
                    while (dr.Read())
                    {
                        bo.Items.Add(dr.GetValue(0).ToString());
                    }
                    dr.Close();
                    cmd.Connection.Close();
                    con.Close();

                }// end block if 
            }
            catch (Exception ee)
            { MessageBox.Show(ee.Message); }
        }// end block if 
#endregion
       #region//幫定DataGridView 控件 public void GetDatGridView(object Dataview)
        public void GetWarrPrint(object Dataview)
        {
            if (Dataview.GetType().ToString() == "System.Windows.Forms.DataGridView")
            {

                con = getcon.GetCon();
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter("select b.warrantId as 憑證編號,a.subName as 科目名稱,b.warrantDate as 憑證日期 ,b.subLendmoney as 借方金額 ,b.subGoodsMoney  as 貸方金額  ,b.subEquation as 平衡關系 ,b.subRemark as 備注 from tb_subjectInfo a,tb_warrantInfo b where a.subId=b.subid and subEquation is not null", con);
                da.Fill(ds, "tb_warrantInfo");
                DataGridView dv = (DataGridView)Dataview;
                dv.DataSource = ds.Tables[0].DefaultView;
            }//
        
        }// end block if 
        #endregion
        #region//憑證結算  public string GetWarrbalance()
        public string GetWarrbalance()
        {
            string P_str_result = null;
            try
            {
                con = getcon.GetCon();
                cmd = new SqlCommand();
                string P_str_update = "update tb_warrantInfo set subRemark ='已結算' where (subLendmoney=0  or subGoodsMoney=0) and subEquation is not null";
                cmd.CommandText = P_str_update;
                cmd.Connection = con;
                int P_int_inst = cmd.ExecuteNonQuery();
                if (P_int_inst !=0)
                {
                    P_str_result = "updateOk";
                }
                else
                {
                    P_str_result = "updateNO";
                }// end blcok if 
                cmd.Connection.Close();
                con.Close();
                return P_str_result;
            }// end block try
            catch (Exception e)
            {
                P_str_result = "updateError";
                return P_str_result;
            }// end blokc catch
        
        
        }// end block 
        #endregion
        #region//幫定DataGridView 控件查詢用憑證編號public void GetDatGridView(object Dataview)
        public void GetWarrPrint(object Dataview,int P_int_warrID)
        {
            if (Dataview.GetType().ToString() == "System.Windows.Forms.DataGridView")
            {

                con = getcon.GetCon();
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter("select b.warrantId as 憑證編號,a.subName as 科目名稱,b.warrantDate as 憑證日期 ,b.subLendmoney as 借方金額 ,b.subGoodsMoney  as 貸方金額  ,b.subEquation as 平衡關系 ,b.subRemark as 備注 from tb_subjectInfo a,tb_warrantInfo b where a.subId=b.subid and b.warrantId ='" + P_int_warrID + "'", con);
                da.Fill(ds, "tb_warrantInfo");
                DataGridView dv = (DataGridView)Dataview;
                dv.DataSource = ds.Tables[0].DefaultView;
            }//

        }// end block if 
         #endregion
        #region  //憑證號查詢 public void GetMoney(object Dataview,int P_int_warrID)
        public void GetMoney(object Dataview,int P_int_warrID)
        { 
             if (Dataview.GetType().ToString() == "System.Windows.Forms.DataGridView")
            {

                con = getcon.GetCon();
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter("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_warrID + "'", con);
                da.Fill(ds, "tb_warrantInfo");
                DataGridView dv = (DataGridView)Dataview;
                dv.DataSource = ds.Tables[0].DefaultView;
            }//
        }

        #endregion
        #region//憑證報表  public DataSet getWarRepot(int P_int_warrID)
        public DataSet getWarRepot(int P_int_warrID)
        {
            con = getcon.GetCon();
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter("select * from V_Slectt_WarrantID where warrantId='" + P_int_warrID + "'", con);
            da.Fill(ds, "View_sub_Wart");
            return ds;
        
        }// end bloc if 
        #endregion
        #region//憑證報表  public DataSet getWarRepot(int P_int_warrID)
        public DataSet getWarRepotInof(int P_int_warrID)
        {
            con = getcon.GetCon();
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter("select * from V_WarratnInfo where warrantId='" + P_int_warrID + "'", con);
            da.Fill(ds, "View_sub_Wart");
            return ds;

        }// end bloc if 
                #endregion
        #region//憑證報表  public DataSet getWarRepot(int P_int_warrID)
        public DataSet getWarRepotInof()
        {
            con = getcon.GetCon();
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter("select * from V_WarratnInfo", con);
            da.Fill(ds, "View_sub_Wart");
            return ds;

        }// end bloc if 
            #endregion


    }// end block class WarrantInfo
}