oa/zygl/Clsq_Add.aspx.cs

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

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using haoke365;

namespace hkoa.oa.zygl
{
    public partial class Clsq_Add : System.Web.UI.Page
    {
        mydb hkdb = new mydb();
        public void Page_Load(object Sender, EventArgs E)
        {
            hkdb.VeriSess("4");
            
            if (!IsPostBack)
            {
                hkdb.PassTo("10108", "0");

                //短信
                dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms());

                DropDownListBind();

                sqbm.SelectedValue = this.Session["deptid"].ToString();
            }
        }

        //dp绑定 
        public void DropDownListBind()
        {
            // SqlDataReader datar = SqlHelper.ExecuteReader("select id,clmc from oa_clda where id not in (select xycl from oa_clsq where zt in ('审批中','已同意') and (getdate() between xssj_s and xssj_e))");
            SqlDataReader datar = SqlHelper.ExecuteReader("select id,clmc from oa_clda where clzt='未借出'");
            while (datar.Read())
            {
                ListItem theItem = new ListItem();
                theItem.Text = datar["clmc"].ToString();
                theItem.Value = datar["id"].ToString();
                xycl.Items.Add(theItem);
            }
            datar.Close();

            SqlDataReader datar1 = SqlHelper.ExecuteReader("select xm,id from OA_JSYDA order by id");
            while (datar1.Read())
            {
                ListItem theItem = new ListItem();
                theItem.Text = datar1["xm"].ToString();
                theItem.Value = datar1["id"].ToString();
                jsy.Items.Add(theItem);
            }
            datar1.Close();