private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9990", this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.tdnewdoc.Visible = true; //新建
this.tddeldoc.Visible = true; //删除
}
else
{
this.isrole.Value = "0";
this.tdnewdoc.Visible = false; //新建
this.tddeldoc.Visible = false; //删除
}
if (this.txtdeptid.Value == "")
this.tdnewdoc.Visible = false; //新建
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt;
if (this.hy_name.Value != "")
{
if (this.txtdeptid.Value == "")
{
dt = Hyoa_user.GetusersbynameforCX(this.hy_name.Value);
}
else
{
dt = Hyoa_user.GetusersbydeptidforCX(this.txtdeptid.Value, this.hy_name.Value);
}
}
else
{
if (this.txtdeptid.Value == "")
{
//显示所有用户
dt = Hyoa_user.GetusersOrderbydeptsortandusersort();
}
else
{
//按部门ID显示
dt = Hyoa_user.Getusersbydeptid(this.txtdeptid.Value);
}
}
DataTable tempTable = dt.Clone();
DataColumn col = new DataColumn("ifjz", typeof(String)); //定义新的一列 是否兼职
tempTable.Columns.Add(col); //追加一列 add
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
if (dt.Rows[i]["hy_loginuid"].ToString() == "")
{
dr["ifjz"] = "<font color=red>[兼职信息]</font>"; //将新值赋给相应的列 add
}
else
{
dr["ifjz"] = ""; //将新值赋给相应的列 add
}
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
//发布投票add by fy 2014-02-23
protected void Button_Pub_Click(object sender, EventArgs e)
{
//发布投票时发送邮件给参与投票人
HyoaClass.DAO db = new HyoaClass.DAO();
HyoaClass.Hyoa_mail Hyoa_mail = new HyoaClass.Hyoa_mail();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
string ls_yqmlists = "";
if (this.hy_field43.Text == "")
{
//从人员库中读取人员
DataTable dt = Hyoa_user.GetusersOrderbydeptsortandusersort();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string ls_jsrid = dt.Rows[i]["hy_userid"].ToString();
string ls_jsrname = dt.Rows[i]["hy_username"].ToString();
string ls_yqm = "";
string ls_yqms = GetRandom3();
if (ls_jsrid == "admin")
{
ls_yqm = "000" + ls_yqms;
}
else
{
ls_yqm = ls_jsrid.Substring(ls_jsrid.Length - 3) + ls_yqms; //获得6位数字的随机数
}
//string ls_dburl = "/wstp.aspx?yqm=" + ls_yqm + "&rnd=" + Hyoa_global.GetRandom();
string ls_dburl = "/wstp.aspx?rnd=" + Hyoa_global.GetRandom();
string ls_body = this.Session["hyuname"].ToString() + "发起投票，您的投票邀请码为：" + ls_yqm + "。<a href=" + ls_dburl + " target=\"_blank\">请点击进入</a>";
String ls_sql = "insert into hyt_mail(ID,DOCID,hy_type,hy_foldername,hy_fsrid,hy_fsrname,hy_jsrid,hy_wbjsrid,hy_jsrname,hy_title,hy_body,hy_datetime,hy_ifsavetofjx,hy_yxj,hy_yjbg,hy_zycd,hy_hz,hy_wbjszh) values ";
ls_sql += "('" + Hyoa_global.GetRandom() + "','" + Hyoa_global.GetRandom() + "','收件','收件箱','" + this.hy_djrid.Text + "','" + this.hy_djrname.Text + "','" + ls_jsrid + "','','" + ls_jsrname + "','" + this.hy_field23.Text + "','" + ls_body + "','" + System.DateTime.Now.ToString() + "','','','','','','') ";
db.Execute(ls_sql);
//将邀请码
if (ls_yqmlists == "")
{
ls_yqmlists = ls_yqm;
}
else
{
ls_yqmlists = ls_yqmlists + "+" + ls_yqm;
}
}
}
}
else
{
string ls_jsrid = this.hy_field43.Text;
string ls_jsrname = this.hy_field41.Text;
string[] lv_jsrid = ls_jsrid.Split('+');
string[] lv_jsrname = ls_jsrname.Split('+');
for (var i = 0; i < lv_jsrid.Length; i++)
{
if (lv_jsrid[i] != "")
{
string ls_yqm = "";
string ls_yqms = GetRandom3();
if (lv_jsrid[i] == "admin")
{
ls_yqm = "000" + ls_yqms;
}
else
{
ls_yqm = lv_jsrid[i].Substring(lv_jsrid[i].Length - 3) + ls_yqms; //获得6位数字的随机数
}
////发送待办
//string ls_dburl = "wstp.aspx?rnd=" + Hyoa_global.GetRandom();
//string ls_body = this.Session["hyuname"].ToString() + "发起投票，请您参与";
//Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_jsrid[i].ToString(), lv_jsrname[i].ToString(),
// this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), ls_dburl, "待办", this.hy_mudelid.Text, "待办箱", "一般", ls_body, "请参与", 0, "", "");
//给参与的人发送邮件
//string ls_dburl = "/wstp.aspx?yqm=" + ls_yqm + "&rnd=" + Hyoa_global.GetRandom();
string ls_dburl = "/wstp.aspx?rnd=" + Hyoa_global.GetRandom();
string ls_body = this.Session["hyuname"].ToString() + "发起投票，您的投票邀请码为：" + ls_yqm + "。<a href=" + ls_dburl + " target=\"_blank\">请点击进入</a>";
String ls_sql = "insert into hyt_mail(ID,DOCID,hy_type,hy_foldername,hy_fsrid,hy_fsrname,hy_jsrid,hy_wbjsrid,hy_jsrname,hy_title,hy_body,hy_datetime,hy_ifsavetofjx,hy_yxj,hy_yjbg,hy_zycd,hy_hz,hy_wbjszh) values ";
ls_sql += "('" + Hyoa_global.GetRandom() + "','" + Hyoa_global.GetRandom() + "','收件','收件箱','" + this.hy_djrid.Text + "','" + this.hy_djrname.Text + "','" + lv_jsrid[i].ToString() + "','','" + lv_jsrname[i].ToString() + "','" + this.hy_field23.Text + "','" + ls_body + "','" + System.DateTime.Now.ToString() + "','','','','','','') ";
db.Execute(ls_sql);
//将邀请码
if (ls_yqmlists == "")
{
ls_yqmlists = ls_yqm;
}
else
{
ls_yqmlists = ls_yqmlists + "+" + ls_yqm;
}
}
}
}
//更新表
string sql = "update hyp_flowmain set hy_field30='" + ls_yqmlists + "',hy_field100=1 where docid='" + this.txtdocid.Value + "'";
db.Execute(sql);
db.Close();
db.Dispose();
Response.Write("<script>alert('发布投票成功！');window.location = '/list_tpgl.aspx?mid=moduletpgl&tableid=bb4c4ac0-53b4-4c7f-89a6-4bde425c24fd';</script>");
}
public string CreateCharts()
{
string strXML;
string lssql;
string lscolor;
lscolor = "color='D64646'";
strXML = "";
//统计日期
string lsdatestart=System.DateTime.Now.ToShortDateString();
string lsdateend = System.DateTime.Now.ToShortDateString();
string lsif="";
if (this.Request.QueryString["datestart"] != null)
{
if (this.Request.QueryString["datestart"].ToString() != "")
{
lsdatestart = this.Request.QueryString["datestart"].ToString();
//lsif = lsif + " and hy_field31>='" + lsdatestart + "'";
}
}
if (this.Request.QueryString["dateend"] != null)
{
if (this.Request.QueryString["dateend"].ToString() != "")
{
lsdateend = this.Request.QueryString["dateend"].ToString();
//lsif = lsif + " and hy_field31<='" + lsdateend + "'";
}
}
HyoaClass.DAO db = new HyoaClass.DAO();
string ls_ryxx = "";
string ls_sum = "";
string ls_startmonth = System.DateTime.Parse(lsdatestart).ToString("MM");
string ls_endmonth = System.DateTime.Parse(lsdateend).ToString("MM");
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt_user = Hyoa_user.GetusersOrderbydeptsortandusersort();
string ls_html = "";
ls_html += "<table width=\"100%\" height=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\" class=\"tb2-print\">";
ls_html += "<tr height=40px>";
ls_html += "<td valign=\"top\" >";
ls_html += "<table width=\"100%\" >";
ls_html += "<tr>";
ls_html += "<td align=\"center\" valign=\"top\">";
ls_html += "<table width=\"98%\" border=0 cellpadding=0 cellspacing=1 class=\"tb1-main\">";
ls_html += "<tr>";
ls_html += "<td width=\"5%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">序号</td>";
ls_html += "<td width=\"8%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">科室</td>";
ls_html += "<td width=\"8%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">姓名</td>";
for (int ll = 0; ll <= System.Int32.Parse(ls_endmonth) - System.Int32.Parse(ls_startmonth); ll++)
{
ls_html += "<td width=\"8%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">" + System.Int32.Parse(System.DateTime.Parse(lsdatestart).AddMonths(ll).ToString("MM")).ToString() + "月(篇数/分数)</td>";
//ls_html += "<td width=\"8%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">" + System.Int32.Parse(System.DateTime.Parse(lsdatestart).AddMonths(ll).ToString("MM")).ToString() + "月(分数)</td>";
}
ls_html += "<td width=\"8%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">合计(篇数/分数)</td>";
//ls_html += "<td width=\"8%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">分数合计</td>";
ls_html += "</tr>";
double liperfssum = 0;
double lipertssum = 0;
for (int li = 0; li < dt_user.Rows.Count; li++)
{
lipertssum = 0.0;
liperfssum = 0.0;
ls_html += "<tr>";
ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">"+(li+1).ToString()+"</td>";
ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">" + dt_user.Rows[li]["hy_deptname"].ToString() + "</td>";
ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">"+dt_user.Rows[li]["hy_username"].ToString()+"</td>";
for (int ll = 0; ll <= System.Int32.Parse(ls_endmonth) - System.Int32.Parse(ls_startmonth); ll++)
{
string lsyearandmonth = System.DateTime.Parse(lsdatestart).AddMonths(ll).ToString("yyyyMM");
string lssqlsum = "select count(*) as ts, sum(convert(float,hy_field9)) as fs from hyp_flowmain where convert(nvarchar(6),hy_field31,112)='" + lsyearandmonth + "' and hy_mudelid='xxgl' and hy_tableid='f1265875-5494-465f-ac33-6fa43d208c8f' and replace(hy_field6,' ','')='" + dt_user.Rows[li]["hy_username"].ToString() + "'";
DataTable dtsum = db.GetDataTable(lssqlsum);
if (dtsum.Rows.Count > 0)
{
string ls_fs = dtsum.Rows[0]["fs"].ToString();
if (ls_fs == "")
{
ls_fs = "0";
}
else
{
liperfssum += System.Double.Parse(ls_fs);
}
ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">" + dtsum.Rows[0]["ts"].ToString() + "/" + ls_fs + "</td>";
//if (dtsum.Rows[0]["fs"].ToString() == "")
//{
// ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">" + "0" + "</td>";
//}
//else
//{
// ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">" + dtsum.Rows[0]["fs"].ToString() + "</td>";
// liperfssum += System.Double.Parse(dtsum.Rows[0]["fs"].ToString());
//}
}
else
{
ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">" + "0/0" + "</td>";
//ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">" + "0" + "</td>";
}
lipertssum += System.Int32.Parse(dtsum.Rows[0]["ts"].ToString());
}
ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">" + lipertssum.ToString() + "/" + liperfssum.ToString() + "</td>";
//ls_html += "<td height=\"30\" align=\"center\" class=\"Tdcellright\">" + liperfssum.ToString() + "</td>";
ls_html += "</tr>";
}
ls_html += "</table>";
ls_html += "</td>";
ls_html += "</tr>";
ls_html += "</table>";
ls_html += "</td>";
ls_html += "</tr>";
ls_html += " </table>";
return ls_html;
//this.Response.Write(ls_ryxx + ls_sum);
//////////////string[] lv_ryxx;
//////////////lv_columnshowselect = dt.Rows[0]["hy_columnshow"].ToString().Split(',');
////////////////strXML +="<graph caption='绩效统计' showNames='1' showvalues='" + 100 + "' baseFontSize='12' xAxisName='Name' yAxisName='Point' decimalPrecision='0' formatNumberScale='0'>";
//////////////strXML += "<graph caption='" + lssumdate + "信息统计' showNames='1' baseFontSize='12' xAxisName='姓 名' yAxisName='Point' decimalPrecision='2' formatNumberScale='0'>";
//////////////for (int i = 0; i < dt.Rows.Count; i++)
//////////////{
////////////// lscolor = lscolor.Substring(0, 9) + (i * 100).ToString() + "'";
////////////// //lssql = "select sum(convert(int,hy_field12)) from hyp_flowmain where hy_mudelid='rsgl' and hy_tableid='6047076e-6a95-4fb8-aec8-5551d3900590' and hy_field10 = '" + dt.Rows[i]["hy_userid"].ToString() + "'";
////////////// //dtfs = db.GetDataTable(lssql);
////////////// strXML += "<set name='" + dt.Rows[i]["hy_field6"].ToString() + "' value='" + dt.Rows[i]["fs"].ToString() + "' " + lscolor + " />";
//////////////}
////////////////strXML += "<set name='人员1' value='" + "30" + "' color='D64646' />";
////////////////strXML += "<set name='人员2' value='" + "60" + "' color='8E468E' />";
////////////////strXML += "<set name='人员3' value='" + "90" + "' color='8E468E' />";
//////////////db.Close();
//////////////strXML += "</graph>";
////////////////this.lbscrbdataY.Text = " <font color=red>生产日报</font><br>当日实绩:" + xmldata[5] + "吨<br>" + "月度计划:" + xmldata[0] + "吨<br>" + "月度累计:" + xmldata[1] + "吨<br>" + "完成月计划:" + xmldata[2] + "%<br>" + "年度累计:" + xmldata[6] + "吨<br>" + "完成年计划:" + xmldata[7] + "%<br>";
//////////////return FusionCharts.RenderChartHTML("/app/FusionChartsFree/Charts/FCF_Column3D.swf", "ChartId", strXML, "myNext", "1224", "500", false);
///////////////////ztmend
return "aaa";
}
public string CreateCharts()
{
string strXML;
string lssql;
string lscolor;
lscolor = "color='D64646'";
strXML = "";
//统计日期
string lsdatestart="";
string lsdateend="";
string lsif = "";
if (this.Request.QueryString["datestart"] != null)
{
if (this.Request.QueryString["datestart"].ToString() != "")
{
lsdatestart = this.Request.QueryString["datestart"].ToString();
lsif = lsif + " and hy_djsj>='" + lsdatestart + "' ";
}
}
if (this.Request.QueryString["dateend"] != null)
{
if (this.Request.QueryString["dateend"].ToString() != "")
{
lsdateend = this.Request.QueryString["dateend"].ToString();
DateTime dts = Convert.ToDateTime(lsdateend);
DateTime date_effect = dts.AddDays(1);//加一天
lsif = lsif + " and hy_djsj<='" + date_effect.ToString("yyyy-MM-dd").ToString() + "' ";
}
}
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt = Hyoa_user.GetusersOrderbydeptsortandusersort();
HyoaClass.DAO db = new HyoaClass.DAO();
DataTable dtfs;
string lssumdate = "";
if (lsdatestart != "")
{
lssumdate = lsdatestart;
}
if (lsdateend != "")
{
lssumdate = lssumdate + "至" + lsdateend;
}
else
{
lssumdate = lssumdate + "至今";
}
//strXML +="<graph caption='绩效统计' showNames='1' showvalues='" + 100 + "' baseFontSize='12' xAxisName='Name' yAxisName='Point' decimalPrecision='0' formatNumberScale='0'>";
strXML += "<graph caption='" + lssumdate + "绩效统计' showNames='1' baseFontSize='12' xAxisName='姓 名' yAxisName='Point' decimalPrecision='0' formatNumberScale='0'>";
for (int i = 0; i < dt.Rows.Count; i++)
{
lscolor = lscolor.Substring(0, 9) + (i*100).ToString() + "'";
lssql = "select sum(convert(float,hy_field12)) from hyp_flowmain where hy_mudelid='rsgl' and hy_tableid='6047076e-6a95-4fb8-aec8-5551d3900590'" + lsif + " and hy_field1 = '" + dt.Rows[i]["hy_username"].ToString() + "'";
dtfs = db.GetDataTable(lssql);
//增加0的数据不显示 added by xf 20110722
if(dtfs.Rows[0][0].ToString()!="" && dtfs.Rows[0][0].ToString()!="0")
strXML += "<set name='" + dt.Rows[i]["hy_username"].ToString() + "' value='" + dtfs.Rows[0][0].ToString() + "' " + lscolor + " />";
}
//strXML += "<set name='人员1' value='" + "30" + "' color='D64646' />";
//strXML += "<set name='人员2' value='" + "60" + "' color='8E468E' />";
//strXML += "<set name='人员3' value='" + "90" + "' color='8E468E' />";
db.Close();
strXML += "</graph>";
return FusionCharts.RenderChartHTML("/app/FusionChartsFree/Charts/FCF_Pie3D.swf", "ChartId", strXML, "myNext", "1024", "500", false);
/////ztmend
}
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
}
else
{
this.isrole.Value = "0";
}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt;
if (this.hy_name.Value != "")
{
if (this.txtdeptid.Value == "")
{
dt = Hyoa_user.GetusersbynameforCX(this.hy_name.Value);
}
else
{
dt = Hyoa_user.GetusersbydeptidforCX(this.txtdeptid.Value, this.hy_name.Value);
}
}
else
{
if (this.txtdeptid.Value == "")
{
//显示所有用户
dt = Hyoa_user.GetusersOrderbydeptsortandusersort();
}
else
{
//按部门ID显示
dt = Hyoa_user.Getusersbydeptid(this.txtdeptid.Value);
}
}
DataTable tempTable = dt.Clone();
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
