本文整理汇总了C#中HyoaClass.Hyoa_mudel.Getmudel方法的典型用法代码示例。如果您正苦于以下问题：C# HyoaClass.Hyoa_mudel.Getmudel方法的具体用法？C# HyoaClass.Hyoa_mudel.Getmudel怎么用？C# HyoaClass.Hyoa_mudel.Getmudel使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类HyoaClass.Hyoa_mudel的用法示例。
在下文中一共展示了HyoaClass.Hyoa_mudel.Getmudel方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: hy_dbsy
public void hy_dbsy()
{
//得到待办事宜
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt;
dt = Hyoa_dbsy.Getdbsys_dbanddy(this.Session["hyuid"].ToString());
int i, j;
string lstitle;
i = 8;//显示条数
if (dt.Rows.Count < i)
i = dt.Rows.Count;
for (j = 0; j < i; j++)
{
string ls_mudelid = dt.Rows[j]["hy_mudelid"].ToString();
string ls_mudelname = "";
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_getmudel = Hyoa_mudel.Getmudel(ls_mudelid);
if (dt_getmudel.Rows.Count > 0)
ls_mudelname = dt_getmudel.Rows[0]["hy_mudelname"].ToString();
lstitle = "[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString();
if (ls_mudelid == "yzgl")
{
lstitle = lstitle + "用印申请";
}
if (lstitle.Length > 35)
lstitle = lstitle.Substring(0, 35) + "...";
this.lbdbsy.Text += "<tr height='18px'><td valign='top'>·<a href='ggdy/Hy_DbToYb.aspx?id=" + dt.Rows[j]["ID"].ToString() + "' title='[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString() + "' target='_blank'>" + lstitle + "</a> [" + System.DateTime.Parse(dt.Rows[j]["hy_createtime"].ToString()).ToShortDateString().ToString() + "]</td></tr>";
}
if (this.lbdbsy.Text == "")
this.lbdbsy.Text = "·暂无记录！";
}示例2: 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_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
if (this.txtop.Value == "add")
{
//先判断这个模块编号是否已经存在
DataTable dt = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该模块编号已存在，请重新填写！');history.back();</script>");
return;
}
if(this.txtid.Text.Length<6)
{
Response.Write("<script>alert('模块编号长度必须大于5位！');history.back();</script>");
return;
}
if (this.txtid.Text.Substring(0, 5) != "Mudel")
{
Response.Write("<script>alert('模块编号必须以Mudel开头！');history.back();</script>");
return;
}
Hyoa_mudel.hy_mudelid = this.txtid.Text;
Hyoa_mudel.hy_mudelname = this.txtname.Value;
Hyoa_mudel.hy_sort = System.Int32.Parse(this.txtsort.Value);
Hyoa_mudel.hy_isenabled = this.ddlisenabled.SelectedValue;
Hyoa_mudel.hy_roleid = this.ddlrole.SelectedValue;
Hyoa_mudel.hy_qqroleid = this.ddlqqrole.SelectedValue;
Hyoa_mudel.Insert();
}
else
{
Hyoa_mudel.hy_mudelid = this.txtid.Text;
Hyoa_mudel.hy_mudelname = this.txtname.Value;
Hyoa_mudel.hy_sort = System.Int32.Parse(this.txtsort.Value);
Hyoa_mudel.hy_isenabled = this.ddlisenabled.SelectedValue;
Hyoa_mudel.hy_roleid = this.ddlrole.SelectedValue;
Hyoa_mudel.hy_qqroleid = this.ddlqqrole.SelectedValue;
Hyoa_mudel.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>");
}
}示例3: hy_mudelname
public string hy_mudelname()
{
string mudelname = "";
if (this.Request.QueryString["mid"] != null)
{
//得到模块中文名
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dtmudel = Hyoa_mudel.Getmudel(Request.QueryString["mid"].ToString());
mudelname = dtmudel.Rows[0]["hy_mudelname"].ToString();
dtmudel.Clear();
}
return mudelname;
}示例4: hyjstx
public void hyjstx()
{
HyoaClass.Hyoa_jstx Hyoa_jstx = new HyoaClass.Hyoa_jstx();
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
try
{
DataTable dt = Hyoa_jstx.Getjstxs_wf();
if (dt.Rows.Count > 0)
{
string ls_content = "";
string ls_mudelname = "消息提醒";
string ls_url = "";
for (var i = 0; i < dt.Rows.Count; i++)
{
//得到模块名称
DataTable dt_mudel = Hyoa_mudel.Getmudel(dt.Rows[i]["hy_from"].ToString());
if (dt_mudel.Rows.Count > 0)
ls_mudelname = dt_mudel.Rows[0]["hy_mudelname"].ToString();
//如果没找到该文档对应的待办事宜，则不发送消息
DataTable dt_dbsy = Hyoa_dbsy.Getdbsybydocid(dt.Rows[i]["DOCID"].ToString());
if (dt_dbsy.Rows.Count > 0)
{
ls_url = dt_dbsy.Rows[0]["hy_url"].ToString();
ls_content = "[" + ls_mudelname + "]-<a href='" + amtooa_ym + "/jstx_login.aspx?uid=" + dt.Rows[i]["hy_jsrid"].ToString() + "&key=cd04fa144ec48507&redirectto=" + ls_url + "' target=_blank>" + dt.Rows[i]["hy_content"].ToString() + "</a>";
int li_value = SendMessage("消息提醒", ls_content, dt.Rows[i]["hy_jsrid"].ToString());
if (li_value == 1)
{
Hyoa_jstx.ID = dt.Rows[i]["ID"].ToString();
Hyoa_jstx.hy_state = 1;
Hyoa_jstx.Update();
}
else
{
Hyoa_jstx.ID = dt.Rows[i]["ID"].ToString();
Hyoa_jstx.hy_state = 2;
Hyoa_jstx.Update();
}
}
}
}
}
catch
{
}
finally
{
}
}示例5: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
if (this.Request.QueryString["pop"] != null)
{
this.txtifpop.Value = this.Request.QueryString["pop"].ToString(); //是否弹出窗口
}
//esppath = Server.MapPath("esp");
//if (this.Session["hyuid"].ToString() == "")
// this.Response.Redirect("../login.aspx");
if (Request.QueryString["url"] != null)
{
this.url.Value = Request.QueryString["url"].ToString();
}
if (Request.QueryString["espid"] != null)
{
this.txtdocid.Value = Request.QueryString["espid"].ToString();
}
//按钮控制
this.tdCreateNew.Visible = false;
this.tdSave.Visible = false;
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string ls_mudelid = "Mudelfwgl";
string ls_role = "";
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(ls_mudelid);
if (dt_mudel.Rows.Count > 0)
{
ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString();
}
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
if (Request.QueryString["op"] != null)
{
string ls_op = Request.QueryString["op"].ToString();
txtop.Value = ls_op;
if (ls_op == "add")
{
this.tdCreateNew.Visible = true;
this.tdSave.Visible = true;
this.txtdocid.Value = Hyoa_global.GetRandom();
}
}
}
}
}示例6: hy_dbsy
//待办事宜
private void hy_dbsy()
{
string ls_html = "";
int i, j;
string ls_title = "";
string ls_title2 = "";
string ls_url = "";
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt = Hyoa_dbsy.Getdbsys_db(this.Session["hyuid"].ToString());
i = 7; //显示条数
if (dt.Rows.Count < i)
i = dt.Rows.Count;
for (j = 0; j < i; j++)
{
string ls_mudelid = dt.Rows[j]["hy_mudelid"].ToString();
string ls_mudelname = "";
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_getmudel = Hyoa_mudel.Getmudel(ls_mudelid);
if (dt_getmudel.Rows.Count > 0)
ls_mudelname = dt_getmudel.Rows[0]["hy_mudelname"].ToString();
ls_title = "[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString();
if (ls_title.Length > 35)
ls_title2 = ls_title.Substring(0, 35) + "...";
else
ls_title2 = ls_title;
ls_url = "ggdy/Hy_DbToYb.aspx?id=" + dt.Rows[j]["ID"].ToString() + "&pop=1&rnd=" + System.Guid.NewGuid().ToString();
ls_html += "<tr>";
ls_html += "<td width=\"10\" align=\"center\">·</td>";
ls_html += "<td height=\"26\"><a title=\"" + ls_title + "\" onclick=\"window.open('" + ls_url + "')\" href=\"javascript:\"><b>" + ls_title2 + "</b></a></td>";
ls_html += "<td width=\"70\" align=\"center\"><font color='#2D2D2D' >" + System.DateTime.Parse(dt.Rows[j]["hy_createtime"].ToString()).ToString("yyyy-MM-dd") + "</font></td>";
ls_html += "</tr>";
}
if (ls_html == "")
{
ls_html = "<tr><td>· 暂无待办事宜！</td></tr>";
}
this.lbldbsy.Text = ls_html;
}示例7: hy_mudelname
public string hy_mudelname()
{
string mudelname = "";
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(","));
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dtmudel = Hyoa_mudel.Getmudel(ls_mid);
//Response.Write(Request.QueryString["mid"].ToString());
if (dtmudel.Rows.Count > 0)
{
mudelname = dtmudel.Rows[0]["hy_mudelname"].ToString();
}
}
return mudelname;
}示例8: DataPlay
private void DataPlay(int PageNo)
{
//得到当前模块对应的role
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
string ls_role = "Role9999";
if (dt_mudel.Rows.Count > 0)
ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString();
//判断当前用户是否有删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.tddeldoc.Visible = true; //删除
}
else
{
this.isrole.Value = "0";
this.tddeldoc.Visible = false; //删除
}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.DAO db = new HyoaClass.DAO();
string lssql = "";
lssql = "select distinct a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid,a.hy_curclrname,a.hy_djrid";
lssql += ",a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt";
lssql += ",a.hy_field1,a.hy_field2,a.hy_field3,a.hy_field4,a.hy_field5,a.hy_field6,a.hy_field7,a.hy_field8,a.hy_field9,a.hy_field10,a.hy_field11";
lssql += ",a.hy_field12,a.hy_field13,a.hy_field14,a.hy_field15,a.hy_field16,a.hy_field17,a.hy_field18,a.hy_field19,a.hy_field20,a.hy_field21";
lssql += ",a.hy_field22,a.hy_field23,a.hy_field24,a.hy_field25,a.hy_field26,a.hy_field27,a.hy_field28,a.hy_field29,a.hy_field30,a.hy_field31";
lssql += ",a.hy_field32,a.hy_field33,a.hy_field34,a.hy_field35,a.hy_field36,a.hy_field37,a.hy_field38,a.hy_field39,a.hy_field40,a.hy_field41";
lssql += ",a.hy_field42,a.hy_field43,a.hy_field44,a.hy_field45,a.hy_field46,a.hy_field47,a.hy_field48,a.hy_field49,a.hy_field50,a.hy_field51";
lssql += ",a.hy_field52,a.hy_field53,a.hy_field54,a.hy_field55,a.hy_field56,a.hy_field57,a.hy_field58,a.hy_field59,a.hy_field60,a.hy_field61";
lssql += ",a.hy_field62,a.hy_field63,a.hy_field64,a.hy_field65,a.hy_field66,a.hy_field67,a.hy_field68,a.hy_field69,a.hy_field70";
lssql += ",a.hy_field71,a.hy_field72,a.hy_field73,a.hy_field74,a.hy_field75,a.hy_field76,a.hy_field77,a.hy_field78,a.hy_field79,a.hy_field80";
lssql += ",a.hy_field81,a.hy_field82,a.hy_field83,a.hy_field84,a.hy_field85,a.hy_field86,a.hy_field87,a.hy_field88,a.hy_field89,a.hy_field90";
lssql += ",a.hy_field91,a.hy_field92,a.hy_field93,a.hy_field94,a.hy_field95,a.hy_field96,a.hy_field97,a.hy_field98,a.hy_field99,a.hy_field100";
lssql += ",a.hy_iftx,a.hy_zhtxsj,a.hy_readuserlist from hyp_flowmain a,hyp_flowhistoryinfo_cl b ";
lssql += "where a.DOCID=b.DOCID and (','+b.hy_clrid+',' like '%," + this.Session["hyuid"].ToString() + ",%' or ','+b.hy_cyrid+',' like '%," + this.Session["hyuid"].ToString() + ",%') and a.hy_curtacheid!='' and a.hy_djrid!='" + this.Session["hyuid"].ToString() + "' and a.hy_curtacheid!='**'";
if (this.hy_bt_1.Value != "")
{
lssql += " and hy_bt like '%" + this.hy_bt_1.Value + "%'";
}
lssql += " order by hy_djsj desc ";
//--根据查询条件得到返回数据集--s
DataTable dt = db.GetDataTable(lssql); //当前用户能够看到的未结束的文档
//--根据查询条件得到返回数据集--e
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();
}示例9: DataPlay
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
//{
// this.tddeldoc.Visible = true; //删除
//}
//else
//{
// this.tddeldoc.Visible = false; //删除
//}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt;
dt = Hyoa_dbsy.Getdbsys_dy(Session["hyuid"].ToString());
DataTable tempTable = dt.Clone();
DataColumn col = new DataColumn("mudelname", typeof(String));
tempTable.Columns.Add(col);
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];
}
//根据模块ID得到模块名称
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(dt.Rows[i]["hy_mudelid"].ToString());
if(dt_mudel.Rows.Count>0)
dr["mudelname"] = dt_mudel.Rows[0]["hy_mudelname"].ToString();
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();
}示例10: DataPlay
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string ls_mudelid = "";
string ls_role = "";
if (Request.QueryString["mid"] != null)
{
ls_mudelid = Request.QueryString["mid"].ToString();
}
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(ls_mudelid);
if (dt_mudel.Rows.Count > 0)
{
ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString();
}
if (Hyoa_global.isHaveRole(ls_role, 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_ntkohongtou Hyoa_ntkohongtou = new HyoaClass.Hyoa_ntkohongtou();
DataTable dt;
dt = Hyoa_ntkohongtou.Gethongtous();
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();
}示例11: Gethy_field
public string Gethy_field(string ls_num)
{
string ls_return = "";
string ls_show = ""; //这个区域的内容
string ls_temp = "";
string lstitle = "";
string ls_url = "";
string ls_sql = "";
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//得到待办事宜
if (ls_num == "1")
{
ls_show = "待办事宜"; //这个区域的内容
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
DataTable dt = Hyoa_dbsy.Getdbsys_dbanddy(this.Session["hyuid"].ToString());
int i = 5; //显示条数
if (dt.Rows.Count < i)
i = dt.Rows.Count;
for (int j = 0; j < i; j++)
{
string ls_mudelid = dt.Rows[j]["hy_mudelid"].ToString();
string ls_mudelname = "";
DataTable dt_getmudel = Hyoa_mudel.Getmudel(ls_mudelid);
if (dt_getmudel.Rows.Count > 0)
ls_mudelname = dt_getmudel.Rows[0]["hy_mudelname"].ToString();
lstitle = "[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString();
if (lstitle.Length > 20)
lstitle = lstitle.Substring(0, 20) + "...";
ls_url = "ggdy/Hy_DbToYb.aspx?id=" + dt.Rows[j]["ID"].ToString() + "&pop=1&rnd=" + System.Guid.NewGuid().ToString();
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"72%\"> <a title=\"" + "[" + ls_mudelname + "]" + dt.Rows[j]["hy_subbt"].ToString() + "-" + dt.Rows[j]["hy_bt"].ToString() + "\" onclick=\"window.open('" + ls_url + "')\" href=\"javascript:\"><b>" + lstitle + "</b></a></td>";
ls_temp += "<td width=\"28%\" align=\"right\">";
ls_temp += "<font color=\"#056ea5\">" + System.DateTime.Parse(dt.Rows[j]["hy_createtime"].ToString()).ToShortDateString().ToString() + "</font> </td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
if (ls_temp == "")
{
ls_temp += "<tr>";
ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_temp += "<tbody>";
ls_temp += "<tr>";
ls_temp += "<td width=\"100%\"> 暂无记录！</td>";
ls_temp += "</tr>";
ls_temp += "</tbody>";
ls_temp += "</table>";
ls_temp += "</td>";
ls_temp += "</tr>";
}
ls_return += "<div style=\"position: relative; padding-bottom: 0px\" id=\"module_1\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"height: 160px;border-bottom: 1px solid #cccccc\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td height=\"25\">";
ls_return += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
ls_return += "<tbody>";
ls_return += "<tr>";
ls_return += "<td style=\"cursor: move; color: #262d33; font-weight: bold\" id=\"module_1_head\" class=\"Navigation\" width=\"72%\"> <img align=\"absMiddle\" src=\"hyhtml/images/ico/FUNC20029.gif\"> " + ls_show + "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += ls_temp;
ls_return += "<tr>";
ls_return += "<td height=\"22\" align=\"right\">";
ls_return += "<a href=\"#\" onclick=\"window.open('system/list_dbsy.aspx')\"><font color=\"red\">";
ls_return += " 更多>>..</font></a>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "<tr>";
ls_return += "<td>";
ls_return += "</td>";
ls_return += "</tr>";
ls_return += "</tbody>";
ls_return += "</table>";
ls_return += "</div>";
ls_return += "<div>";
ls_return += "</div>";
}
//得到电子邮件
if (ls_num == "2")
{
ls_show = "最新客户"; //这个区域的内容
ls_sql = "select * from hyc_Tablekhda order by hy_djsj desc ";
//.........这里部分代码省略.........
示例12: hy_mudelname
public string hy_mudelname()
{
//得到模块中文名
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dtmudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
string mudelname = dtmudel.Rows[0]["hy_mudelname"].ToString();
dtmudel.Clear();
return mudelname;
}示例13: DataPlay
private void DataPlay(int PageNo)
{
//得到当前模块对应的全权用户组
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
string ls_role = "Role9999";
if (dt_mudel.Rows.Count > 0)
{
if (dt_mudel.Rows[0]["hy_qqroleid"] == null)
{
return;
}
else
{
if (dt_mudel.Rows[0]["hy_qqroleid"] == "")
{
return;
}
else
{
ls_role = dt_mudel.Rows[0]["hy_qqroleid"].ToString();
}
}
}
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
}
else
{
this.isrole.Value = "0";
Response.Write("<script>alert('您无权访问此页面的数据！');self.close();</script>");
return;
}
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//---查询条件---开始
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
}
else
{
if (ls_fieldid_sx == "1")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "2")
{
if (Session["conntype"].ToString() == "SQL")
//.........这里部分代码省略.........
示例14: DataPlay
//.........这里部分代码省略.........
}
dt_flowhistoryinfo_cl.Clear();
//判断是否为最后一个环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
this.txtiflasttache.Value = "1";
}
dtflowwork.Clear();
//////////////流程未结束///////////////////////
}
//如果表单是流程后公开显示，则置为阅读权限
if (this.hy_curtacheid.Text == "**")
{
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)
{
if (dt_tableconfig.Rows[0]["hy_ispuballByflowYB"].ToString() == "是")
{
this.txtSystemYdRight.Value = "1";
}
}
}
//没有操作权限的用户，如果是全权用户，则置为阅读权限 ADD BY XF 2011-11-17
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{
//得到当前模块对应的全权用户组
HyoaClass.Hyoa_mudel Hyoa_mudel_forqqyh = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel_forqqyh = Hyoa_mudel_forqqyh.Getmudel(this.hy_mudelid.Text);
if (dt_mudel_forqqyh.Rows.Count > 0)
{
if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != null)
{
if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != "")
{
string ls_role_forqqyh = dt_mudel_forqqyh.Rows[0]["hy_qqroleid"].ToString();
HyoaClass.Hyoa_global Hyoa_global_forqqyh = new HyoaClass.Hyoa_global();
if (Hyoa_global_forqqyh.isHaveRole(ls_role_forqqyh, this.Session["hyuid"].ToString()))
{
this.txtSystemYdRight.Value = "1"; //阅读权限
}
}
}
}
}
//指定的特殊模块，流转过程中，所有人员可以浏览该文档
hySetYdRight_TS();
//如果是“可修改所有文档的权限人员”，则可以修改所有的，可以把已办文件转在办
if (Hyoa_global.isHaveRole("Role9995", Session["hyuid"].ToString()))
{
this.txtSystemYdRight.Value = "1";
this.td_submit.Visible = true; //保存
if (this.hy_curtacheid.Text == "**")
this.td_ybtozb.Visible = true; //已办转在办
}
//既没有处理权限，又没有阅读权限的情况下
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{示例15: DataPlay
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
//{
// this.tddeldoc.Visible = true; //删除
//}
//else
//{
// this.tddeldoc.Visible = false; //删除
//}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
//DataTable dt;
//dt = Hyoa_dbsy.Getdbsys_yb(Session["hyuid"].ToString());
DataTable dt;
string lssql22 = "Select * from hyt_dbsy where hy_ifyb=1 and hy_property='待办' and hy_dbrid='" + Session["hyuid"].ToString() + "' ";
if (this.txtbt.Text != "")
{
lssql22 += " and hy_bt like '%" + this.txtbt.Text + "%'";
}
lssql22 += " order by hy_createtime desc";
HyoaClass.DAO db = new HyoaClass.DAO();
dt = db.GetDataTable(lssql22);
DataTable tempTable = dt.Clone();
DataColumn col = new DataColumn("mudelname", typeof(String));
tempTable.Columns.Add(col);
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];
}
//根据模块ID得到模块名称
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(dt.Rows[i]["hy_mudelid"].ToString());
if(dt_mudel.Rows.Count>0)
dr["mudelname"] = dt_mudel.Rows[0]["hy_mudelname"].ToString();
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();
}