本文整理汇总了C#中HyoaClass.Hyoa_tableconfig类的典型用法代码示例。如果您正苦于以下问题:C# HyoaClass.Hyoa_tableconfig类的具体用法?C# HyoaClass.Hyoa_tableconfig怎么用?C# HyoaClass.Hyoa_tableconfig使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
HyoaClass.Hyoa_tableconfig类属于命名空间,在下文中一共展示了HyoaClass.Hyoa_tableconfig类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: btnLogin_Click
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("更新完成");
}
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:49,代码来源:updatehyc.aspx.cs
示例2: btndelinfo_Click
protected void btndelinfo_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
String[] v_uids = this.txtuids.Value.Split(',');
for (var i = 0; i < v_uids.Length; i++)
{
if (v_uids[i] != "")
{
Hyoa_tableconfig.ID = v_uids[i];
Hyoa_tableconfig.Delete();
}
}
this.txtuids.Value = "";
//DataPlay(1);
DataPlay(System.Int32.Parse(this.curpage.Text));
}
开发者ID:wjszxli,项目名称:Webapp,代码行数:16,代码来源:list_tableconfig.aspx.cs
示例3: btndelinfo_Click
protected void btndelinfo_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
String[] v_uids = this.txtuids.Value.Split(',');
for (var i = 0; i < v_uids.Length; i++)
{
if (v_uids[i] != "")
{
//先删除SQL中的表
DelSQLTableByTableid(v_uids[i]);
//删除配置表
Hyoa_tableconfig.ID = v_uids[i];
Hyoa_tableconfig.Delete();
//删除表字段
string ls_sql = "delete from hyt_flowfield where hy_tableid='"+v_uids[i]+"'";
Hyoa_global.ExcuteSQL_BASE(ls_sql);
}
}
this.txtuids.Value = "";
//DataPlay(1);
DataPlay(System.Int32.Parse(this.curpage.Text));
}
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:23,代码来源:list_tableconfig.aspx.cs
示例4: ddlmudelid_SelectedIndexChanged
protected void ddlmudelid_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.ddlmudelid.SelectedIndex != 0)
{
this.ddltableid.Items.Clear();
//根据模块ID得到表单ID
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt = Hyoa_tableconfig.GetTablesbymudelid(this.ddlmudelid.SelectedValue);
if (dt.Rows.Count > 0)
{
for (var i = 0; i < dt.Rows.Count; i++)
{
this.ddltableid.Items.Insert(i, new ListItem(dt.Rows[i]["hy_name"].ToString(), dt.Rows[i]["ID"].ToString()));
}
this.ddltableid.Items.Insert(0, new ListItem("--请选择--", ""));
this.ddltableid.Attributes.Add("onchange ", "mudelidonchang() ");
}
}
else
{
//清空
this.ddltableid.Items.Clear();
}
}
开发者ID:wjszxli,项目名称:Webapp,代码行数:24,代码来源:main_listconfig.aspx.cs
示例5: DataPlay
//.........这里部分代码省略.........
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();
}
}
}
}
开发者ID:wjszxli,项目名称:Webapp,代码行数:101,代码来源:main_ml2.aspx.cs
示例6: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("login.aspx");
if (!this.IsPostBack)
{
//当前用户信息
this.txtcurloginuserid.Text = Session["hyuid"].ToString();
this.txtcurloginusername.Text = Session["hyuname"].ToString();
this.txtcurlogindeptid.Text = Session["hydeptid"].ToString();
this.txtcurlogindeptname.Text = Session["hydeptname"].ToString();
if (this.Request.QueryString["pop"] != null)
{
string ls_pop = "";
ls_pop = this.Request.QueryString["pop"].ToString(); //是否弹出窗口
if (ls_pop.Contains(","))
ls_pop = ls_pop.Substring(0, ls_pop.IndexOf(","));
this.txtifpop.Value = ls_pop;
}
if (this.Request.QueryString["mid"] != null)
{
string ls_mid = "";
ls_mid = this.Request.QueryString["mid"].ToString();
if (ls_mid.Contains(","))
ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));
this.hy_mudelid.Text = ls_mid;
}
if (this.Request.QueryString["tableid"] != null)
{
string ls_tableid = "";
ls_tableid = this.Request.QueryString["tableid"].ToString();
if (ls_tableid.Contains(","))
ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));
this.hy_tableid.Text = ls_tableid;
//得到表单名称
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
this.lbltablename.Text = dt_tableconfig.Rows[0]["hy_name"].ToString();
this.txttablerole.Value = dt_tableconfig.Rows[0]["hy_tablerole"].ToString();
dt_tableconfig.Clear();
}
if (this.Request.QueryString["listid"] != null)
{
string ls_listid = "";
ls_listid = this.Request.QueryString["listid"].ToString();
if (ls_listid.Contains(","))
ls_listid = ls_listid.Substring(0, ls_listid.IndexOf(","));
this.txtlistid.Text = ls_listid;
}
if (this.Request.QueryString["url"] != null)
{
//this.txturl.Value = this.Request.QueryString["url"].ToString(); //返回URL
string ls_url = this.Request.Url.ToString();
this.txturl.Value = ls_url.Substring(ls_url.LastIndexOf("url=") + 4, ls_url.Length - ls_url.LastIndexOf("url=") - 4); //返回URL
}
else
{
//没有URL值的保存后进入列表中,即/list.aspx?mid=clgl&tableid=8b10b316-98d6-4a50-bc15-52745bb119bb
this.txturl.Value = "list.aspx?mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&listid=" + this.txtlistid.Text;
getreturnurl(); //特殊返回地址
}
}
DataPlay();
//add by wjs 20141103 start 给合同加matherid
if (this.Request.QueryString["motherid"] != null)
{
this.hy_motherid.Text = this.Request.QueryString["motherid"].ToString();
}
// add by wjs 20141112 在付款流程结束时将提交改为付款
//最后一环节
if (this.txtiflasttache.Value == "1" && this.hy_tableid.Text == "Tablefpbd")
{
this.btn_nextstep.Value = "付款";
}
}
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:84,代码来源:main.aspx.cs
示例7: DataPlay
//加载主表单 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();
#region 新文档
if (this.Request.QueryString["op"] == "add")
{
this.td_ydry.Visible = false; //新文档时,“已读人员”按钮隐藏
this.txtiffirsttache.Value = "1"; //新文档时,“是否第一环节”置为1
//文档ID(保存POST到当前页面时,DOCID不重新加载)
if (!this.IsPostBack)
{
this.txtdocid.Value = Hyoa_global.GetRandom();
this.hy_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
this.hy_djrid.Text = this.Session["hyuid"].ToString();
this.hy_djrname.Text = this.Session["hyuname"].ToString();
this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
{
if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
//根据模块ID得到流程信息
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text);
if (dt.Rows.Count > 0)
{
//判断当前用户是否有登记权限
//得到第一环节ID
string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString());
if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].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_nexttacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.hy_curclrid.Text = this.Session["hyuid"].ToString();
this.hy_curclrname.Text = this.Session["hyuname"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.txtSystemClRight.Value = "1";
//-------条件流程start-------
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
if (dt_firsttache.Rows.Count > 0)
{
if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是")
ConditionFlow(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
}
//-------条件流程end-------
}
else
{
if (this.txtifpop.Value == "")
{
this.td_submit.Visible = false;
this.td_nextstep.Visible = false;
Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');window.location='" + this.txturl.Value + "';</script>");
return;
}
else
{
this.td_submit.Visible = false;
this.td_nextstep.Visible = false;
Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');self.close();</script>");
return;
}
}
}
dt.Clear();
this.td_nextstep.Visible = true; //提交
}
}
//加载页面
if (this.hy_tableid.Text == "Tablefpbd")
{
this.td_dc.Visible = true;
}
GetMainTableHtml("0", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
this.td_submit.Visible = true; //保存
hywebopen_newdoc(); //新文档OPEN时的特殊处理
}
#endregion
#region 旧文档
if (this.Request.QueryString["op"] == "modify")
{
//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:101,代码来源:main.aspx.cs
示例8: DataPlay
//打开文档显示
private void DataPlay()
{
HyoaClass.DAO db = new HyoaClass.DAO();
StringBuilder sb = new StringBuilder();
string ls_flag = "0"; //是否为授权人员
string ls_uid = this.Session["hyuid"].ToString();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role_search", ls_uid))
{
ls_flag = "1";
}
int ls_Container = 1;
string ls_docids = "";
string sql1 = "";
//查询关键字按|分割
string[] lv_key = ls_keywords.Split('|');
//读取待查模块的字段
if (ls_Modelid != "--请选择--")
{
sql1 = "select *,(select hy_mudelname from hyt_mudel where hy_mudelid=a.hy_mudelid) as hy_name from hyt_searchconfig a where hy_ifsearch='是' and hy_mudelid='" + ls_Modelid + "'";
sql1 += " order by hy_sort ";
}
else
{
sql1 = "select *,(select hy_mudelname from hyt_mudel where hy_mudelid=a.hy_mudelid) as hy_name from hyt_searchconfig a where hy_ifsearch='是'";
sql1 += " order by hy_sort ";
}
//Response.Write(sql1);
//return;
DataTable dt = db.GetDataTable(sql1);
if (dt.Rows.Count > 0)
{
//循环查询模块
for (int i = 0; i < dt.Rows.Count; i++)
{
string sql2 = "";
string ls_or = "";
string ls_mid = dt.Rows[i]["hy_mudelid"].ToString();
string ls_mname = dt.Rows[i]["hy_name"].ToString();
string ls_tid = dt.Rows[i]["hy_tableid"].ToString();
string ls_cid = dt.Rows[i]["hy_columnshowid"].ToString(); //hy_field1,hy_bt,hy_content1
string ls_xsid = dt.Rows[i]["hy_xszdid"].ToString();
string ls_kckryid = "+" + dt.Rows[i]["hy_kckryid"].ToString() + "+";
//根据表单ID得到表单信息
string ls_tname = "", ls_ifflow = "", ls_ifgk = "", ls_ifxssy = "";
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(ls_tid);
if (dt_tableconfig.Rows.Count > 0)
{
ls_tname = dt_tableconfig.Rows[0]["hy_name"].ToString(); //表单名称
ls_ifflow = dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString();//是否为流程表单
ls_ifgk = dt_tableconfig.Rows[0]["hy_ispuballByflowYB"].ToString(); //流程结束后是否公开
ls_ifxssy = dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString(); //是否显示所有记录
}
dt_tableconfig.Clear();
if (ls_flag == "1")
{
//授权查看所有人员
sql2 = "select * from hyp_flowmain a where 1=1 ";
}
else
{
//某模块是否授权为可查看人员
if (ls_kckryid.IndexOf("+" + ls_uid + "+") >= 0)
{
sql2 = "select * from hyp_flowmain a where 1=1 ";
}
else
{
//未授权人员根据表单配置判断模块的数据显示情况
if (ls_ifflow == "是")
{
sql2 = "select * from hyp_flowmain a,hyp_flowhistoryinfo_cl b where a.DOCID=b.DOCID ";
//流程模块
if (ls_ifgk == "是")
{
//流程结束后公开
sql2 += " and (','+b.hy_clrid+',' like '%," + ls_uid + ",%' or ','+b.hy_cyrid+',' like '%," + ls_uid + ",%' or a.hy_curtacheid='**' ) ";
}
if (ls_ifgk == "否")
{
//流程结束后不公开
sql2 += " and (','+b.hy_clrid+',' like '%," + ls_uid + ",%' or ','+b.hy_cyrid+',' like '%," + ls_uid + ",%') ";
}
}
if (ls_ifflow == "否")
{
//非流程模块
if (ls_ifxssy == "是")
{
//非流程显示所有记录
sql2 = "select * from hyp_flowmain a where 1=1 ";
}
//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:Webapp,代码行数:101,代码来源:Search_All.aspx.cs
示例9: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("login.aspx");
if (!this.IsPostBack)
{
//当前用户信息
this.txtcurloginuserid.Text = Session["hyuid"].ToString();
this.txtcurloginusername.Text = Session["hyuname"].ToString();
this.txtcurlogindeptid.Text = Session["hydeptid"].ToString();
this.txtcurlogindeptname.Text = Session["hydeptname"].ToString();
if (this.Request.QueryString["pop"] != null)
{
string ls_pop = "";
ls_pop = this.Request.QueryString["pop"].ToString(); //是否弹出窗口
if (ls_pop.Contains(","))
ls_pop = ls_pop.Substring(0, ls_pop.IndexOf(","));
this.txtifpop.Value = ls_pop;
}
if (this.Request.QueryString["mid"] != null)
{
string ls_mid = "";
ls_mid = this.Request.QueryString["mid"].ToString();
if (ls_mid.Contains(","))
ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));
this.hy_mudelid.Text = ls_mid;
}
if (this.Request.QueryString["tableid"] != null)
{
string ls_tableid = "";
ls_tableid = this.Request.QueryString["tableid"].ToString();
if (ls_tableid.Contains(","))
ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));
this.hy_tableid.Text = ls_tableid;
//得到表单名称
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
this.lbltablename.Text = dt_tableconfig.Rows[0]["hy_name"].ToString();
//是否为流程表单
this.txtifhaveflow.Value = dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString();
this.txttablerole.Value = dt_tableconfig.Rows[0]["hy_tablerole"].ToString();
dt_tableconfig.Clear();
}
if (this.Request.QueryString["listid"] != null)
{
string ls_listid = "";
ls_listid = this.Request.QueryString["listid"].ToString();
if (ls_listid.Contains(","))
ls_listid = ls_listid.Substring(0, ls_listid.IndexOf(","));
this.txtlistid.Text = ls_listid;
}
if (this.Request.QueryString["url"] != null)
{
//this.txturl.Value = this.Request.QueryString["url"].ToString(); //返回URL
string ls_url = this.Request.Url.ToString();
this.txturl.Value = ls_url.Substring(ls_url.LastIndexOf("url=") + 4, ls_url.Length - ls_url.LastIndexOf("url=") - 4); //返回URL
}
else
{
//没有URL值的保存后进入列表中,即/list.aspx?mid=clgl&tableid=8b10b316-98d6-4a50-bc15-52745bb119bb
this.txturl.Value = "list.aspx?mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&listid=" + this.txtlistid.Text;
}
}
DataPlay();
}
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:74,代码来源:main_print.aspx.cs
示例10: Button_Save_Click
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功!";
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//判断目的表单ID是否重复
DataTable dt_table = Hyoa_tableconfig.GetTable(txttableidbymd.Text);
if (dt_table.Rows.Count > 0)
{
Response.Write("<script>alert('目的表单ID已存在!');</script>");
return;
}
//插入TABLE配置
DataTable tableconfigdt = Hyoa_tableconfig.GetTablesbymudelid(this.lbmudelidbysource.Text);
if (tableconfigdt.Rows.Count > 0)
{
Hyoa_tableconfig.ID = txttableidbymd.Text;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
Hyoa_tableconfig.hy_name = this.txttablenamebymd.Text;
Hyoa_tableconfig.hy_onload = tableconfigdt.Rows[0]["hy_onload"].ToString();
Hyoa_tableconfig.hy_sort = float.Parse(this.txttablesortbymd.Text);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
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();
}
//插入FIELD配置
int i;
DataTable flowfielddt = Hyoa_flowfield.Getflowfieldsbytableid(this.lbtableidbysorce.Text);
if (flowfielddt.Rows.Count > 0)
{
for (i = 0; i < flowfielddt.Rows.Count; i++)
{
Hyoa_flowfield.ID = Hyoa_global.GetRandom();
Hyoa_flowfield.hy_tableid = txttableidbymd.Text;
Hyoa_flowfield.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
Hyoa_flowfield.hy_flowid = this.txtflowidbymd.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_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();
}
}
//生成SQL/ORACLE中的表
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * into hyc_" + txttableidbymd.Text + " from hyc_" + this.lbtableidbysorce.Text + " where 1=0";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "create table hyc_" + txttableidbymd.Text + " as select * from hyc_" + this.lbtableidbysorce.Text + " where 1=2";
}
Hyoa_global.ExcuteSQL(sql);
//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:101,代码来源:main_tablecopy.aspx.cs
示例11: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() =="")
this.Response.Redirect("/login.aspx");
if (this.Request.QueryString["mid"] != null)
{
//得到模块ID
this.txtmudelid.Value = this.Request.QueryString["mid"].ToString();
}
else
{
this.Response.Write("<script>alert('模块ID没有传入,请联系管理员!');</script>");
return;
}
if (this.Request.QueryString["tableid"] != null)
{
//表的ID
this.txttableid.Value = this.Request.QueryString["tableid"].ToString();
//得到表名
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.txttableid.Value);
if (dt_tableconfig.Rows.Count > 0)
this.lblcurtachenameshow.Text = dt_tableconfig.Rows[0]["hy_name"].ToString();
}
else
{
this.Response.Write("<script>alert('表单ID没有传入,请联系管理员!');</script>");
return;
}
if (!IsPostBack)
{
//判断是否需要查询(目前一个表单只能对应一个列表,所以直接用表单ID进行查找)
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dt_listconfig = Hyoa_listconfig.GetlistconfigByTableid(this.txttableid.Value);
if (dt_listconfig.Rows.Count > 0)
{
if (dt_listconfig.Rows[0]["hy_ifsearch"].ToString() == "是")
GetSearchTableHtml();//查询表格动态生成
}
DataPlay(1); //列表区动态生成
PageListItem();
EnabledWhatButton();
if (this.txtmudelid.Value == "kqgl" && this.txttableid.Value == "74e7e280-4fc5-4ccb-be3d-0f995ac2c934")
{
this.delcontrol_my.Visible = false;
this.newcontrol.Visible = false;
}
if (this.txtmudelid.Value == "clgl" && this.txttableid.Value == "0b5c53fe-114b-4fa3-8b59-4163b3053504")
{
this.exportexcel.Visible = true;
}
///只有管理员岗位能删除(大榭特有)
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
}
else
{
this.delcontrol.Visible = false;
this.delcontrol_my.Visible = false;
}
}
}
开发者ID:wjszxli,项目名称:Webapp,代码行数:69,代码来源:list_db.aspx.cs
示例12: onloadjs
//加载当前表单执行的onload代码 Written by xf 20110621
public string onloadjs()
{
string ls_mid = "";
if (this.Request.QueryString["mid"] != null)
{
ls_mid = this.Request.QueryString["mid"].ToString();
if (ls_mid.Contains(","))
ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));
}
string ls_tableid = "";
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
if (ls_tableid.Contains(","))
ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));
}
string ls_return = "";
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt = Hyoa_tableconfig.GetTablesbymudelidandtableid(ls_mid, ls_tableid);
if (dt.Rows.Count > 0)
ls_return = dt.Rows[0]["hy_onload"].ToString();
return ls_return;
}
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:25,代码来源:main_look.aspx.cs
示例13: DataPlay
//加载主表单 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() == "是")
{
|
请发表评论