資源簡介
合同管理信息系統(c#源碼)

代碼片段和文件信息
using?System;
using?System.Collections;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Web;
using?System.Web.SessionState;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.HtmlControls;
using?System.Configuration?;
using?System.Data?.SqlClient?;
namespace?TMS
{
///?
///?AdvancedSearch?的摘要說明。
///?
public?class?AdvancedSearch?:?System.Web.UI.Page
{
protected?System.Web.UI.WebControls.Hyperlink?hlk_goodsmanage;
protected?System.Web.UI.WebControls.Hyperlink?hlk_clientsmanage;
protected?System.Web.UI.WebControls.Hyperlink?hlk_projectsmanage;
protected?System.Web.UI.WebControls.Hyperlink?hlk_contractmanage;
protected?System.Web.UI.WebControls.Hyperlink?hlk_contractcontrol;
protected?System.Web.UI.WebControls.Hyperlink?hlk_contractcount;
protected?System.Web.UI.WebControls.Hyperlink?hlk_passwordmodifyforadmin;
protected?System.Web.UI.WebControls.DropDownList?ddl_tcid;
protected?System.Web.UI.WebControls.DropDownList?ddl_tpid;
protected?System.Web.UI.WebControls.DropDownList?ddl_tstate;
protected?System.Web.UI.WebControls.Button?btn_search;
protected?System.Web.UI.WebControls.DataGrid?dgd_contractlist;
protected?System.Web.UI.WebControls.Hyperlink?hlk_default;
private?void?Page_Load(object?sender?System.EventArgs?e)
{
//綁定客戶信息及項目信息下拉列表框
if(!IsPostBack)
{//客戶信息下拉列表框綁定
string?strconn=?ConfigurationSettings.AppSettings[“dsn“];
//連接本地計算機的HMS數據庫
SqlConnection?cn0=?new?SqlConnection?(strconn);
cn0.Open?();
string?mysql=“select?*?from?Clients?“;
SqlCommand?cm=new?SqlCommand??(mysqlcn0);
SqlDataReader?dr=cm.ExecuteReader?();
while(dr.Read?())
{
ddl_tcid.Items?.Add?(new?ListItem(dr[“cname“].ToString()dr[“cid“].ToString())?);
}
cn0.Close?();
//項目信息下拉列表框綁定
cn0.Open?();
string?mysql1=“select?*?from?Projects“;
SqlCommand?cm1=new?SqlCommand??(mysql1cn0);
SqlDataReader?dr1=cm1.ExecuteReader?();
while(dr1.Read?())
{
ddl_tpid.Items?.Add?(new?ListItem(dr1[“pname“].ToString()dr1[“pid“].ToString())?);
}
cn0.Close?();
//綁定列表框
BindGrid();
}
}
public?void?DataGrid_Page(object?senderDataGridPageChangedEventArgs?E)
{
dgd_contractlist.CurrentPageIndex?=E.NewPageIndex?;
BindGrid();
}
public?void?BindGrid()
{ //從文件Web.config中讀取連接字符串
string?strconn=?ConfigurationSettings.AppSettings[“dsn“];
//連接本地計算機的TMS數據庫
SqlConnection?cn=?new?SqlConnection?(strconn);
//創建帶篩子的SQL語句
string?mysql=“SELECT?*?FROM?ProjectsClientsContract?WHERE TCID=CID?AND?TPID=PID?“;
//對控建進行篩選
if?(ddl_tcid.SelectedItem?.Value?.ToString?()!=“0“)//如果“客戶信息”有輸入0為未選
{
mysql=mysql+“?and?tcid=‘“+ddl_tcid.SelectedItem?.Value?.ToString?()+“‘“;
}
if?(ddl_tpid.SelectedItem?.Value?.ToString?()!=“0“)//如果“項目信息”有輸入0為未選
{
mysql=mysql+“?and?tpid=‘“+ddl_tpid.Sel
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄??????????0??2006-05-19?15:43??合同管理信息系統(c#)
?????目錄??????????0??2008-01-23?13:03??合同管理信息系統(c#)\ContractManage
?????文件??????15134??2004-08-17?16:55??合同管理信息系統(c#)\ContractManage\AdvancedSearch.aspx
?????文件???????4228??2004-08-17?16:55??合同管理信息系統(c#)\ContractManage\AdvancedSearch.aspx.cs
?????文件???????5317??2004-08-17?16:55??合同管理信息系統(c#)\ContractManage\AdvancedSearch.aspx.resx
?????文件???????2102??2003-06-23?14:41??合同管理信息系統(c#)\ContractManage\AssemblyInfo.cs
?????目錄??????????0??2008-01-23?13:03??合同管理信息系統(c#)\ContractManage\Backup
?????目錄??????????0??2008-01-23?13:03??合同管理信息系統(c#)\ContractManage\Backup\ContractManage
?????文件????????934??2004-08-15?20:47??合同管理信息系統(c#)\ContractManage\Backup\ContractManage.sln
????..A..H.?????15872??2004-08-22?23:01??合同管理信息系統(c#)\ContractManage\Backup\ContractManage.suo
?????目錄??????????0??2006-05-19?15:43??合同管理信息系統(c#)\ContractManage\bin
?????文件??????65536??2004-08-18?01:22??合同管理信息系統(c#)\ContractManage\bin\TMS.dll
?????文件?????130560??2004-08-18?01:22??合同管理信息系統(c#)\ContractManage\bin\TMS.pdb
?????文件???????9137??2004-08-17?17:05??合同管理信息系統(c#)\ContractManage\ClientsAdd.aspx
?????文件???????5047??2004-08-17?17:03??合同管理信息系統(c#)\ContractManage\ClientsAdd.aspx.cs
?????文件???????5317??2004-08-17?17:03??合同管理信息系統(c#)\ContractManage\ClientsAdd.aspx.resx
?????文件???????9587??2004-08-18?01:35??合同管理信息系統(c#)\ContractManage\ClientsManage.aspx
?????文件???????3374??2004-08-17?17:19??合同管理信息系統(c#)\ContractManage\ClientsManage.aspx.cs
?????文件???????5317??2004-08-17?17:19??合同管理信息系統(c#)\ContractManage\ClientsManage.aspx.resx
?????文件???????9063??2004-08-17?17:28??合同管理信息系統(c#)\ContractManage\ClientsModify.aspx
?????文件???????5963??2004-08-17?17:27??合同管理信息系統(c#)\ContractManage\ClientsModify.aspx.cs
?????文件???????5317??2004-08-17?17:27??合同管理信息系統(c#)\ContractManage\ClientsModify.aspx.resx
?????文件???????8685??2004-08-17?17:35??合同管理信息系統(c#)\ContractManage\ContractAdd.aspx
?????文件???????5609??2004-08-17?17:33??合同管理信息系統(c#)\ContractManage\ContractAdd.aspx.cs
?????文件???????5317??2004-08-17?17:33??合同管理信息系統(c#)\ContractManage\ContractAdd.aspx.resx
?????文件??????13986??2004-08-17?18:39??合同管理信息系統(c#)\ContractManage\ContractControl.aspx
?????文件???????8149??2004-08-17?17:51??合同管理信息系統(c#)\ContractManage\ContractControl.aspx.cs
?????文件???????5317??2004-08-17?17:51??合同管理信息系統(c#)\ContractManage\ContractControl.aspx.resx
?????文件??????14941??2004-08-17?18:10??合同管理信息系統(c#)\ContractManage\ContractCount.aspx
?????文件???????6284??2004-08-17?18:05??合同管理信息系統(c#)\ContractManage\ContractCount.aspx.cs
............此處省略144個文件信息
- 上一篇:人力資源管理系統(c#.net源碼)
- 下一篇:c#寫的word嵌入form
評論
共有 條評論