91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

<tbody id="dioqv"><pre id="dioqv"></pre></tbody>

<pre id="dioqv"><source id="dioqv"></source></pre>

<dl id="dioqv"></dl>

源碼之巔峰

C#進銷存系統(tǒng)

收藏(0)

大小: 845KB

文件類型: .rar

金幣: 2

下載: 0 次

發(fā)布日期: 2021-05-29
語言: C#
標簽:

高速下載

資源簡介

一個基于C#和Oracle開發(fā)的進銷存系統(tǒng)，現(xiàn)在將源代碼公布給大家，這個例子只為學(xué)習(xí)，有需要的兄弟們可以拿去參考參考，大家多交流交流由于數(shù)據(jù)庫之間的主外鍵關(guān)系以及多表查詢，為了方便，我創(chuàng)建了視圖，這和SqlServer里面是一樣的(Oracle里面是Create Or Replace)，當然你也可以建立外鍵對象，我上個項目就是這么干的，當然ORM我們就不討論了。再補充一點：Oracle的自動增長列并不是像SqlServer那樣設(shè)置一下，就會自動增長，Oracle里面需要你自己創(chuàng)建Sequences,圖形操作也行，命令也行，我導(dǎo)出的Oracle腳本里面已經(jīng)包含了相應(yīng)的Sequences,應(yīng)該可以看懂的。其余差別不大，相信你能看懂。

資源截圖

小圖大圖

代碼片段和文件信息

using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Runtime.Serialization;
using?System.ServiceModel;
using?System.Text;
using?Insigma.Eyes.PSS.IDAL;
using?Insigma.Eyes.PSS.OracleDAL;

namespace?Insigma.Eyes.PSS.BLLWCFService
{
????//?注意:?使用“重構(gòu)”菜單上的“重命名”命令，可以同時更改代碼、svc?和配置文件中的類名“CommodityManagerService”。
????public?class?CommodityManagerService?:?ICommodityManagerService
????{
????????public?Model.CommodityModel[]?GetCommodities（string?name?string?type?string?manufacturer?string?priceLow?string?priceHigh）
????????{
????????????string?sqlWhere?=?““;
????????????if?（!string.IsNullOrWhiteSpace（name））
????????????{
????????????????sqlWhere?+=?string.Format（“?and?Name?like?‘%{0}%‘“name）;
????????????}
????????????if?（!string.IsNullOrWhiteSpace（type））
????????????{
????????????????sqlWhere?+=?string.Format（“?and?Type?like?‘%{0}%‘“?type）;
????????????}
????????????if?（!string.IsNullOrWhiteSpace（manufacturer））
????????????{
????????????????sqlWhere?+=?string.Format（“?and?Manufacturer?like?‘%{0}%‘“?manufacturer）;
????????????}
????????????if?（!string.IsNullOrWhiteSpace（priceLow））
????????????{
????????????????try
????????????????{
????????????????????decimal?dPriceLow=decimal.Parse（priceLow）;//調(diào)試一下，是否需要賦值
????????????????????sqlWhere?+=?string.Format（“?and?UnitPrice>={0}“?dPriceLow）;
????????????????}
????????????????catch
????????????????{
????????????????????Exception?e?=?new?Exception（）;
????????????????????throw?new?FaultException（e“單價下限有誤！“）;
????????????????}
????????????}
????????????if?（!string.IsNullOrWhiteSpace（priceHigh））
????????????{
????????????????try
????????????????{
????????????????????decimal?dPriceHigh?=?decimal.Parse（priceHigh）;
????????????????????sqlWhere?+=?string.Format（“?and?UnitPrice<={0}“dPriceHigh）;
????????????????}
????????????????catch?
????????????????{
????????????????????Exception?e?=?new?Exception（）;
????????????????????throw?new?FaultException（e?“單價上限有誤會!“）;
????????????????}
????????????}
????????????ICommodityService?commodityService?=?new?OracleDAL.CommodityService（）;
????????????return?commodityService.GetCommodities（sqlWhere）.ToArray（）;
????????}


????????public?Model.CommodityModel[]?GetCommoditiesByCondition（string?condition）
????????{
????????????string?sqlWhere?=?““;
????????????if?（string.IsNullOrWhiteSpace（condition））
????????????{
????????????????sqlWhere+=string.Format（“and?（Name?Like?‘%{0}%‘?or?Type?Like?‘%{0}%‘?or?Manufacturer?Like?‘%{0}%‘?）“condition）;
????????????}
????????????return?new?OracleDAL.CommodityService（）.GetCommodities（sqlWhere）.ToArray（）;
????????}

????????///?
????????///?獲取一個產(chǎn)品信息
????????///?

????????///?
????????///?
????????public?Model.CommodityModel?GetOneCommodity（int?id）
????????{
????????????return?new?OracleDAL.CommodityService（）.GetOneCommodityByID（id）;
????????}
????}
}

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

?????文件????????159??2012-06-23?01:48??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\CommodityManagerService.svc

?????文件???????3148??2012-06-25?13:04??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\CommodityManagerService.svc.cs

?????文件????????856??2012-06-25?11:46??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\ICommodityManagerService.cs

?????文件???????5717??2012-06-25?00:03??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\Insigma.Eyes.PSS.BLLWCFService.csproj

?????文件???????1086??2012-06-25?00:03??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\Insigma.Eyes.PSS.BLLWCFService.csproj.user

?????文件????????513??2012-06-24?23:46??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\IPurchaseManagerService.cs

?????文件???????1096??2012-06-25?00:02??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\ISalesManagerService.cs

?????文件???????1369??2012-06-23?01:40??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\Properties\AssemblyInfo.cs

?????文件????????157??2012-06-24?23:45??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\PurchaseManagerService.svc

?????文件????????571??2012-06-24?23:47??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\PurchaseManagerService.svc.cs

?????文件????????151??2012-06-24?23:47??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\SalesManagerService.svc

?????文件???????5561??2012-06-25?16:07??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\SalesManagerService.svc.cs

?????文件???????1161??2012-06-23?03:04??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\Web.config

?????文件????????260??2012-06-23?01:40??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\Web.Debug.config

?????文件????????356??2012-06-23?01:40??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.BLLWCFService\Web.Release.config

?????文件???????5948??2012-06-23?02:46??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.sln

????..A..H.?????88064??2012-06-25?17:14??C#進銷存系統(tǒng)\Backup\Insigma.Eyes.PSS.v11.suo

?????文件???????4096??2012-08-03?00:30??C#進銷存系統(tǒng)\Common\bin\Debug\Common.dll

?????文件???????7680??2012-08-03?00:30??C#進銷存系統(tǒng)\Common\bin\Debug\Common.pdb

?????文件???????2306??2012-08-02?20:34??C#進銷存系統(tǒng)\Common\Common.csproj

?????文件????????300??2012-08-02?20:44??C#進銷存系統(tǒng)\Common\Commonhelper.cs

?????文件????????260??2012-08-03?00:30??C#進銷存系統(tǒng)\Common\obj\Debug\Common.csproj.FileListAbsolute.txt

?????文件???????4096??2012-08-03?00:30??C#進銷存系統(tǒng)\Common\obj\Debug\Common.dll

?????文件???????7680??2012-08-03?00:30??C#進銷存系統(tǒng)\Common\obj\Debug\Common.pdb

?????文件???????5693??2012-08-03?00:30??C#進銷存系統(tǒng)\Common\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1344??2012-08-02?20:31??C#進銷存系統(tǒng)\Common\Properties\AssemblyInfo.cs

?????文件???????4608??2012-08-03?04:31??C#進銷存系統(tǒng)\Insigma.Eyes.IDAL\bin\Debug\Insigma.Eyes.PSS.IDAL.dll

?????文件???????7680??2012-08-03?04:31??C#進銷存系統(tǒng)\Insigma.Eyes.IDAL\bin\Debug\Insigma.Eyes.PSS.IDAL.pdb

?????文件??????12800??2012-08-03?04:31??C#進銷存系統(tǒng)\Insigma.Eyes.IDAL\bin\Debug\Insigma.Eyes.PSS.Model.dll

?????文件???????7680??2012-08-03?04:31??C#進銷存系統(tǒng)\Insigma.Eyes.IDAL\bin\Debug\Insigma.Eyes.PSS.Model.pdb

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

上一篇：C#蟻群算法求解TSP問題
下一篇：簡易word、記事本小程序，基于VS2008開發(fā)

評論

共有條評論

相關(guān)資源

<delect id="ods09"><acronym id="ods09"></acronym></delect>

<acronym id="ods09"><pre id="ods09"><strong id="ods09"></strong></pre></acronym>