using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?dal;
using?model;
using?System.Data;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?bll
{
????public?class?Classcktj
????{
????????sjk?db?=?new?sjk（）;
????????banding?bd?=?new?banding（）;
????????SqlDataReader?dtrksl;
????????DataTable?dtspm?=?new?DataTable（）;
????????DataTable?dtxh?=?new?DataTable（）;
????????DataTable?dtgys?=?new?DataTable（）;
????????DataTable?dthj?=?new?DataTable（）;
????????public?void?DataBindingCmbckSpm（ComboBox?cmbspm）
????????{
????????????//組合框的綁定
????????????dtspm?=?db.Select（“SELECT?DISTINCT?dbo.spxxb.spbh?dbo.spb.spm?FROM?dbo.spxxb?INNER?JOIN?dbo.spb?ON?dbo.spxxb.spbh?=?dbo.spb.spbh?WHERE?（dbo.spxxb.sl?>?0）“）;
????????????bd.bd（cmbspmdtspm?“spm“?“spbh“）;
????????}

????????public?void?DataBindingCmbckSpxh（ComboBox?cmbxh?ckb?c）
????????{
????????????//組合框的綁定
????????????db.AddParameters（“@spbh“?SqlDbType.Int?c.spbh）;
????????????dtxh?=?db.Select（“select?xh?from?hjxxb?where?spbh=@spbh?and?sl>0“）;
????????????bd.bd（cmbxh?dtxh?“xh“?“xh“）;
????????}

????????public?void?DataBindingCmbckcfhj（ComboBox?cmbcfhjckb?c）
????????{
????????????//組合框的綁定
????????????db.AddParameters（“@spbh“?SqlDbType.Int?c.spbh）;
????????????db.AddParameters（“@xh“SqlDbType.VarCharc.xh）;
????????????dthj?=?db.Select（“select?hjbh?from?hjxxb?where?spbh=@spbh?and?xh=@xh“）;
????????????bd.bd（cmbcfhj?dthj?“hjbh“?“hjbh“）;
????????}?

????????public?void?DataBindingCmbckshr（ComboBox?cmbshr）
????????{
????????????//組合框的綁定
????????????dtgys?=?db.Select（“SELECT?khbhkh?from?khb“）;
????????????bd.bd（cmbshr?dtgys?“kh“?“khbh“）;
????????}

????????public?void?DataBindingCmbcksl（ckb?c）
????????{
????????????db.AddParameters（“@spbh“SqlDbType.Intc.spbh）;
????????????db.AddParameters（“@xh“SqlDbType.VarCharc.xh）;
????????????db.AddParameters（“@hjbh“?SqlDbType.VarChar?c.cfhj）;
????????????dtrksl?=?db.Select2（“select?sl?from?hjxxb?where?hjbh=@hjbh?and?spbh=@spbh?and?xh=@xh“）;
????????????while?（dtrksl.Read（））//每次讀取一行，記錄會自動下移至下一條記錄，反復讀取，直到讀完記錄
????????????{
????????????????c.sl?=?int.Parse（dtrksl[0].ToString（））;
????????????}
????????????db.close（）;
????????}
????????public?void?Insertrktj（ckb?c）
????????{
????????????db.AddParameters（“@spbh“?SqlDbType.Int?c.spbh）;
????????????db.AddParameters（“@spm“?SqlDbType.Char?c.spm）;
????????????db.AddParameters（“@xh“?SqlDbType.VarChar?c.xh）;
????????????db.AddParameters（“@sl“?SqlDbType.Int?c.sl）;
????????????db.AddParameters（“@chr“?SqlDbType.VarChar?c.chr）;
????????????db.AddParameters（“@shr“?SqlDbType.Int?c.shr）;
????????????db.AddParameters（“@cfhj“?SqlDbType.Char?c.cfhj）;
????????????db.Insert（“insert?into?ckb?（spbhspmxhslchrshrcfhjcksjyz）values（@spbh@spm@xh@sl@chr@shr@cfhjGETDATE（）1）“）;
????????}
????????public?void?DataBindingDataGridView（DataGridView?dgvck?int?num?ckb?c?khb?k）
????????{

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????3182??2014-12-19?13:28??51Aspx源碼必讀.txt
?????目錄???????????0??2014-12-19?11:36??DB_51aspx\
?????文件?????2359296??2014-12-19?13:16??DB_51aspx\cangku.mdf
?????文件?????5373952??2014-12-19?13:16??DB_51aspx\cangku_log.LDF
?????目錄???????????0??2014-12-19?11:36??bll\
?????文件????????3432??2014-01-07?13:23??bll\Classcktj.cs
?????文件????????4524??2014-01-07?13:32??bll\Classckyz.cs
?????文件?????????736??2014-01-04?21:00??bll\Classdh.cs
?????文件????????5793??2014-01-08?23:50??bll\Classhj.cs
?????文件?????????822??2014-01-09?00:05??bll\Classhjqk.cs
?????文件????????1185??2013-12-31?09:57??bll\Classlogin.cs
?????文件????????2462??2014-01-01?14:34??bll\Classrktj.cs
?????文件????????4776??2013-12-25?18:38??bll\Classrkyz.cs
?????文件?????????999??2014-01-04?22:01??bll\Classrqcx.cs
?????文件????????1632??2014-01-07?20:27??bll\Classscyh.cs
?????文件????????1397??2014-01-04?01:56??bll\Classspkc.cs
?????文件????????2960??2014-01-07?20:12??bll\Classsplr.cs
?????文件????????7942??2014-01-08?23:42??bll\Classspxgsc.cs
?????文件????????1849??2014-01-07?23:01??bll\Classtjyh.cs
?????文件?????????881??2013-12-31?19:40??bll\Classxgmm.cs
?????文件????????2103??2014-01-08?23:39??bll\Classxgyh.cs
?????文件?????????490??2014-01-02?16:06??bll\Classzhuye.cs
?????目錄???????????0??2014-12-19?11:36??bll\Properties\
?????文件????????1338??2013-12-21?22:14??bll\Properties\AssemblyInfo.cs
?????文件????????1651??2014-01-08?09:45??bll\Validator.cs
?????目錄???????????0??2014-12-19?11:36??bll\bin\
?????目錄???????????0??2014-12-19?11:36??bll\bin\Debug\
?????文件???????30208??2014-12-19?11:39??bll\bin\Debug\bll.dll
?????文件???????83456??2014-12-19?11:39??bll\bin\Debug\bll.pdb
?????文件????????6656??2014-12-19?11:39??bll\bin\Debug\dal.dll
?????文件???????19968??2014-12-19?11:39??bll\bin\Debug\dal.pdb
............此處省略180個文件信息