bas/dxgl/Cydx.aspx.cs

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

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

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

namespace hkoa.oa.dxgl
{
    public partial class Cydx : System.Web.UI.Page
    {
        BindData bd = new BindData();

        protected void Page_Load(object Sender, EventArgs E)
        {
            mydb hkdb = new mydb();
            hkdb.VeriSess("3");

            if (!IsPostBack)
            {
                hkdb.PassTo("11001", "11001");

                DropDownListBind();

                panel2.Visible = false;
                add.Text = "增 加";
                add.AccessKey = "a";
            }

            //页面绑定
            GridViewBind();
        }

        //dp绑定 
        public void DropDownListBind()
        {
            SqlDataReader datar = SqlHelper.ExecuteReader("SELECT ID,MC FROM HK_ZDYLX WHERE FL='DX' AND ZT='正常' ORDER BY ID");
            while (datar.Read())
            {
                ListItem theItem = new ListItem();
                theItem.Text = datar["mc"].ToString();
                theItem.Value = datar["id"].ToString();
                dxlx.Items.Add(theItem);
            }
            datar.Close();
        }

        public void GridViewBind()
        {
            if (!string.IsNullOrEmpty(dxlx.SelectedValue))
            {
                Msg.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT COUNT(*) AS NUMS FROM HK_CYDX A LEFT OUTER JOIN HK_ZDYLX B ON(A.LX=B.ID) WHERE LX=" + dxlx.SelectedValue + ""));
                SqlDataSource1.SelectCommand = "";
                SqlDataSource1.SelectCommand = "SELECT A.*,B.MC FROM HK_CYDX A LEFT OUTER JOIN HK_ZDYLX B ON(A.LX=B.ID) WHERE LX= " + dxlx.SelectedValue + " ORDER BY A.ID";
                SqlDataSource1.DeleteCommand = "";
                SqlDataSource1.DeleteCommand = "DELETE FROM HK_CYDX WHERE id=@id";
                SqlDataSource1.UpdateCommand = "";
                SqlDataSource1.UpdateCommand = "UPDATE HK_CYDX SET nr=@nr WHERE id=@id";
            }
        }