//得到我负责资产包的查询结果
public DataSet GetZcBaoSearchResult2(string Bname, string bzeren)
{
List <SearchField> condition = new List <SearchField>();
if (Bname != "" && Bname != null)
{
condition.Add(new SearchField("Bname", Bname, SearchOperator.包含, SearchFieldType.字符型));
}
condition.Add(new SearchField("zeren", bzeren, SearchOperator.集合, SearchFieldType.字符型));
String sql = "select * from ZcBaoView3";
DataSet ds1 = null;
CommTable comm = new CommTable();
if (condition != null && condition.Count > 0)
{
String conditionStr = SearchField.GetSearchCondition(condition);
if (String.IsNullOrEmpty(conditionStr) == false)
{
sql = sql + " where " + conditionStr;
}
}
ds1 = comm.TableComm.SearchData(sql);
comm.Close();
return(ds1);
}
//得到案卷的综合查询结果
public DataSet GetSearchResult(List <SearchField> list1)
{
U_RolesBU role1 = new U_RolesBU();
String sql = null;
String condition = SearchField.GetSearchCondition(list1);
if (role1.isRole(new string[] { "公司领导", "评审部角色", "会计", "出纳", "档案管理员" }))
{
sql = "select * from DA_AnJuan ";
if (condition != null && condition.Trim() != String.Empty)
{
sql = sql + " where " + condition;
}
}
else
{
sql = @"select DA_AnJuan.* from DA_AnJuan inner join U_ZC on
DA_AnJuan.ajnum=U_ZC.num2 where U_ZC.zeren='" + Comm.CurUser + "'";
if (condition != null && condition.Trim() != String.Empty)
{
sql = sql + " and " + condition;
}
}
DataSet ds1 = this.tabCommand.TableComm.SearchData(sql);
return(ds1);
}
public static SearchField GetSearchFieldOR(SearchField su1, SearchField su2)
{
string str1 = SearchField.GetSearchCondition(new SearchField[] { su1 });
string str2 = SearchField.GetSearchCondition(new SearchField[] { su2 });;
string sname = " ( " + str1 + " ) or ( " + str2 + " ) ";
return(new SearchField(sname, "", SearchOperator.用户定义));
}
/// <summary>
/// 根据条件，得到资产列表（排除掉资产包内的资产）
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public DataSet GetZcList(List <SearchField> condition, bool AllZc)
{
String sql = null;
if (AllZc == false)
{
sql = @"select distinct u_zc.id,num2,u_zc.danwei,bj,isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) lx ,zeren,zeren1,U_ZC2SearchView2.spstatus,
U_ZC2SearchView2.status1,U_ZC2SearchView2.status2,U_ZC2SearchView2.spresult,U_ZC2SearchView2.spdotime,
bj+isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) bjlx
from u_zc left outer join U_ZC2SearchView2 on U_ZC.id=U_ZC2SearchView2.zcid where not exists (select * from u_zcbaoinfo where zcid=u_zc.id) ";
}
else
{
sql = @"select distinct u_zc.id,num2,u_zc.danwei,bj,isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) lx ,zeren,zeren1,U_ZC2SearchView2.spstatus,
U_ZC2SearchView2.status1,U_ZC2SearchView2.status2,U_ZC2SearchView2.spresult,U_ZC2SearchView2.spdotime,
bj+isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) bjlx
from u_zc left outer join U_ZC2SearchView2 on U_ZC.id=U_ZC2SearchView2.zcid where 1=1 ";
}
DataSet ds1 = null;
CommTable comm = new CommTable();
if (condition != null && condition.Count > 0)
{
String conditionStr = SearchField.GetSearchCondition(condition);
if (String.IsNullOrEmpty(conditionStr) == false)
{
sql = sql + " and " + conditionStr;
}
}
sql = sql + " order by num2 ";
//Comm.Print(sql);
ds1 = comm.TableComm.SearchData(sql);
comm.Close();
return(ds1);
}
/// <summary>
/// 根据条件，得到资产包列表
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public DataSet GetZcBaoList(List <SearchField> condition)
{
String sql = @"select * from zcbaoView3 left outer join U_ZC2BaoSearchView2 on zcbaoView3.id=U_ZC2BaoSearchView2.zcbid";
;
DataSet ds1 = null;
CommTable comm = new CommTable();
if (condition != null && condition.Count > 0)
{
String conditionStr = SearchField.GetSearchCondition(condition);
if (String.IsNullOrEmpty(conditionStr) == false)
{
sql = sql + " where " + conditionStr;
}
}
//Comm.Print(sql);
ds1 = comm.TableComm.SearchData(sql);
comm.Close();
return(ds1);
}
/// <summary>
/// 得到Bug的统计结果
/// tjkind=0 按登记人 tjkind=1 按责任人
/// </summary>
/// <param name="tjkind"></param>
/// <param name="time0"></param>
/// <param name="time1"></param>
/// <returns></returns>
public DataTable GetTjResult(String tjkind, String time0, String time1, String status)
{
DataTable dt1 = new DataTable();
dt1.Columns.Add("doman");
dt1.Columns.Add("A", typeof(int));
dt1.Columns.Add("B", typeof(int));
dt1.Columns.Add("C", typeof(int));
dt1.Columns.Add("TC", typeof(double));
List <SearchField> condition = new List <SearchField>();
if (String.IsNullOrEmpty(status) == false)
{
condition.Add(new SearchField("Status", status));
}
if (String.IsNullOrEmpty(time0) == false)
{
condition.Add(new SearchField(String.Format("AddTime>=cdate('{0}')", time0), "", SearchOperator.UserDefine));
}
if (String.IsNullOrEmpty(time1) == false)
{
condition.Add(new SearchField(String.Format("AddTime<=cdate('{0} 23:59:59')", time1), "", SearchOperator.UserDefine));
}
//统计数据
String commdText = String.Empty;
JCommand comm1 = new JCommand();
if (tjkind == "0")
{
commdText = "select AddUser as domanID,testman as domanName,BugKind,count(*) as count1 from Tb_DebugView";
if (condition.Count > 0)
{
commdText = commdText + " where " + SearchField.GetSearchCondition(condition);
}
commdText = commdText + " group by AddUser,testman,BugKind";
}
else
{
commdText = "select executeMan as domanID,zrr as domanName,BugKind,count(*) as count1 from Tb_DebugView";
if (condition.Count > 0)
{
commdText = commdText + " where " + SearchField.GetSearchCondition(condition);
}
commdText = commdText + " group by executeMan,zrr,BugKind";
}
comm1.CommandText = commdText;
DataTable dt0 = comm1.SearchData(-1).Tables[0];
String doman1 = String.Empty;
DataRow dr1 = null;
foreach (DataRow dr0 in dt0.Rows)
{
if (doman1 != dr0["domanID"].ToString())
{
if (dr1 != null)
{
dt1.Rows.Add(dr1);
}
dr1 = dt1.NewRow();
dr1["doman"] = dr0["domanName"];
dr1["A"] = 0;
dr1["B"] = 0;
dr1["C"] = 0;
dr1[dr0["BugKind"].ToString()] = int.Parse(dr0["count1"].ToString());
}
else
{
dr1[dr0["BugKind"].ToString()] = int.Parse(dr0["count1"].ToString());
}
}
if (dr1 != null)
{
dt1.Rows.Add(dr1);
}
return(dt1);
}
/// <summary>
/// 得到银行的资产
/// </summary>
/// <returns></returns>
private DataSet GetZcForDb(String DbName, bool AllZc)
{
DataSet ds1 = null;
List <SearchField> condition = new List <SearchField>();
WebFrame.Data.JConnect conn1 = WebFrame.Data.JConnect.GetConnect(DbName);
//1－单位名称
if (this.danwei.Text.Trim() != "")
{
condition.Add(new SearchField("u_zc.danwei", this.danwei.Text.Trim(), SearchOperator.Contains));
}
//2－档案编号
if (this.num2.Text.Trim() != "")
{
condition.Add(new SearchField("num2", this.num2.Text.Trim()));
}
if (this.depart.SelectedValue != String.Empty || this.zeren.SelectedValue != String.Empty)
{
//4－责任人
if (this.zeren.SelectedValue != "")
{
condition.Add(new SearchField("zeren", this.zeren.SelectedValue));
}
else
{
//3－责任部门
if (this.depart.SelectedValue != "")
{
condition.Add(new SearchField("depart", this.depart.SelectedValue));
}
}
}
if (condition.Count > 0)
{
JCommand comm1 = new JCommand(conn1);
String sql = null;
if (AllZc == false)
{
sql = @"select distinct u_zc.id,num2,u_zc.danwei,bj,isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) lx ,zeren,zeren1,U_ZC2SearchView2.spstatus,
U_ZC2SearchView2.status1,U_ZC2SearchView2.status2,U_ZC2SearchView2.spresult,U_ZC2SearchView2.spdotime,
bj+isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) bjlx
from u_zc left outer join U_ZC2SearchView2 on U_ZC.id=U_ZC2SearchView2.zcid where not exists (select * from u_zcbaoinfo where zcid=u_zc.id) ";
}
else
{
sql = @"select distinct u_zc.id,num2,u_zc.danwei,bj,isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) lx ,zeren,zeren1,U_ZC2SearchView2.spstatus,
U_ZC2SearchView2.status1,U_ZC2SearchView2.status2,U_ZC2SearchView2.spresult,U_ZC2SearchView2.spdotime,
bj+isnull(lx1,0)+isnull(lx2,0)+isnull(lx3,0) bjlx
from u_zc left outer join U_ZC2SearchView2 on U_ZC.id=U_ZC2SearchView2.zcid where 1=1 ";
}
if (condition != null && condition.Count > 0)
{
String conditionStr = SearchField.GetSearchCondition(condition);
if (String.IsNullOrEmpty(conditionStr) == false)
{
sql = sql + " and " + conditionStr;
}
}
sql = sql + " order by num2 ";
comm1.CommandText = sql;
ds1 = comm1.SearchData(-1);
comm1.Close();
WebFrame.Data.JConnect.CloseConnect();
}
return(ds1);
}
