//模块权限列表
protected string fRoleNames()
{
string ls_return = "";
string ls_userid = "";
string ls_roleids = "";
//加载
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
DataTable dt = Hyoa_role.Getroles();
//fdselectroleid
if (this.Request.QueryString["selectroleid"] != null)
{
this.fdselectroleid.Value = ","+ this.Request.QueryString["selectroleid"].ToString()+",";
}
if(dt.Rows.Count>0)
{
for(var i=0;i<dt.Rows.Count;i++)
{
//if (ls_roleids == "")
//{
ls_return += "<td width=\"25%\">";
if (this.fdselectroleid.Value.IndexOf(","+dt.Rows[i]["hy_roleid"].ToString()+",") >= 0)
{
//判断是否已经选中，如果选中了，则前面打勾
ls_return += "<input type=\"checkbox\" checked=true name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\" text=\"" + dt.Rows[i]["hy_rolename"].ToString() + "\" id=\"" + dt.Rows[i]["hy_rolename"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString();
}
else
{
ls_return += "<input type=\"checkbox\" name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\" text=\"" + dt.Rows[i]["hy_rolename"].ToString() + "\" id=\"" + dt.Rows[i]["hy_rolename"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString();
}
ls_return += "</td>";
//}
//else
//{
// if (ls_roleids.Contains(dt.Rows[i]["hy_roleid"].ToString()))
// {
// ls_return += "<td width=\"25%\"><input type=\"checkbox\" checked=\"checked\" name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\" text=\"" + dt.Rows[i]["hy_rolename"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString() + "</td>";
// }
// else
// {
// ls_return += "<td width=\"25%\"><input type=\"checkbox\" name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\" text=\"" + dt.Rows[i]["hy_rolename"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString() + "</td>";
// }
//}
if (((i+1) % 4)==0 && i<dt.Rows.Count)
ls_return += "</tr><tr>";
}
}
dt.Clear();
return ls_return;
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功！";
//新文档时
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
if (this.txtop.Value == "add")
{
//先判断这个ROLEID是否已经存在
DataTable dt = Hyoa_role.Getrole(this.txtroleid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该权限已存在，请重新填写！');history.back();</script>");
return;
}
if (this.txtroleid.Text.Length < 5)
{
Response.Write("<script>alert('权限编号长度必须大于4位！');history.back();</script>");
return;
}
if (this.txtroleid.Text.Substring(0, 4) != "Role")
{
Response.Write("<script>alert('权限编号必须以Role开头！');history.back();</script>");
return;
}
Hyoa_role.hy_roleid = this.txtroleid.Text;
Hyoa_role.hy_rolename = this.txtrolename.Value;
Hyoa_role.hy_sort = System.Int32.Parse(this.txtroleno.Value);
Hyoa_role.Insert();
}
else
{
Hyoa_role.hy_roleid = this.txtroleid.Text;
Hyoa_role.hy_rolename = this.txtrolename.Value;
Hyoa_role.hy_sort = System.Int32.Parse(this.txtroleno.Value);
Hyoa_role.Update();
}
//处理完成后的提示及跳转
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>");
}
}
protected void btndelinfo_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
String[] v_uids = this.txtuids.Value.Split(',');
for (var i = 0; i < v_uids.Length; i++)
{
if (v_uids[i] != "")
{
Hyoa_role.hy_roleid = v_uids[i];
Hyoa_role.Delete();
}
}
this.txtuids.Value = "";
//DataPlay(1);
DataPlay(System.Int32.Parse(this.curpage.Text));
}
private void DataPlay()
{
//加载一级目录ID、一级目录名称、每个一级目录最大的二级目录
HyoaClass.Hyoa_ml Hyoa_firstml = new HyoaClass.Hyoa_ml();
DataTable dtfirstml = Hyoa_firstml.GetFirstmls();
if (dtfirstml.Rows.Count > 0)
{
this.ddlfirstmlid.DataSource = dtfirstml;
this.ddlfirstmlid.DataTextField = "MLID";
this.ddlfirstmlid.DataValueField = "MLID";
this.ddlfirstmlid.DataBind();
this.ddlfirstmlid.Items.Insert(0, "--请选择--");
this.ddlfirstmlid.SelectedIndex = 0;
this.ddlfirstmlname.DataSource = dtfirstml;
this.ddlfirstmlname.DataTextField = "MLName";
this.ddlfirstmlname.DataValueField = "MLName";
this.ddlfirstmlname.DataBind();
this.ddlfirstmlname.Items.Insert(0, "--请选择--");
this.ddlfirstmlname.SelectedIndex = 0;
//加载每个一级目录最大的二级目录
string ls_id;
for (var i = 0; i < dtfirstml.Rows.Count; i++)
{
ls_id = Hyoa_firstml.GetMaxMLID(dtfirstml.Rows[i]["MLID"].ToString());
this.ddlsecondmlid.Items.Insert(i, ls_id);
}
this.ddlsecondmlid.Items.Insert(0, "--请选择--");
this.ddlsecondmlid.SelectedIndex = 0;
}
//加载模块信息
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, "--请选择--");
this.ddlmudelid.SelectedIndex = 0;
}
//加载权限
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
DataTable dtrole = Hyoa_role.Getroles();
if (dtrole.Rows.Count > 0)
{
this.ddlrole.DataSource = dtrole;
this.ddlrole.DataTextField = "hy_rolename";
this.ddlrole.DataValueField = "hy_roleid";
this.ddlrole.DataBind();
this.ddlrole.Items.Insert(0, "--请选择--");
this.ddlrole.SelectedIndex = 0;
}
this.ddlisenabled.Items.Insert(0, "是");
this.ddlisenabled.Items.Insert(1, "否");
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_ml Hyoa_ml = new HyoaClass.Hyoa_ml();
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
if (this.Request.QueryString["id"] != null)
{
//根据id得到信息
this.lblid.Value = this.Request.QueryString["id"].ToString();
this.txtMLID.Value = this.Request.QueryString["id"].ToString();
DataTable dt = Hyoa_ml.Getml(this.lblid.Value);
if (dt.Rows.Count > 0)
{
this.txtname.Value = dt.Rows[0]["MLName"].ToString();
this.txtlink.Value = dt.Rows[0]["hy_link"].ToString();
this.ddltarget.SelectedValue = dt.Rows[0]["hy_target"].ToString();
this.ddlrole.SelectedValue = dt.Rows[0]["hy_role"].ToString();
this.txtsort.Value = dt.Rows[0]["hy_sort"].ToString();
//模块信息定位
for (var i = 0; i < this.ddlmudelid.Items.Count; i++)
{
if (this.ddlmudelid.Items[i].Value == dt.Rows[0]["hy_mudelid"].ToString())
{
this.ddlmudelid.SelectedIndex = i;
}
}
//一级目录定位
for (var i = 0; i < this.ddlfirstmlid.Items.Count; i++)
{
if (this.ddlfirstmlid.Items[i].Value == dt.Rows[0]["MLID"].ToString().Substring(0,3))
{
this.ddlfirstmlid.SelectedIndex = i;
this.ddlfirstmlname.SelectedIndex = i;
}
}
if (dt.Rows[0]["hy_ifqy"].ToString() == "是")
this.ddlisenabled.SelectedIndex = 0;
else
this.ddlisenabled.SelectedIndex = 1;
//根据模块信息得到对应的选择表单值
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.SelectedValue = dt.Rows[0]["hy_tableid"].ToString();
}
}
}
dt.Clear();
}
}
}
}
private void DataPlay()
{
this.btn_submit.Visible = false; //保存
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", (this.Session["hyuid"].ToString())))
{
this.btn_submit.Visible = true; //保存
}
//加载模块信息
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, "--请选择--");
this.ddlmudelid.SelectedIndex = 0;
}
//获取排序号
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
DataTable dt = Hyoa_role.GetMaxrolesort();
if (dt.Rows.Count > 0)
this.txtno.Value = (System.Int32.Parse(dt.Rows[0]["hy_sort"].ToString()) + 2).ToString();
else
this.txtno.Value = "1";
}
//保存
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 string fRoleNames()
{
string ls_return = "";
string ls_userid = "";
string ls_roleids = "";
if(this.Request.QueryString["userid"]!=null)
{
ls_userid = this.Request.QueryString["userid"].ToString();
//得到已有的模块权限
HyoaClass.Hyoa_roleuser Hyoa_roleuser = new HyoaClass.Hyoa_roleuser();
DataTable dtroleuser = Hyoa_roleuser.Getrolesbyuserid(ls_userid);
if (dtroleuser.Rows.Count > 0)
{
for (var i = 0; i < dtroleuser.Rows.Count; i++)
{
ls_roleids += "," + dtroleuser.Rows[i]["hy_roleid"].ToString();
}
this.fdHaveRoleid.Value = ls_roleids + ",";
}
//加载
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
DataTable dt = Hyoa_role.Getroles();
if (dt.Rows.Count > 0)
{
for (var i = 0; i < dt.Rows.Count; i++)
{
if (ls_roleids == "")
{
ls_return += "<td style=\"border-bottom:1px solid #cccccc\" width=\"25%\"><input type=\"checkbox\" name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString() + "</td>";
}
else
{
if (ls_roleids.Contains(dt.Rows[i]["hy_roleid"].ToString()))
{
ls_return += "<td style=\"border-bottom:1px solid #cccccc\" width=\"25%\"><input type=\"checkbox\" checked=\"checked\" name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString() + "</td>";
}
else
{
ls_return += "<td style=\"border-bottom:1px solid #cccccc\" width=\"25%\"><input type=\"checkbox\" name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString() + "</td>";
}
}
if (((i + 1) % 4) == 0 && i < dt.Rows.Count)
ls_return += "</tr><tr style=\"border-bottom:1px\">";
}
}
dtroleuser.Clear();
dt.Clear();
}
return ls_return;
}
private void DataPlay()
{
this.ddlisenabled.Items.Insert(0, "是");
this.ddlisenabled.Items.Insert(1, "否");
//加载权限和全权用户
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
DataTable dtrole = Hyoa_role.Getroles();
if (dtrole.Rows.Count > 0)
{
this.ddlrole.DataSource = dtrole;
this.ddlrole.DataTextField = "hy_rolename";
this.ddlrole.DataValueField = "hy_roleid";
this.ddlrole.DataBind();
this.ddlrole.Items.Insert(0, new ListItem("--请选择--", ""));
this.ddlrole.SelectedIndex = 0;
this.ddlqqrole.DataSource = dtrole;
this.ddlqqrole.DataTextField = "hy_rolename";
this.ddlqqrole.DataValueField = "hy_roleid";
this.ddlqqrole.DataBind();
this.ddlqqrole.Items.Insert(0, new ListItem("--请选择--", ""));
this.ddlqqrole.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; //保存
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
if (this.Request.QueryString["id"] != null)
{
//根据roleid得到信息
this.txtmudelid.Value = this.Request.QueryString["id"].ToString();
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
if (dt.Rows.Count > 0)
{
this.txtid.Text = this.Request.QueryString["id"].ToString();
this.txtname.Value = dt.Rows[0]["hy_mudelname"].ToString();
this.txtsort.Value = dt.Rows[0]["hy_sort"].ToString();
if (dt.Rows[0]["hy_isenabled"].ToString() == "是")
this.ddlisenabled.SelectedIndex = 0;
else
this.ddlisenabled.SelectedIndex = 1;
this.ddlrole.SelectedValue = dt.Rows[0]["hy_roleid"].ToString();
this.ddlqqrole.SelectedValue = dt.Rows[0]["hy_qqroleid"].ToString();
}
dt.Clear();
this.txtid.Enabled = false;
}
}
else
{
this.txtid.Text = "Mudel";
//自动获取最大排序号，然后+2
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_maxsort = Hyoa_mudel.GetMaxmudelsort();
if (dt_maxsort.Rows.Count > 0)
txtsort.Value = (int.Parse(dt_maxsort.Rows[0]["hy_sort"].ToString()) + 2).ToString();
else
txtsort.Value = "1";
}
}
}
private void DataPlay()
{
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_role Hyoa_role = new HyoaClass.Hyoa_role();
if (this.Request.QueryString["op"] == "modify")
{
txtroleid.Enabled = false;
if (this.Request.QueryString["roleid"] != null)
{
//根据roleid得到信息
this.txtroleid.Text = this.Request.QueryString["roleid"].ToString();
DataTable dt = Hyoa_role.Getrole(this.txtroleid.Text);
if (dt.Rows.Count > 0)
{
this.txtrolename.Value = dt.Rows[0]["hy_rolename"].ToString();
this.txtroleno.Value = dt.Rows[0]["hy_sort"].ToString();
}
dt.Clear();
}
}
else
{
this.txtroleid.Text = "Role";
////得到最大的ROLEID值
//this.txtroleid.Text = Hyoa_role.GetNextroleid();
//this.txtroleno.Value = this.txtroleid.Text.Substring(4);
//自动获取最大排序号，然后+2
DataTable dt_maxsort = Hyoa_role.GetMaxrolesort();
if (dt_maxsort.Rows.Count > 0)
txtroleno.Value = (int.Parse(dt_maxsort.Rows[0]["hy_sort"].ToString()) + 2).ToString();
else
txtroleno.Value = "1";
}
}
}
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.tdnewdoc.Visible = true; //新建
this.tddeldoc.Visible = true; //删除
}
else
{
this.isrole.Value = "0";
this.tdnewdoc.Visible = false; //新建
this.tddeldoc.Visible = false; //删除
}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
HyoaClass.Hyoa_roleuser Hyoa_roleuser = new HyoaClass.Hyoa_roleuser();
DataTable dt = new DataTable();
if (this.hy_name.Value != "")
{
dt = Hyoa_role.Getrolesbyrolename(this.hy_name.Value);
}
else
{
dt = Hyoa_role.Getroles();
}
DataTable tempTable = dt.Clone();
DataColumn col1 = new DataColumn("hy_roleuser", typeof(String)); //定义新的一列 add原因说明
tempTable.Columns.Add(col1); //追加一列 add
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//得到该权限下边已经配置的人员
string ls_roleuser = "";
if (dt.Rows[i]["hy_roleid"].ToString() != "")
{
DataTable dtjudeg = Hyoa_roleuser.Getroleusersbyroleid(dt.Rows[i]["hy_roleid"].ToString());
if (dtjudeg.Rows.Count > 0)
{
for (var ii = 0; ii < dtjudeg.Rows.Count; ii++)
{
if (ls_roleuser == "")
{
ls_roleuser = getusernamebyuserid(dtjudeg.Rows[ii]["hy_userid"].ToString());
}
else
{
ls_roleuser = ls_roleuser + "," + getusernamebyuserid(dtjudeg.Rows[ii]["hy_userid"].ToString());
}
}
}
}
if (ls_roleuser.Length > 50)
{
ls_roleuser = ls_roleuser.Substring(0, 50) + "...";
}
dr["hy_roleuser"] = ls_roleuser;
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
private void DataPlay()
{
if (this.Request.QueryString["op"] != null)
{
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; //保存
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
if (this.Request.QueryString["roleid"] != null)
{
//根据roleid得到信息
this.txtroleid.Text = this.Request.QueryString["roleid"].ToString();
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
DataTable dt = Hyoa_role.Getrole(this.txtroleid.Text);
if (dt.Rows.Count > 0)
{
this.txtrolename.Value = dt.Rows[0]["hy_rolename"].ToString();
this.txtroleno.Value = dt.Rows[0]["hy_sort"].ToString();
}
dt.Clear();
this.txtroleid.Enabled = false;
}
}
}
}
private void DataPlay()
{
//加载权限
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
DataTable dtrole = Hyoa_role.Getroles();
if (dtrole.Rows.Count > 0)
{
this.ddlrole.DataSource = dtrole;
this.ddlrole.DataTextField = "hy_rolename";
this.ddlrole.DataValueField = "hy_roleid";
this.ddlrole.DataBind();
this.ddlrole.Items.Insert(0, "--请选择--");
this.ddlrole.SelectedIndex = 0;
}
this.ddlisenabled.Items.Insert(0, "是");
this.ddlisenabled.Items.Insert(1, "否");
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_ml Hyoa_ml = new HyoaClass.Hyoa_ml();
//新文档，自动得到最大目录号
if (this.Request.QueryString["op"] == "add")
{
this.lblid.Text = Hyoa_ml.GetMaxFirstMLID();
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
if (this.Request.QueryString["id"] != null)
{
//根据id得到信息
this.lblid.Text = this.Request.QueryString["id"].ToString();
DataTable dt = Hyoa_ml.Getml(this.lblid.Text);
if (dt.Rows.Count > 0)
{
this.txtname.Value = dt.Rows[0]["MLName"].ToString();
for (var i = 0; i < this.fdPic.Items.Count; i++)
{
if (this.fdPic.Items[i].Value == dt.Rows[0]["hy_pic"].ToString())
{
this.fdPic.SelectedIndex = i;
}
}
//图片
this.ml_pic.Src = dt.Rows[0]["hy_pic"].ToString();
this.txtlink.Value = dt.Rows[0]["hy_link"].ToString();
this.ddltarget.SelectedValue = dt.Rows[0]["hy_target"].ToString();
this.ddlrole.SelectedValue = dt.Rows[0]["hy_role"].ToString();
this.txtsort.Value = dt.Rows[0]["hy_sort"].ToString();
if (dt.Rows[0]["hy_ifqy"].ToString() == "是")
this.ddlisenabled.SelectedIndex = 0;
else
this.ddlisenabled.SelectedIndex = 1;
}
dt.Clear();
this.lblid.Enabled = false;
}
}
}
}
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.tdnewdoc.Visible = true; //新建
this.tddeldoc.Visible = true; //删除
}
else
{
this.isrole.Value = "0";
this.tdnewdoc.Visible = false; //新建
this.tddeldoc.Visible = false; //删除
}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
DataTable dt;
if (this.hy_name.Value != "")
{
dt = Hyoa_role.Getrolesbyrolename(this.hy_name.Value);
}
else
{
dt = Hyoa_role.Getroles();
}
DataTable tempTable = dt.Clone();
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
