//得到我和我的下属信息
private string GetMyDepartMen()
{
U_UserNameBU bu1 = new U_UserNameBU();
string result = bu1.GetSelfAndXiaShu(User.Identity.Name);
bu1.Close();
return(result);
}
/// <summary>
/// 统计方案数据
/// </summary>
/// <param name="time0"></param>
/// <param name="time1"></param>
/// <returns></returns>
private DataSet GetTongJiData(String time0, String time1)
{
DataSet ds0 = new DataSet();
DataTable dt0 = new DataTable("Table0");
ds0.Tables.Add(dt0);
dt0.Columns.Add("depart");
for (int i = 1; i <= 12; i++)
{
dt0.Columns.Add("num" + i);
}
List <SearchField> condition = new List <SearchField>();
if (time0.Trim() != String.Empty)
{
condition.Add(new SearchField("shijian1", time0, SearchOperator.大于等于));
}
if (time1.Trim() != String.Empty)
{
condition.Add(new SearchField("shijian1", time1, SearchOperator.小于等于));
}
//设置查询范围
U_RolesBU role1 = new U_RolesBU();
bool isAllCanSee = role1.isRole(new string[] { "公司领导", "评审部角色", "会计", "出纳", "领导秘书" });
role1.Close();
//1)公司领导、会计、出纳、领导秘书 可查询所有的项目
if (isAllCanSee == false)
{
//普通的用户只能查询自己负责（或下属负责的项目）
List <SearchField> condition1 = new List <SearchField>();
U_UserNameBU user1 = new U_UserNameBU();
String userName1 = user1.GetSelfAndXiaShu(User.Identity.Name);
user1.Close();
if (userName1 != String.Empty)
{
condition.Add(new SearchField("zeren", userName1, SearchOperator.集合));
}
}
//2)统计新数据
int[] sum1 = new int[12];
String fdepart = "";
CommTable comm1 = new CommTable();
comm1.TabName = "U_ZC2";
DataSet ds1 = comm1.SearchData("id,depart,status,spstatus,spkind", condition, "depart");
DataRow dr1 = null;
foreach (DataRow dr in ds1.Tables[0].Rows)
{
if (dr["depart"].ToString().Trim() != fdepart)
{
if (dr1 != null)
{
ds0.Tables[0].Rows.Add(dr1);
}
//设置初值
dr1 = ds0.Tables[0].NewRow();
dr1["depart"] = dr["depart"];
fdepart = dr["depart"].ToString().Trim();
for (int i = 1; i <= 12; i++)
{
dr1["num" + i] = 0;
}
}
//设置值
String spstatus = dr["spstatus"].ToString().Trim();
if (spstatus == "0")
{
dr1["num1"] = int.Parse(dr1["num1"].ToString()) + 1;
sum1[0] += 1;
}
else if (spstatus == "1")
{
dr1["num2"] = int.Parse(dr1["num2"].ToString()) + 1;
dr1["num4"] = int.Parse(dr1["num4"].ToString()) + 1;
sum1[1] += 1;
sum1[3] += 1;
}
else if (spstatus == "2")
{
dr1["num3"] = int.Parse(dr1["num3"].ToString()) + 1;
dr1["num4"] = int.Parse(dr1["num4"].ToString()) + 1;
sum1[2] += 1;
sum1[3] += 1;
}
String status = dr["status"].ToString().Trim();
if (status == "21")
{
dr1["num5"] = int.Parse(dr1["num5"].ToString()) + 1;
dr1["num12"] = int.Parse(dr1["num12"].ToString()) + 1;
sum1[4] += 1;
sum1[11] += 1;
}
else if (status == "22")
{
dr1["num6"] = int.Parse(dr1["num6"].ToString()) + 1;
dr1["num12"] = int.Parse(dr1["num12"].ToString()) + 1;
sum1[5] += 1;
sum1[11] += 1;
}
else if (status == "23")
{
dr1["num7"] = int.Parse(dr1["num7"].ToString()) + 1;
dr1["num12"] = int.Parse(dr1["num12"].ToString()) + 1;
sum1[6] += 1;
sum1[11] += 1;
}
else if (status == "24")
{
dr1["num8"] = int.Parse(dr1["num8"].ToString()) + 1;
dr1["num12"] = int.Parse(dr1["num12"].ToString()) + 1;
sum1[7] += 1;
sum1[11] += 1;
}
else if (status == "25")
{
dr1["num9"] = int.Parse(dr1["num9"].ToString()) + 1;
dr1["num12"] = int.Parse(dr1["num12"].ToString()) + 1;
sum1[8] += 1;
sum1[11] += 1;
}
else if (status == "26")
{
dr1["num10"] = int.Parse(dr1["num10"].ToString()) + 1;
dr1["num12"] = int.Parse(dr1["num12"].ToString()) + 1;
sum1[9] += 1;
sum1[11] += 1;
}
else if (status == "27")
{
dr1["num11"] = int.Parse(dr1["num11"].ToString()) + 1;
dr1["num12"] = int.Parse(dr1["num12"].ToString()) + 1;
sum1[10] += 1;
sum1[11] += 1;
}
else
{
;
}
}
if (dr1 != null)
{
ds0.Tables[0].Rows.Add(dr1);
dr1 = ds0.Tables[0].NewRow();
dr1["depart"] = "合计";
for (int i = 1; i <= 12; i++)
{
dr1["num" + i] = sum1[i - 1];
}
ds0.Tables[0].Rows.Add(dr1);
}
comm1.Close();
return(ds0);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.SetMyData();
if (this.SearchType == SearchDataType.单条资产)
{
this.SearchCaption.Text = "查 询 单 条 资 产";
this.ZcbRow0.Visible = false;
}
else
{
this.SearchCaption.Text = "查 询 资 产 包";
this.ZcRow0.Visible = false;
this.ZcRow1.Visible = false;
this.ZcRow2.Visible = false;
this.ZcRow3.Visible = false;
this.ZcRow4.Visible = false;
this.num2.Enabled = false;
this.Button1.Text = "查询资产包";
}
//增加法律顾问的查询选项
if (this.IsRawSearch == false)
{
this.noRawData.Visible = true;
this.RawData.Visible = false;
//this.ZcRow4.Visible = true;
}
else
{
this.noRawData.Visible = false;
this.RawData.Visible = true;
this.ZcRow4.Visible = false;
}
//设置法律顾问资产责任人查询选项目
this.zerenlaw.DataSource = LawBU.GetZerenForScan(0);
this.zerenlaw.DataBind();
//设置个人查询的选项目
if (this.isPersonSearch)
{
this.noRawData.Visible = false;
}
//设置部门资产查询选项(2013年9月16日）
if (this.isDepartSearch == false)
{
this.DepartRowData.Visible = false;
}
else
{
this.DepartRowData.Visible = true;
this.noRawData.Visible = false;
//设置部门责任人
U_UserNameBU user1 = new U_UserNameBU();
String myuser1 = user1.GetSelfAndXiaShu(Page.User.Identity.Name);
this.alldepartuser.Text = myuser1;
String[] arr1 = myuser1.Split(',');
this.zerenForDepart.DataSource = arr1;
this.zerenForDepart.DataBind();
//WebFrame.Util.JControl.SetControlValue(this.zerenForDepart, myuser1);
}
}
}