protected void Page_Load(object sender, EventArgs e)
{
string lsyear = "";
if (this.Request.QueryString["lsyear"] != null)
{
lsyear = this.Request.QueryString["lsyear"].ToString();
}
HyoaClass.DAO db = new HyoaClass.DAO();
//本年已年休天数
string lssql1 = "select sum(convert(float,hy_field2) ) from hyp_flowmain where hy_mudelid='qjsq' and hy_tableid='d4af25f1-c7c0-4df9-a3b4-2c968ec3f2bc' and hy_curtacheid='**' and hy_field1='年休假' and hy_djrid='" + this.Session["hyuid"].ToString() + "' and hy_field3='"+lsyear+"'";
//可年休天数
string lssql2 = "select hy_field36 from hyp_flowmain where hy_mudelid='modulenxjwh' and hy_tableid='ed3f3e1b-1c2c-49b4-91de-5bcc35b83ffa' and hy_field1='" + this.Session["hyuid"].ToString() + "' and hy_field3='" + lsyear + "'";
DataTable dt1 = db.GetDataTable(lssql1);
DataTable dt2 = db.GetDataTable(lssql2);
string lsstr1 = "0";
string lsstr2 = "0";
if (dt1.Rows.Count > 0)
{
lsstr1 = dt1.Rows[0][0].ToString();
}
if (dt2.Rows.Count > 0)
{
lsstr2 = dt2.Rows[0][0].ToString();
}
this.Response.Write(lsstr1 + "#" + lsstr2);
//return ;
}
//获取投票数量的比例
public string GetItemproportion(string pis_xxid, Boolean bl)
{
string rValue;
HyoaClass.DAO db = new HyoaClass.DAO();
//总参与投票数
double ls_tpall;
string ls_sql1 = " Select * from hyk_whzx_tpgl_tpmx where hy_tpztid ='" + this.txtdocid.Value + "' ";
DataTable dt1 = db.GetDataTable(ls_sql1);
ls_tpall = dt1.Rows.Count;
//得到某一个选项投票数
double ls_tpxx;
string ls_sql2 = " Select * from hyk_whzx_tpgl_tpmx where hy_tpztid ='" + this.txtdocid.Value + "' and hy_tpxxid ='" + pis_xxid + "' ";
DataTable dt2 = db.GetDataTable(ls_sql2);
ls_tpxx = dt2.Rows.Count;
double ls_num = 0.0;
if (ls_tpxx != 0)
{
ls_num = (ls_tpxx / ls_tpall) * 100;
}
if (bl)
{
rValue = ls_num.ToString("#0.#0") + "%";
}
else
{
rValue = ls_num.ToString("#0.#0");
}
dt1.Clear();
dt2.Clear();
db.Close();
return rValue;
}
protected void Page_Load(object sender, EventArgs e)
{
string lsyear = "";
if (this.Request.QueryString["lsyear"] != null)
{
lsyear = this.Request.QueryString["lsyear"].ToString();
}
HyoaClass.DAO db = new HyoaClass.DAO();
//本年已加班天数
string lssql1 = "select sum(convert(float,hy_field16)) from hyp_flowmain where hy_mudelid='jbsq' and ";
lssql1 += " hy_tableid='c980c86b-da0c-4758-b3d8-7236240c77da' and hy_curtacheid='**' and ";
lssql1 += " hy_djrid='" + this.Session["hyuid"].ToString() + "' and datename(year,hy_field31)='" + lsyear + "'";
//已调休天数
string lssql2 = "select sum(convert(float,hy_field2)) from hyp_flowmain where hy_mudelid='qjsq' and ";
lssql2 += " hy_tableid='d4af25f1-c7c0-4df9-a3b4-2c968ec3f2bc' and hy_curtacheid='**' and hy_field1='调休' and ";
lssql2 += " hy_djrid='" + this.Session["hyuid"].ToString() + "' and hy_field3='" + lsyear + "'";
DataTable dt1 = db.GetDataTable(lssql1);
DataTable dt2 = db.GetDataTable(lssql2);
string lsstr1 = "0";
string lsstr2 = "0";
if (dt1.Rows.Count > 0)
{
lsstr1 = dt1.Rows[0][0].ToString();
}
if (dt2.Rows.Count > 0)
{
lsstr2 = dt2.Rows[0][0].ToString();
}
this.Response.Write(lsstr1 + "#" + lsstr2);
//return ;
}
//部门信息得分
public string GetDF(string deptname)
{
string ls_temp = deptname;
string lsif = "";
HyoaClass.DAO db = new HyoaClass.DAO();
if (this.hy_djsj_start_1.Value != "")
{
lsif += " and CONVERT(varchar(10), hy_field31, 120)>='" + this.hy_djsj_start_1.Value + "' ";
}
if (this.hy_djsj_end_1.Value != "")
{
lsif += " and CONVERT(varchar(10), hy_field31, 120)<='" + this.hy_djsj_end_1.Value + "' ";
}
string strSelect = "select * from hyt_user d left join hyp_flowmain m on d.hy_username=m.hy_field6 left join hyt_dept n on n.hy_deptid=d.hy_deptid where m.hy_mudelid='xxgl' and m.hy_tableid='f1265875-5494-465f-ac33-6fa43d208c8f' " + lsif + " and n.hy_deptname='" + ls_temp + "' order by d.hy_deptid,d.hy_sort";
double tt = 0;
DataTable dt = db.GetDataTable(strSelect);
if (dt.Rows.Count != 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tt += double.Parse(dt.Rows[i]["hy_field9"].ToString());
}
}
return tt.ToString();
}
protected void btnscsj_Click_gzjcb(object sender, EventArgs e)
{
//工作检查表
HyoaClass.DAO db = new HyoaClass.DAO();
string sql = "select * from hyp_flowmain where hy_mudelid='djgz' and hy_tableid='0e5efe98-49a5-4ccd-9532-8cac74ab328d' ";
if (this.hy_field9_1.Value != "")
sql += " and hy_field9 like '%" + this.hy_field9_1.Value + "%' ";
if (this.hy_djsj_start_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) <= '" + this.hy_djsj_end_1.Value + "' ";
sql += " and (hy_field8='委员会' or hy_field8='党员大会' or hy_field8='党课' or hy_field8='其它组织生活') order by hy_field31 asc ";
//this.Response.Write(sql);
DataTable dt = db.GetDataTable(sql);
string lsstr = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
lsstr += (i + 1).ToString() + "~" + System.DateTime.Parse(dt.Rows[i]["hy_field31"].ToString()).ToShortDateString() + "~" + dt.Rows[i]["hy_field7"].ToString();
lsstr += "~" + dt.Rows[i]["hy_field37"].ToString() + "~" + dt.Rows[i]["hy_field38"].ToString() + "~" + dt.Rows[i]["hy_field8"].ToString() + "：" + dt.Rows[i]["hy_bt"].ToString();
lsstr += "#*";
}
this.hy_count.Text = dt.Rows.Count.ToString();
this.hy_scsj.Text = lsstr;
this.Response.Write("<script>alert('生成完成，请点击导出按钮！');</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_mudelid="";
string ls_tableid = "";
string ls_value = "";
if (this.Request.QueryString["mudelid"] != null)
{
ls_mudelid = this.Request.QueryString["mudelid"].ToString();
}
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
}
if (this.Request.QueryString["lsvalue"] != null)
{
ls_value = this.Request.QueryString["lsvalue"].ToString(); //物品名称
}
HyoaClass.DAO db = new HyoaClass.DAO();
string lssql = "select hy_field3 from hyp_flowmain where hy_mudelid='" + ls_mudelid + "' and hy_tableid='" + ls_tableid + "' and hy_field2='" + ls_value + "'";
DataTable dt = db.GetDataTable(lssql);
this.Response.Write(dt.Rows[0]["hy_field3"].ToString());
//return ;
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_value1 = "";
string ls_value2 = "";
if (this.Request.QueryString["lsvalue1"] != null)
{
ls_value1 = this.Request.QueryString["lsvalue1"].ToString(); //类别
}
if (this.Request.QueryString["lsvalue2"] != null)
{
ls_value2 = this.Request.QueryString["lsvalue2"].ToString(); //年份
}
//Response.Write(ls_value2);
HyoaClass.DAO db = new HyoaClass.DAO();
string lssql = "select hy_field37 from hyp_flowmain where hy_mudelid='Mudellsh' and hy_field1='" + ls_value1 + "' and hy_field2='" + ls_value2 + "' order by hy_field36";
//Response.Write(lssql);
DataTable dt = db.GetDataTable(lssql);
if (dt.Rows.Count > 0)
{
this.Response.Write(dt.Rows[0][0].ToString());
}
else
{
this.Response.Write("1");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() =="")
this.Response.Redirect("/login.aspx");
if (!IsPostBack)
{
string lstr = "";
HyoaClass.DAO db = new HyoaClass.DAO();
string lssql = "select * from hyp_flowmain where hy_mudelid = 'clgl' and hy_tableid='0b5c53fe-114b-4fa3-8b59-4163b3053504'";
if (this.Request.QueryString["startdate"] != null)
{
if (this.Request.QueryString["startdate"].ToString() != "")
{
lssql += " and hy_field31>='" + this.Request.QueryString["startdate"].ToString() + "'";
}
}
if (this.Request.QueryString["enddate"] != null)
{
if (this.Request.QueryString["enddate"].ToString() != "")
{
lssql += " and hy_field31<='" + this.Request.QueryString["enddate"].ToString() + "'";
}
}
if (this.Request.QueryString["hy_field1"] != null)
{
if (this.Request.QueryString["hy_field1"].ToString() != "")
{
lssql += " and hy_field1 like '%" + this.Request.QueryString["hy_field1"].ToString() + "%'";
}
}
lssql += " order by hy_field31 desc";
DataTable dt = db.GetDataTable(lssql);
for (int i = 0; i < dt.Rows.Count; i++)
{
lstr += "<TR >";
lstr += "<td >" + dt.Rows[i]["hy_field1"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field2"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field3"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field4"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field5"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field6"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field7"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field8"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field9"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field10"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field11"].ToString() + "</td>";
lstr += "<td >" + dt.Rows[i]["hy_field12"].ToString() + "</td>";
lstr += "</tr>";
}
this.lbltr.Text = lstr;
db.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_mudelid="";
string ls_tableid = "";
string ls_value = "";
if (this.Request.QueryString["mudelid"] != null)
{
ls_mudelid = this.Request.QueryString["mudelid"].ToString();
}
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
}
if (this.Request.QueryString["lsvalue"] != null)
{
ls_value = this.Request.QueryString["lsvalue"].ToString(); //物品名称
}
HyoaClass.DAO db = new HyoaClass.DAO();
//string lssql = "select b.hy_deptname,a.hy_officetel,a.hy_mobile,a.hy_virtualnumber,a.hy_userid,a.hy_post,a.hy_hometel from hyt_user as a ,hyt_dept as b where a.hy_username='******' and a.hy_deptid=b.hy_deptid";
string lssql = "select * from hyt_user as a ,hyt_dept as b where a.hy_username='******' and a.hy_deptid=b.hy_deptid";
DataTable dt = db.GetDataTable(lssql);
if (dt.Rows.Count > 0)
{
string lssql2 = "select * from hyt_user_detail where hy_userid='" + dt.Rows[0]["hy_userid"].ToString() + "'";
DataTable dt2 = db.GetDataTable(lssql2);
if (dt2.Rows.Count > 0)
{
this.Response.Write(dt.Rows[0]["hy_deptname"].ToString() + "#" + dt.Rows[0]["hy_officetel"].ToString() + "#" + dt.Rows[0]["hy_mobile"].ToString() + "#" + dt.Rows[0]["hy_virtualnumber"].ToString() + "#" + dt.Rows[0]["hy_userid"].ToString() + "#" + dt.Rows[0]["hy_post"].ToString() + "#" + dt.Rows[0]["hy_hometel"].ToString() + "#" + dt2.Rows[0]["hy_xb"].ToString() + "#" + dt2.Rows[0]["hy_zzmm"].ToString() + "#" + dt2.Rows[0]["hy_xl"].ToString());
}
else
{
this.Response.Write(dt.Rows[0]["hy_deptname"].ToString() + "#" + dt.Rows[0]["hy_officetel"].ToString() + "#" + dt.Rows[0]["hy_mobile"].ToString() + "#" + dt.Rows[0]["hy_virtualnumber"].ToString() + "#" + dt.Rows[0]["hy_userid"].ToString() + "#" + dt.Rows[0]["hy_post"].ToString() + "#" + dt.Rows[0]["hy_hometel"].ToString() + "###");
}
}
else
{
this.Response.Write("");
}
db.Close();
//return ;
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("/login.aspx");
string ls_tip = "保存成功！";
//新文档时
string lscolunid = "", sql = "";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.DAO db = new HyoaClass.DAO();
if (this.txtselcolid.Value =="")
{
Response.Write("<script>alert('请选择查询的字段！');window.location.href = window.location.href;</script>");
return;
}
if (this.txtop.Value == "add")
{
//判断是否重复
string sql1 = "select * from hyt_searchconfig where hy_mudelid='" + this.ddlmudelid.SelectedValue + "' and hy_tableid='" + this.ddltableid.SelectedValue + "'";
DataTable dt = db.GetDataTable(sql1);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该模块已添加，请修改！');window.location.href = window.location.href;</script>");
return;
}
lscolunid = Hyoa_global.GetRandom();
sql = "insert into hyt_searchconfig (ID,hy_mudelid,hy_tableid,hy_sort,hy_columnshowid,hy_columnshow,hy_ifsearch,hy_xszdid,hy_xszd,hy_kckry,hy_kckryid) values (";
sql += "'" + lscolunid + "','" + this.ddlmudelid.SelectedValue + "','" + this.ddltableid.SelectedValue + "'," + float.Parse(this.txtsort.Text) + "";
sql += ",'" + this.txtselcolid.Value + "','" + this.txtselcol.Value + "','" + this.ddlifsearch.SelectedValue + "'";
sql += ",'" + this.txtselsearchid.Value + "','" + this.txtselsearch.Value + "','" + this.hy_field41_1.Value + "','" + this.hy_field43_1.Value + "')";
db.Execute(sql);
}
else
{
sql = "update hyt_searchconfig set hy_mudelid='" + this.ddlmudelid.SelectedValue + "', hy_tableid='" + this.ddltableid.SelectedValue + "',";
sql += "hy_sort=" + float.Parse(this.txtsort.Text) + ",hy_columnshowid='" + this.txtselcolid.Value + "',hy_columnshow='" + this.txtselcol.Value + "',";
sql += " hy_ifsearch='" + this.ddlifsearch.SelectedValue + "',hy_xszdid='" + this.txtselsearchid.Value + "',hy_xszd='" + this.txtselsearch.Value + "', ";
sql += " hy_kckry='" + this.hy_field41_1.Value + "',hy_kckryid='" + this.hy_field43_1.Value + "' where ID='" + this.txtdocid.Value + "'";
db.Execute(sql);
}
db.Close();
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
private void DataPlay(int PageNo)
{
//得到当前页号
HyoaClass.DAO db = new HyoaClass.DAO();
string sql = "";
sql = "select * from hyp_flowmain where hy_mudelid='clgl' and hy_tableid='a7c3875f-d6c8-4c9d-819b-e5e84a6bd79f' ";
sql += " order by hy_field1 ";
DataTable dt = db.GetDataTable(sql);
DataTable tempTable = dt.Clone();
DataColumn col1 = new DataColumn("lcs", typeof(String));
tempTable.Columns.Add(col1);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//根据车牌号去查找这辆车的里程数的记录
string lsdateend;
string ls_sqllc = "select sum(hy_field36) from hyp_flowmain where hy_mudelid='clgl' and hy_tableid='8b10b316-98d6-4a50-bc15-52745bb119bb' and hy_field5='" + dt.Rows[i]["hy_field1"].ToString()+"' ";
if (this.hy_djsj_start_1.Value!="")
{
ls_sqllc = ls_sqllc + " and hy_djsj>='" + this.hy_djsj_start_1.Value + "' ";
}
if (this.hy_djsj_end_1.Value != "")
{
lsdateend = this.hy_djsj_end_1.Value;
DateTime dts = Convert.ToDateTime(lsdateend);
DateTime date_effect = dts.AddDays(1);//加一天
ls_sqllc = ls_sqllc + " and hy_djsj<='" + date_effect.ToString("yyyy-MM-dd").ToString() + "' ";
}
DataTable dt_gettoday = db.GetDataTable(ls_sqllc);
if (dt_gettoday.Rows.Count > 0)
{
dr["lcs"] = dt_gettoday.Rows[0][0];
}
tempTable.Rows.Add(dr);
}
DataView dv = new DataView();
dv.Table = tempTable;
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.rptlist.DataSource = dv;
this.rptlist.DataBind();
dt.Clear();
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() =="")
this.Response.Redirect("/login.aspx");
if (!IsPostBack)
{
if (this.Request.QueryString["mid"] != null)
{
this.txtmudelid.Value = Request.QueryString["mid"].ToString();
}
else
{
this.Response.Write("<script>alert('模块ID没有传入，请联系管理员！');</script>");
return;
}
if (this.Request.QueryString["tableid"] != null)
{
this.txttableid.Value = Request.QueryString["tableid"].ToString();
}
else
{
this.Response.Write("<script>alert('表单ID没有传入，请联系管理员！');</script>");
return;
}
//加车牌号下拉信息
HyoaClass.DAO clgldb = new HyoaClass.DAO();
string lsclglsql = "select hy_field1 from hyp_flowmain where hy_mudelid='clgl' and hy_tableid='a7c3875f-d6c8-4c9d-819b-e5e84a6bd79f'";
DataTable dtclgl = clgldb.GetDataTable(lsclglsql);
if (dtclgl.Rows.Count > 0)
{
this.hy_field1_1.DataSource = dtclgl;
this.hy_field1_1.DataTextField = "hy_field1";
this.hy_field1_1.DataValueField = "hy_field1";
this.hy_field1_1.DataBind();
this.hy_field1_1.Items.Insert(0, new ListItem("", ""));
this.hy_field1_1.SelectedIndex = 0;
//this.ddlmudelid.Items.Insert(0, new ListItem(lsmudel, lsmudelid));
}
//经费类别下拉信息
this.hy_field3_1.Items.Insert(0, "");
this.hy_field3_1.Items.Insert(1, "保养经费");
this.hy_field3_1.Items.Insert(2, "维护经费");
this.hy_field3_1.Items.Insert(3, "汽油经费");
this.txturl.Text = this.Request.RawUrl;
DataPlay(1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_temp = "";
if (this.Request.QueryString["ls_txtdocid"] != null)
{
ls_temp = this.Request.QueryString["ls_txtdocid"].ToString();
}
HyoaClass.DAO db = new HyoaClass.DAO();
string sql = "select * from hyp_flowmain where hy_mudelid='rsgl' and hy_tableid='6047076e-6a95-4fb8-aec8-5551d3900590' and docid='" + ls_temp + "'";
DataTable dt = db.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
this.Response.Write(dt.Rows[0]["hy_field11"].ToString());
}
}
//判断是否已经投票过
public string pdsftpg(string pis_id)
{
string rValue = "<font color='red'>我要投票</font>";
HyoaClass.DAO db = new HyoaClass.DAO();
string sql1 = "select * from hyk_whzx_tpgl_tpmx where hy_tpztid='" + pis_id + "' and hy_tprid='" + this.Session["hyuid"].ToString() + "' ";
DataTable dt = db.GetDataTable(sql1);
if (dt.Rows.Count > 0)
{
rValue = "已投票";
}
string sql2 = "select * from hyk_whzx_tpgl where id='" + pis_id + "'";
DataTable dt2 = db.GetDataTable(sql2);
if (dt2.Rows.Count > 0)
{
if (dt2.Rows[0]["hy_gjzt"].ToString() == "结束投票")
{
rValue = "<font color='bule'>结束投票</font>";
}
}
dt.Clear();
dt2.Clear();
db.Close();
return rValue;
}
private void DataPlay()
{
HyoaClass.DAO db = new HyoaClass.DAO();
string ls_html = "";
float ls_sum = 0;
String[] v_ids = this.txtids.Value.Split(',');
for (var i = 0; i < v_ids.Length; i++)
{
//根据ID得到信息
string ls_sql = "select * from hyp_flowmain where DOCID='" + v_ids[i] + "'";
DataTable dt = db.GetDataTable(ls_sql);
if (dt.Rows.Count > 0)
{
string ls_spyj = dt.Rows[0]["hy_content2"].ToString();
ls_spyj = ls_spyj.Replace("<br>","");
ls_spyj = ls_spyj.Replace(" ", " ");
//ls_spyj = ls_spyj.Replace(" ", "");
ls_spyj = ls_spyj.Replace("）", "）<br>");
string ls_spyj2 = dt.Rows[0]["hy_content3"].ToString();
ls_spyj2 = ls_spyj2.Replace("<br>", "");
ls_spyj2 = ls_spyj2.Replace(" ", " ");
//ls_spyj = ls_spyj.Replace(" ", "");
ls_spyj2 = ls_spyj2.Replace("）", "）<br>");
ls_html += "<tr onMouseOver=\"this.className='tr-over'\" onmouseout=\"this.className='TrList_ciq'\" class=\"TrList_ciq\">";
ls_html += "<td width=\"5%\" height=\"28\" align=\"center\">" + (i + 1) + "</td>";
ls_html += "<td width=\"8%\" align=\"center\">" + dt.Rows[0]["hy_djrname"].ToString() + "</td>";
ls_html += "<td width=\"8%\" align=\"center\">" + dt.Rows[0]["hy_djrbmname"].ToString() + "</td>";
ls_html += "<td width=\"8%\" align=\"center\">" + DateTime.Parse(dt.Rows[0]["hy_djsj"].ToString()).ToString("yyyy-MM-dd") + "</td>";
ls_html += "<td width=\"8%\" align=\"center\">" + dt.Rows[0]["hy_field16"].ToString() + "</td>";
ls_html += "<td width=\"8%\" align=\"center\">" + dt.Rows[0]["hy_bt"].ToString() + "</td>";
ls_html += "<td width=\"8%\" align=\"center\">" + dt.Rows[0]["hy_field1"].ToString() + "</td>";
ls_html += "<td width=\"8%\" align=\"center\">" + dt.Rows[0]["hy_field99"].ToString() + "</td>";
ls_html += "<td width=\"12%\" align=\"center\">" + dt.Rows[0]["hy_content1"].ToString() + "</td>";
ls_html += "<td width=\"27%\" align=\"left\">" + ls_spyj + ls_spyj2 + "</td>";
ls_html += "</tr>";
ls_sum += float.Parse(dt.Rows[0]["hy_field99"].ToString());
}
}
this.lblsum.Text = "合计总额：" + ls_sum.ToString("f2");
this.lblhtml.Text = ls_html;
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_value = "";
if (this.Request.QueryString["lsvalue"] != null)
{
ls_value = this.Request.QueryString["lsvalue"].ToString();
}
HyoaClass.DAO db = new HyoaClass.DAO();
string lssql = "select * from hyt_user as a ,hyt_dept as b where a.hy_username='******' and a.hy_deptid=b.hy_deptid";
DataTable dt = db.GetDataTable(lssql);
string ls_str = "";
if (dt.Rows.Count > 0)
{
ls_str = dt.Rows[0]["hy_deptname"].ToString() + "," + dt.Rows[0]["hy_deptid"].ToString();
}
this.Response.Write(ls_str);
db.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
//生成省侨办的用户及密码
HyoaClass.DAO db = new HyoaClass.DAO();
String lssql = "select * from hyt_user where 1=1 order by hy_userid";
DataTable dt = db.GetDataTable(lssql);
this.Response.Write("<table border='1'>");
Random Random1 = new Random();
int i1;
String lspassword = "";
String lssqlupdate = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
this.Response.Write("<tr>");
this.Response.Write("<td>");
this.Response.Write("登录名");
this.Response.Write("</td>");
this.Response.Write("<td>");
this.Response.Write(dt.Rows[i]["hy_userid"].ToString());
this.Response.Write("</td>");
this.Response.Write("<td>");
this.Response.Write("中文名");
this.Response.Write("</td>");
this.Response.Write("<td>");
this.Response.Write(dt.Rows[i]["hy_username"].ToString());
this.Response.Write("</td>");
this.Response.Write("<td>");
this.Response.Write("密码");
this.Response.Write("</td>");
this.Response.Write("<td>");
i1 = Random1.Next(100000, 999999);
this.Response.Write(i1.ToString());
this.Response.Write("</td>");
this.Response.Write("</tr>");
lspassword = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(i1.ToString(), "MD5");
lssqlupdate = "update hyt_user set hy_pwd='" + lspassword + "' where hy_userid='" + dt.Rows[i]["hy_userid"].ToString() + "'";
db.Execute(lssqlupdate);
}
this.Response.Write("</table>");
}
protected void Page_Load(object sender, EventArgs e)
{
HyoaClass.DAO db = new HyoaClass.DAO();
string lssql = "select hy_field1 from hyp_flowmain where hy_mudelid='grtxl_fl' and hy_tableid='c1d7829d-ce46-498c-bec9-f0cc84c39c4a' and hy_djrid='" + this.Session["hyuid"].ToString() + "' order by hy_field2 asc";
DataTable dt = db.GetDataTable(lssql);
string ls_return = "";
if (dt.Rows.Count > 0)
{
for(var i=0;i<dt.Rows.Count;i++)
{
if (ls_return == "")
ls_return = dt.Rows[i][0].ToString();
else
ls_return += ","+dt.Rows[i][0].ToString();
}
}
this.Response.Write(ls_return);
//return ;
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_mudelid="";
string ls_tableid = "";
string ls_value = "";
if (this.Request.QueryString["mudelid"] != null)
{
ls_mudelid = this.Request.QueryString["mudelid"].ToString();
}
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
}
if (this.Request.QueryString["lsvalue"] != null)
{
ls_value = this.Request.QueryString["lsvalue"].ToString(); //物品名称
}
HyoaClass.DAO db = new HyoaClass.DAO();
string lssql = "select hy_field37,hy_field38 from hyp_flowmain where hy_mudelid='" + ls_mudelid + "' and hy_tableid='" + ls_tableid + "' and hy_field1='" + ls_value + "'";
DataTable dt = db.GetDataTable(lssql);
//是否包含小数点，包含的话，取小数点后两位
string lsgetputfiled; //价格（单价
if (dt.Rows[0][0].ToString().Contains(".") == true)
{
lsgetputfiled = float.Parse(dt.Rows[0][0].ToString()).ToString("F2");
}
else
{
lsgetputfiled = float.Parse(dt.Rows[0][0].ToString()).ToString();
}
this.Response.Write(lsgetputfiled + "," + dt.Rows[0][1].ToString());
//return ;
}
//添加候选项
protected void btn_add1_Click(object sender, EventArgs e)
{
HyoaClass.DAO db = new HyoaClass.DAO();
string ls_sql = "";
int ls_sort = 1;
//通过问卷题目ID得到最大排序号
ls_sql = "select max(hy_sort) as hy_sort,count(*) as num from hyk_whzx_tpgl_tpxx where hy_tpztid='" + this.txtdocid.Value + "' order by hy_sort desc ";
DataTable dt = db.GetDataTable(ls_sql);
if (dt.Rows[0]["num"].ToString() != "0")
{
ls_sort = System.Int32.Parse(dt.Rows[0]["hy_sort"].ToString()) + 1;
}
dt.Clear();
ls_sql = "insert into hyk_whzx_tpgl_tpxx (id,hy_tpztid,hy_tpxxmc,hy_sort) values (";
ls_sql += "'" + System.Guid.NewGuid().ToString() + "','" + this.txtdocid.Value + "','" + this.hy_hxx.Value + "'," + ls_sort + "";
ls_sql += ")";
db.Execute(ls_sql);
savetj("准备投票");
//处理完成后的提示及跳转(增加刷新候选项功能)
Response.Write("<script>window.location='main_tpgl.aspx?op=modify&id=" + this.txtdocid.Value + "&url=" + this.txturl.Value + "'</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
if(Request.QueryString["key"]!=null)
{
string ls_key = "";
ls_key = Request.QueryString["key"].ToString();
DataTable dt;
string sql = "select * from hyt_user where hy_userid like '%" + ls_key + "%'";
HyoaClass.DAO db = new HyoaClass.DAO();
dt = db.GetDataTable(sql);
string ls_name = "";
this.Response.Write("<div align=left id=sampleLayer style=\"position:absolute; top:130px; left:240px; width:250px; height:100px; background:#EEEEEE; overflow:scroll; border: 1px solid #919191; font-family:Verdana; font-size:8pt\">");
for (int i = 0; i < dt.Rows.Count; i++)
{
ls_name = ls_name + dt.Rows[i]["hy_userid"].ToString();
this.Response.Write("<li><a href=\"#\" onclick=\"if(document.forms[0].txthy_jsrname.value==''){document.forms[0].txthy_jsrname.value='" + dt.Rows[i]["hy_username"].ToString() + "';document.forms[0].txthy_jsrid.value='" + dt.Rows[i]["hy_userid"].ToString() + "';}else{document.forms[0].txthy_jsrname.value=document.forms[0].txthy_jsrname.value+'+" + dt.Rows[i]["hy_username"].ToString() + "';document.forms[0].txthy_jsrid.value=document.forms[0].txthy_jsrid.value+'+" + dt.Rows[i]["hy_userid"].ToString() + "';} document.all('sampleLayer').style.visibility='hidden'; \">" + dt.Rows[i]["hy_username"].ToString() + "</a></li>");
}
this.Response.Write("</div>");
db.Close();
return;
}
}
//得到某一个字段的HTML
//pi_flag 0:不赋值 1：需赋值
//ifsearch:是否查询时使用 0:非查询时使用 1:查询时使用
public string GetFieldHtml(string hy_mudelid, string hy_fieldid, string pi_flag, string hy_tableid, string ifsearch)
{
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(hy_mudelid, hy_fieldid, hy_tableid);
HyoaClass.DAO db = new HyoaClass.DAO();
string lsField = "";
string field_css = "";
string field_value = "";
string field_functionhy_onclick = "";
string field_functionhy_ondblclick = "";
string field_functionhy_onchange = "";
string field_functionhy_onkeydown = "";
string field_functionhy_onkeyup = "";
if (dtfield.Rows.Count > 0)
{
//得到该字段的样式start
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
if (ifsearch == "0")
field_css += " readonly ";
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
field_css += " class='" + dtfield.Rows[0]["hy_class"].ToString() + "' ";
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
field_css += " style='width:" + dtfield.Rows[0]["hy_width"].ToString() + ";";
}
else
{
field_css += " style='";
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
field_css += " height:" + dtfield.Rows[0]["hy_height"].ToString() + "'";
}
else
{
field_css += "'";
}
//默认值
//默认值取值的方式,查询时不使用默认值
if (ifsearch == "0")
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "")
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "0")
field_value += dtfield.Rows[0]["hy_defaultvalue"].ToString();
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "1")
{
DataTable dtdefault = db.GetDataTable(dtfield.Rows[0]["hy_defaultvalue"].ToString());
if (dtdefault.Rows.Count > 0)
field_value += dtdefault.Rows[0][0].ToString();
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "2")
{
field_value += Session[dtfield.Rows[0]["hy_defaultvalue"].ToString()].ToString();
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "3")
{
if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
field_value += System.DateTime.Now.ToShortDateString();
else
field_value += System.DateTime.Now.ToString();
}
}
}
//事件
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
field_functionhy_onclick += " onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
field_functionhy_ondblclick += " ondblclick=\"" + dtfield.Rows[0]["hy_ondblclick"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
field_functionhy_onchange += " onchange=\"" + dtfield.Rows[0]["hy_onchange"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
field_functionhy_onkeydown += " onkeydown=\"" + dtfield.Rows[0]["hy_onkeydown"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
field_functionhy_onkeyup += " onkeyup=\"" + dtfield.Rows[0]["hy_onkeyup"].ToString() + "\" ";
}
//得到该字段的样式end
string field_type = dtfield.Rows[0]["hy_fieldtype"].ToString();
//单行文本
if (field_type == "文本")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + " value=\"" + field_value + "\">";
}
//多行文本
if (field_type == "多行文本")
{
lsField = "<textarea name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_css + " >" + field_value + "</textarea>";
}
//日期
if (field_type == "日期")
{
if (ifsearch == "0")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + field_value + "\">";
}
else
{
field_css = " style='width:47%;'";
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" " + "onclick=\"WdatePicker({el:$dp.$('" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1')})\"" +field_css + " value=\"" + field_value + "\">至";
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" " +"onclick=\"WdatePicker({el:$dp.$('" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1')})\"" +field_css + " value=\"" + field_value + "\">";
}
}
//数值
if (field_type == "数值")
{
if (ifsearch == "0")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + " value=\"" + field_value + "\">";
}
else
{
field_css = " style='width:47%;'";
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + " value=\"" + field_value + "\">到";
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + " value=\"" + field_value + "\">";
}
}
//对话框列表（下拉框
if (field_type == "对话框列表")
{
lsField = "<select name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onchange + field_css + "> ";
//有哪些选项
lsField += "<option value=''></option>";
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
lsField += "<option value='" + lv_options[ii].ToString() + "'>" + lv_options[ii].ToString() + "</option>";
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
lsField += "<option value='" + dtoptions.Rows[ii][0].ToString() + "'>" + dtoptions.Rows[ii][0].ToString() + "</option>";
}
}
}
lsField += "</select>";
}
//复选框
if (field_type == "复选框")
{
//有哪些选项
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
if (field_value == lv_options[ii].ToString())
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=checkbox checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=checkbox id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
if (field_value == dtoptions.Rows[ii][0].ToString())
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=checkbox checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=checkbox id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
}
}
}
}
//单选框
if (field_type == "单选框")
{
//有哪些选项
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
if (field_value == lv_options[ii].ToString())
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=radio checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=radio id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
if (field_value == dtoptions.Rows[ii][0].ToString())
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=radio checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=radio id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
}
}
}
}
//口令
if (field_type == "口令")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=password id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + field_value + "\">";
}
//附件组件
if (field_type == "附件组件")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_css + " value=\"" + "\"><input type=button id=\"uploadfile1\" text='附件' class=\"text1\" onclick=\"window.open('/ggdy/uploadfile.aspx?id=" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "');\" ";
}
//说明文字
if (field_type == "说明文字")
{
lsField = "<span id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\">" + field_value + "</span>";
}
//编辑器文本
//if (field_type.Equals("ewebeditor"))
//{
// tfile.setField(field_name, field_value);
//}
db.Close();
}
return lsField;
}
private void DataPlay(int PageNo)
{
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.DAO db = new HyoaClass.DAO();
string sql = "";
sql = "select * from hyp_flowmain where hy_mudelid='" + this.txtmudelid.Value + "' and hy_tableid='" + this.txttableid.Value + "' ";
if (this.hy_djrname_1.Value != "")
sql += " and hy_djrname like '%" + this.hy_djrname_1.Value + "%' ";
if (this.hy_bt_1.Value != "")
sql += " and hy_bt like '%" + this.hy_bt_1.Value + "%' ";
sql += " order by hy_djsj desc ";
DataTable dt = db.GetDataTable(sql);
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();
}
//打开文档显示
private void DataPlay()
{
if (this.Request.QueryString["op"] != null)
{
HyoaClass.DAO db = new HyoaClass.DAO();
this.txtop.Value = this.Request.QueryString["op"].ToString(); //我要投票还是查看投票
this.txtdocid.Value = this.Request.QueryString["id"].ToString(); //文档ID
//我要投票
if (this.Request.QueryString["op"] == "add")
{
//判断是否已经投票过
string issql = "select * from hyk_whzx_tpgl_tpmx where hy_tpztid='" + this.txtdocid.Value + "' and hy_tprid ='" + Session["hyuid"].ToString() + "'";
DataTable isdt = db.GetDataTable(issql);
if (isdt.Rows.Count > 0)
{
Response.Write("<script>alert('您已经投票了！');window.location='list_tpgl_wytp.aspx'</script>");
}
//显示我要投票
this.btn_submit.Visible = true;
}
//根据id得到信息
string sql = "select * from hyk_whzx_tpgl where id='" + this.txtdocid.Value + "'";
DataTable dt = db.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
#region 根据id得到信息
this.txtdjr.Value = dt.Rows[0]["hy_djr"].ToString();
this.txtdjrid.Value = dt.Rows[0]["hy_djrid"].ToString();
this.hy_lbl1.Text = System.DateTime.Parse(dt.Rows[0]["hy_djsj"].ToString()).ToString("yyyy-MM-dd");
this.hy_lbl2.Text = dt.Rows[0]["hy_tplb"].ToString();
this.hy_lbl3.Text = System.DateTime.Parse(dt.Rows[0]["hy_tpkssj"].ToString()).ToString("yyyy-MM-dd");
this.hy_lbl4.Text = System.DateTime.Parse(dt.Rows[0]["hy_tpjssj"].ToString()).ToString("yyyy-MM-dd");
this.hy_lbl5.Text = dt.Rows[0]["hy_xxsm"].ToString();
this.hy_lbl6.Text = dt.Rows[0]["hy_bt"].ToString();
//判断该投票是否已经过期
if (Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd")) > Convert.ToDateTime(this.hy_lbl4.Text))
{
//将该文档设为“结束投票”
string ls_sql = "update hyk_whzx_tpgl set hy_jssj=getdate(),hy_gjzt='结束投票' where id='" + this.txtdocid.Value + "'";
db.Execute(ls_sql);
Response.Write("<script>alert('对不起，该投票已经结束！');window.location='list_tpgl_wytp.aspx'</script>");
return;
}
//根据单选或多选得到选项
this.hy_tpfs.Value = dt.Rows[0]["hy_ktxx"].ToString(); //单选还是多选
string lssql = "select * from hyk_whzx_tpgl_tpxx where hy_tpztid='" + this.txtdocid.Value + "'";
DataTable dt2 = db.GetDataTable(lssql);
if (this.hy_tpfs.Value == "多选")
{
this.GridView1.Visible = false;
GridView2.DataSource = dt2;
GridView2.DataBind();
}
else
{
this.GridView2.Visible = false;
GridView1.DataSource = dt2;
GridView1.DataBind();
}
dt2.Clear();
#endregion
}
dt.Clear();
db.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_mudelid="";
string ls_colname="";
string ls_colid="";
string ls_colname2="";
string ls_colid2="";
string ls_colname3="";
string ls_colid3="";
string ls_tableid = "";
if (this.Request.QueryString["mudelid"] != null)
{
ls_mudelid = this.Request.QueryString["mudelid"].ToString();
}
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
}
//模块对应的域
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dt4 = Hyoa_flowfield.GetflowfieldsbyMudelidAndTableid(ls_mudelid, ls_tableid);
if (dt4.Rows.Count > 0)
{
for (int i = 0; i < dt4.Rows.Count; i++)
{
if (ls_colname == "")
{
ls_colname = dt4.Rows[i]["hy_fieldname"].ToString();
ls_colid = dt4.Rows[i]["hy_fieldid"].ToString();
}
else
{
ls_colname = ls_colname + "+" + dt4.Rows[i]["hy_fieldname"].ToString();
ls_colid = ls_colid + "+" + dt4.Rows[i]["hy_fieldid"].ToString();
}
}
}
dt4.Clear();
string lsid = "";
//HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
//dt4 = Hyoa_listconfig.GetlistconfigsbyMudelidAndTableid(ls_mudelid,ls_tableid);
HyoaClass.DAO db = new HyoaClass.DAO();
string sql = "select *from hyt_searchconfig where hy_mudelid='" + ls_mudelid + "' and hy_tableid='" + ls_tableid + "'";
dt4 = db.GetDataTable(sql);
if (dt4.Rows.Count > 0)
{
ls_colname2 = dt4.Rows[0]["hy_columnshow"].ToString();
ls_colid2 = dt4.Rows[0]["hy_columnshowid"].ToString();
lsid = dt4.Rows[0]["ID"].ToString();
ls_colname3 = dt4.Rows[0]["hy_xszd"].ToString();
ls_colid3 = dt4.Rows[0]["hy_xszdid"].ToString();
}
dt4.Clear();
//HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
//dt4 = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndListid(ls_mudelid,lsid);
//if (dt4.Rows.Count > 0)
//{
// for (int k = 0; k < dt4.Rows.Count; k++)
// {
// if (ls_colname3 == "")
// {
// ls_colname3 = dt4.Rows[k]["hy_field"].ToString();
// ls_colid3 = dt4.Rows[k]["hy_fieldid"].ToString();
// }
// else
// {
// ls_colname3 = ls_colname3 + "+" + dt4.Rows[k]["hy_field"].ToString();
// ls_colid3 = ls_colid3 + "+" + dt4.Rows[k]["hy_fieldid"].ToString();
// }
// }
//}
//HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
//this.Response.Write(ls_colname + "*" + ls_colid + "#" + ls_colname2 + "*" + ls_colid2);
this.Response.Write(ls_colname + "*" + ls_colid + "#" + ls_colname2 + "*" + ls_colid2 + "#" + ls_colname3 + "*" + ls_colid3);
//return ;
}
protected void btnscsj_Click_tzml(object sender, EventArgs e)
{
//台账目录
HyoaClass.DAO db = new HyoaClass.DAO();
//得到支部概况
string sql = "select * from hyp_flowmain where hy_mudelid='djgz' and hy_tableid='0e5efe98-49a5-4ccd-9532-8cac74ab328d' and hy_field8='支部概况' ";
if (this.hy_field9_1.Value != "")
sql += " and hy_field9 like '%" + this.hy_field9_1.Value + "%' ";
if (this.hy_djsj_start_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) <= '" + this.hy_djsj_end_1.Value + "' ";
sql += " order by hy_djsj asc ";
DataTable dt = db.GetDataTable(sql);
string lsstr = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (lsstr == "")
{
lsstr = dt.Rows[i]["hy_bt"].ToString();
}
else
{
lsstr += "~"+dt.Rows[i]["hy_bt"].ToString();
}
}
//this.hy_count.Text = dt.Rows.Count.ToString();
this.hy_scsj.Text = lsstr;
//得到思想建设方面
sql = "select * from hyp_flowmain where hy_mudelid='djgz' and hy_tableid='0e5efe98-49a5-4ccd-9532-8cac74ab328d' and hy_field12='思想建设方面' ";
if (this.hy_field9_1.Value != "")
sql += " and hy_field9 like '%" + this.hy_field9_1.Value + "%' ";
if (this.hy_djsj_start_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) <= '" + this.hy_djsj_end_1.Value + "' ";
sql += " order by hy_djsj asc ";
dt.Clear();
dt = db.GetDataTable(sql);
lsstr = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (lsstr == "")
{
lsstr = dt.Rows[i]["hy_bt"].ToString();
}
else
{
lsstr += "~" + dt.Rows[i]["hy_bt"].ToString();
}
}
//this.hy_count.Text += "*#" + dt.Rows.Count.ToString();
this.hy_scsj.Text += "*#" + lsstr;
//得到组织建设方面
sql = "select * from hyp_flowmain where hy_mudelid='djgz' and hy_tableid='0e5efe98-49a5-4ccd-9532-8cac74ab328d' and hy_field12='组织建设方面' ";
if (this.hy_field9_1.Value != "")
sql += " and hy_field9 like '%" + this.hy_field9_1.Value + "%' ";
if (this.hy_djsj_start_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) <= '" + this.hy_djsj_end_1.Value + "' ";
sql += " order by hy_djsj asc ";
dt.Clear();
dt = db.GetDataTable(sql);
lsstr = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (lsstr == "")
{
lsstr = dt.Rows[i]["hy_bt"].ToString();
}
else
{
lsstr += "~" + dt.Rows[i]["hy_bt"].ToString();
}
}
//this.hy_count.Text += "*#" + dt.Rows.Count.ToString();
this.hy_scsj.Text += "*#" + lsstr;
//得到作风建设方面
sql = "select * from hyp_flowmain where hy_mudelid='djgz' and hy_tableid='0e5efe98-49a5-4ccd-9532-8cac74ab328d' and hy_field12='作风建设方面' ";
if (this.hy_field9_1.Value != "")
sql += " and hy_field9 like '%" + this.hy_field9_1.Value + "%' ";
if (this.hy_djsj_start_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) <= '" + this.hy_djsj_end_1.Value + "' ";
sql += " order by hy_djsj asc ";
dt.Clear();
dt = db.GetDataTable(sql);
lsstr = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (lsstr == "")
{
lsstr = dt.Rows[i]["hy_bt"].ToString();
}
else
{
lsstr += "~" + dt.Rows[i]["hy_bt"].ToString();
}
}
//this.hy_count.Text += "*#" + dt.Rows.Count.ToString();
this.hy_scsj.Text += "*#" + lsstr;
//得到制度建设方面
sql = "select * from hyp_flowmain where hy_mudelid='djgz' and hy_tableid='0e5efe98-49a5-4ccd-9532-8cac74ab328d' and hy_field12='制度建设方面' ";
if (this.hy_field9_1.Value != "")
sql += " and hy_field9 like '%" + this.hy_field9_1.Value + "%' ";
if (this.hy_djsj_start_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) <= '" + this.hy_djsj_end_1.Value + "' ";
sql += " order by hy_djsj asc ";
dt.Clear();
dt = db.GetDataTable(sql);
lsstr = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (lsstr == "")
{
lsstr = dt.Rows[i]["hy_bt"].ToString();
}
else
{
lsstr += "~" + dt.Rows[i]["hy_bt"].ToString();
}
}
//this.hy_count.Text += "*#" + dt.Rows.Count.ToString();
this.hy_scsj.Text += "*#" + lsstr;
//得到反腐倡廉建设方面
sql = "select * from hyp_flowmain where hy_mudelid='djgz' and hy_tableid='0e5efe98-49a5-4ccd-9532-8cac74ab328d' and hy_field12='反腐倡廉建设方面' ";
if (this.hy_field9_1.Value != "")
sql += " and hy_field9 like '%" + this.hy_field9_1.Value + "%' ";
if (this.hy_djsj_start_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and CONVERT(varchar(10),hy_field31,120) <= '" + this.hy_djsj_end_1.Value + "' ";
sql += " order by hy_djsj asc ";
dt.Clear();
dt = db.GetDataTable(sql);
lsstr = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (lsstr == "")
{
lsstr = dt.Rows[i]["hy_bt"].ToString();
}
else
{
lsstr += "~" + dt.Rows[i]["hy_bt"].ToString();
}
}
//this.hy_count.Text += "*#" + dt.Rows.Count.ToString();
this.hy_scsj.Text += "*#" + lsstr;
//this.hy_scsj.Text = lsstr;
this.Response.Write("<script>alert('生成完成，请点击导出按钮！');</script>");
}
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
//{
// this.tddeldoc.Visible = true; //删除
//}
//else
//{
// this.tddeldoc.Visible = false; //删除
//}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
//DataTable dt;
//dt = Hyoa_dbsy.Getdbsys_yb(Session["hyuid"].ToString());
DataTable dt;
string lssql22 = "Select * from hyt_dbsy where hy_ifyb=1 and hy_property='待办' and hy_dbrid='" + Session["hyuid"].ToString() + "' ";
if (this.txtbt.Text != "")
{
lssql22 += " and hy_bt like '%" + this.txtbt.Text + "%'";
}
lssql22 += " order by hy_createtime desc";
HyoaClass.DAO db = new HyoaClass.DAO();
dt = db.GetDataTable(lssql22);
DataTable tempTable = dt.Clone();
DataColumn col = new DataColumn("mudelname", typeof(String));
tempTable.Columns.Add(col);
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];
}
//根据模块ID得到模块名称
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(dt.Rows[i]["hy_mudelid"].ToString());
if(dt_mudel.Rows.Count>0)
dr["mudelname"] = dt_mudel.Rows[0]["hy_mudelname"].ToString();
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();
}
protected void btnImport_Click(object sender, EventArgs e)
{
String sql;
sql = "";
if (this.lblDisplay.Text == "")
{
this.lblReturnInformation.Text = "请先保存Excel文件!";
}
else
{
sql = "";
sql = " select 姓名,日期,签到时间,签退时间,是否旷工,例外情况,部门 from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=''" + this.lblDisplay.Text + "'';User ID=admin;Password=;Extended properties=Excel 5.0')...Sheet1$ ";
HyoaClass.DAO db = new HyoaClass.DAO();
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt = db.GetDataTable(sql);
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dtuser;
for (int j = 0; j < dt.Rows.Count; j++)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
Hyoa_flowmain.DOCID = Hyoa_global.GetRandom();
Hyoa_flowmain.hy_mudelid = "kqgl";
Hyoa_flowmain.hy_tableid = "74e7e280-4fc5-4ccb-be3d-0f995ac2c934";
Hyoa_flowmain.hy_flowid = "";
Hyoa_flowmain.hy_flowname = "";
Hyoa_flowmain.hy_curtacheid = "";
Hyoa_flowmain.hy_curtachename = "";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
dtuser = Hyoa_user.GetusersbynameforCX(dt.Rows[j]["姓名"].ToString());
if (dtuser.Rows.Count > 0)
{
Hyoa_flowmain.hy_djrid = dtuser.Rows[0]["hy_userid"].ToString();
Hyoa_flowmain.hy_djrbmid = dtuser.Rows[0]["hy_deptid"].ToString();
}
else
{
Hyoa_flowmain.hy_djrid = "";
Hyoa_flowmain.hy_djrbmid = "";
}
Hyoa_flowmain.hy_djrname = dt.Rows[j]["姓名"].ToString();
Hyoa_flowmain.hy_djrbmname = dt.Rows[j]["部门"].ToString();
Hyoa_flowmain.hy_djsj = System.DateTime.Now.ToString();
Hyoa_flowmain.hy_bt = "";
Hyoa_flowmain.hy_content1 = "";
Hyoa_flowmain.hy_content2 = "";
Hyoa_flowmain.hy_content3 = "";
Hyoa_flowmain.hy_content4 = "";
Hyoa_flowmain.hy_content5 = "";
Hyoa_flowmain.hy_content6 = "";
Hyoa_flowmain.hy_content7 = "";
Hyoa_flowmain.hy_content8 = "";
Hyoa_flowmain.hy_content9 = "";
Hyoa_flowmain.hy_content10 = "";
Hyoa_flowmain.hy_content11 = "";
Hyoa_flowmain.hy_content12 = "";
Hyoa_flowmain.hy_content13 = "";
Hyoa_flowmain.hy_content14 = "";
Hyoa_flowmain.hy_content15 = "";
Hyoa_flowmain.hy_field1 = dt.Rows[j]["签到时间"].ToString();
Hyoa_flowmain.hy_field2 = dt.Rows[j]["签退时间"].ToString();
if (dt.Rows[j]["是否旷工"].ToString() == "True")
{
Hyoa_flowmain.hy_field3 = "是";
}
else
{
Hyoa_flowmain.hy_field3 = "";
}
Hyoa_flowmain.hy_field4 = dt.Rows[j]["例外情况"].ToString();
Hyoa_flowmain.hy_field5 = "";
Hyoa_flowmain.hy_field6 = "";
Hyoa_flowmain.hy_field7 = "";
Hyoa_flowmain.hy_field8 = "";
Hyoa_flowmain.hy_field9 = "";
Hyoa_flowmain.hy_field10 = "";
Hyoa_flowmain.hy_field11 = "";
Hyoa_flowmain.hy_field12 = "";
Hyoa_flowmain.hy_field13 = "";
Hyoa_flowmain.hy_field14 = "";
Hyoa_flowmain.hy_field15 = "";
Hyoa_flowmain.hy_field16 = "";
Hyoa_flowmain.hy_field17 = "";
Hyoa_flowmain.hy_field18 = "";
Hyoa_flowmain.hy_field19 = "";
Hyoa_flowmain.hy_field20 = "";
Hyoa_flowmain.hy_field21 = "";
Hyoa_flowmain.hy_field22 = "";
Hyoa_flowmain.hy_field23 = "";
Hyoa_flowmain.hy_field24 = "";
Hyoa_flowmain.hy_field25 = "";
Hyoa_flowmain.hy_field26 = "";
Hyoa_flowmain.hy_field27 = "";
Hyoa_flowmain.hy_field28 = "";
Hyoa_flowmain.hy_field29 = "";
Hyoa_flowmain.hy_field30 = "";
Hyoa_flowmain.hy_field31 = dt.Rows[j]["日期"].ToString(); ;
Hyoa_flowmain.hy_field32 = "";
Hyoa_flowmain.hy_field33 = "";
Hyoa_flowmain.hy_field34 = "";
Hyoa_flowmain.hy_field35 = "";
Hyoa_flowmain.hy_field36 = 0;
Hyoa_flowmain.hy_field37 = 0;
Hyoa_flowmain.hy_field38 = 0;
Hyoa_flowmain.hy_field39 = 0;
Hyoa_flowmain.hy_field40 = 0;
Hyoa_flowmain.hy_field41 = "";
Hyoa_flowmain.hy_field42 = "";
Hyoa_flowmain.hy_field43 = "";
Hyoa_flowmain.hy_field44 = "";
Hyoa_flowmain.hy_field45 = "";
Hyoa_flowmain.hy_field46 = "";
Hyoa_flowmain.hy_field47 = "";
Hyoa_flowmain.hy_field48 = "";
Hyoa_flowmain.hy_field49 = "";
Hyoa_flowmain.hy_field50 = "";
Hyoa_flowmain.hy_field51 = "";
Hyoa_flowmain.hy_field52 = "";
Hyoa_flowmain.hy_field53 = "";
Hyoa_flowmain.hy_field54 = "";
Hyoa_flowmain.hy_field55 = "";
Hyoa_flowmain.hy_field56 = "";
Hyoa_flowmain.hy_field57 = "";
Hyoa_flowmain.hy_field58 = "";
Hyoa_flowmain.hy_field59 = "";
Hyoa_flowmain.hy_field60 = "";
Hyoa_flowmain.hy_field61 = "";
Hyoa_flowmain.hy_field62 = "";
Hyoa_flowmain.hy_field63 = "";
Hyoa_flowmain.hy_field64 = "";
Hyoa_flowmain.hy_field65 = "";
Hyoa_flowmain.hy_field66 = "";
Hyoa_flowmain.hy_field67 = "";
Hyoa_flowmain.hy_field68 = "";
Hyoa_flowmain.hy_field69 = "";
Hyoa_flowmain.hy_field70 = "";
Hyoa_flowmain.hy_field71 = 0;
Hyoa_flowmain.hy_field72 = 0;
Hyoa_flowmain.hy_field73 = 0;
Hyoa_flowmain.hy_field74 = 0;
Hyoa_flowmain.hy_field75 = 0;
Hyoa_flowmain.hy_field76 = 0;
Hyoa_flowmain.hy_field77 = 0;
Hyoa_flowmain.hy_field78 = 0;
Hyoa_flowmain.hy_field79 = 0;
Hyoa_flowmain.hy_field80 = 0;
Hyoa_flowmain.hy_field81 = 0;
Hyoa_flowmain.hy_field82 = 0;
Hyoa_flowmain.hy_field83 = 0;
Hyoa_flowmain.hy_field84 = 0;
Hyoa_flowmain.hy_field85 = 0;
Hyoa_flowmain.hy_field86 = 0;
Hyoa_flowmain.hy_field87 = 0;
Hyoa_flowmain.hy_field88 = 0;
Hyoa_flowmain.hy_field89 = 0;
Hyoa_flowmain.hy_field90 = 0;
Hyoa_flowmain.hy_field91 = 0;
Hyoa_flowmain.hy_field92 = 0;
Hyoa_flowmain.hy_field93 = 0;
Hyoa_flowmain.hy_field94 = 0;
Hyoa_flowmain.hy_field95 = 0;
Hyoa_flowmain.hy_field96 = 0;
Hyoa_flowmain.hy_field97 = 0;
Hyoa_flowmain.hy_field98 = 0;
Hyoa_flowmain.hy_field99 = 0;
Hyoa_flowmain.hy_field100 = 0;
Hyoa_flowmain.hy_iftx = "";
Hyoa_flowmain.hy_zhtxsj = "";
Hyoa_flowmain.hy_readuserlist = "";
Hyoa_flowmain.Insert();
}
db.Close();
this.lblReturnInformation.Text = "导入成功";
if (File.Exists(this.lblDisplay.Text))
{
System.IO.File.Delete(this.lblDisplay.Text);
}
}
}
private void DataPlay(int PageNo)
{
//得到当前模块对应的role
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
string ls_role = "Role9999";
if (dt_mudel.Rows.Count > 0)
ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString();
//判断当前用户是否有删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()) || Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.tddeldoc.Visible = true; //删除
}
else
{
this.isrole.Value = "0";
this.tddeldoc.Visible = false; //删除
}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.DAO db = new HyoaClass.DAO();
string ls_user = "";
if (this.Request.QueryString["user"] != null)
ls_user = this.Request.QueryString["user"].ToString();
string sql = "";
sql = "select * from hyp_flowmain where hy_mudelid='" + this.txtmudelid.Value + "' and hy_tableid='" + this.txttableid.Value + "' ";
sql += " and hy_field1='" + ls_user + "' and left(convert(char(7),getdate(),120),4)=left(convert(char(7),hy_field31,120),4) order by hy_field31 desc ";
DataTable dt = db.GetDataTable(sql);
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();
}
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_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();
lssql = "select sum(convert(float,hy_field9)) as fs,b.hy_deptname as hy_field6 from hyt_user as a,hyt_dept as b,hyp_flowmain as c where a.hy_deptid=b.hy_deptid and rtrim(ltrim(c.hy_field6))=a.hy_username and c.hy_mudelid='xxgl' and c.hy_tableid='f1265875-5494-465f-ac33-6fa43d208c8f' " + lsif + " group by b.hy_deptname";
DataTable dt = db.GetDataTable(lssql);
//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 + "至今";
}
dt.DefaultView.Sort = "fs desc";
DataTable dtTemp = dt.DefaultView.ToTable();
//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'>";
int n = 0;
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
//lscolor = lscolor.Substring(0, 9) + (i * 100).ToString() + "'";
if (System.Double.Parse(dtTemp.Rows[i]["fs"].ToString()) > 50)
{
lscolor = "color='FF0202'";
}
if (System.Double.Parse(dtTemp.Rows[i]["fs"].ToString()) > 20 && System.Double.Parse(dtTemp.Rows[i]["fs"].ToString()) <= 50)
{
lscolor = "color='FA01DA'";
}
if (System.Double.Parse(dtTemp.Rows[i]["fs"].ToString()) > 5 && System.Double.Parse(dtTemp.Rows[i]["fs"].ToString()) <= 20)
{
lscolor = "color='9002FD'";
}
if (System.Double.Parse(dtTemp.Rows[i]["fs"].ToString()) > 1 && System.Double.Parse(dtTemp.Rows[i]["fs"].ToString()) <= 5)
{
lscolor = "color='00FD65'";
}
//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='" + dtTemp.Rows[i]["hy_field6"].ToString() + "' value='" + dtTemp.Rows[i]["fs"].ToString() + "' " + lscolor + " />";
n++;
}
//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>";
string lsnlen = "";
lsnlen = (n * 115).ToString();
//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", lsnlen, "500", false);
/////ztmend
}