bas/tpgl/Tp.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
using haoke365;

namespace hkoa.oa.tpgl
{
    public partial class Tp : System.Web.UI.Page
    {
        int k;
        int j;
        string strsubname;
        string str1;
        string str2;
        static int ProjID;
        public void Page_Load(object Sender, EventArgs E)
        {
            mydb hkdb = new mydb();
            hkdb.VeriSess("3");

            SqlDataReader datar = SqlHelper.ExecuteReader("SELECT HK_POLL_PROJECT.ID,PROJECTNAME,HK_POLL_SUBJECT.SUBID,SUBJECTNAME,HK_POLL_KEY.KEYID,KEYNAME,KEYTYPE FROM HK_POLL_SUBJECT,HK_POLL_PROJECT,HK_POLL_KEY WHERE SSID=HK_POLL_PROJECT.ID AND HK_POLL_SUBJECT.SUBID=HK_POLL_KEY.SUBID AND PROJECTTAG='1' AND PROJECTTYPE='企业' ORDER BY HK_POLL_SUBJECT.SUBID,KEYID");
            k = 0;
            while (datar.Read())
            {
                xmname.Text = (datar["ProjectName"] == System.DBNull.Value ? "" : datar["ProjectName"].ToString());
                if (k == 0)
                {
                    Repeater1.Controls.Add(new LiteralControl("<table class='table_1' cellspacing='1' id='table1' cellpadding='1' width='60%' align='center'>"));
                    Repeater1.Controls.Add(new LiteralControl("<tr class='tr2'><td align=center></td></tr>"));
                    Repeater1.Controls.Add(new LiteralControl("<tr class='tr1'><td ><b>1、" + datar["SubjectName"].ToString() + "</td></tr>"));
                    Repeater1.Controls.Add(new LiteralControl("<tr class='tr2'><td>"));
                    strsubname = datar["SubjectName"].ToString();
                    ProjID = (int)datar["id"];
                    j = 2;
                }

                if (strsubname != datar["SubjectName"].ToString())
                {
                    SaveBtn.Enabled = true;
                    if (k != 0)
                    {
                        Repeater1.Controls.Add(new LiteralControl("</td></tr>"));
                    }
                    Repeater1.Controls.Add(new LiteralControl("<tr class='tr1'><td><b>" + Convert.ToInt32(j) + "、" + datar["SubjectName"].ToString() + "</td></tr>"));
                    Repeater1.Controls.Add(new LiteralControl("<tr class='tr2'><td>"));
                    j = j + 1;
                    strsubname = datar["SubjectName"].ToString();
                }

                switch (datar["keytype"].ToString())
                {
                    case "文本":
                        str1 = "txt" + (datar["keyid"]);
                        Repeater1.Controls.Add(new LiteralControl("&nbsp;&nbsp;&nbsp;&nbsp;"));
                        TextBox T = new TextBox();
                        T.ID = str1;
                        Repeater1.Controls.Add(T);
                        Repeater1.Controls.Add(new LiteralControl("<br>"));
                        break;