protected void btndelinfo_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
String[] v_uids = this.txtuids.Value.Split(',');
for (var i = 0; i < v_uids.Length; i++)
{
if (v_uids[i] != "")
{
Hyoa_listconfig.ID = v_uids[i];
Hyoa_listconfig.Delete();
Hyoa_listsearchfield.hy_listid = v_uids[i];
Hyoa_listsearchfield.DeleteBylistid();
}
}
this.txtuids.Value = "";
//DataPlay(1);
DataPlay(System.Int32.Parse(this.curpage.Text));
}
public string hyjs()
{
//输出查询字段的JS start
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
DataTable dtlistsearch = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndTableid(this.txtmudelid.Value,this.txttableid.Value);
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtgetsqlfield;
string ls_return = "";
string fieldfz = "";//对应域JS域值
ls_return += "<script>function jssearch()"; //js生成
ls_return += "{fm = document.forms[0];";//js生成
for (int t = 0; t < dtlistsearch.Rows.Count; t++)
{
//根据模块ID和当前域名和表名id得到SQL字段 ztmztm
dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, dtlistsearch.Rows[t]["hy_fieldid"].ToString(), this.txttableid.Value);
fieldfz = "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + ".value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_1.value;";
if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString()=="数值")
{
fieldfz = "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_start.value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1.value;";
fieldfz += "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_end.value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1.value;";
}
if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "日期")
{
fieldfz = "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_start.value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1.value;";
fieldfz += "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_end.value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1.value;";
}
if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "对话框列表")
{
//document.forms[0].fNumber（域名）.options[document.forms[0].fNumber（域名）.selectedIndex].text
fieldfz += "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + ".value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_1.options[fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_1.selectedIndex].text;";
}
ls_return += fieldfz;
dtgetsqlfield.Clear();
}
ls_return += "fm.btnsearch.click();";//js生成
ls_return += "}</script>";//js生成
return ls_return;
}
public void GetSearchTableHtml()
{
//输出查询字段的表格（查询输入框） start
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
DataTable dtlistsearch = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndTableid(this.txtmudelid.Value, this.txttableid.Value);
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
//DataTable dtgetsqlfield;
string lssearchdispaly = ""; //返回值
//输出外框（开始）
lssearchdispaly +="<tr height=40px>";
lssearchdispaly +="<td valign=\"top\" >";
lssearchdispaly +="<table width=\"100%\" border=0>";
lssearchdispaly +="<tr>";
lssearchdispaly +="<td align=\"center\" valign=\"top\">";
lssearchdispaly +="<table width=\"100%\" height=\"5\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
lssearchdispaly +="<tr>";
lssearchdispaly +="<td></td>";
lssearchdispaly +="</tr>";
lssearchdispaly +="</table>";
lssearchdispaly +="<table width=\"98%\" border=0 cellpadding=0 cellspacing=1 class=\"tb1-main\">";
HyoaClass.DAO db = new HyoaClass.DAO();
string lsflag = "0"; //1表示有</tr>,则最后不用输出，否则循环完后，要输出一个</tr>
for (int t = 0; t < dtlistsearch.Rows.Count; t++)
{
if (t % 2 == 0)
{
lssearchdispaly += "<tr>";
lsflag = "0";
}
//得到hyt_listsearchfield表中的hy_fieldid，
string lslistsearch = dtlistsearch.Rows[t]["hy_fieldid"].ToString();
//根据字段英文名得到数据库中对应的字段名，ztmztm
DataTable dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, lslistsearch, this.txttableid.Value); //得到与SQL表对应的字段名
lssearchdispaly += "<td width=\"15%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">";
lssearchdispaly += dtlistsearch.Rows[t]["hy_field"].ToString();
lssearchdispaly += "</td>";
lssearchdispaly += " <td width=\"35%\" align=\"left\" class=\"Tdcellright\">";
//调用公用函数，输出txt查询框
lssearchdispaly += GetFieldHtml(this.txtmudelid.Value, dtgetsqlfield.Rows[0]["hy_fieldid"].ToString(), "0", this.txttableid.Value, "1");
lssearchdispaly += "</td>";
if ((t + 1) % 2 == 0)
{
lssearchdispaly += "</tr>";
lsflag = "1";
}
dtgetsqlfield.Clear();
}
//如果上面</tr>没有输出过，则要输出一个</tr>，保证html的完整性
if (lsflag != "1")
{
for (int t = 0; t < (4 - dtlistsearch.Rows.Count % 2 * 2); t++)
{
//如果行不足四列，则要补满四列
lssearchdispaly += " <td align=\"left\" class=\"Tdcellright\">";
lssearchdispaly += " ";
lssearchdispaly += "</td>";
}
lssearchdispaly += "</tr>";
}
//输出外框（结束）
lssearchdispaly += "<tr>";
lssearchdispaly += "<td height=\"30\" align=\"right\" class=\"Tdcellright\" colspan=4>";
lssearchdispaly += "<input type=\"button\" onclick=\"jssearch();\" value=\" 查 询\" class=btn7 name=\"Button_Return\" /> ";
lssearchdispaly += "</td>";
lssearchdispaly += "</tr>";
lssearchdispaly += "</table>";
lssearchdispaly += "</td>";
lssearchdispaly += "</tr>";
lssearchdispaly += "</table>";
lssearchdispaly += "</td>";
lssearchdispaly += "</tr>";
this.lbsearchidspaly.Text = lssearchdispaly;
//输出查询字段的表格 end
}
//输出查询字段的表格（查询输入框）
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);
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "复制成功！";
try
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
#region 生成权限
DataTable dt = Hyoa_role.Getrole("Role" + this.txtmudelid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该权限编号已存在，请重新填写！');history.back();</script>");
return;
}
else
{
Hyoa_role.hy_roleid = "Role" + this.txtmudelid.Text;
Hyoa_role.hy_rolename = this.txtmudelname.Text;
Hyoa_role.hy_sort = System.Int32.Parse(this.txtno.Value);
Hyoa_role.Insert();
}
#endregion
#region 生成模块
dt = Hyoa_mudel.Getmudel("Mudel" + this.txtmudelid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该模块编号已存在，请重新填写！');history.back();</script>");
return;
}
else
{
Hyoa_mudel.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_mudel.hy_mudelname = this.txtmudelname.Text;
Hyoa_mudel.hy_sort = System.Int32.Parse(this.txtno.Value);
Hyoa_mudel.hy_isenabled = "是";
Hyoa_mudel.hy_roleid = "Role" + this.txtmudelid.Text;
Hyoa_mudel.hy_qqroleid = "Role" + this.txtmudelid.Text;
Hyoa_mudel.Insert();
}
#endregion
#region 生成表单
DataTable tableconfigdt = Hyoa_tableconfig.GetTablesbymudelid(this.ddlmudelid.SelectedValue);
if (tableconfigdt.Rows.Count > 0)
{
Hyoa_tableconfig.ID = "Table" + this.txtmudelid.Text;
Hyoa_tableconfig.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_tableconfig.hy_name = this.txtmudelname.Text;
Hyoa_tableconfig.hy_onload = tableconfigdt.Rows[0]["hy_onload"].ToString();
Hyoa_tableconfig.hy_sort = float.Parse(this.txtno.Value);
Hyoa_tableconfig.hy_ifflowdoc = tableconfigdt.Rows[0]["hy_ifflowdoc"].ToString();
Hyoa_tableconfig.hy_ifdisplayall = tableconfigdt.Rows[0]["hy_ifdisplayall"].ToString();
Hyoa_tableconfig.hy_ispuballByflowYB = tableconfigdt.Rows[0]["hy_ispuballByflowYB"].ToString();
Hyoa_tableconfig.hy_tablerole = tableconfigdt.Rows[0]["hy_tablerole"].ToString();
Hyoa_tableconfig.hy_ifcomment = tableconfigdt.Rows[0]["hy_ifcomment"].ToString();
Hyoa_tableconfig.hy_colnum = float.Parse(tableconfigdt.Rows[0]["hy_colnum"].ToString());
Hyoa_tableconfig.hy_field1 = tableconfigdt.Rows[0]["hy_field1"].ToString();
Hyoa_tableconfig.hy_field2 = tableconfigdt.Rows[0]["hy_field2"].ToString();
Hyoa_tableconfig.hy_field3 = tableconfigdt.Rows[0]["hy_field3"].ToString();
Hyoa_tableconfig.hy_field4 = tableconfigdt.Rows[0]["hy_field4"].ToString();
Hyoa_tableconfig.hy_field5 = tableconfigdt.Rows[0]["hy_field5"].ToString();
Hyoa_tableconfig.Insert();
}
#endregion
#region 生成表单字段
int i;
DataTable flowfielddt = Hyoa_flowfield.Getflowfieldsbytableid(this.ddltableid.SelectedValue);
if (flowfielddt.Rows.Count > 0)
{
for (i = 0; i < flowfielddt.Rows.Count; i++)
{
Hyoa_flowfield.ID = Hyoa_global.GetRandom();
Hyoa_flowfield.hy_tableid = "Table" + this.txtmudelid.Text;
Hyoa_flowfield.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_flowfield.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowfield.hy_fieldid = flowfielddt.Rows[i]["hy_fieldid"].ToString();
Hyoa_flowfield.hy_fieldname = flowfielddt.Rows[i]["hy_fieldname"].ToString();
Hyoa_flowfield.hy_fieldtype = flowfielddt.Rows[i]["hy_fieldtype"].ToString();
Hyoa_flowfield.hy_ifreadonly = flowfielddt.Rows[i]["hy_ifreadonly"].ToString();
Hyoa_flowfield.hy_defaultvaluetype = System.Int32.Parse(flowfielddt.Rows[i]["hy_defaultvaluetype"].ToString());
Hyoa_flowfield.hy_defaultvalue = flowfielddt.Rows[i]["hy_defaultvalue"].ToString();
Hyoa_flowfield.hy_optiontype = System.Int32.Parse(flowfielddt.Rows[i]["hy_optiontype"].ToString());
Hyoa_flowfield.hy_options = flowfielddt.Rows[i]["hy_options"].ToString();
Hyoa_flowfield.hy_onclick = flowfielddt.Rows[i]["hy_onclick"].ToString();
Hyoa_flowfield.hy_ondblclick = flowfielddt.Rows[i]["hy_ondblclick"].ToString();
Hyoa_flowfield.hy_onchange = flowfielddt.Rows[i]["hy_onchange"].ToString();
Hyoa_flowfield.hy_onkeydown = flowfielddt.Rows[i]["hy_onkeydown"].ToString();
Hyoa_flowfield.hy_onkeyup = flowfielddt.Rows[i]["hy_onkeyup"].ToString();
Hyoa_flowfield.hy_onfocus = flowfielddt.Rows[i]["hy_onfocus"].ToString();
Hyoa_flowfield.hy_onblur = flowfielddt.Rows[i]["hy_onblur"].ToString();
Hyoa_flowfield.hy_sqlfield = flowfielddt.Rows[i]["hy_sqlfield"].ToString();
Hyoa_flowfield.hy_class = flowfielddt.Rows[i]["hy_class"].ToString();
Hyoa_flowfield.hy_width = flowfielddt.Rows[i]["hy_width"].ToString();
Hyoa_flowfield.hy_height = flowfielddt.Rows[i]["hy_height"].ToString();
Hyoa_flowfield.hy_tdnums = System.Int32.Parse(flowfielddt.Rows[i]["hy_tdnums"].ToString());
Hyoa_flowfield.hy_config = flowfielddt.Rows[i]["hy_config"].ToString();
Hyoa_flowfield.hy_sort = float.Parse(flowfielddt.Rows[i]["hy_sort"].ToString());
Hyoa_flowfield.hy_wordlimit = System.Int32.Parse(flowfielddt.Rows[i]["hy_wordlimit"].ToString());
Hyoa_flowfield.hy_required = flowfielddt.Rows[i]["hy_required"].ToString();
Hyoa_flowfield.hy_align = flowfielddt.Rows[i]["hy_align"].ToString();
Hyoa_flowfield.hy_ifhiddle = flowfielddt.Rows[i]["hy_ifhiddle"].ToString();
Hyoa_flowfield.hy_ifdbsybt = flowfielddt.Rows[i]["hy_ifdbsybt"].ToString();
Hyoa_flowfield.hy_field1 = flowfielddt.Rows[i]["hy_field1"].ToString();
Hyoa_flowfield.hy_field2 = flowfielddt.Rows[i]["hy_field2"].ToString();
Hyoa_flowfield.hy_field3 = flowfielddt.Rows[i]["hy_field3"].ToString();
Hyoa_flowfield.hy_field4 = flowfielddt.Rows[i]["hy_field4"].ToString();
Hyoa_flowfield.hy_field5 = flowfielddt.Rows[i]["hy_field5"].ToString();
Hyoa_flowfield.Insert();
}
}
#endregion
#region 生成SQL/ORACLE中的表
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * into hyc_Table" + this.txtmudelid.Text + " from hyc_" + this.ddltableid.SelectedValue + " where 1=0";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "create table hyc_Table" + this.txtmudelid.Text + " as select * from hyc_" + this.ddltableid.SelectedValue + " where 1=2";
}
Hyoa_global.ExcuteSQL(sql);
#endregion
#region 生成列表
DataTable listconfigdt = Hyoa_listconfig.GetlistconfigsbyMudelidAndTableid(this.ddlmudelid.SelectedValue, this.ddltableid.SelectedValue);
//列表ID
string strListId = Hyoa_global.GetRandom();
if (listconfigdt.Rows.Count > 0)
{
Hyoa_listconfig.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_listconfig.hy_tableid = "Table" + this.txtmudelid.Text;
Hyoa_listconfig.hy_ifflowdoc = listconfigdt.Rows[0]["hy_ifflowdoc"].ToString();
Hyoa_listconfig.hy_sort = System.Int32.Parse(this.txtno.Value);
Hyoa_listconfig.hy_columnshowid = listconfigdt.Rows[0]["hy_columnshowid"].ToString();
Hyoa_listconfig.hy_columnshow = listconfigdt.Rows[0]["hy_columnshow"].ToString();
Hyoa_listconfig.hy_ifsearch = listconfigdt.Rows[0]["hy_ifsearch"].ToString();
Hyoa_listconfig.hy_ifshowsearch = listconfigdt.Rows[0]["hy_ifshowsearch"].ToString();
Hyoa_listconfig.hy_width = listconfigdt.Rows[0]["hy_width"].ToString();
Hyoa_listconfig.hy_listname = this.txtmudelname.Text;
Hyoa_listconfig.hy_sortfield1 = listconfigdt.Rows[0]["hy_sortfield1"].ToString();
Hyoa_listconfig.hy_sorttype1 = listconfigdt.Rows[0]["hy_sorttype1"].ToString();
Hyoa_listconfig.hy_sortfield2 = listconfigdt.Rows[0]["hy_sortfield2"].ToString();
Hyoa_listconfig.hy_sorttype2 = listconfigdt.Rows[0]["hy_sorttype2"].ToString();
Hyoa_listconfig.hy_sortfield3 = listconfigdt.Rows[0]["hy_sortfield3"].ToString();
Hyoa_listconfig.hy_sorttype3 = listconfigdt.Rows[0]["hy_sorttype3"].ToString();
Hyoa_listconfig.hy_fieldid_fl1 = listconfigdt.Rows[0]["hy_fieldid_fl1"].ToString();
Hyoa_listconfig.hy_fieldname_fl1 = listconfigdt.Rows[0]["hy_fieldname_fl1"].ToString();
Hyoa_listconfig.hy_sql_fl1 = listconfigdt.Rows[0]["hy_sql_fl1"].ToString();
Hyoa_listconfig.hy_fieldid_fl2 = listconfigdt.Rows[0]["hy_fieldid_fl2"].ToString();
Hyoa_listconfig.hy_fieldname_fl2 = listconfigdt.Rows[0]["hy_fieldname_fl2"].ToString();
Hyoa_listconfig.hy_sql_fl2 = listconfigdt.Rows[0]["hy_sql_fl2"].ToString();
Hyoa_listconfig.hy_fieldid_fl3 = listconfigdt.Rows[0]["hy_fieldid_fl3"].ToString();
Hyoa_listconfig.hy_fieldname_fl3 = listconfigdt.Rows[0]["hy_fieldname_fl3"].ToString();
Hyoa_listconfig.hy_sql_fl3 = listconfigdt.Rows[0]["hy_sql_fl3"].ToString();
Hyoa_listconfig.ID = strListId;
Hyoa_listconfig.Insert();
}
#endregion
#region 生成列表查询条件
DataTable listsearchdt = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndTableid(this.ddlmudelid.SelectedValue, this.ddltableid.SelectedValue);
for (int m = 0; m < listsearchdt.Rows.Count; m++)
{
Hyoa_listsearchfield.ID = Hyoa_global.GetRandom();
Hyoa_listsearchfield.hy_listid = strListId;
Hyoa_listsearchfield.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_listsearchfield.hy_tableid = "Table" + this.txtmudelid.Text;
Hyoa_listsearchfield.hy_field = listsearchdt.Rows[m]["hy_field"].ToString();
Hyoa_listsearchfield.hy_fieldid = listsearchdt.Rows[m]["hy_fieldid"].ToString();
Hyoa_listsearchfield.hy_sort = m + 2;
Hyoa_listsearchfield.Insert();
}
#endregion
#region 生成流程信息
string lssoureceflowid = "";
if (tableconfigdt.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
DataTable flowinfordt = Hyoa_flowinfor.Getflowinforbymudelid(this.ddlmudelid.SelectedValue);
if (flowinfordt.Rows.Count > 0)
{
//得到老模块的flowid 后面要用到
lssoureceflowid = flowfielddt.Rows[0]["hy_flowid"].ToString();
//插入流程信息start
Hyoa_flowinfor.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowinfor.hy_flowname = this.txtmudelname.Text;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtno.Value);
Hyoa_flowinfor.hy_mudelid = "Mudel" + this.txtmudelid.Text;
// Hyoa_flowinfor.hy_addbyalluser = flowinfordt.Rows[0]["hy_addbyalluser"].ToString();
Hyoa_flowinfor.Insert();
}
//插入流程信息end
//流程环节
DataTable flowtachedt = Hyoa_flowtache.Getflowtachebyflowid(lssoureceflowid);
if (flowtachedt.Rows.Count > 0)
{
for (i = 0; i < flowtachedt.Rows.Count; i++)
{
Hyoa_flowtache.ID = Hyoa_global.GetRandom();
Hyoa_flowtache.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowtache.hy_tacheid = flowtachedt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtache.hy_tachename = flowtachedt.Rows[i]["hy_tachename"].ToString();
Hyoa_flowtache.hy_sort = System.Int32.Parse(flowtachedt.Rows[i]["hy_sort"].ToString());
Hyoa_flowtache.hy_ifshowcurcomp = flowtachedt.Rows[i]["hy_ifshowcurcomp"].ToString();
Hyoa_flowtache.hy_ifshowcurdept = flowtachedt.Rows[i]["hy_ifshowcurdept"].ToString();
Hyoa_flowtache.hy_XValue = flowtachedt.Rows[i]["hy_XValue"].ToString();
Hyoa_flowtache.hy_YValue = flowtachedt.Rows[i]["hy_YValue"].ToString();
Hyoa_flowtache.hy_rdDoIsSendSms = flowtachedt.Rows[i]["hy_rdDoIsSendSms"].ToString();
Hyoa_flowtache.hy_rdDoIsSendMessage = flowtachedt.Rows[i]["hy_rdDoIsSendMessage"].ToString();
Hyoa_flowtache.hy_rdPassIsSendSms = flowtachedt.Rows[i]["hy_rdPassIsSendSms"].ToString();
Hyoa_flowtache.hy_rdPassIsSendMessage = flowtachedt.Rows[i]["hy_rdPassIsSendMessage"].ToString();
Hyoa_flowtache.hy_enablecondition = flowtachedt.Rows[i]["hy_enablecondition"].ToString();
Hyoa_flowtache.Insert();
}
}
//流程环节对应的域
DataTable flowtachefielddt = Hyoa_flowtachefield.Getflowtachefieldbyflowid(lssoureceflowid);
if (flowtachefielddt.Rows.Count > 0)
{
for (i = 0; i < flowtachefielddt.Rows.Count; i++)
{
Hyoa_flowtachefield.ID = Hyoa_global.GetRandom();
Hyoa_flowtachefield.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowtachefield.hy_tacheid = flowtachefielddt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtachefield.hy_fieldid = flowtachefielddt.Rows[i]["hy_fieldid"].ToString();
Hyoa_flowtachefield.Insert();
}
}
//流程环节对应的用户
DataTable flowtacheuserdt = Hyoa_flowtacheuser.Getflowtacheuserbyflowid(lssoureceflowid);
if (flowtacheuserdt.Rows.Count > 0)
{
for (i = 0; i < flowtacheuserdt.Rows.Count; i++)
{
Hyoa_flowtacheuser.ID = Hyoa_global.GetRandom();
Hyoa_flowtacheuser.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowtacheuser.hy_tacheid = flowtacheuserdt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtacheuser.hy_userid = flowtacheuserdt.Rows[i]["hy_userid"].ToString();
Hyoa_flowtacheuser.Insert();
}
}
//工作流
DataTable flowworkdt = Hyoa_flowwork.Getflowworksbyflowid(lssoureceflowid);
if (flowworkdt.Rows.Count > 0)
{
for (i = 0; i < flowworkdt.Rows.Count; i++)
{
Hyoa_flowwork.ID = Hyoa_global.GetRandom();
Hyoa_flowwork.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowwork.hy_curtacheid = flowworkdt.Rows[i]["hy_curtacheid"].ToString();
Hyoa_flowwork.hy_curtachename = flowworkdt.Rows[i]["hy_curtachename"].ToString();
Hyoa_flowwork.hy_nexttacheid = flowworkdt.Rows[i]["hy_nexttacheid"].ToString();
Hyoa_flowwork.hy_nexttachename = flowworkdt.Rows[i]["hy_nexttachename"].ToString();
Hyoa_flowwork.hy_sort = System.Int32.Parse(flowworkdt.Rows[i]["hy_sort"].ToString());
Hyoa_flowwork.hy_actiontype = flowworkdt.Rows[i]["hy_actiontype"].ToString();
Hyoa_flowwork.hy_identity_type = flowworkdt.Rows[i]["hy_identity_type"].ToString();
Hyoa_flowwork.hy_identity_id = flowworkdt.Rows[i]["hy_identity_id"].ToString();
Hyoa_flowwork.hy_jscondition = flowworkdt.Rows[i]["hy_jscondition"].ToString();
Hyoa_flowwork.hy_jscondition1 = flowworkdt.Rows[i]["hy_jscondition1"].ToString();
Hyoa_flowwork.hy_jscondition2 = flowworkdt.Rows[i]["hy_jscondition2"].ToString();
Hyoa_flowwork.hy_zdcyuserids = flowworkdt.Rows[i]["hy_zdcyuserids"].ToString();
Hyoa_flowwork.Insert();
}
}
}
#endregion
}
catch
{
ls_tip = "复制失败！";
}
finally
{
Response.Write("<script>alert('" + ls_tip + "');window.location.href='" + txturl.Text + "';</script>");
}
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功！";
//新文档时
string lscolunid = "";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
Hyoa_listconfig.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_listconfig.hy_tableid = this.ddltableid.SelectedValue;
Hyoa_listconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
Hyoa_listconfig.hy_sort = System.Int32.Parse(this.txtsort.Text);
Hyoa_listconfig.hy_columnshowid = this.txtselcolid.Value;
Hyoa_listconfig.hy_columnshow = this.txtselcol.Value;
Hyoa_listconfig.hy_ifsearch = this.ddlifsearch.SelectedValue;
Hyoa_listconfig.hy_ifshowsearch = this.ddlifshowsearch.SelectedValue;
Hyoa_listconfig.hy_width = this.txtwidth.Text;
Hyoa_listconfig.hy_listname = this.txthy_listname.Text;
Hyoa_listconfig.hy_sortfield1 = this.txtselsortfieldid1.Value;
Hyoa_listconfig.hy_sorttype1 = this.ddlsorttype1.SelectedValue;
Hyoa_listconfig.hy_sortfield2 = this.txtselsortfieldid2.Value;
Hyoa_listconfig.hy_sorttype2 = this.ddlsorttype2.SelectedValue;
Hyoa_listconfig.hy_sortfield3 = this.txtselsortfieldid3.Value;
Hyoa_listconfig.hy_sorttype3 = this.ddlsorttype3.SelectedValue;
Hyoa_listconfig.hy_fieldid_fl1 = this.txtflfieldid1.Value;
Hyoa_listconfig.hy_fieldname_fl1 = this.txtflfieldname1.Value;
Hyoa_listconfig.hy_sql_fl1 = this.txthy_field_fl1.Text;
Hyoa_listconfig.hy_fieldid_fl2 = this.txtflfieldid2.Value;
Hyoa_listconfig.hy_fieldname_fl2 = this.txtflfieldname2.Value;
Hyoa_listconfig.hy_sql_fl2 = this.txthy_field_fl2.Text;
Hyoa_listconfig.hy_fieldid_fl3 = this.txtflfieldid3.Value;
Hyoa_listconfig.hy_fieldname_fl3 = this.txtflfieldname3.Value;
Hyoa_listconfig.hy_sql_fl3 = this.txthy_field_fl3.Text;
if (this.txtop.Value == "add")
{
lscolunid = Hyoa_global.GetRandom();
Hyoa_listconfig.ID = lscolunid;
Hyoa_listconfig.Insert();
//向查询字段表中插入数据
string[] lv_selsearchid;
string[] lv_selsearch;
lv_selsearchid = this.txtselsearchid.Value.ToString().Split(',');
lv_selsearch = this.txtselsearch.Value.ToString().Split(',');
for (int m = 0; m < lv_selsearchid.Length; m++)
{
Hyoa_listsearchfield.ID = Hyoa_global.GetRandom();
Hyoa_listsearchfield.hy_listid = lscolunid;
Hyoa_listsearchfield.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_listsearchfield.hy_tableid = this.ddltableid.SelectedValue;
Hyoa_listsearchfield.hy_field = lv_selsearch[m];
Hyoa_listsearchfield.hy_fieldid = lv_selsearchid[m];
Hyoa_listsearchfield.hy_sort = m + 1;
Hyoa_listsearchfield.Insert();
}
}
else
{
Hyoa_listconfig.ID = this.txtdocid.Value;
Hyoa_listconfig.Update();
//向查询字段表中插入数据
//要先删除再插入
Hyoa_listsearchfield.hy_listid = this.txtdocid.Value;
Hyoa_listsearchfield.DeleteBylistid();
string[] lv_selsearchid;
string[] lv_selsearch;
lv_selsearchid = this.txtselsearchid.Value.ToString().Split(',');
lv_selsearch = this.txtselsearch.Value.ToString().Split(',');
for (int m = 0; m < lv_selsearchid.Length; m++)
{
Hyoa_listsearchfield.ID = Hyoa_global.GetRandom();
Hyoa_listsearchfield.hy_listid = this.txtdocid.Value;
Hyoa_listsearchfield.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_listsearchfield.hy_tableid = this.ddltableid.SelectedValue;
Hyoa_listsearchfield.hy_field = lv_selsearch[m];
Hyoa_listsearchfield.hy_fieldid = lv_selsearchid[m];
Hyoa_listsearchfield.hy_sort = m;
Hyoa_listsearchfield.Insert();
}
}
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
private void DataPlay()
{
//是否启用
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";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_mudelid="";
string ls_colname="";
string ls_colid="";
string ls_colname2="";
string ls_colid2="";
string ls_colname3="";
string ls_colid3="";
string ls_tableid = "";
if (this.Request.QueryString["mudelid"] != null)
{
ls_mudelid = this.Request.QueryString["mudelid"].ToString();
}
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
}
//模块对应的域
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dt4 = Hyoa_flowfield.GetflowfieldsbyMudelidAndTableid(ls_mudelid, ls_tableid);
if (dt4.Rows.Count > 0)
{
for (int i = 0; i < dt4.Rows.Count; i++)
{
if (ls_colname == "")
{
ls_colname = dt4.Rows[i]["hy_fieldname"].ToString();
ls_colid = dt4.Rows[i]["hy_fieldid"].ToString();
}
else
{
ls_colname = ls_colname + "+" + dt4.Rows[i]["hy_fieldname"].ToString();
ls_colid = ls_colid + "+" + dt4.Rows[i]["hy_fieldid"].ToString();
}
}
}
dt4.Clear();
string lsid = "";
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
dt4 = Hyoa_listconfig.GetlistconfigsbyMudelidAndTableid(ls_mudelid,ls_tableid);
if (dt4.Rows.Count > 0)
{
ls_colname2 = dt4.Rows[0]["hy_columnshow"].ToString();
ls_colid2 = dt4.Rows[0]["hy_columnshowid"].ToString();
lsid = dt4.Rows[0]["ID"].ToString();
}
dt4.Clear();
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
dt4 = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndListid(ls_mudelid,lsid);
if (dt4.Rows.Count > 0)
{
for (int k = 0; k < dt4.Rows.Count; k++)
{
if (ls_colname3 == "")
{
ls_colname3 = dt4.Rows[k]["hy_field"].ToString();
ls_colid3 = dt4.Rows[k]["hy_fieldid"].ToString();
}
else
{
ls_colname3 = ls_colname3 + "+" + dt4.Rows[k]["hy_field"].ToString();
ls_colid3 = ls_colid3 + "+" + dt4.Rows[k]["hy_fieldid"].ToString();
}
}
}
//HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
this.Response.Write(ls_colname + "*" + ls_colid + "#" + ls_colname2 + "*" + ls_colid2 + "#" + ls_colname3 + "*" + ls_colid3);
//return ;
}
