//输出查询字段的表格（查询输入框）
public void GetSearchTableHtml()
{
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
DataTable dtlistsearch = new DataTable();
if (this.txtlistid.Value == "")
{
dtlistsearch = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndTableid(this.txtmudelid.Value, this.txttableid.Value);
}
else
{
dtlistsearch = Hyoa_listsearchfield.Getlistsearchfieldsbylistid(this.txtlistid.Value);
}
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
//得到表单配置信息
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.txttableid.Value);
int li_colnums_show = int.Parse(dt_tableconfig.Rows[0]["hy_colnum"].ToString()) / 2; //一行显示几列
int li_rows_show = 0; //一共有几行
int li_ifaddcols = 0; //所有列显示完成后，是否需要补齐显示列 0：否 1：是
int li_addcols = 0; //需要补齐的列数量
if (dtlistsearch.Rows.Count % li_colnums_show == 0)
{
li_rows_show = dtlistsearch.Rows.Count / li_colnums_show;
li_ifaddcols = 0;
}
else
{
li_rows_show = (dtlistsearch.Rows.Count / li_colnums_show) + 1;
li_ifaddcols = 1;
li_addcols = li_colnums_show - (dtlistsearch.Rows.Count % li_colnums_show);
}
for (int i = 0; i < li_rows_show; i++)
{
TableRow tRow = new TableRow();
tb_search.Rows.Add(tRow);
for (int j = 0; j < li_colnums_show; j++)
{
//dtlistsearch中的记录行数
int t = i * li_colnums_show + j;
if ((t + 1) > dtlistsearch.Rows.Count)
{
break;
}
//得到hyt_listsearchfield表中的hy_fieldid，
GetFieldHtml(tRow, li_colnums_show, dtlistsearch.Rows[t]["hy_fieldid"].ToString());
}
//如果最后一行的列没有显示完整，则补齐
if (li_ifaddcols == 1 && i == (li_rows_show - 1))
{
for (int k = 0; k < li_addcols; k++)
{
TableCell tCell8 = new TableCell();
tRow.Cells.Add(tCell8);
tCell8.Height = Unit.Pixel(30);
tCell8.CssClass = "Tdcellleft";
tCell8.HorizontalAlign = HorizontalAlign.Center;
tCell8.Controls.Add(new LiteralControl(" "));
TableCell tCell9 = new TableCell();
tRow.Cells.Add(tCell9);
tCell9.Height = Unit.Pixel(30);
tCell9.CssClass = "Tdcellright";
tCell9.HorizontalAlign = HorizontalAlign.Center;
tCell9.Controls.Add(new LiteralControl(" "));
}
}
}
//插入查询按钮行
TableRow tRow2 = new TableRow();
tb_search.Rows.Add(tRow2);
TableCell tCell3 = new TableCell();
tRow2.Cells.Add(tCell3);
tCell3.Height = Unit.Pixel(30);
tCell3.CssClass = "Tdcellright";
tCell3.HorizontalAlign = HorizontalAlign.Right;
tCell3.ColumnSpan = li_colnums_show * 2;
Button btnButton = new Button();
btnButton.ID = "btnsearch_ht";
btnButton.Text = " 查 询";
btnButton.CssClass = "btn7";
btnButton.Click += new EventHandler(btnsearch_Click);
tCell3.Controls.Add(btnButton);
}
private void DataPlay()
{
//是否启用
this.ddlifsearch.Items.Insert(0, "是");
this.ddlifsearch.Items.Insert(1, "否");
this.ddlifflowdoc.Items.Insert(0, "是");
this.ddlifflowdoc.Items.Insert(1, "否");
this.ddlifshowsearch.Items.Insert(0, "是");
this.ddlifshowsearch.Items.Insert(1, "否");
//模块编号
//加载模块信息
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dtmudel = Hyoa_mudel.Getmudels();
if (dtmudel.Rows.Count > 0)
{
this.ddlmudelid.DataSource = dtmudel;
this.ddlmudelid.DataTextField = "hy_mudelname";
this.ddlmudelid.DataValueField = "hy_mudelid";
this.ddlmudelid.DataBind();
this.ddlmudelid.Items.Insert(0, new ListItem("请选择", "请选择"));
this.ddlmudelid.SelectedIndex = 0;
}
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
//判断当前用户是否有保存的权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.btn_submit.Visible = true; //保存
}
else
{
this.btn_submit.Visible = false; //保存
}
//旧文档
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
if (this.Request.QueryString["op"] == "modify")
{
if (this.Request.QueryString["id"] != null)
{
//根据id得到信息
this.txtdocid.Value = this.Request.QueryString["id"].ToString();
DataTable dt = Hyoa_listconfig.Getlistconfig(this.txtdocid.Value);
if (dt.Rows.Count > 0)
{
this.txtsort.Text = dt.Rows[0]["hy_sort"].ToString();
if (dt.Rows[0]["hy_ifsearch"].ToString() == "是")
{
this.ddlifsearch.SelectedIndex = 0;
}
else
{
this.ddlifsearch.SelectedIndex = 1;
}
if (dt.Rows[0]["hy_ifshowsearch"].ToString() != "否")
{
this.ddlifshowsearch.SelectedIndex = 0;
}
else
{
this.ddlifshowsearch.SelectedIndex = 1;
}
this.ddlmudelid.SelectedValue = dt.Rows[0]["hy_mudelid"].ToString();
if (dt.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
this.ddlifflowdoc.SelectedIndex = 0;
}
else
{
this.ddlifflowdoc.SelectedIndex = 1;
}
this.txthy_listname.Text = dt.Rows[0]["hy_listname"].ToString();
this.txtwidth.Text = dt.Rows[0]["hy_width"].ToString();
//加载所有列信息
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield;
//dtflowfield = Hyoa_flowfield.Getflowfields();
dtflowfield = Hyoa_flowfield.GetflowfieldsbyMudelidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
if (dtflowfield.Rows.Count > 0)
{
this.ddlcolumnshow.DataSource = dtflowfield;
this.ddlcolumnshow.DataTextField = "hy_fieldname";
this.ddlcolumnshow.DataValueField = "hy_fieldid";
this.ddlcolumnshow.DataBind();
this.ddlcolumnshow.SelectedIndex = 0;
}
dtflowfield.Clear();
//将列都列出来
string[] lv_columnshowselect;
string[] lv_columnshowselectid;
lv_columnshowselect = dt.Rows[0]["hy_columnshow"].ToString().Split(',');
lv_columnshowselectid = dt.Rows[0]["hy_columnshowid"].ToString().Split(',');
for (int j = 0; j < lv_columnshowselect.Length; j++)
{
this.ddlcolumnshowselect.Items.Insert(j, new ListItem(lv_columnshowselect[j], lv_columnshowselectid[j]));
}
//根据模块信息得到对应的选择表单值
if (dt.Rows[0]["hy_tableid"] != "" && dt.Rows[0]["hy_tableid"] != null)
{
this.ddltableid.Items.Clear();
//根据模块ID得到表单ID
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dtgettableid = Hyoa_tableconfig.GetTablesbymudelid(dt.Rows[0]["hy_mudelid"].ToString());
if (dtgettableid.Rows.Count > 0)
{
for (var i = 0; i < dtgettableid.Rows.Count; i++)
{
this.ddltableid.Items.Insert(i, new ListItem(dtgettableid.Rows[i]["hy_name"].ToString(), dtgettableid.Rows[i]["ID"].ToString()));
}
this.ddltableid.Items.Insert(0, new ListItem("--请选择--", ""));
this.ddltableid.Attributes.Add("onchange ", "mudelidonchang() ");
//定位
this.ddltableid.SelectedValue = dt.Rows[0]["hy_tableid"].ToString();
}
}
//排序的字段
//根据模块ID+表单ID+字段ID得到字段中文名
DataTable dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield1"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
if (dt_flowfield.Rows.Count > 0)
{
this.searchsort1.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield1"].ToString()));
}
this.ddlsorttype1.SelectedValue = dt.Rows[0]["hy_sorttype1"].ToString();
dt_flowfield.Clear();
dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield2"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
if (dt_flowfield.Rows.Count > 0)
{
this.searchsort2.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield2"].ToString()));
}
this.ddlsorttype2.SelectedValue = dt.Rows[0]["hy_sorttype2"].ToString();
dt_flowfield.Clear();
dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield3"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
if (dt_flowfield.Rows.Count > 0)
{
this.searchsort3.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield3"].ToString()));
}
this.ddlsorttype3.SelectedValue = dt.Rows[0]["hy_sorttype3"].ToString();
dt_flowfield.Clear();
//分类的字段
this.txthy_field_fl1.Text = dt.Rows[0]["hy_sql_fl1"].ToString();
if (dt.Rows[0]["hy_fieldid_fl1"].ToString() != "")
{
this.flfield1.Items.Insert(0, new ListItem(dt.Rows[0]["hy_fieldname_fl1"].ToString(), dt.Rows[0]["hy_fieldid_fl1"].ToString()));
}
this.txthy_field_fl2.Text = dt.Rows[0]["hy_sql_fl2"].ToString();
if (dt.Rows[0]["hy_fieldid_fl2"].ToString() != "")
{
this.flfield2.Items.Insert(0, new ListItem(dt.Rows[0]["hy_fieldname_fl2"].ToString(), dt.Rows[0]["hy_fieldid_fl2"].ToString()));
}
this.txthy_field_fl3.Text = dt.Rows[0]["hy_sql_fl3"].ToString();
if (dt.Rows[0]["hy_fieldid_fl3"].ToString() != "")
{
this.flfield3.Items.Insert(0, new ListItem(dt.Rows[0]["hy_fieldname_fl3"].ToString(), dt.Rows[0]["hy_fieldid_fl3"].ToString()));
}
}
dt.Clear();
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
DataTable dt5 = Hyoa_listsearchfield.Getlistsearchfieldsbylistid(this.txtdocid.Value);
if (dt5.Rows.Count > 0)
{
for (int m = 0; m < dt5.Rows.Count; m++)
{
this.searchselect.Items.Insert(m, new ListItem(dt5.Rows[m]["hy_field"].ToString(), dt5.Rows[m]["hy_fieldid"].ToString()));
}
}
}
}
else
{
//自动获取最大排序号，然后+2
DataTable dt_maxsort = Hyoa_listconfig.GetMaxlistconfigsort();
if (dt_maxsort.Rows.Count > 0)
txtsort.Text = (int.Parse(dt_maxsort.Rows[0]["hy_sort"].ToString()) + 2).ToString();
else
txtsort.Text = "1";
}
}
}
