Beispiel #1
0
        protected void btnIcon1_Click(object sender, EventArgs e)
        {
            School清查盘点BLL      pdbll = new School清查盘点BLL();
            List <School一级部门表> xxmc  = pdbll.查询一级部门();

            Window2.Hidden = false;
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            School盘点任务表 model = new School盘点任务表();

            model.称    = this.项目名称.Text;
            model.盘点单号 = 单号.Text;
            model.起始时间 = Convert.ToDateTime(DatePicker1.Text);
            model.截止时间 = Convert.ToDateTime(DatePicker2.Text);
            model.等级   = 1;
            //后续判断下checked
            model.清查范围 = rbtnFirst.Text;
            model.清查ID = "全部";
            model.完成状态 = "进行中";
            model.盘点方式 = RadioButton1.Text;
            model.备注   = TextBox1.Text;
            model.学校ID = 1;
            model.盘点完成 = "1";
            School清查盘点BLL bll = new School清查盘点BLL();

            if (bll.addpdrw(model))
            {
                Alert.Show("chengg!");
                Window1.Hidden = true;
                //Window1.Hidden();
            }
            else
            {
                Alert.Show("xxx!");
            }
        }
Beispiel #3
0
        protected void 存放地点_SelectedIndexChanged(object sender, EventArgs e)
        {
            int ID = Convert.ToInt32(存放地点.SelectedValue);

            if (ID > 0)
            {
                房间.Enabled = true;
                School清查盘点BLL      pdbll  = new School清查盘点BLL();
                List <School房间信息表> 查询房间信息 = pdbll.查询房间信息表(ID);
                房间.DataTextField  = "名称";
                房间.DataValueField = "ID";
                房间.DataSource     = 查询房间信息;
                房间.DataBind();
            }
            else
            {
                房间.Enabled = false;
                School清查盘点BLL      pdbll  = new School清查盘点BLL();
                List <School房间信息表> 查询房间信息 = pdbll.查询房间信息表(ID);
                房间.DataTextField  = "名称";
                房间.DataValueField = "ID";
                房间.DataSource     = 查询房间信息;
                房间.DataBind();
            }
        }
Beispiel #4
0
        protected void 一级_SelectedIndexChanged(object sender, EventArgs e)
        {
            int ID = Convert.ToInt32(一级.SelectedValue);

            if (ID > 0)
            {
                级.Enabled  = false;
                二级.Enabled = true;
                School清查盘点BLL      pdbll    = new School清查盘点BLL();
                List <School二级类别表> listuser = pdbll.查询二级类别(ID);
                二级.DataTextField  = "名称";
                二级.DataValueField = "ID";
                二级.DataSource     = listuser;
                二级.DataBind();
                级.DataBind();
            }
            else
            {
                二级.Enabled = false;
                级.Enabled  = false;
                School清查盘点BLL      pdbll    = new School清查盘点BLL();
                List <School二级类别表> listuser = pdbll.查询二级类别(ID);
                二级.DataTextField  = "名称";
                二级.DataValueField = "ID";
                二级.DataSource     = listuser;
                级.DataSource      = listuser;
                二级.DataBind();
                级.DataBind();
            }
        }
        protected void Button9_Click(object sender, EventArgs e)
        {
            Window1.Hidden = false;
            School清查盘点BLL       pdbll = new School清查盘点BLL();
            List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();

            报修地址.DataTextField  = "名称";
            报修地址.DataValueField = "ID";
            报修地址.DataSource     = 查询建筑物;
            报修地址.DataBind();
            DateTime dt = DateTime.Now;
            string   y  = dt.Year.ToString();
            string   m  = dt.Month.ToString();
            string   d  = dt.Day.ToString();
            string   h  = dt.Hour.ToString();
            string   mm = dt.Minute.ToString();

            报修单号.Text    = "ZCBX" + y + m + d + h + mm;
            报修单号.Enabled = false;
            OffSession();
            string nm = HttpContext.Current.Session["姓名"].ToString();

            if (nm == "" || nm == null)
            {
                Alert.ShowInTop("验证过期,请重新登陆!");
                return;
            }
            报修人.Text = HttpContext.Current.Session["姓名"].ToString();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                fr0.Hidden   = false;
                Grid2.Hidden = true;
                Grid3.Hidden = true;
                DataSet   ds     = gzysbll.DataSet购置验收查询("流程状态-全部", "", "");
                DataTable dt     = ds.Tables[0].Copy();//复制一份table
                DataTable source = dt;
                // 3.绑定到Grid
                Grid1.DataSource = dt;//DataTable
                Grid1.DataBind();


                // 3.绑定到Grid
                Grid1.DataSource = dt;//DataTable
                Grid1.DataBind();
                //二级.Enabled = false;
                //三级.Enabled = false;
                负责人.Enabled = false;
                房间.Enabled  = false;



                School清查盘点BLL pdbll = new School清查盘点BLL();

                List <School一级部门表> xxmc = pdbll.查询一级部门();
                部门.DataTextField  = "名称";
                部门.DataValueField = "ID";
                部门.DataSource     = xxmc;
                部门.DataBind();
                部门.EmptyText = "全部";

                //List<School一级类别表> yjlb = pdbll.查询一级类别();
                //一级.DataTextField = "名称";
                //一级.DataValueField = "ID";
                //一级.DataSource = yjlb;
                //一级.DataBind();
                //一级.EmptyText = "全部";

                List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();
                存放地点.DataTextField  = "名称";
                存放地点.DataValueField = "ID";
                存放地点.DataSource     = 查询建筑物;
                存放地点.DataBind();
                存放地点.EmptyText = "全部";

                //二级.Enabled = false;
                //三级.Enabled = false;
                负责人.Enabled = false;
                房间.Enabled  = false;

                //二级.EmptyText = "全部";
                //三级.EmptyText = "全部";
                负责人.EmptyText = "全部";
                房间.EmptyText  = "全部";
            }
        }
Beispiel #7
0
        protected void btnIcon1_Click(object sender, EventArgs e)
        {
            School清查盘点BLL      pdbll = new School清查盘点BLL();
            List <School一级部门表> xxmc  = pdbll.查询一级部门();

            部门.DataTextField  = "名称";
            部门.DataValueField = "ID";
            部门.DataSource     = xxmc;
            部门.DataBind();
            Window2.Hidden = false;
        }
        protected void btnIcon1_Click(object sender, EventArgs e)
        {
            School资产处置BLL bll    = new School资产处置BLL();
            DataSet       ds     = bll.查询全部资产信息();
            DataTable     dt     = ds.Tables[0].Copy();//复制一份table
            DataTable     source = dt;


            // 3.绑定到Grid
            Grid4.DataSource = dt;//DataTable
            Grid4.DataBind();
            //绑定条件
            School清查盘点BLL pdbll = new School清查盘点BLL();

            List <School一级部门表> xxmc = pdbll.查询一级部门();

            部门.DataTextField  = "名称";
            部门.DataValueField = "ID";
            部门.DataSource     = xxmc;
            部门.DataBind();

            List <School一级类别表> yjlb = pdbll.查询一级类别();

            一级.DataTextField  = "名称";
            一级.DataValueField = "ID";
            一级.DataSource     = yjlb;
            一级.DataBind();


            List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();

            存放地点.DataTextField  = "名称";
            存放地点.DataValueField = "ID";
            存放地点.DataSource     = 查询建筑物;
            存放地点.DataBind();


            二级.Enabled  = false;
            级.Enabled   = false;
            负责人.Enabled = false;
            房间.Enabled  = false;

            二级.EmptyText  = "全部";
            级.EmptyText   = "全部";
            负责人.EmptyText = "全部";
            房间.EmptyText  = "全部";



            Window2.Hidden = false;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                OffSession();

                二级分类.Enabled  = false;
                级分类.Enabled   = false;
                负责人_a.Enabled = false;
                房间.Enabled    = false;

                BindGrid();

                //BindGrid();
                //btnCheckSelection.OnClientClick = Grid2.GetNoSelectionAlertReference("请至少选择一项!");

                School清查盘点BLL pdbll = new School清查盘点BLL();

                List <School一级部门表> xxmc = pdbll.查询一级部门();
                部门归属.DataTextField  = "名称";
                部门归属.DataValueField = "ID";
                部门归属.DataSource     = xxmc;
                部门归属.DataBind();
                部门归属.EmptyText = "全部";

                List <School一级类别表> yjlb = pdbll.查询一级类别();
                一级分类.DataTextField  = "名称";
                一级分类.DataValueField = "ID";
                一级分类.DataSource     = yjlb;
                一级分类.DataBind();
                一级分类.EmptyText = "全部";

                List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();
                存放地点_a.DataTextField  = "名称";
                存放地点_a.DataValueField = "ID";
                存放地点_a.DataSource     = 查询建筑物;
                存放地点_a.DataBind();
                存放地点_a.EmptyText = "全部";

                二级分类.Enabled  = false;
                级分类.Enabled   = false;
                负责人_a.Enabled = false;
                房间.Enabled    = false;

                二级分类.EmptyText  = "全部";
                级分类.EmptyText   = "全部";
                负责人_a.EmptyText = "全部";
                房间.EmptyText    = "全部";
            }
        }
        protected void 报修地址_SelectedIndexChanged(object sender, EventArgs e)
        {
            int ID = Convert.ToInt32(报修地址.SelectedValue);

            if (ID > 0)
            {
                School清查盘点BLL      pdbll  = new School清查盘点BLL();
                List <School房间信息表> 查询房间信息 = pdbll.查询房间信息表(ID);
                房间1.DataTextField  = "名称";
                房间1.DataValueField = "ID";
                房间1.DataSource     = 查询房间信息;
                房间1.DataBind();
            }
        }
Beispiel #11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                二级.Enabled  = false;
                级.Enabled   = false;
                负责人.Enabled = false;
                房间.Enabled  = false;
                btnCheckSelection.OnClientClick = Grid1.GetNoSelectionAlertInTopReference("没有选中项!");
                BindGrid();


                School清查盘点BLL pdbll = new School清查盘点BLL();

                List <School一级部门表> xxmc = pdbll.查询一级部门();
                部门.DataTextField  = "名称";
                部门.DataValueField = "ID";
                部门.DataSource     = xxmc;
                部门.DataBind();
                部门.EmptyText = "全部";

                List <School一级类别表> yjlb = pdbll.查询一级类别();
                一级.DataTextField  = "名称";
                一级.DataValueField = "ID";
                一级.DataSource     = yjlb;
                一级.DataBind();
                一级.EmptyText = "全部";

                List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();
                存放地点.DataTextField  = "名称";
                存放地点.DataValueField = "ID";
                存放地点.DataSource     = 查询建筑物;
                存放地点.DataBind();
                存放地点.EmptyText = "全部";

                二级.Enabled  = false;
                级.Enabled   = false;
                负责人.Enabled = false;
                房间.Enabled  = false;

                二级.EmptyText  = "全部";
                级.EmptyText   = "全部";
                负责人.EmptyText = "全部";
                房间.EmptyText  = "全部";
            }
        }
Beispiel #12
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                二级.Enabled  = false;
                级.Enabled   = false;
                负责人.Enabled = false;
                房间.Enabled  = false;
                //btnCheckSelection.OnClientClick = Grid1.GetNoSelectionAlertInTopReference("没有选中项!");
                //BindGrid();


                School清查盘点BLL pdbll = new School清查盘点BLL();

                List <School一级部门表> xxmc = pdbll.查询一级部门();
                部门.DataTextField  = "名称";
                部门.DataValueField = "ID";
                部门.DataSource     = xxmc;
                部门.DataBind();
                部门.EmptyText = "全部";

                List <School一级类别表> yjlb = pdbll.查询一级类别();
                一级.DataTextField  = "名称";
                一级.DataValueField = "ID";
                一级.DataSource     = yjlb;
                一级.DataBind();
                一级.EmptyText = "全部";

                List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();
                存放地点.DataTextField  = "名称";
                存放地点.DataValueField = "ID";
                存放地点.DataSource     = 查询建筑物;
                存放地点.DataBind();
                存放地点.EmptyText = "全部";

                二级.Enabled  = false;
                级.Enabled   = false;
                负责人.Enabled = false;
                房间.Enabled  = false;

                二级.EmptyText  = "全部";
                级.EmptyText   = "全部";
                负责人.EmptyText = "全部";
                房间.EmptyText  = "全部";


                //DataSet dsa = bll.资产汇总查询();

                //DataTable dta = dsa.Tables[0].Copy();//复制一份table
                //DataTable sourcea = dta;
                //// 3.绑定到Grid
                //Grid1.DataSource = dta;//DataTable
                //Grid1.DataBind();


                DataSet   dss     = zjfxbll.一级类别();
                DataTable dts     = dss.Tables[0].Copy();//复制一份table
                DataTable sourcea = dts;
                Grid1.DataSource = dts;
                Grid1.DataBind();


                DataSet   ds     = bll.资产明细查询();
                DataTable dt     = ds.Tables[0].Copy();//复制一份table
                DataTable source = dt;
                // 3.绑定到Grid
                //Grid2.DataSource = dt;//DataTable
                //Grid2.DataBind();
            }
        }
        //确认申报
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (类别.SelectedValue.ToString() == "待报废")
            {
                if (类别.SelectedValue.ToString() == "待报废")
                {
                    OffSession();
                    string     职务         = Session["职务"].ToString();
                    List <int> intlist    = new List <int>();
                    int[]      selections = Grid2.SelectedRowIndexArray;
                    Console.Write(selections.Length);
                    if (selections.Length == 0)
                    {
                        Alert.Show("请选择");
                    }
                    else
                    {
                        Window2.Hidden = false;
                        Console.Write(selections);
                        foreach (int rowIndex in selections)
                        {
                            int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
                            intlist.Add(ID);
                        }
                        List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue);
                        string flowstate = 类别.SelectedValue;
                        //int 总数 = 0;
                        //int 总价 = 0;
                        float 总数 = 0.0f;
                        float 总价 = 0.0f;
                        if (listdata != null)
                        {
                            foreach (School办公设备信息表 itemjj in listdata)
                            {
                                总数 += itemjj.数量;
                                总价 += Convert.ToInt32(itemjj.价格);
                            }
                        }
                        Grid3.DataSource = listdata;//DataTable
                        Grid3.DataBind();

                        Grid4.DataSource = listdata;//DataTable
                        Grid4.DataBind();
                        JObject summary = new JObject();
                        //summary.Add("major", "全部合计");
                        summary.Add("数量", 总数.ToString("F2"));
                        summary.Add("价格", 总价.ToString("F2"));

                        Grid3.SummaryData = summary;
                        Grid4.SummaryData = summary;
                        //Grid7.SummaryData = summary;
                        //Grid8.SummaryData = summary;
                        //待报废Grid3
                        报废流程状态.Text     = "待审核";
                        报废流程状态.Enabled  = false;
                        报废_申报单位.Text    = Session["二级部门名称"].ToString();
                        报废_申报单位.Enabled = false;
                        报废_申报日期.Text    = DateTime.Now.ToShortDateString();
                        报废单据编号.Text     = SchoolUtility.strbumber("ZCCZBF");;
                        报废单据编号.Enabled  = false;
                        报废_申请人.Text     = HttpContext.Current.Session["姓名"].ToString();
                        报废_申请人.Enabled  = false;

                        报废_职务.Text    = 职务;
                        报废_职务.Enabled = false;
                    }
                }
            }
            else if (类别.SelectedValue.ToString() == "待调拨")
            {
                OffSession();
                string 职务 = Session["职务"].ToString();
                if (职务 == "资产管理员")
                {
                    School清查盘点BLL      pdbll = new School清查盘点BLL();
                    List <School一级部门表> xxmc  = SchoolUtility.查询一级部门不带全部();;
                    调拨调入单位.DataTextField  = "名称";
                    调拨调入单位.DataValueField = "ID";
                    调拨调入单位.DataSource     = xxmc;
                    调拨调入单位.DataBind();

                    List <int> intlist    = new List <int>();
                    int[]      selections = Grid2.SelectedRowIndexArray;
                    if (selections.Length == 0)
                    {
                        Alert.Show("请选择");
                    }
                    else
                    {
                        Window3.Hidden = false;
                        foreach (int rowIndex in selections)
                        {
                            int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
                            intlist.Add(ID);
                        }
                        List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue);
                        string flowstate = 类别.SelectedValue;
                        Grid5.DataSource = listdata;//DataTable
                        Grid5.DataBind();

                        Grid6.DataSource = listdata;
                        Grid6.DataBind();


                        //当前用户部门是调出单位  调入单位操作人选填
                        调拨流程状态.Text    = "待审核";
                        调拨流程状态.Enabled = false;
                        调拨调出单位.Text    = Session["二级部门名称"].ToString();
                        调拨调出单位.Enabled = false;
                        调拨申报日期.Text    = DateTime.Now.ToShortDateString();
                        调拨验收日期.Text    = DateTime.Now.ToShortDateString();

                        DateTime dt = DateTime.Now;
                        string   y  = dt.Year.ToString();
                        string   m  = dt.Month.ToString();
                        string   d  = dt.Day.ToString();
                        string   h  = dt.Hour.ToString();
                        string   mm = dt.Minute.ToString();
                        调拨单据编号.Text    = SchoolUtility.strbumber("ZCCZDB");
                        调拨单据编号.Enabled = false;
                        调拨_申请人.Text    = HttpContext.Current.Session["姓名"].ToString();
                        调拨_申请人.Enabled = false;
                        调拨职务.Enabled   = false;
                        调拨电话.Enabled   = false;
                        调拨职务.Text      = HttpContext.Current.Session["职务"].ToString();
                        try
                        {
                            调拨电话.Text = HttpContext.Current.Session["联系电话"].ToString();
                        }
                        catch (Exception)
                        {
                            调拨电话.Text = "";
                        }
                    }
                }
                else
                {
                    Alert.Show("您没有资产处置-调拨处理的权限,请联系资产管理员", MessageBoxIcon.Warning);
                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DataSet   ds     = bll.首页_X_资产报修流程表("全部");
                DataTable dt     = ds.Tables[0].Copy();//复制一份table
                DataTable source = dt;

                // 3.绑定到Grid
                Grid1.DataSource = dt;//DataTable
                Grid1.DataBind();
                DateTime dtime = DateTime.Now;
                string   sj    = dtime.Year + "-" + dtime.Month + "-" + dtime.Day;
                报修时间2.EmptyText       = sj;
                DatePicker1.EmptyText = sj;
                完成时间.EmptyText        = sj;
                List <School房间信息表> cfdd = bll.cfdd();
                报修地址.DataTextField  = "名称";
                报修地址.DataValueField = "ID";
                报修地址.DataSource     = cfdd;
                报修地址.DataBind();

                //DatePicker1.MinDate = DateTime.Now;
                //DatePicker1.MaxDate = DateTime.Now.AddDays(10);


                // 3.绑定到Grid
                Grid4.DataSource = dt;//DataTable
                Grid4.DataBind();
                //绑定条件
                School清查盘点BLL pdbll = new School清查盘点BLL();

                List <School一级部门表> xxmc = pdbll.查询一级部门();
                部门.DataTextField  = "名称";
                部门.DataValueField = "ID";
                部门.DataSource     = xxmc;
                部门.DataBind();

                List <School一级类别表> yjlb = pdbll.查询一级类别();
                一级.DataTextField  = "名称";
                一级.DataValueField = "ID";
                一级.DataSource     = yjlb;
                一级.DataBind();


                List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();
                存放地点.DataTextField  = "名称";
                存放地点.DataValueField = "ID";
                存放地点.DataSource     = 查询建筑物;
                存放地点.DataBind();


                二级.Enabled  = false;
                级.Enabled   = false;
                负责人.Enabled = false;
                房间.Enabled  = false;

                二级.EmptyText  = "全部";
                级.EmptyText   = "全部";
                负责人.EmptyText = "全部";
                房间.EmptyText  = "全部";
                OffSession();
                string 职务 = HttpContext.Current.Session["职务"].ToString();
                联系电话.Text = HttpContext.Current.Session["电话号码"].ToString();
                if (职务 == "资产管理员")
                {
                    Button1.Hidden = false;
                }
            }
        }