?? sbgl_tmp.cs
字號:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using Datamodel;
namespace Data_Contrl
{
/* ****************************************************
重慶杰諾軟件開發(fā)工作室
QQ:83898700
EMAIL:gimao@163.com
url:www.gisii.com
***************************************************** */
/// <summary>
/// Sbgl_Tmp 的摘要說明。
/// </summary>
public class Sbgl_Tmp
{
public Sbgl_Tmp()
{
//
// TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
}
/// <summary>
/// 設(shè)備編碼
/// </summary>
/// <returns></returns>
public string Get_SBbm()
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
Rs=my.ExecuteCreateReader(my.ExeCommand("select max(id)+1 as id from H_Sb_info"));
string id="";
while(Rs.Read())
{
id=Rs["id"].ToString();
}
if (id=="")
id="1";
return id;
}
/// <summary>
/// 取得給定設(shè)備類別的設(shè)備信息
/// </summary>
/// <param name="lbid"></param>
/// <returns></returns>
public IDataReader Get_Sb_bh(int lbid)
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
Rs=my.ExecuteCreateReader(my.ExeCommand("select * from h_Sb_info where sblbid="+lbid));
return Rs;
}
/// <summary>
/// 取得維修數(shù)據(jù)集
/// </summary>
/// <param name="bmbm"></param>
/// <returns></returns>
public IDataReader Get_WxList(string bmbm)
{
string sql="SELECT a.id AS id,a.sbbh as sbbh,b.sn as xh, c.bmnr AS bmnr, a.Wxr AS wxr,a.kssj AS kssj, a.jssj AS jssj FROM H_WxJl a , H_SB_info b, H_Sblb c where a.sbbh = b.id and b.sblbid = c.id";
if(bmbm!="")
{
Tree_Contrl zgjg= new Tree_Contrl();
sql+=" and b.classid in ("+zgjg.Treeinit(Convert.ToInt32(bmbm))+"0)";
}
sql+=" order by a.id desc";
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
Rs=my.ExecuteCreateReader(my.ExeCommand(sql));
return Rs;
}
/// <summary>
/// 調(diào)撥數(shù)據(jù)集
/// </summary>
/// <param name="bmbm"></param>
/// <returns></returns>
public IDataReader Get_DbList(string bmbm)
{
string sql="SELECT a.id as id,a.sbbh as sbbh,b.sn as xh,c.bmnr as bmnr, a.ybm_Name AS ybm, a.y_syr as y_syr, a.xbm_Name as xbm_name, a.syr as syr FROM H_Sb_Db a,H_SB_info b, H_Sblb c where a.sbbh = b.id and b.sblbid = c.id";
if(bmbm!="")
{
Tree_Contrl zgjg= new Tree_Contrl();
sql+=" and b.classid in ("+zgjg.Treeinit(Convert.ToInt32(bmbm))+"0)";
}
sql+=" order by a.id desc";
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
Rs=my.ExecuteCreateReader(my.ExeCommand(sql));
return Rs;
}
/// <summary>
/// 取得報廢數(shù)據(jù)集
/// </summary>
/// <param name="bmbm"></param>
/// <returns></returns>
public IDataReader Get_BfList(string bmbm)
{
string sql="SELECT a.id AS id,a.sbbh as sbbh,b.sn as xh,c.bmnr AS bmnr, a.bfsj AS bfsj FROM H_SBbf a,H_SB_info b,H_Sblb c where a.sbbh = b.id and b.sblbid = c.id";
if(bmbm!="")
{
Tree_Contrl zgjg= new Tree_Contrl();
sql+=" and b.classid in ("+zgjg.Treeinit(Convert.ToInt32(bmbm))+"0)";
}
sql+=" order by a.id desc";
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
Rs=my.ExecuteCreateReader(my.ExeCommand(sql));
return Rs;
}
/// <summary>
/// 取得所有設(shè)備信息
/// </summary>
/// <returns></returns>
public IDataReader Get_SbList()
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
Rs=my.ExecuteCreateReader(my.ExeCommand("SELECT * from H_Sb_info order by id desc"));
return Rs;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -