using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data.SqlClient;
using?System.Data;
using?System.Data.OleDb;
using?System.Configuration;


namespace?Makings
{

????class?DAL
????{
????????//DataConnection?dc?=?new?DataConnection（）;
????????private?static?string?strconn?=?ConfigurationManager.ConnectionStrings[“MakingsInfo“].ConnectionString;
????????///?

????????///?顯示所有物料的進出情況
????????///?

????????///?
????????public?static?DataTable?GetShowBomPass（）
????????{
????????????DataTable?dt?=?new?DataTable（）;
????????????SqlConnection?conn?=?new?SqlConnection（strconn）;
????????????SqlDataAdapter?sda?=?new?SqlDataAdapter（“Pro_ShowBomPass“?conn）;
????????????sda.SelectCommand.CommandType?=?CommandType.StoredProcedure;
????????????sda.Fill（dt）;
????????????return?dt;
????????}

????????public?static?DataTable?GetPassAndOut（string?PN?DateTime?StartTime?DateTime?EndTime）
????????{

????????????DataTable?dt?=?new?DataTable（）;
????????????SqlConnection?conn?=?new?SqlConnection（strconn）;
????????????SqlDataAdapter?sda?=?new?SqlDataAdapter（“CHK_PN“?conn）;
????????????sda.SelectCommand.CommandType?=?CommandType.StoredProcedure;
????????????sda.SelectCommand.Parameters.AddWithValue（“@PN“?PN）;
????????????sda.SelectCommand.Parameters.AddWithValue（“@StartTime“?StartTime）;
????????????sda.SelectCommand.Parameters.AddWithValue（“@EndTime“?EndTime）;
????????????sda.Fill（dt）;
????????????return?dt;
????????}

????????public?static?bool?GetAdd（string?PN?string?Category?string?Supplier?Single?Price?double?quantity?bool?Operate?string?Odd_Number?string?Indent_Number?DateTime?Timestring?Remark）
????????{
????????????bool?result?=?false;
????????????SqlConnection?conn?=?new?SqlConnection（strconn）;
????????????SqlCommand?com?=?new?SqlCommand（“ADD_passAndout“?conn）;
????????????com.CommandType?=?CommandType.StoredProcedure;
????????????com.Parameters.AddWithValue（“@PN“?PN）;
????????????com.Parameters.AddWithValue（“@Category“?Category）;
????????????com.Parameters.AddWithValue（“@Supplier“?Supplier）;
????????????com.Parameters.AddWithValue（“@Price“?Price）;
????????????com.Parameters.AddWithValue（“@quantity“?quantity）;
????????????com.Parameters.AddWithValue（“@Operate?“?Operate）;
????????????com.Parameters.AddWithValue（“@Odd_Number“?Odd_Number）;
????????????com.Parameters.AddWithValue（“@Indent_Number“?Indent_Number）;
????????????com.Parameters.AddWithValue（“@Time“?Time）;
????????????com.Parameters.AddWithValue（“@Remark“Remark）;
????????????conn.Open（）;
????????????result?=?com.ExecuteNonQuery（）?>?0;
????????????conn.Close（）;
????????????return?result;
????????}
????????///?

????????///?顯示進出表所有信息
????????///?

????????///?
????????public?static?DataTable?GetShowPassOutAll（）
????????{
????????????DataTable?dt?=?new?DataTable（）;
????????????SqlConnection?conn?=?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????246??2013-03-08?13:48??Makings修改\Makings\Makings\App.config

?????文件??????35840??2013-03-08?16:30??Makings修改\Makings\Makings\bin\Debug\Makings.exe

?????文件????????246??2013-03-08?13:48??Makings修改\Makings\Makings\bin\Debug\Makings.exe.config

?????文件??????73216??2013-03-08?16:30??Makings修改\Makings\Makings\bin\Debug\Makings.pdb

?????文件??????22984??2013-03-09?00:04??Makings修改\Makings\Makings\bin\Debug\Makings.vshost.exe

?????文件????????246??2013-03-08?13:48??Makings修改\Makings\Makings\bin\Debug\Makings.vshost.exe.config

?????文件????????490??2012-06-06?02:06??Makings修改\Makings\Makings\bin\Debug\Makings.vshost.exe.manifest

?????文件??????10389??2013-03-08?16:30??Makings修改\Makings\Makings\DAL.cs

?????文件????????827??2013-03-08?16:30??Makings修改\Makings\Makings\FomP.cs

?????文件???????4178??2013-03-08?14:51??Makings修改\Makings\Makings\FomP.Designer.cs

?????文件???????5817??2013-03-08?14:51??Makings修改\Makings\Makings\FomP.resx

?????文件???????1962??2013-03-06?18:43??Makings修改\Makings\Makings\FrmAddPO.cs

?????文件??????17439??2013-03-06?17:13??Makings修改\Makings\Makings\FrmAddPO.Designer.cs

?????文件???????5817??2013-03-06?17:13??Makings修改\Makings\Makings\FrmAddPO.resx

?????文件???????2446??2013-03-07?09:39??Makings修改\Makings\Makings\FrmBOM.cs

?????文件??????11906??2013-03-07?09:39??Makings修改\Makings\Makings\FrmBOM.Designer.cs

?????文件???????5817??2013-03-07?09:39??Makings修改\Makings\Makings\FrmBOM.resx

?????文件???????3365??2013-03-08?16:30??Makings修改\Makings\Makings\FrmLogin.cs

?????文件???????7769??2013-03-08?22:11??Makings修改\Makings\Makings\FrmLogin.Designer.cs

?????文件???????5817??2013-03-08?14:51??Makings修改\Makings\Makings\FrmLogin.resx

?????文件???????1419??2013-03-08?10:58??Makings修改\Makings\Makings\FrmMain.cs

?????文件???????7610??2013-03-08?10:58??Makings修改\Makings\Makings\FrmMain.Designer.cs

?????文件???????6015??2013-03-08?10:58??Makings修改\Makings\Makings\FrmMain.resx

?????文件???????3150??2013-03-09?00:57??Makings修改\Makings\Makings\FrmSelect.cs

?????文件??????11370??2013-03-09?00:50??Makings修改\Makings\Makings\FrmSelect.Designer.cs

?????文件???????5817??2013-03-09?00:50??Makings修改\Makings\Makings\FrmSelect.resx

?????文件???????2022??2013-03-06?16:40??Makings修改\Makings\Makings\FrmUser.cs

?????文件???????8822??2013-03-06?09:41??Makings修改\Makings\Makings\FrmUser.Designer.cs

?????文件???????5998??2013-03-06?09:41??Makings修改\Makings\Makings\FrmUser.resx

?????文件???????7421??2013-03-08?14:51??Makings修改\Makings\Makings\Makings.csproj

............此處省略40個文件信息