protected void btnLogin_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt = Hyoa_tableconfig.GetTables();
string sql = "";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//增加字段,先删除再添加
sql = "ALTER TABLE hyc_" + dt.Rows[i]["ID"].ToString();
sql += " ADD hy_clrylist text ";
Hyoa_global.ExcuteSQL(sql);
sql = "ALTER TABLE hyc_" + dt.Rows[i]["ID"].ToString();
sql += " ADD hy_cyrylist text ";
//Hyoa_global.ExcuteSQL(sql); //第一次要执行一下添加字段
//处理数据
sql = "select * from hyc_" + dt.Rows[i]["ID"].ToString();
DataTable dt2 = Hyoa_global.GetDataTable(sql);
if (dt2.Rows.Count > 0)
{
for (int j = 0; j < dt2.Rows.Count; j++)
{
//先置为,
sql = "update hyc_" + dt.Rows[i]["ID"].ToString() + " set hy_clrylist=',',hy_cyrylist=',' where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
Hyoa_global.ExcuteSQL(sql);
//再根据cl表更新
sql = "select * from hyp_flowhistoryinfo_cl where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
DataTable dt3 = Hyoa_global.GetDataTable(sql);
if (dt3.Rows.Count > 0)
{
for (int m = 0; m < dt3.Rows.Count; m++)
{
//得到初始值
sql = "select * from hyc_" + dt.Rows[i]["ID"].ToString() + " where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
DataTable dt4 = Hyoa_global.GetDataTable(sql);
string ls_value = dt4.Rows[0]["hy_clrylist"].ToString() + dt3.Rows[m]["hy_clrid"].ToString() + ",";
sql = "update hyc_" + dt.Rows[i]["ID"].ToString() + " set hy_clrylist='" + ls_value + "',hy_cyrylist=',' where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
//Response.Write(sql);
Hyoa_global.ExcuteSQL(sql);
}
}
}
}
}
}
Response.Write("更新完成");
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
if (!this.IsPostBack)
{
if (this.Request.QueryString["docid"] != null)
{
string ls_docid = this.Request.QueryString["docid"].ToString();
string ls_tableid = this.Request.QueryString["tableid"].ToString();
//根据文档ID得到记录
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string sql = "select * from hyc_" + ls_tableid + " where DOCID='" + ls_docid + "'";
DataTable dt = Hyoa_global.GetDataTable(sql);
string ls_flowid, ls_flowname, ls_mudelid, ls_curtacheid, ls_curtachename;
if (dt.Rows.Count > 0)
{
ls_flowid = dt.Rows[0]["hy_flowid"].ToString(); //流程ID
ls_flowname = dt.Rows[0]["hy_flowname"].ToString(); //流程名称
ls_mudelid = dt.Rows[0]["hy_mudelid"].ToString(); //模块ID
ls_curtacheid = dt.Rows[0]["hy_curtacheid"].ToString(); //当前环节ID
ls_curtachename = dt.Rows[0]["hy_curtachename"].ToString(); //当前环节名称
dt.Clear();
HyoaClass.Hyoa_cklc Hyoa_cklc_CurrnetDocFlow = new HyoaClass.Hyoa_cklc();
//制作表格式信息
this.txtCurrnetDocFlow.Value = Hyoa_cklc_CurrnetDocFlow.GetCurrnetDocFlow(ls_docid,ls_flowid,ls_flowname,ls_mudelid,ls_curtacheid,ls_curtachename);
//制作流程图
this.txtFlowXML.Value = Hyoa_cklc_CurrnetDocFlow.GetXmlBody(ls_docid, ls_flowid, ls_flowname, ls_mudelid, ls_curtacheid, ls_curtachename);
}
}
}
}
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.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string lssql = "select hyc_lsh from hyc_TableLsh where hyc_lb='" + ls_value1 + "' and hyc_nf='" + ls_value2 + "'";
//Response.Write(lssql);
DataTable dt = Hyoa_global.GetDataTable(lssql);
if (dt.Rows.Count > 0)
{
this.Response.Write(dt.Rows[0][0].ToString());
}
else
{
this.Response.Write("1");
}
}
private void DataPlay()
{
//label清空
int count = 1;
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string sqlSelect = " select hyc_gzzq from hyc_Tablezbgl where 1=1 ";
if (this.txt_tjz_s.Value != "")
{
sqlSelect += " and hy_djsj >= '" + this.txt_tjz_s.Value + "' ";
}
if (this.txt_tjz_e.Value != "")
{
sqlSelect += " and hy_djsj <='" + this.txt_tjz_e.Value + "' ";
}
sqlSelect += " GROUP BY hyc_gzzq ";
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
DataTable dt3;
if(dt.Rows.Count>0)
{
sqlSelect = " select hy_userid,hy_username from hyt_user ";
DataTable dt2 = Hyoa_global.GetDataTable_USER(sqlSelect);
for(int j=0;j<dt.Rows.Count;j++)
{
if(dt2.Rows.Count>0)
{
for (int i = 0; i < dt2.Rows.Count;i++ )
{
sqlSelect = " select * from hyc_Tablezbgl where 1=1 and hyc_gzzq='" + dt.Rows[j]["hyc_gzzq"].ToString() + "' and hy_djrid='" + dt2.Rows[i]["hy_userid"].ToString() + "' ";
dt3 = Hyoa_global.GetDataTable(sqlSelect);
if(dt3.Rows.Count==0)
{
Total++;
lb_show.Text += " <tr height=\"35px\"><td width=\"5%\" class=\"TdcellHead\"><p align=\"center\">" + Total + "</p></td>";
lb_show.Text += "<td width=\"25%\" class=\"TdcellHead\"><p align=\"center\">第" + dt.Rows[j]["hyc_gzzq"].ToString() + "周</p></td>";
lb_show.Text += " <td width=\"30%\" class=\"TdcellHead\"><p align=\"center\"> " + dt2.Rows[i]["hy_username"].ToString() + "</p> </td>";
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strDwmc = "";
string sqlSelect = "";
if (Request.QueryString["dwmc"] != null)
{
strDwmc = Request.QueryString["dwmc"].ToString();
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
List<DateTime> list = new List<DateTime>();
List<string> ls_key = new List<string>();
//合同表单id
string[] arryStr = new string[] { "Tablesyyhfwxy", "Tablejdhazfwht", "TableVODfwxy", "Tableffpdfwht", "TableDVBazfwdght", "Tablejwdsjsxy", "Tablejwdscsxy", "Tablekdjrht", "Tablesjcsfwht", "Tablesjgdcsfwht", "Tablesjtxyyhzxy", "Tablezdyht" };
//将所有表单的登记时间和DOCID Tableid放入集合中
for (int i = 0; i < arryStr.Length; i++)
{
sqlSelect = " select DOCID,hy_mudelid,hy_tableid,hy_djsj from hyc_" + arryStr[i] + " where hyc_jfmc='" + strDwmc + "' order by hy_djsj desc ";
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
//获取每个表单一个的表单id 表名 和登记时间
if (dt.Rows.Count > 0)
{
list.Add(Convert.ToDateTime(dt.Rows[0]["hy_djsj"].ToString()));
ls_key.Add(dt.Rows[0]["DOCID"].ToString() + "#" + dt.Rows[0]["hy_mudelid"].ToString() + "#" + dt.Rows[0]["hy_tableid"].ToString());
}
}
if ((list != null && list.Count > 0) && (ls_key != null && ls_key.Count > 0))
{
string temp_string = "";
DateTime temp_dateTime;
for (int m = 0; m < list.Count; m++)
{
for (int n = 0; n < list.Count - 1; n++)
{
if (list[n] < list[n + 1])
{
temp_dateTime = list[n];
list[n] = list[n + 1];
list[n + 1] = temp_dateTime;
temp_string = ls_key[n];
ls_key[n] = ls_key[n + 1];
ls_key[n + 1] = temp_string;
}
}
}
Response.Write(ls_key[0]);
}
else
{
Response.Write("空值");
}
}
protected void Button_Save_Getdt_Click(object sender, EventArgs e)
{
if (txtsql_getdt.Text != "")
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string sql = this.txtsql_getdt.Text;
DataTable dt = Hyoa_global.GetDataTable(sql);
lbldt.Text = "";
if (dt.Rows.Count > 0)
{
lbldt.Text = "<table width='100%' border='1'>";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
lbldt.Text += "<tr>";
lbldt.Text += "<td>";
lbldt.Text += "序号";
lbldt.Text += "</td>";
for (int k = 0; k < dt.Columns.Count; k++)
{
lbldt.Text += "<td>";
lbldt.Text += dt.Columns[k].ColumnName.ToString();
lbldt.Text += "</td>";
}
lbldt.Text += "</tr>";
}
lbldt.Text += "<tr>";
lbldt.Text += "<td>";
lbldt.Text += (i + 1).ToString();
lbldt.Text += "</td>";
for (int j = 0; j < dt.Columns.Count; j++)
{
lbldt.Text += "<td>";
if (dt.Rows[i][j].ToString() == "")
lbldt.Text += " ";
else
lbldt.Text += dt.Rows[i][j].ToString();
lbldt.Text += "</td>";
}
lbldt.Text += "</tr>";
}
lbldt.Text += "</table>";
}
}
else
{
Response.Write("<script>alert('请填写SQL语句');window.location='excutesql.aspx'</script>");
}
}
private void DataPlay()
{
string lsydry="";
if (this.Request.QueryString["docid"] != null)
{
string ls_docid = this.Request.QueryString["docid"].ToString();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string lssql = "select * from hyc_" + Request.QueryString["tableid"].ToString() + " where DOCID='" + ls_docid + "'";
DataTable dt = Hyoa_global.GetDataTable(lssql);
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
string lsusername = "";
if(dt.Rows.Count>0)
{
lsusername = "";
string[] lvhy_readuserlist;
string[] lvhy_readdatelist;
lvhy_readuserlist = dt.Rows[0]["hy_readuserlist"].ToString().Split(',');
lvhy_readdatelist = dt.Rows[0]["hy_readdatelist"].ToString().Split(',');
for (int j = 1; j < lvhy_readuserlist.Length; j++)
{
lsydry += "<TR height=27px>";
lsydry += "<TD align=\"center\" class=\"Tdcellright\">"+j.ToString()+"</TD>";
DataTable dtuser = Hyoa_user.Getuserallinfobyloginid(lvhy_readuserlist[j]);
if (dtuser.Rows.Count > 0)
{
lsusername = dtuser.Rows[0]["hy_username"].ToString();
}
else
{
lsusername = "******";
}
dtuser.Clear();
lsydry += "<TD align=\"center\" class=\"Tdcellright\">" + lsusername + "</TD>";
if (lvhy_readdatelist.Length > j)
{
lsydry += "<TD align=\"center\" class=\"Tdcellright\">" + lvhy_readdatelist[j] + "</TD>";
}
else
{
lsydry += "<TD align=\"center\" class=\"Tdcellright\"> </TD>";
}
lsydry += "</TR>";
}
}
this.lblydry.Text = lsydry;
}
}
//ntko_class db = new ntko_class();//实例ntko_class类
protected void Page_Load(object sender, EventArgs e)
{
//title = db.getdemotitle();
//attachpath = db.getattachpath();
title = "宁波合益";
newofficetype = Request.QueryString["newofficetype"];
HyoaClass.Hyoa_ntko Hyoa_ntko = new HyoaClass.Hyoa_ntko();
tableid="";
if (this.Request.QueryString["tableid"] != null)
{
tableid = this.Request.QueryString["tableid"].ToString();
}
if (this.Request.QueryString["fatherid"] != null)
{
fatherid = this.Request.QueryString["fatherid"].ToString();
DataTable dtfatherid = Hyoa_ntko.GetntkofileByfother(fatherid);
//this.Response.Write("<script>alert('" + dtfatherid.Rows.Count + "');</script>");
if (dtfatherid.Rows.Count > 0)
{
url = dtfatherid.Rows[0]["fid"].ToString();
DataTable dt = Hyoa_ntko.Getntkofile(url);
if (dt.Rows.Count > 0)
{
fileid = dt.Rows[0]["fid"].ToString();
filetitle = dt.Rows[0]["ftitle"].ToString();
fileother = dt.Rows[0]["fother"].ToString();
filename = dt.Rows[0]["fname"].ToString();
}
}
//隐藏控制(根据fatherid)
string ls_flowid = "";
string ls_currenttacheid = "";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string sql = "select * from hyc_" + tableid + " where DOCID='" + fatherid + "' ";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
if (dt_flowmain.Rows[0]["hy_curtacheid"].ToString() == "**")
ckhjbl.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strDocid = "";
if (Request.QueryString["strDocid"] != null)
{
strDocid = Request.QueryString["strDocid"].ToString();
}
string sqlSelect = " select hyc_dwmc from hyc_Tablekhda where docid='"+strDocid+"' ";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
Response.Write(dt.Rows[0]["hyc_dwmc"].ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string ls_fsrid = "";
string ls_fsrname = "";
string ls_jsrid = "";
string ls_jsrname = "";
string ls_content = "";
string ls_id = "";
string ls_txfs = "";
string lssql = "";
string ls_update = "";
lssql = "select * from hyp_wjcd where hy_type='收件' and hy_ifyhf='0' and hy_txstatus='0' ";
DataTable dt = Hyoa_global.GetDataTable(lssql);
if (dt.Rows.Count > 0)
{
for (var i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["hy_txfs"].ToString() != "")
{
System.TimeSpan ts = System.DateTime.Parse(dt.Rows[i]["hy_jzsj"].ToString()) - System.DateTime.Parse(System.DateTime.Now.ToString("yyyy-MM-dd"));
int day = ts.Days;
//距离一天且是下午进行提醒
if (day == 1)
{
//string.Compare(DateTime.Now.ToString("HH:mm").ToString(), "11:00") > 0 & string.Compare(DateTime.Now.ToString("HH:mm").ToString(), "13:00") < 0
if (string.Compare(DateTime.Now.ToString("HH:mm").ToString(), "14:00") > 0)
{
ls_fsrid = dt.Rows[i]["hy_fsrid"].ToString();
ls_fsrname = dt.Rows[i]["hy_fsrname"].ToString();
ls_jsrid = dt.Rows[i]["hy_jsrid"].ToString();
ls_jsrname = dt.Rows[i]["hy_jsrname"].ToString();
ls_content = "请尽快办理[工作联系单]-" + dt.Rows[i]["hy_title"].ToString();
ls_id = dt.Rows[i]["ID"].ToString();
ls_txfs = dt.Rows[i]["hy_txfs"].ToString();
hysendxx2(ls_fsrid, ls_fsrname,ls_jsrid, ls_jsrname, ls_content, ls_id, ls_txfs);
ls_update = "update hyp_wjcd set hy_txstatus='1' where hy_type='收件' and ID='" + ls_id + "' ";
Hyoa_global.ExcuteSQL(ls_update);
}
}
}
}
}
}
//查询
protected void Button_Save_Click(object sender, EventArgs e)
{
string ls_return = "";
if (txtsql.Value == "")
{
ls_return = "请填写查询语句";
}
if (ddldbconn.SelectedValue == "")
{
ls_return = "请选择连接";
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt = new DataTable();
if (ddldbconn.SelectedValue == "base")
{
dt = Hyoa_global.GetDataTable_BASE(txtsql.Value);
}
if (ddldbconn.SelectedValue == "pro")
{
dt = Hyoa_global.GetDataTable(txtsql.Value);
}
if (ddldbconn.SelectedValue == "user")
{
dt = Hyoa_global.GetDataTable_USER(txtsql.Value);
}
if (dt.Rows.Count > 0)
{
ls_return += "<table border=1 width='100%'>";
ls_return += "<tr>";
for (int j = 0; j < dt.Columns.Count; j++)
{
ls_return += "<td>" + dt.Columns[j].ToString() + "</td>";
}
ls_return += "</tr>";
for (int i = 0; i < dt.Rows.Count; i++)
{
ls_return += "<tr>";
for (int j = 0; j < dt.Columns.Count; j++)
{
ls_return += "<td>"+dt.Rows[i][dt.Columns[j].ToString()].ToString()+"</td>";
}
ls_return += "</tr>";
}
ls_return += "</table>";
}
lbljg.Text = ls_return;
}
protected void Page_Load(object sender, EventArgs e)
{
string sqlSelect = " select * from hyc_Tabletjjzr order by hyc_pxh desc ";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
string[] arryTjjzd = new string[] { };
string index = DateTime.Now.DayOfWeek.ToString();
int intTjjzd = Convert.ToInt32(dt.Rows[0]["hyc_tjjzd"].ToString());
if (dt.Rows[0]["hyc_tjjzd"].ToString().Contains('+'))
{
intTjjzd = Convert.ToInt32(dt.Rows[0]["hyc_tjjzd"].ToString()) - 1;
}
Response.Write(getJzrq(index, -intTjjzd));
}
}
protected void Page_Load(object sender, EventArgs e)
{
string lv_jfmc = "";
string lsShow = "";
if (Request.QueryString["ls_jfmc"] != null)
{
lv_jfmc = Request.QueryString["ls_jfmc"].ToString();
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string sqlSelect = " select * from hyc_Tablekhda where hyc_dwmc='" + lv_jfmc + "'";
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
lsShow += dt.Rows[0]["hyc_lxr"].ToString() + "#" + dt.Rows[0]["hyc_sj"].ToString() + "#" + dt.Rows[0]["hyc_dwdz"].ToString();
}
Response.Write(lsShow);
}
protected void Page_Load(object sender, EventArgs e)
{
hyoa = new HyoaClass.Hyoa_global();
string khdz = Request["selectValue"];
if (!string.IsNullOrEmpty(khdz))
{
string khxx = "";
string ls_sql = "SELECT * FROM hyc_Tablekhda WHERE hyc_dwmc = '" + khdz + "'";
DataTable dt= hyoa.GetDataTable(ls_sql);
if (dt.Rows.Count > 0)
{
khxx += ""+dt.Rows[0]["hyc_dwdz"].ToString()+"";
khxx += "|"+dt.Rows[0]["hyc_lxr"].ToString()+"";
khxx += "|"+dt.Rows[0]["hyc_sj"].ToString()+"";
}
Response.Write(khxx);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string SelectValue = "";
string lsShow = "";
if (Request.QueryString["selectValue"] != null)
{
SelectValue = Request.QueryString["selectValue"].ToString();
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string sqlSelect= " select hyc_bxlx from hyc_Tablebxlx where hyc_bxfw='"+SelectValue+"' ";
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if(dt.Rows.Count>0){
for (int i = 0; i < dt.Rows.Count;i++ )
{
lsShow += dt.Rows[i]["hyc_bxlx"].ToString() + "#";
}
}
Response.Write(lsShow);
}
private void getData(string lsTable)
{
StringBuilder strShow = new StringBuilder();
string sqlSelect = " select * from hyc_" + lsTable + " where hy_motherid='" + this.txtmotherid.Value + "' ";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
number++;
strShow.Append("<tr onmouseover=\"this.className='tr-over'\" onmouseout=\"this.className='TrList'\" class=\"TrList\">");
strShow.Append("<td width=\"5%\" height=\"22\" align=\"center\">" + (number) + "</td>");
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[i]["hyc_htbh"].ToString() + "</p></td>");
strShow.Append("<td width=\"30%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[i]["hyc_jfmc"].ToString() + "</p></td>");
if (dt.Rows[i]["hyc_htkssj"].ToString() == "")
{
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\"></p></td>");
}
else
{
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">" + Convert.ToDateTime(dt.Rows[i]["hyc_htkssj"].ToString()).ToString("yyyy-MM-dd") + "</p></td>");
}
if (dt.Rows[i]["hyc_htzzsj"].ToString() == "")
{
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\"></p></td>");
}
else
{
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">" + Convert.ToDateTime(dt.Rows[i]["hyc_htzzsj"].ToString()).ToString("yyyy-MM-dd") + "</p></td>");
}
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[i]["hyc_htje"].ToString() + "</p></td>");
// strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[i]["hyc_khlx"].ToString() + "</p></td>");
strShow.Append("<td width=\"5%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[i]["hyc_fzr"].ToString() + "</p></td>");
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">");
strShow.Append("<a href=\"#\" onclick=\"var ss='main_look.aspx?op=modify&mid=" + dt.Rows[i]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[i]["hy_tableid"].ToString() + "&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url='+window.location;window.open(ss);\">");
strShow.Append("查看</a> <a href=\"#\" onclick=\"var ss='main_flc.aspx?op=modify&mid=" + dt.Rows[i]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[i]["hy_tableid"].ToString() + "&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url='+window.location;window.open(ss);\">");
strShow.Append("操作</a></td></tr>");
}
}
this.lb_show.Text += strShow.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
string lsDocid = "";
string lsTable = "";
if (this.Request.QueryString["lsDocid"] != null)
{
lsDocid = this.Request.QueryString["lsDocid"].ToString();
}
if (this.Request.QueryString["lsTable"] !=null)
{
lsTable = this.Request.QueryString["lsTable"].ToString();
}
string sqlSelect = " select * from hyc_"+lsTable+" where docid='"+lsDocid+"' ";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if(dt.Rows.Count>0)
{
Response.Write(dt.Rows[0]["hyc_jfmc"].ToString() + "#" + dt.Rows[0]["hyc_htje"].ToString());
}
}
private void DataPlay()
{
//label清空
int count = 1;
string sqlSelect = " select * from hyc_Tablefpbd where hy_curtacheid='**' ";
if (this.txt_tjz_s.Value != "")
{
sqlSelect += " and left(CONVERT(varchar, hy_djsj, 120 ) ,10) >='" + this.txt_tjz_s.Value + "'";
}
if (this.txt_tjz_e.Value != "")
{
sqlSelect += " and left(convert(varchar,hy_djsj,120),10) <='"+this.txt_tjz_e.Value+"' ";
}
sqlSelect += " order by hy_djsj desc ";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
strShow.Append("<tr onmouseover=\"this.className='tr-over'\" onmouseout=\"this.className='TrList'\" class=\"TrList\">");
strShow.Append("<td width=\"5%\" class=\"TdcellHead\"><p align=\"center\">" + count + "</p></td>");
if (dt.Rows.Count > 0)
{
fpTotal++;
strShow.Append("<td width=\"20%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[i]["hyc_fptt"].ToString() + "</p></td>");
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[i]["hyc_bxje"].ToString() + "</p></td>");
fpjeTotal += Convert.ToDouble(dt.Rows[i]["hyc_bxje"].ToString());
}
strShow.Append("</tr>");
count++;
}
}
strShow.Append("<tr onmouseover=\"this.className='tr-over'\" onmouseout=\"this.className='TrList'\" class=\"TrList\">");
strShow.Append("<td width=\"5%\" class=\"TdcellHead\"><p align=\"center\">合计</p></td>");
strShow.Append("<td width=\"20%\" class=\"TdcellHead\"><p align=\"center\">" + fpTotal + "个发票</p></td>");
strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">发票金额合计："+fpjeTotal+"</p></td>");
this.lb_show.Text += strShow.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
//string ls_mudelid = "";
//string ls_tableid = "";
string ls_value1 = "";
string ls_value2 = "";
//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["lsvalue1"] != null)
{
ls_value1 = this.Request.QueryString["lsvalue1"].ToString(); //发文类型
}
if (this.Request.QueryString["lsvalue2"] != null)
{
ls_value2 = this.Request.QueryString["lsvalue2"].ToString(); //年份
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string lssql = "select hyc_lsh from hyc_Tablefwlsh where hyc_lb='" + ls_value1 + "' and hyc_nf='" + ls_value2 + "'";
//this.Response.Write(lssql);
DataTable dt = Hyoa_global.GetDataTable(lssql);
if (dt.Rows.Count > 0)
{
this.Response.Write(dt.Rows[0][0].ToString());
}
else
{
this.Response.Write("1");
}
//return ;
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_value1 = "";
if (this.Request.QueryString["lsvalue1"] != null)
{
ls_value1 = this.Request.QueryString["lsvalue1"].ToString(); //物品名称
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string lssql = "select hyc_dw,hyc_sl,hyc_dj from hyc_Tablekcxx where hyc_wzmc='" + ls_value1 + "'";
//this.Response.Write(lssql);
DataTable dt = Hyoa_global.GetDataTable(lssql);
if (dt.Rows.Count > 0)
{
this.Response.Write(dt.Rows[0][0].ToString() + "|" + dt.Rows[0][1].ToString() + "|" + dt.Rows[0][2].ToString());
}
else
{
this.Response.Write("1");
}
//return ;
}
private void DataPlay()
{
//文档ID
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
if (this.Request.QueryString["tableid"] != null)
{
this.txttableid.Text = this.Request.QueryString["tableid"].ToString();
}
if (this.Request.QueryString["flowid"] != null)
{
this.txtflowid.Text = this.Request.QueryString["flowid"].ToString();
}
if (this.Request.QueryString["tacheid"] != null)
{
this.txtcurtacheid.Text = this.Request.QueryString["tacheid"].ToString();
}
if (this.Request.QueryString["nexttacheids"] != null)
{
string pis_nexttacheids = this.Request.QueryString["nexttacheids"].ToString();
string pis_nexttachenames = this.Request.QueryString["nexttachenames"].ToString();
//-----条件流程的情况 start-----
//根据模块ID得到流程信息
DataTable dt = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.txtflowid.Text, this.txtcurtacheid.Text);
if (dt.Rows.Count > 0)
{
//给相应的域赋值
//当前环节
this.Hy_CurrTacheName_Show.Text = dt.Rows[0]["hy_curtachename"].ToString();
//后续环节
if (pis_nexttacheids != "")
{
string[] piv_nexttacheids = pis_nexttacheids.Split(',');
string[] piv_nexttachenames = pis_nexttachenames.Split(',');
for (var i = 0; i < piv_nexttacheids.Length; i++)
{
Hy_nexttachename.Items.Add(new ListItem(piv_nexttachenames[i], piv_nexttacheids[i]));
}
this.Hy_nexttachename.SelectedIndex = 0;
//得到 后续环节的默认环节 对应的 提醒默认值，然后进行赋值
string ls_temp_tacheid = piv_nexttacheids[0];
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_getrddoissendsmsandmsg = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.txtflowid.Text, ls_temp_tacheid);
if (dt_getrddoissendsmsandmsg.Rows.Count > 0)
{
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendSms"].ToString() == "是")
this.f_isSendsms_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendMessage"].ToString() == "是")
this.f_isSendjstx_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendSms"].ToString() == "是")
this.f_isSendsms_cyr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendMessage"].ToString() == "是")
this.f_isSendjstx_cyr.Checked = true;
this.txthy_ifshowcurcomp.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurcomp"].ToString();
this.txthy_ifshowcurdept.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurdept"].ToString();
}
}
}
dt.Clear();
//后序环节处理人部门
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
//先得到后续环节处理人集合
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
this.Hy_deptlist_clr.Items.Insert(0, "--请选择--");
ls_temp1 = "";
int t = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_deptid"].ToString() + ","))
{
}
else
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist_clr.Items.Insert(t, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_deptid"].ToString();
}
}
this.Hy_deptlist_clr.SelectedIndex = 0;
}
}
dt.Clear();
//后序环节传阅人部门
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
dt = Hyoa_dept.Getdepts();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist.Items.Insert(i, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
}
//this.Hy_deptlist.DataSource = dt;
//this.Hy_deptlist.DataTextField = "hy_deptname";
//this.Hy_deptlist.DataValueField = "hy_deptid";
//this.Hy_deptlist.DataBind();
this.Hy_deptlist.SelectedIndex = 0;
}
dt.Clear();
//后序环节处理人员
//先得到后续环节处理人集合
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
//后序环节传阅人员
dt = Hyoa_user.Getusersbydeptid(this.Hy_deptlist.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_rylist.DataSource = dt;
this.Hy_rylist.DataTextField = "hy_username";
this.Hy_rylist.DataValueField = "hy_userid";
this.Hy_rylist.DataBind();
//this.Hy_rylist.SelectedIndex = 0;
}
dt.Clear();
//-----条件流程的情况 end-----
}
else
{
//-----非条件流程的情况 start-----
//根据模块ID得到流程信息
DataTable dt = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.txtflowid.Text, this.txtcurtacheid.Text);
if (dt.Rows.Count > 0)
{
//给相应的域赋值
//当前环节
this.Hy_CurrTacheName_Show.Text = dt.Rows[0]["hy_curtachename"].ToString();
//后续环节
this.Hy_nexttachename.DataSource = dt;
this.Hy_nexttachename.DataTextField = "hy_nexttachename";
this.Hy_nexttachename.DataValueField = "hy_nexttacheid";
this.Hy_nexttachename.DataBind();
this.Hy_nexttachename.SelectedIndex = 0;
//得到 后续环节的默认环节 对应的 提醒默认值，然后进行赋值
string ls_temp_tacheid = dt.Rows[0]["hy_nexttacheid"].ToString();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_getrddoissendsmsandmsg = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.txtflowid.Text, ls_temp_tacheid);
if (dt_getrddoissendsmsandmsg.Rows.Count > 0)
{
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendSms"].ToString() == "是")
this.f_isSendsms_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendMessage"].ToString() == "是")
this.f_isSendjstx_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendSms"].ToString() == "是")
this.f_isSendsms_cyr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendMessage"].ToString() == "是")
this.f_isSendjstx_cyr.Checked = true;
this.txthy_ifshowcurcomp.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurcomp"].ToString();
this.txthy_ifshowcurdept.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurdept"].ToString();
}
}
dt.Clear();
//后序环节处理人部门
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
//先得到后续环节处理人集合
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
this.Hy_deptlist_clr.Items.Insert(0, "--请选择--");
ls_temp1 = "";
int t = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_deptid"].ToString() + ","))
{
}
else
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist_clr.Items.Insert(t, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_deptid"].ToString();
}
}
this.Hy_deptlist_clr.SelectedIndex = 0;
}
}
dt.Clear();
//后序环节传阅人部门
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
dt = Hyoa_dept.Getdepts();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist.Items.Insert(i, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
}
//this.Hy_deptlist.DataSource = dt;
//this.Hy_deptlist.DataTextField = "hy_deptname";
//this.Hy_deptlist.DataValueField = "hy_deptid";
//this.Hy_deptlist.DataBind();
this.Hy_deptlist.SelectedIndex = 0;
}
dt.Clear();
//后序环节处理人员
//先得到后续环节处理人集合
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql="";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
//后序环节传阅人员
dt = Hyoa_user.Getusersbydeptid(this.Hy_deptlist.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_rylist.DataSource = dt;
this.Hy_rylist.DataTextField = "hy_username";
this.Hy_rylist.DataValueField = "hy_userid";
this.Hy_rylist.DataBind();
//this.Hy_rylist.SelectedIndex = 0;
}
dt.Clear();
//-----非条件流程的情况 end-----
}
//----考虑只显示本单位的情况start-----
if (this.txthy_ifshowcurcomp.Text == "是")
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
ls_dept1 = ls_dept1.Substring(0, 3);
string ls_curdept = Session["hydeptid"].ToString();
ls_curdept = ls_curdept.Substring(0, 3);
if (ls_dept1 == ls_curdept)
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
dt.Clear();
}
}
//----考虑只显示本单位的情况end-------
//----考虑只显示和登记人同单位的情况start-----
if (this.txthy_ifshowcurcomp.Text == "和登记人同单位")
{
if (Request.QueryString["docid"] != null)
{
//得到登记人的部门ID
string ls_djrbmid = "";
string sql = "select * from hyc_" + this.txttableid.Text+" where DOCID='" + Request.QueryString["docid"].ToString()+"'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
ls_djrbmid = dt_flowmain.Rows[0]["hy_djrbmid"].ToString();
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1.Substring(0, 3) == ls_djrbmid.Substring(0, 3))
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
dt.Clear();
}
}
}
}
//----考虑只显示和登记人同单位的情况end-------
//----考虑只显示登记人的分管领导的情况start-----
if (this.txthy_ifshowcurcomp.Text == "登记人的分管领导")
{
if (Request.QueryString["docid"] != null)
{
//得到登记人的部门ID
string ls_djrbmid = "";
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
ls_djrbmid = dt_flowmain.Rows[0]["hy_djrbmid"].ToString();
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门(登记人的分管领导(部门ID前3位不一样后边一样))
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1.Substring(3) == ls_djrbmid.Substring(3))
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
dt.Clear();
}
}
}
}
//----考虑只显示登记人的分管领导的情况end-------
//----只显示登记人start-----
if (this.txthy_ifshowcurdept.Text == "只显示登记人")
{
if (Request.QueryString["docid"] != null)
{
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
//先清空
this.Hy_deptlist_clr.Items.Clear();
Hy_deptlist_clr.Items.Insert(0, new ListItem(dt_flowmain.Rows[0]["hy_djrbmname"].ToString(), dt_flowmain.Rows[0]["hy_djrbmid"].ToString()));
//先清空
this.Hy_hjclr.Items.Clear();
Hy_hjclr.Items.Insert(0, new ListItem(dt_flowmain.Rows[0]["hy_djrname"].ToString(), dt_flowmain.Rows[0]["hy_djrid"].ToString()));
}
}
}
//----只显示登记人end-------
//----只显示当前用户本部门人员start-----
if (this.txthy_ifshowcurdept.Text == "是")
{
if (Request.QueryString["docid"] != null)
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1 == Session["hydeptid"].ToString())
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
dt.Clear();
}
}
}
//----只显示当前用户本部门人员end-------
//----自动传阅 start------------
DataTable dt_zdcy = Hyoa_flowwork.Getflowworkbyflowidtacheidnexttacheid(this.txtflowid.Text, this.txtcurtacheid.Text, this.Hy_nexttachename.SelectedValue);
if (dt_zdcy.Rows.Count > 0)
{
if (dt_zdcy.Rows[0]["hy_zdcyuserids"] != null)
{
if (dt_zdcy.Rows[0]["hy_zdcyuserids"].ToString() != "")
{
int ii=0;
//自动加载
string[] lv_zdcyuserids = dt_zdcy.Rows[0]["hy_zdcyuserids"].ToString().Split(',');
for (int i = 0; i < lv_zdcyuserids.Length; i++)
{
//根据系统名得到中文名
DataTable dt_user = Hyoa_user.Getuserallinfobyloginid(lv_zdcyuserids[i]);
if (dt_user.Rows.Count > 0)
{
this.Hy_selectedcyr.Items.Insert(ii, new ListItem(dt_user.Rows[0]["hy_username"].ToString(), lv_zdcyuserids[i]));
ii = ii + 1;
}
}
}
}
}
//----自动传阅 end------------
}
protected void Hy_nexttachename_SelectedIndexChanged(object sender, EventArgs e)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//后序环节处理人部门
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt = new DataTable();
//先清空
this.Hy_deptlist_clr.DataSource = dt;
this.Hy_deptlist_clr.DataTextField = "hy_deptname";
this.Hy_deptlist_clr.DataValueField = "hy_deptid";
this.Hy_deptlist_clr.DataBind();
//先得到后续环节处理人集合
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
this.Hy_deptlist_clr.Items.Insert(0, "--请选择--");
ls_temp1 = "";
int t = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_deptid"].ToString() + ","))
{
}
else
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist_clr.Items.Insert(t, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_deptid"].ToString();
}
}
this.Hy_deptlist_clr.SelectedIndex = 0;
}
}
dt.Clear();
//后序环节传阅人员部门
//先清空
this.Hy_deptlist.DataSource = dt;
this.Hy_deptlist.DataTextField = "hy_deptname";
this.Hy_deptlist.DataValueField = "hy_deptid";
this.Hy_deptlist.DataBind();
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
dt = Hyoa_dept.Getdepts();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist.Items.Insert(i, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
}
this.Hy_deptlist.SelectedIndex = 0;
}
dt.Clear();
//后序环节处理人员
//先得到后续环节处理人集合
//先清空
this.Hy_hjclr.DataSource = dt;
this.Hy_hjclr.DataTextField = "hy_username";
this.Hy_hjclr.DataValueField = "hy_userid";
this.Hy_hjclr.DataBind();
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
//后序环节传阅人员
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
dt = Hyoa_user.Getusersbydeptid(this.Hy_deptlist.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_rylist.DataSource = dt;
this.Hy_rylist.DataTextField = "hy_username";
this.Hy_rylist.DataValueField = "hy_userid";
this.Hy_rylist.DataBind();
}
dt.Clear();
//得到 后续环节的默认环节 对应的 提醒默认值，然后进行赋值
string ls_temp_tacheid = this.Hy_nexttachename.SelectedValue.ToString();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_getrddoissendsmsandmsg = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.txtflowid.Text, ls_temp_tacheid);
if (dt_getrddoissendsmsandmsg.Rows.Count > 0)
{
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendSms"].ToString() == "是")
this.f_isSendsms_clr.Checked = true;
else
this.f_isSendsms_clr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendMessage"].ToString() == "是")
this.f_isSendjstx_clr.Checked = true;
else
this.f_isSendjstx_clr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendSms"].ToString() == "是")
this.f_isSendsms_cyr.Checked = true;
else
this.f_isSendsms_cyr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendMessage"].ToString() == "是")
this.f_isSendjstx_cyr.Checked = true;
else
this.f_isSendjstx_cyr.Checked = false;
this.txthy_ifshowcurcomp.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurcomp"].ToString();
this.txthy_ifshowcurdept.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurdept"].ToString();
}
//----考虑只显示本单位的情况start-----
if (this.txthy_ifshowcurcomp.Text == "是")
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
ls_dept1 = ls_dept1.Substring(0, 3);
string ls_curdept = Session["hydeptid"].ToString();
ls_curdept = ls_curdept.Substring(0, 3);
if (ls_dept1 == ls_curdept)
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
//先得到后续环节处理人集合
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
}
//----考虑只显示本单位的情况end-------
//----考虑只显示和登记人同单位的情况start-----
if (this.txthy_ifshowcurcomp.Text == "和登记人同单位")
{
if (Request.QueryString["docid"] != null)
{
//得到登记人的部门ID
string ls_djrbmid = "";
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
ls_djrbmid = dt_flowmain.Rows[0]["hy_djrbmid"].ToString();
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1.Substring(0, 3) == ls_djrbmid.Substring(0, 3))
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
}
}
}
//----考虑只显示和登记人同单位的情况end-------
//----考虑只显示登记人的分管领导的情况start-----
if (this.txthy_ifshowcurcomp.Text == "登记人的分管领导")
{
if (Request.QueryString["docid"] != null)
{
//得到登记人的部门ID
string ls_djrbmid = "";
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
ls_djrbmid = dt_flowmain.Rows[0]["hy_djrbmid"].ToString();
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1.Substring(3) == ls_djrbmid.Substring(3))
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
}
}
}
//----考虑只显示登记人的分管领导的情况end-------
//----只显示登记人start-----
if (this.txthy_ifshowcurdept.Text == "只显示登记人")
{
if (Request.QueryString["docid"] != null)
{
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
//先清空
this.Hy_deptlist_clr.Items.Clear();
Hy_deptlist_clr.Items.Insert(0, new ListItem(dt_flowmain.Rows[0]["hy_djrbmname"].ToString(), dt_flowmain.Rows[0]["hy_djrbmid"].ToString()));
//先清空
this.Hy_hjclr.Items.Clear();
Hy_hjclr.Items.Insert(0, new ListItem(dt_flowmain.Rows[0]["hy_djrname"].ToString(), dt_flowmain.Rows[0]["hy_djrid"].ToString()));
}
}
}
//----只显示登记人end-------
//----只显示当前用户本部门人员start-----
if (this.txthy_ifshowcurdept.Text == "是")
{
if (Request.QueryString["docid"] != null)
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1 == Session["hydeptid"].ToString())
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
}
}
//----只显示当前用户本部门人员end-------
}
private void DataPlay()
{
if (this.Request.QueryString["id"] != null)
{
this.txtid.Value = this.Request.QueryString["id"].ToString();
}
HyoaClass.Hyoa_wjcd Hyoa_wjcd = new HyoaClass.Hyoa_wjcd();
DataTable dt = Hyoa_wjcd.Getdoc(this.txtid.Value);
if (dt.Rows.Count > 0)
{
this.txtdocid.Value = dt.Rows[0]["DOCID"].ToString();
this.txtid.Value = dt.Rows[0]["ID"].ToString();
this.lblhy_fsrid.Text = dt.Rows[0]["hy_fsrid"].ToString();
this.txtfsrid.Text = dt.Rows[0]["hy_fsrid"].ToString();
this.lblhy_fsrname.Text = dt.Rows[0]["hy_fsrname"].ToString();
this.txtfrsname.Text = dt.Rows[0]["hy_fsrname"].ToString();
this.lblhy_datetime.Text = dt.Rows[0]["hy_datetime"].ToString();
this.txthy_jsrid.Text = dt.Rows[0]["hy_jsrid"].ToString();
this.lblhy_title.Text = dt.Rows[0]["hy_title"].ToString();
this.ddlhy_foldername.Text = dt.Rows[0]["hy_foldername"].ToString();
if (dt.Rows[0]["hy_jzsj"] == System.DBNull.Value)
{
this.jzsj.Text = "";
}
else
{
if (System.DateTime.Parse(dt.Rows[0]["hy_jzsj"].ToString()).ToShortDateString() == "1900-1-1")
{
this.jzsj.Text = "";
}
else
{
this.jzsj.Text = System.DateTime.Parse(dt.Rows[0]["hy_jzsj"].ToString()).ToShortDateString();
}
}
//附件
HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt();
DataTable dt_fileatt = Hyoa_fileatt.GetfileattByFatherid(this.txtdocid.Value);
if (dt_fileatt.Rows.Count > 0)
{
string ls_temp = "";
for (var i = 0; i < dt_fileatt.Rows.Count; i++)
{
ls_temp += (i + 1).ToString() + "、<a href='/" + dt_fileatt.Rows[i]["hy_filepath"].ToString() + "' target='_blank'>" + dt_fileatt.Rows[i]["hy_filename"].ToString() + "</a><br />";
}
this.lblhy_field2.Text = ls_temp;
}
//回复附件
DataTable dt_fileatt2 = Hyoa_fileatt.GetfileattByFatherid(this.txtid.Value);
if (dt_fileatt2.Rows.Count > 0)
{
string ls_temp = "";
for (var j = 0; j < dt_fileatt2.Rows.Count; j++)
{
ls_temp += (j + 1).ToString() + "、<a href='/" + dt_fileatt2.Rows[j]["hy_filepath"].ToString() + "' target='_blank'>" + dt_fileatt2.Rows[j]["hy_filename"].ToString() + "</a><br />";
}
this.lblhy_field3.Text = ls_temp;
}
this.lblhy_content1.Text = dt.Rows[0]["hy_body"].ToString();
//判断是否已回复
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string lshfsql = "select * from hyp_gzlxdhf where hy_jsrdocid='" + this.txtid.Value + "' ";
DataTable dt_hf = Hyoa_global.GetDataTable(lshfsql);
if (dt_hf.Rows.Count > 0)
{
this.txthfnr.Text = dt_hf.Rows[0]["hy_body"].ToString();
this.btn_submit.Visible = false;
}
else
{
this.txthfnr.Text = "已收到。";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
if (!IsPostBack)
{
String lstableid = "";
String lsmid = "";
String lsstartdate = "";
String lsenddate = "";
string strSql = "";
if (this.Request.QueryString["strSql"] != null)
{
strSql = Request.QueryString["strSql"].ToString();
}
if (this.Request.QueryString["tableid"] != null)
{
lstableid = Request.QueryString["tableid"].ToString();
}
if (this.Request.QueryString["mid"] != null)
{
lsmid = Request.QueryString["mid"].ToString();
}
if (this.Request.QueryString["startdate"] != null)
{
lsstartdate = Request.QueryString["startdate"].ToString();
}
if (this.Request.QueryString["enddate"] != null)
{
lsenddate = Request.QueryString["enddate"].ToString();
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//得到这个模块对应有哪些字段
//if (field_type == "文本" || field_type == "多行文本" || field_type == "文本加按钮" || field_type == "多行文本加按钮" || field_type == "日期" || field_type == "数值" || field_type == "对话框列表" || field_type == "复选框" || field_type == "单选框" || field_type == "口令" || field_type == "编辑器")
String lssqlfield = "select * from hyt_flowfield where hy_tableid='" + lstableid + "' and hy_mudelid='" + lsmid + "' and hy_ifhiddle='否' and (hy_fieldtype='文本' or hy_fieldtype='多行文本' or hy_fieldtype='文本加按钮' or hy_fieldtype='多行文本加按钮' or hy_fieldtype='日期' or hy_fieldtype='数值' or hy_fieldtype='对话框列表' or hy_fieldtype='复选框' or hy_fieldtype='单选框' or hy_fieldtype='口令' or hy_fieldtype='编辑器') order by hy_sort";
//Response.Write(lssqlfield);
//return;
DataTable dtfield = Hyoa_global.GetDataTable_BASE(lssqlfield);
String lsfieldid = "";
String lsfieldname = "";
String lsfieldidsub = "";
String lsfieldnamesub = "";
String lstableidsub = "";
String lsmudelidsub = "";
if (dtfield.Rows.Count > 0)
{
for (int i = 0; i < dtfield.Rows.Count; i++)
{
if (lsfieldid == "")
{
lsfieldid = "hyc_" + dtfield.Rows[i]["hy_fieldid"].ToString();
lsfieldname = dtfield.Rows[i]["hy_fieldname"].ToString();
}
else
{
lsfieldid += "," + "hyc_" + dtfield.Rows[i]["hy_fieldid"].ToString();
lsfieldname += "," + dtfield.Rows[i]["hy_fieldname"].ToString();
}
}
}
else
{
this.Response.Write("<script>alert('目录配置有问题，请联系管理员！');window.close();</script>");
return;
}
if (lsfieldid != "")
{
//判断当前表中是否有子表如果有的话，就将对应的表得到。只能输出一个子表，不考虑二个及以上的情况。
String lssqlsub = "select * from hyt_flowfield where hy_tableid='" + lstableid + "' and hy_mudelid='" + lsmid + "' and hy_fieldtype='IFRAME列表'";
DataTable dtsub = Hyoa_global.GetDataTable_BASE(lssqlsub);
String ls_defaultvalue = "";
if (dtsub.Rows.Count > 0)
{
ls_defaultvalue = dtsub.Rows[0]["hy_defaultvalue"].ToString();
lstableidsub = ls_defaultvalue.Substring(ls_defaultvalue.IndexOf("tableid=") + 8, ls_defaultvalue.IndexOf("&listid=") - ls_defaultvalue.IndexOf("tableid=") - 8);
lsmudelidsub = ls_defaultvalue.Substring(ls_defaultvalue.IndexOf("mid=") + 4, ls_defaultvalue.IndexOf("&tableid") - ls_defaultvalue.IndexOf("mid=") - 4);
String lssqlsubfield = "select * from hyt_flowfield where hy_tableid='" + lstableidsub + "' and hy_mudelid='" + lsmudelidsub + "' order by hy_sort";
DataTable dtsubfield = Hyoa_global.GetDataTable_BASE(lssqlsubfield);
for (int ii = 0; ii < dtsubfield.Rows.Count; ii++)
{
if (lsfieldidsub == "")
{
lsfieldidsub = "hyc_" + dtsubfield.Rows[ii]["hy_fieldid"].ToString();
lsfieldnamesub = dtsubfield.Rows[ii]["hy_fieldname"].ToString();
}
else
{
lsfieldidsub += "," + "hyc_" + dtsubfield.Rows[ii]["hy_fieldid"].ToString();
lsfieldnamesub += "," + dtsubfield.Rows[ii]["hy_fieldname"].ToString();
}
}
}
}
//得到应用数据
String lssqldata = "";
lssqldata = "select " + lsfieldid + ",docid" + " from hyc_" + lstableid + " where 1=1 ";
//if (Hyoa_global.isHaveRole("Roleldqx", this.Session["hyuid"].ToString()))
//{
// //领导的话，条件就不用加了，可以导出所有记录
//}
//else
//{
// //部门负责人只能导出本部门的记录
// if (Hyoa_global.isHaveRole("Rolebmldqx", this.Session["hyuid"].ToString()))
// {
// lssqldata += " and hy_djrbmid='" + this.Session["hydeptid"].ToString() + "'";
// }
// else
// {
// //一般能人只能导出自己的记录
// lssqldata += " and hy_djrid='" + this.Session["hyuid"].ToString() + "'";
// }
//}
if (lsstartdate != "")
{
lssqldata += " and CONVERT(varchar(10), hy_djsj, 120) >= '" + lsstartdate + "'";
}
if (lsenddate != "")
{
lssqldata += " and CONVERT(varchar(10), hy_djsj, 120) <= '" + lsenddate + "'";
}
lssqldata += "order by hy_djsj";
if (strSql != "")
{
lssqldata = strSql;
}
lsfieldid += ",DOCID";
if (lssqldata.Contains("*"))
{
lssqldata = lssqldata.Replace("*", lsfieldid);
}
if (lssqldata.Contains("top 20"))
{
lssqldata = lssqldata.Replace("top 20", lsfieldid);
}
DataTable dtdate = Hyoa_global.GetDataTable(lssqldata);
String lsdisplay = "";
string[] lv_colname;
string[] lv_colnamesub;
lv_colnamesub = lsfieldnamesub.Split(',');
lv_colname = lsfieldname.Split(',');
if (dtdate.Rows.Count > 0)
{
lsdisplay += "<TR bgcolor=\"#ABBCEF\" class=\"style1\" id=\"row\">";
for (int m = 0; m < lv_colname.Length; m++)
{
lsdisplay += "<td align=center>" + lv_colname[m] + "</td>";
}
for (int mm = 0; mm < lv_colnamesub.Length; mm++)
{
lsdisplay += "<td align=center>" + lv_colnamesub[mm] + "</td>";
}
lsdisplay += "</tr>";
for (int j = 0; j < dtdate.Rows.Count; j++)
{
lsdisplay += "<TR bgcolor=\"#ABBCEF\" class=\"style1\" >";
for (int n = 0; n < lv_colname.Length; n++)
{
lsdisplay += "<td align=center>" + dtdate.Rows[j][n].ToString() + "</td>";
}
//将主表数据后面的列补齐
for (int nnn = 0; nnn < lv_colnamesub.Length; nnn++)
{
lsdisplay += "<td align=center> </td>";
}
//得到子表的数据并输出
String lssqloutsub = "select " + lsfieldidsub + " from hyc_" + lstableidsub + " where 1=1 and hy_motherid='" + dtdate.Rows[j]["docid"].ToString() + "'";
DataTable dtoutsub = Hyoa_global.GetDataTable(lssqloutsub);
if (dtoutsub.Rows.Count > 0)
{
for (int liout = 0; liout < dtoutsub.Rows.Count; liout++)
{
lsdisplay += "<TR bgcolor=\"#ABBCEF\" class=\"style1\" >";
//输出主表中对应的空列
for (int n = 0; n < lv_colname.Length; n++)
{
lsdisplay += "<td align=center> </td>";
}
//输出子表的数据
for (int lioutcol = 0; lioutcol < lv_colnamesub.Length; lioutcol++)
{
lsdisplay += "<td align=center>" + dtoutsub.Rows[liout][lioutcol].ToString() + "</td>";
}
lsdisplay += "</tr>";
}
}
lsdisplay += "</tr>";
}
}
else
{
this.Response.Write("<script>alert('暂无数据！');window.close();</script>");
return;
}
this.lbldisplay.Text = lsdisplay;
}
}
private void DataPlay(int PageNo)
{
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//得到当前页号
this.curpage.Text = PageNo.ToString();
//---查询条件---开始
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
}
else
{
if (ls_fieldid_sx == "1")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "2")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) <= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') <= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "3")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " >= " + ls_searchtext + " ";
}
if (ls_fieldid_sx == "4")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " <= " + ls_searchtext + " ";
}
}
}
}
}
//---查询条件---结束
//---排序---开始
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield2"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield3"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
}
if (this.txtfieldid.Value != "" && this.txtfieldsort.Value != "")
{
cmdStr_SearchSort = " order by hyc_" + this.txtfieldid.Value + " " + this.txtfieldsort.Value + " ";
}
if (cmdStr_SearchSort == "")
{
//没有配置，则默认按登记日期
cmdStr_SearchSort = " order by hy_djsj desc ";
}
//---排序---结束
//--根据查询条件得到返回数据集--s
DataTable dt = new DataTable(); //单页数据集
DataTable dt_total = new DataTable(); //数据总条数，返回总条数值
DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc
string cmdStr = "";
string ls_from = "";
ls_from = " hyc_" + this.txttableid.Value + " where 1=1 and hy_djrbmid='" + Session["hydeptid"].ToString() + "' " + cmdStr_Search;
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select top " + PageSize.Text + " * from " + ls_from;
cmdStr += " and DOCID not in (select top " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString() + " DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr = " select * from ( ";
cmdStr += " select my_table.*, rownum as my_rownum from ";
cmdStr += " ( ";
cmdStr += " select * from hyc_" + this.txttableid.Value + " where 1=1 and hy_djrbmid='" + Session["hydeptid"].ToString() + "' " + cmdStr_Search + cmdStr_SearchSort;
cmdStr += " ) my_table ";
cmdStr += " where rownum<= " + ((PageNo) * int.Parse(PageSize.Text)).ToString();
cmdStr += " ) where my_rownum> " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString();
}
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from " + ls_from;
dt_total = Hyoa_global.GetDataTable(cmdStr);
//--根据查询条件得到返回数据集--e
//开始输出----整合成HTML为数据行
DataTable tempTable = dt.Clone();
DataColumn col = new DataColumn("displaycol", typeof(String)); //定义新的一列 add
tempTable.Columns.Add(col); //追加一列 add
string lscolname = "";
string lscolnameid = "";
string lscolwidth = "";
string ls_col = "";
string[] lvcolname;
string[] lvcolnameid;
string[] lvcolwidth;
string lscolwidthper;
lscolname = dtlist.Rows[0]["hy_columnshow"].ToString(); //要显示的列名：附件,标题,收文来源
lscolnameid = dtlist.Rows[0]["hy_columnshowid"].ToString(); //要显示的列名id：uploadfile1,Hy_bt,Hy_swly
lscolwidth = dtlist.Rows[0]["hy_width"].ToString(); //要显示的列名id：10,20,30
lvcolname = lscolname.Split(',');
lvcolnameid = lscolnameid.Split(',');
lvcolwidth = lscolwidth.Split(',');
if (dt.Rows.Count <= 0)
{
//如果没有数据则输出表头
for (int n = 0; n < lvcolname.Length; n++)
{
if (n >= lvcolwidth.Length)
{ lscolwidthper = ""; }//此判断是为了防止对应宽度没有输入时，会溢出报错。
else
{ lscolwidthper = lvcolwidth[n]; }
this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\">" + lvcolname[n] + "</td>";
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
//输出主表所有字段,start
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//输出主表所有字段,end
//////开始得到列的值
DataTable dtgetsqlfield;
for (int m = 0; m < lvcolname.Length; m++)
{
//如果有数据，则输出数据
if (m >= lvcolwidth.Length)
{ lscolwidthper = ""; }//此判断是为了防止对应宽度没有输入时，会溢出报错。
else
{ lscolwidthper = lvcolwidth[m]; }
dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, lvcolnameid[m], this.txttableid.Value);
if (i % System.Int32.Parse(PageSize.Text) == 0)
this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" title=\"点击可排序\" onclick=\"fun_sort('" + lvcolnameid[m] + "');\">" + lvcolname[m] + "</a></p></td>";
//根据字段英文名，得到数据库中对应的字段
string lsgetsqlfield = "hyc_" + dtgetsqlfield.Rows[0]["hy_fieldid"].ToString();
//根据数据库中对应的字段，得到输出字段的值start (日期型根据格式进行了转换)
string lsgetputfiled = "";
if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
if (dt.Rows[i][lsgetsqlfield].ToString() != "")
lsgetputfiled = System.DateTime.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToShortDateString();
}
else
{
//解决Float小数点后面出现N位小数乱码的问题
if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "数值")
{
if (dt.Rows[i][lsgetsqlfield].ToString() != "")
{
//是否包含小数点，包含的话，取小数点后两位
if (dt.Rows[i][lsgetsqlfield].ToString().Contains(".") == true)
{
lsgetputfiled = float.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString("F2");
}
else
{
lsgetputfiled = float.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString();
}
}
else
{
lsgetputfiled = "0";
}
//lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
else
{
lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
}
if (lsgetputfiled == "")
lsgetputfiled = " ";
//根据得到的SQL字段，得到输出字段的值end
if (dtgetsqlfield.Rows[0]["hy_ifdbsybt"].ToString() == "是")
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\"><a href=\"#\" onclick=\"var ss='main.aspx?op=modify&mid=" + dt.Rows[i]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[i]["hy_tableid"].ToString() + "&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url='+window.location;window.location=ss;\">" + lsgetputfiled + "</a></td>";
}
else
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\">" + lsgetputfiled + "</td>";
}
}
//如果是流程表单，则最后追加两列（当前环节和当前处理人）
//表头
if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null && i == 0)
{
this.lbdisplaytitle.Text += "<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">当前环节</td>";
this.lbdisplaytitle.Text += "<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">当前处理人</td>";
}
//数据
if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null)
{
ls_col += "<td width=\"10%\" align=\"center\">" + dt.Rows[i]["hy_curtachename"].ToString() + " </td>";
ls_col += "<td width=\"10%\" align=\"center\">" + dt.Rows[i]["hy_curclrname"].ToString() + " </td>";
}
dr["displaycol"] = ls_col; //将新值赋给相应的列 add
ls_col = "";
tempTable.Rows.Add(dr);
}
int TotalRecord = int.Parse(dt_total.Rows[0][0].ToString());
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();
//列表中的一些特殊处理，都放在这个函数内
DataPlay_Tscl();
}
//输出一个字段
public void GetFieldHtml(TableRow tRow, int li_colnums_show, string hy_fieldid)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
//得到字段属性
DataTable dtfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, hy_fieldid, this.txttableid.Value);
if (dtfield.Rows.Count > 0)
{
string field_type = dtfield.Rows[0]["hy_fieldtype"].ToString();
//插入单元格（左侧）
TableCell tCell = new TableCell();
tRow.Cells.Add(tCell);
tCell.Width = Unit.Percentage((30 / li_colnums_show));
tCell.Height = Unit.Pixel(30);
tCell.CssClass = "Tdcellleft";
tCell.HorizontalAlign = HorizontalAlign.Center;
tCell.Controls.Add(new LiteralControl(dtfield.Rows[0]["hy_fieldname"].ToString()));
//插入单元格（右侧）
TableCell tCell2 = new TableCell();
tRow.Cells.Add(tCell2);
tCell2.Width = Unit.Percentage((70 / li_colnums_show));
tCell2.Height = Unit.Pixel(30);
tCell2.CssClass = "Tdcellright";
tCell2.HorizontalAlign = HorizontalAlign.Left;
//单行文本
if (field_type == "文本")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
//if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
//{
// txtTextBox.ReadOnly = true;
//}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
tCell2.Controls.Add(txtTextBox);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//多行文本
if (field_type == "多行文本")
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
//if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
//{
// txtTextBox.ReadOnly = true;
//}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
tCell2.Controls.Add(txtTextBox);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//日期
if (field_type == "日期")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_s";
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("45%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
txtTextBox.Attributes.Add("onclick", "WdatePicker({el:$dp.$('" + dtfield.Rows[0]["hy_fieldid"].ToString() + "_s" + "')})");
tCell2.Controls.Add(txtTextBox);
tCell2.Controls.Add(new LiteralControl("至"));
TextBox txtTextBox2 = new TextBox();
txtTextBox2.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_e";
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox2.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox2.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox2.Width = Unit.Parse("45%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox2.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
txtTextBox2.Attributes.Add("onclick", "WdatePicker({el:$dp.$('" + dtfield.Rows[0]["hy_fieldid"].ToString() + "_e" + "')})");
tCell2.Controls.Add(txtTextBox2);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString() + "_s", "1");
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString() + "_e", "2");
}
//文本加按钮
if (field_type == "文本加按钮")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
//if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
//{
// txtTextBox.ReadOnly = true;
//}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("60%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
Button btnButton = new Button();
btnButton.ID = "btn_" + dtfield.Rows[0]["hy_fieldid"].ToString();
btnButton.CssClass = "btn3";
btnButton.Text = " 选 择 ";
btnButton.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
tCell2.Controls.Add(btnButton);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//多行文本加按钮
if (field_type == "多行文本加按钮")
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
//if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
//{
// txtTextBox.ReadOnly = true;
//}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("60%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
Button btnButton = new Button();
btnButton.ID = "btn_" + dtfield.Rows[0]["hy_fieldid"].ToString();
btnButton.CssClass = "btn3";
btnButton.Text = " 选 择 ";
btnButton.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
tCell2.Controls.Add(btnButton);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//数值
if (field_type == "数值")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_s";
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("45%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
tCell2.Controls.Add(new LiteralControl("至"));
TextBox txtTextBox2 = new TextBox();
txtTextBox2.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_e";
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox2.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox2.Width = Unit.Parse("45%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox2.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox2);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString() + "_s", "3");
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString() + "_e", "4");
}
//对话框列表（下拉框
if (field_type == "对话框列表")
{
DropDownList ddlDropDownList = new DropDownList();
ddlDropDownList.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
ddlDropDownList.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
ddlDropDownList.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
ddlDropDownList.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
//手工配置
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (int i = 0; i < lv_options.Length; i++)
{
ddlDropDownList.Items.Add(lv_options[i].ToString());
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
//SQL语句
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
DataTable dt_options = Hyoa_global.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
ddlDropDownList.DataSource = dt_options;
ddlDropDownList.DataTextField = dt_options.Columns[0].ColumnName;
ddlDropDownList.DataValueField = dt_options.Columns[0].ColumnName;
ddlDropDownList.DataBind();
}
}
ddlDropDownList.Items.Insert(0, new ListItem("--请选择--", ""));
tCell2.Controls.Add(ddlDropDownList);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//复选框(查询时直接显示文本框)
if (field_type == "复选框")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//单选框(查询时直接显示文本框)
if (field_type == "单选框")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
}
}
//输出一个字段
//li_tdnums_onerow：当前行已输出了几列
//li_colnums_show：每行显示几列（标准情况下）
//pi_isnewdoc 0:新文档 1：旧文档
//ifhavarole：表单上是否有权限 0：lable输出 1：input输出
//ifflowdoc：是否流程表单 0：非流程 1：流程
//curtacheid:当前环节ID,用于判断字段是否在当前环节有权限
public int GetFieldHtml(TableRow tRow, int li_tdnums_onerow, int li_colnums_show, string hy_fieldid, string pi_isnewdoc, string ifhavarole, string ifflowdoc, string curtacheid)
{
int li_return = li_tdnums_onerow;
string ls_laborinput = "0"; //输出LABLE还是INPUT 0：LABLE 1：INPUT
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.hy_mudelid.Text, hy_fieldid, this.hy_tableid.Text);
int li_left = 30;
int li_right = 70;
if (dtfield.Rows.Count > 0)
{
string field_type = dtfield.Rows[0]["hy_fieldtype"].ToString(); //字段类型
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "5") //如果设置了不显示左侧说明文字，则不加载左侧列
{
li_return += 1;
//插入单元格（左侧）
TableCell tCell = new TableCell();
tRow.Cells.Add(tCell);
tCell.Width = Unit.Percentage((li_left / li_colnums_show));
tCell.Height = Unit.Pixel(30);
tCell.CssClass = "Tdcellleft";
tCell.HorizontalAlign = HorizontalAlign.Center;
tCell.Controls.Add(new LiteralControl(dtfield.Rows[0]["hy_fieldname"].ToString()));
}
else
{
li_left = 50;
li_right = 50;
}
//插入单元格（右侧）
TableCell tCell2 = new TableCell();
tRow.Cells.Add(tCell2);
tCell2.Width = Unit.Percentage((li_right / li_colnums_show));
tCell2.Height = Unit.Pixel(30);
tCell2.CssClass = "Tdcellright";
if (dtfield.Rows[0]["hy_align"].ToString() == "left")
{
tCell2.HorizontalAlign = HorizontalAlign.Left;
}
if (dtfield.Rows[0]["hy_align"].ToString() == "center")
{
tCell2.HorizontalAlign = HorizontalAlign.Center;
}
if (dtfield.Rows[0]["hy_align"].ToString() == "right")
{
tCell2.HorizontalAlign = HorizontalAlign.Right;
}
tCell2.ColumnSpan = int.Parse(dtfield.Rows[0]["hy_tdnums"].ToString());
li_return += int.Parse(dtfield.Rows[0]["hy_tdnums"].ToString());
//赋值（新文档取配置的默认值，旧文档取数据库表中的值）
string field_docvalue = "";
if (pi_isnewdoc == "0") //新文档
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "-1")
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "0")
{
field_docvalue = dtfield.Rows[0]["hy_defaultvalue"].ToString(); //手工配置
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "1")
{
DataTable dt_getfieldvalue = Hyoa_global.GetDataTable(dtfield.Rows[0]["hy_defaultvalue"].ToString());
field_docvalue = dt_getfieldvalue.Rows[0][0].ToString(); //SQL语句
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "2")
{
field_docvalue = Session[dtfield.Rows[0]["hy_defaultvalue"].ToString()].ToString(); //SESSION
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "3")
{
if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
field_docvalue = System.DateTime.Now.ToString("yyyy-MM-dd"); //当前时间
else
field_docvalue = System.DateTime.Now.ToString("yyyy-MM-dd HH:MM:ss"); //当前时间
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "4")
{
//自动生成
if (dtfield.Rows[0]["hy_fieldtype"].ToString() == "数值")
{
//得到目前最大的数值，然后+1，未找到则赋值为1
DataTable dt_autovalue = Hyoa_global.GetDataTable("select max(hyc_" + hy_fieldid + ") maxint from hyc_" + this.hy_tableid.Text);
if (dt_autovalue.Rows[0]["maxint"].ToString() == null || dt_autovalue.Rows[0]["maxint"].ToString() == "")
field_docvalue += "1";
else
field_docvalue += (System.Int32.Parse(dt_autovalue.Rows[0]["maxint"].ToString()) + 1).ToString();
}
else
{
field_docvalue += System.Guid.NewGuid().ToString();
}
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "5")
{
field_docvalue += dtfield.Rows[0]["hy_defaultvalue"].ToString();
}
}
}
else
{
if (field_type == "文本" || field_type == "多行文本" || field_type == "多行文本_TEXT" || field_type == "文本加按钮" || field_type == "多行文本加按钮" || field_type == "日期" || field_type == "数值" || field_type == "对话框列表" || field_type == "复选框" || field_type == "单选框" || field_type == "口令" || field_type == "编辑器")
{
string ls_sql = "select hyc_" + hy_fieldid + " from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "'";
DataTable dt_getdocvalue = Hyoa_global.GetDataTable(ls_sql);
if (dt_getdocvalue.Rows.Count > 0)
{
field_docvalue = dt_getdocvalue.Rows[0][0].ToString();
if (field_type == "日期")
{
if (field_docvalue.Length > 8)
{
if (field_docvalue.Substring(0, 8) == "1900-1-1")
{
field_docvalue = " ";
}
else
{
if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
field_docvalue = System.DateTime.Parse(field_docvalue).ToString("yyyy-MM-dd");
}
}
}
}
}
}
if (field_type == "说明文字")
{
field_docvalue += dtfield.Rows[0]["hy_defaultvalue"].ToString();
}
}
//判断是输出LABL还是INPUT
if (pi_isnewdoc == "0") //新文档
{
if (ifflowdoc == "0") //非流程
{
if (ifhavarole == "1") //有权限
{
ls_laborinput = "1";
}
}
else
{
if (ifhavarole == "1") //有权限
{
//有流程(判断当前环节这个字段是否有权限)
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
ls_laborinput = Hyoa_flowtachefield.IfHaveRolebyflowidandtacheidandfieldid(hy_flowid.Text, curtacheid, hy_fieldid);
if (ls_laborinput == "0")
{
field_docvalue = "";
}
}
else
{
field_docvalue = "";
}
}
}
else //旧文档
{
if (ifflowdoc == "0") //非流程
{
if (ifhavarole == "1") //有权限
{
ls_laborinput = "1";
//如果文档已经确认，则输出lable
string ls_sql = "select hy_ifconfirm from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "'";
DataTable dt_getifconfirm = Hyoa_global.GetDataTable(ls_sql);
if (dt_getifconfirm.Rows.Count > 0)
{
if (dt_getifconfirm.Rows[0]["hy_ifconfirm"].ToString() == "1")
ls_laborinput = "0";
}
}
}
else
{
if (ifhavarole == "1") //有权限
{
//有流程(判断当前环节这个字段是否有权限)
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
ls_laborinput = Hyoa_flowtachefield.IfHaveRolebyflowidandtacheidandfieldid(hy_flowid.Text, curtacheid, hy_fieldid);
//如果流程结束了，则输出lable
if (hy_curtacheid.Text == "**")
{
ls_laborinput = "0";
}
}
}
}
//如果是输出LABLE，值为空则赋为 不为空时需要转换回车和空格
if (ls_laborinput == "0")
{
if (field_docvalue == "")
{
field_docvalue = " ";
}
else
{
if (field_type != "编辑器")
{
field_docvalue = RtfToText(field_docvalue);
}
}
}
//单行文本
if (field_type == "文本")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//多行文本
if (field_type == "多行文本")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//多行文本_TEXT
if (field_type == "多行文本_TEXT")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//按钮
if (field_type == "按钮")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = " ";
tCell2.Controls.Add(txtTextBox);
}
else
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value='" + dtfield.Rows[0]["hy_fieldname"].ToString() + "' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />";
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//一直显示的按钮
if (field_type == "一直显示的按钮")
{
//-----开始输出字段------
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value='" + dtfield.Rows[0]["hy_fieldname"].ToString() + "' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />";
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
//日期
if (field_type == "日期")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//文本加按钮
if (field_type == "文本加按钮")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("60%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
Label txtTextBox2 = new Label();
txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />";
txtTextBox2.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox2);
}
}
//多行文本加按钮
if (field_type == "多行文本加按钮")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
Label txtTextBox2 = new Label();
txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />";
txtTextBox2.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox2);
}
}
//意见加按钮
if (field_type == "意见加按钮")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
//txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
Label txtTextBox2 = new Label();
txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" /><input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "_cz' value=' 重 置 ' class=btn3 onclick=\"document.getElementById('" + dtfield.Rows[0]["hy_fieldid"].ToString() + "').value='';\" />";
txtTextBox2.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox2);
}
}
//数值
if (field_type == "数值")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//对话框列表（下拉框
if (field_type == "对话框列表")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
DropDownList ddlDropDownList = new DropDownList();
ddlDropDownList.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
ddlDropDownList.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
ddlDropDownList.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
ddlDropDownList.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
//手工配置
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (int i = 0; i < lv_options.Length; i++)
{
ddlDropDownList.Items.Add(lv_options[i].ToString());
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
//SQL语句
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
//如果SQL语句中含有特殊标示，则需要替换
string ls_sql = dtfield.Rows[0]["hy_options"].ToString();
if (ls_sql.Contains("用户ID"))
{
ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'");
}
if (ls_sql.Contains("用户名"))
{
ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'");
}
if (ls_sql.Contains("部门ID"))
{
ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'");
}
if (ls_sql.Contains("部门名"))
{
ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'");
}
DataTable dt_options = Hyoa_global.GetDataTable(ls_sql);
ddlDropDownList.DataSource = dt_options;
ddlDropDownList.DataTextField = dt_options.Columns[0].ColumnName;
ddlDropDownList.DataValueField = dt_options.Columns[0].ColumnName;
ddlDropDownList.DataBind();
}
}
ddlDropDownList.Items.Insert(0, new ListItem("--请选择--", ""));
ddlDropDownList.SelectedValue = field_docvalue;
tCell2.Controls.Add(ddlDropDownList);
}
}
//复选框(查询时直接显示文本框)
if (field_type == "复选框")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
CheckBoxList txtTextBox = new CheckBoxList();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
//手工配置
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (int i = 0; i < lv_options.Length; i++)
{
txtTextBox.Items.Add(lv_options[i].ToString());
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
//SQL语句
//如果SQL语句中含有特殊标示，则需要替换
string ls_sql = dtfield.Rows[0]["hy_options"].ToString();
if (ls_sql.Contains("用户ID"))
{
ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'");
}
if (ls_sql.Contains("用户名"))
{
ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'");
}
if (ls_sql.Contains("部门ID"))
{
ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'");
}
if (ls_sql.Contains("部门名"))
{
ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'");
}
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
DataTable dt_options = Hyoa_global.GetDataTable(ls_sql);
txtTextBox.DataSource = dt_options;
txtTextBox.DataTextField = dt_options.Columns[0].ColumnName;
txtTextBox.DataValueField = dt_options.Columns[0].ColumnName;
txtTextBox.DataBind();
}
}
if (field_docvalue != "")
{
field_docvalue = "," + field_docvalue + ",";
foreach (ListItem li in txtTextBox.Items)
{
if (field_docvalue.Contains(li.Value))
li.Selected = true;
}
}
tCell2.Controls.Add(txtTextBox);
}
}
//单选框(查询时直接显示文本框)
if (field_type == "单选框")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
RadioButtonList txtTextBox = new RadioButtonList();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
//手工配置
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (int i = 0; i < lv_options.Length; i++)
{
txtTextBox.Items.Add(lv_options[i].ToString());
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
//SQL语句
//如果SQL语句中含有特殊标示，则需要替换
string ls_sql = dtfield.Rows[0]["hy_options"].ToString();
if (ls_sql.Contains("用户ID"))
{
ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'");
}
if (ls_sql.Contains("用户名"))
{
ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'");
}
if (ls_sql.Contains("部门ID"))
{
ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'");
}
if (ls_sql.Contains("部门名"))
{
ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'");
}
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
DataTable dt_options = Hyoa_global.GetDataTable(ls_sql);
txtTextBox.DataSource = dt_options;
txtTextBox.DataTextField = dt_options.Columns[0].ColumnName;
txtTextBox.DataValueField = dt_options.Columns[0].ColumnName;
txtTextBox.DataBind();
}
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//口令
if (field_type == "口令")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = " ";
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.Password;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//附件组件
if (field_type == "附件组件")
{
//读取附件内容
HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt();
DataTable dt_fileatt = Hyoa_fileatt.GetfileattByFatheridandFatherfield(this.txtdocid.Value, hy_fieldid);
field_docvalue = "";
if (dt_fileatt.Rows.Count > 0)
{
for (var ii = 0; ii < dt_fileatt.Rows.Count; ii++)
{
field_docvalue += (ii + 1).ToString() + "、<a href=\"" + dt_fileatt.Rows[ii]["hy_filepath"].ToString() + "\" target=_blank>" + dt_fileatt.Rows[ii]["hy_filename"].ToString() + "</a><br />";
}
}
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (field_docvalue == "")
{
field_docvalue = " ";
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue += "<input type=button id='uploadfile1' value='附件管理' class=btn3 onclick=\"window.open('ggdy/main_fileatt.aspx?fatherid=" + this.txtdocid.Value + "&fatherfield=" + hy_fieldid + "','filewindow','height=350,width=600,top=100,left=200,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no, status=no');\" />";
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//说明文字
if (field_type == "说明文字")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//编辑器
if (field_type == "编辑器")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
//隐藏文本框
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
txtTextBox.Style.Value = "display:none";
tCell2.Controls.Add(txtTextBox);
//编辑器
Label txtTextBox2 = new Label();
txtTextBox2.ID = "eWebEditor" + dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<iframe ID=\"eWebEditor" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"system/eWebEditor/ewebeditor.htm?id=" + dtfield.Rows[0]["hy_fieldid"].ToString() + "&style=Portal\" frameborder=0 scrolling=no width=" + dtfield.Rows[0]["hy_width"].ToString() + " height=" + dtfield.Rows[0]["hy_height"].ToString() + "></iframe>";
txtTextBox2.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox2);
}
}
//痕迹保留
if (field_type == "痕迹保留")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/readoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=1&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
//如果是流程模块，则根据环节判断一下
if (ifflowdoc == "1")
{
//判断是否为第一环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, "*");
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == this.hy_curtacheid.Text)
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
}
else
{
//判断是否为最后一个环节
dtflowwork.Clear();
dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=0&jsxd=1&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
}
else
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=0&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
}
}
}
}
}
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//IFRAME列表
if (field_type == "IFRAME列表")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
field_docvalue = "<iframe id=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" name=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"" + dtfield.Rows[0]["hy_defaultvalue"].ToString() + "&motherid=" + this.txtdocid.Value + "&ishaverole=0\" frameborder=\"0\" scrolling=\"yes\" height=\"80px\" width=\"98%\"></iframe>";
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
field_docvalue = "<iframe id=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" name=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"" + dtfield.Rows[0]["hy_defaultvalue"].ToString() + "&motherid=" + this.txtdocid.Value + "&ishaverole=1\" frameborder=\"0\" scrolling=\"yes\" height=\"80px\" width=\"98%\"></iframe>";
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//子表信息带链接
//子表信息不带链接
}
return li_return;
}
//判断合同编号是否生成
private void ifHaveHtbh()
{
this.btn_dc.Visible = false;
this.btnDc.Visible = false;
if (this.hy_tableid.Text == "Tablesyyhfwxy" || this.hy_tableid.Text == "Tablejdhazfwht" || this.hy_tableid.Text == "TableVODfwxy" || this.hy_tableid.Text == "Tableffpdfwht" || this.hy_tableid.Text == "TableDVBazfwdght" || this.hy_tableid.Text == "Tablejwdsjsxy" || this.hy_tableid.Text == "Tablejwdscsxy" || this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesjcsfwht" || this.hy_tableid.Text == "Tablesjgdcsfwht" || this.hy_tableid.Text == "Tablesjtxyyhzxy")
{
string sqlSelect = " select hyc_htbh from hyc_" + this.hy_tableid.Text + " where docid ='" + this.txtdocid.Value + "' ";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["hyc_htbh"].ToString() != "")
{
this.btn_dc.Visible = false;
this.btnDc.Visible = true;
}
else
{
this.btn_dc.Visible = true;
this.btnDc.Visible = false;
}
}
else
{
this.btn_dc.Visible = true;
this.btnDc.Visible = false;
}
}
}
//加载主表单 Written by xf 20110515
private void DataPlay()
{
txtsavefields.Text = "";
txtsavefields_sx.Text = "";
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.td_browseflow.Visible = true; //查看流程
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' ";
DataTable dt = Hyoa_global.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString();
this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString();
this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString();
UpdateReadFlag(); //打开时添加阅读情况
}
dt.Clear();
//流程文档
if (this.txtifhaveflow.Value == "是")
{
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
this.lblcurtachenameshow.Text = "流程已结束";
}
//加载页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
}
else
{
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//非流程表单
this.td_browseflow.Visible = false;
//加载主表单页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "0", "");
//----加载评论页面 s add by xf 2011-11-19-----
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forpinglun = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig_forpinglun = Hyoa_tableconfig_forpinglun.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig_forpinglun.Rows.Count > 0)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"] != null)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"].ToString() == "是")
{
this.tb_nbsp.Visible = true;
this.tb_pltitle.Visible = true;
this.tb_plbody.Visible = true;
this.td_pinglun.Visible = true;
//得到已经评论的内容
HyoaClass.Hyoa_pinglun Hyoa_pinglun = new HyoaClass.Hyoa_pinglun();
DataTable dt_pinglun = Hyoa_pinglun.GetcommentByfatherid(this.txtdocid.Value);
if (dt_pinglun.Rows.Count > 0)
{
//输出评论记录
this.lblbody.Text = "";
for (var i = 0; i < dt_pinglun.Rows.Count; i++)
{
this.lblbody.Text += dt_pinglun.Rows[i]["hy_plbody"].ToString() + "<br> ";
this.lblbody.Text += "（评论人:" + dt_pinglun.Rows[i]["hy_plusername"].ToString() + " 所在部门:" + dt_pinglun.Rows[i]["hy_pldeptname"].ToString();
this.lblbody.Text += " 评论时间:" + dt_pinglun.Rows[i]["hy_pltime"].ToString() + " IP:" + dt_pinglun.Rows[i]["hy_plip"].ToString();
this.lblbody.Text += "）<br><hr height=1 color=#DEEEFE></hr>";
}
}
}
}
}
//----加载评论页面 e-----
}
}
hywebopen_olddoc(); //旧文档OPEN的特殊处理
}
}
//这是主页面下面的按钮
if (this.hy_tableid.Text == "Tablexjsq" || this.hy_tableid.Text == "Tablelzsq"
|| this.hy_tableid.Text == "Tableshd" || this.hy_tableid.Text == "Tableszds"
|| this.hy_tableid.Text == "Tableywsl" || (this.hy_tableid.Text == "Tablefybx") || (this.hy_tableid.Text == "Tablezbgl") || (this.hy_tableid.Text == "Tablefkd"))
{
this.td_ywdc.Visible = true;
}
if ((this.hy_tableid.Text == "Tablefpbd"))
{
this.td_ywdc.Visible = true;
}
if ((this.hy_tableid.Text == "TableVODfwxy") || (this.hy_tableid.Text == "Tableffpdfwht")
|| (this.hy_mudelid.Text == "Mudeljdhazfwht" && this.hy_tableid.Text == "Tablejdhazfwht") || (this.hy_mudelid.Text == "Mudelsyyhfwxy" && this.hy_tableid.Text == "Tablesyyhfwxy")
|| (this.hy_mudelid.Text == "MudelDVBazfwdght" && this.hy_tableid.Text == "TableDVBazfwdght") || (this.hy_mudelid.Text == "MudelDVBazfwdght" && this.hy_tableid.Text == "TableDVBazfwdght")
|| (this.hy_mudelid.Text == "Mudeljwdsjsxy" && this.hy_tableid.Text == "Tablejwdsjsxy") || (this.hy_mudelid.Text == "Mudeljwdscsxy" && this.hy_tableid.Text == "Tablejwdscsxy")
|| (this.hy_mudelid.Text == "Mudelkdjrht" && this.hy_tableid.Text == "Tablekdjrht") || (this.hy_mudelid.Text == "Mudelsjcsfwht" && this.hy_tableid.Text == "Tablesjcsfwht")
|| (this.hy_mudelid.Text == "Mudelsjgdcsfwht" && this.hy_tableid.Text == "Tablesjgdcsfwht") || (this.hy_mudelid.Text == "Mudelsjtxyyhzxy" && this.hy_tableid.Text == "Tablesjtxyyhzxy")
|| (this.hy_mudelid.Text == "Mudelzdyht" && this.hy_tableid.Text == "Tablezdyht"))
{
this.td_htdc.Visible = true;
}
if (this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesyyhfwxy" || this.hy_tableid.Text == "Tablejdhazfwht" || this.hy_tableid.Text == "TableVODfwxy" || this.hy_tableid.Text == "Tableffpdfwht" || this.hy_tableid.Text == "TableDVBazfwdght" || this.hy_tableid.Text == "Tablejwdsjsxy" || this.hy_tableid.Text == "Tablejwdscsxy" || this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesjcsfwht" || this.hy_tableid.Text == "Tablesjgdcsfwht" || this.hy_tableid.Text == "Tablesjtxyyhzxy" || this.hy_tableid.Text == "Tablezdyht" || this.hy_tableid.Text == "Tablegxhzhht" || this.hy_tableid.Text == "Tableqtht" || this.hy_tableid.Text == "Tablexjsq" || this.hy_tableid.Text == "Tableshd" || this.hy_tableid.Text == "Tableszds")
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string sql_wc = "";
DataTable dtwc;
sql_wc = "select top 1 * from hyt_blzt where DOCID='" + this.txtdocid.Value + "' and hy_state='未完成'";
dtwc = Hyoa_global.GetDataTable(sql_wc);
if (dtwc.Rows.Count > 0)
{
if (dtwc.Rows[0]["hy_state"].ToString() == "未完成")
{
this.td_wcan.Visible = true; //完成
}
}
}
//部门礼品卡 导出 小潘 2015-5-12
if (this.hy_tableid.Text == "Tablegslpk")
{
this.td_ywdc.Visible = true;
}
}
protected void btn_dc_Click(object sender, EventArgs e)
{
string htbm = "";
int bh = 0;
string lsHtbh = DateTime.Now.ToString("yyyyMMdd");
string sqlSelect = " select hyc_htbh,hyc_nf,docid from hyc_Tablehtbhwh order by hyc_pxh ";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
if (DateTime.Now.Year.ToString() != dt.Rows[0]["hyc_nf"].ToString())
{
sqlSelect = " update hyc_Tablehtbhwh set hyc_nf='" + DateTime.Now.Year.ToString() + "',hyc_htbh='0' where docid='" + dt.Rows[0]["docid"].ToString() + "' ";
Hyoa_global.ExcuteSQL(sqlSelect);
}
}
dt.Clear();
sqlSelect = " select hyc_htbh,hyc_nf,docid from hyc_Tablehtbhwh order by hyc_pxh ";
dt = Hyoa_global.GetDataTable(sqlSelect);
if (dt.Rows.Count > 0)
{
bh = Convert.ToInt32(dt.Rows[0]["hyc_htbh"].ToString()) + 1;
if (Convert.ToString(bh).Length == 1)
{
htbm = "000" + bh;
}
if (Convert.ToString(bh).Length == 2)
{
htbm = "00" + bh;
}
if (Convert.ToString(bh).Length == 3)
{
htbm = "0" + bh;
}
if (Convert.ToString(bh).Length == 4)
{
htbm = Convert.ToString(bh);
}
lsHtbh += htbm;
//插入当前合同中
sqlSelect = " update hyc_" + this.hy_tableid.Text + " set hyc_htbh='" + lsHtbh + "' where docid = '" + this.txtdocid.Value + "' ";
Hyoa_global.ExcuteSQL(sqlSelect);
sqlSelect = " update hyc_Tablehtbhwh set hyc_htbh='" + bh + "' where docid = '" + dt.Rows[0]["docid"].ToString() + "' ";
Hyoa_global.ExcuteSQL(sqlSelect);
Response.AddHeader("Refresh", "0");
}
}
