Beispiel #1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (!SessionBox.CheckUserSession())
         {
             Response.Redirect("~/Login.aspx");
         }
         else
         {
             SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0]));
             rolelevel  = (int)r.LevelID;
             roledeptid = SessionBox.GetUserSession().DeptNumber;
             if (rolelevel > 1)
             {
                 Session["WhereRole"]      = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString());
                 Session["WhereUserGroup"] = "usergroupid not in(2,3,23)";
                 Session["maindeptid"]     = SessionBox.GetUserSession().DeptNumber;
                 Session["deptid"]         = SessionBox.GetUserSession().DeptNumber.Remove(4);
             }
             InitData();
         }
     }
 }
Beispiel #2
0
    private void storeload()                 //执行查询 已改
    {
        UserHandle.InitModule(this.PageTag); //初始化此模块的权限。
        var data = from sw in dc.Getsanwei select sw;

        if (UserHandle.ValidationHandle(PermissionTag.SW_xxcl)) //三违处理权限
        {
            data = data.Where(p => p.Dwid == SessionBox.GetUserSession().DeptNumber);
        }
        else if (UserHandle.ValidationHandle(PermissionTag.Browse)) //是否有浏览权限
        {
            data = data.Where(p => p.Pcpersonid == SessionBox.GetUserSession().PersonNumber || p.Swpersonid == SessionBox.GetUserSession().PersonNumber);
        }
        if (!df_begin.IsNull)
        {
            data = data.Where(p => p.Pctime >= df_begin.SelectedDate);
        }
        if (!df_end.IsNull)
        {
            data = data.Where(p => p.Pctime <= df_end.SelectedDate);
        }
        if (cbb_part.SelectedIndex > -1)
        {
            data = data.Where(p => p.Kqid == cbb_part.SelectedItem.Value.Trim());
        }
        if (cbb_lavel.SelectedIndex > -1)
        {
            data = data.Where(p => p.Levelid == decimal.Parse(cbb_lavel.SelectedItem.Value.Trim()));
        }

        Store1.DataSource = data;
        Store1.DataBind();
        btn_detail.Disabled = true;
        Button1.Disabled    = true;
        Button2.Disabled    = true;
    }
Beispiel #3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!SessionBox.CheckUserSession())
     {
         Response.Redirect("~/Login.aspx");
     }
     else
     {
         List <string> lstRole = new List <string>();
         lstRole.Add("2");
         lstRole.Add("46");
         if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "31")
         {
         }
         else if (lstRole.Contains(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0]))
         {
         }
         else
         {
             adsPosition.Where = "Maindeptid == \"" + SessionBox.GetUserSession().DeptNumber + "\"";
             adsPFSWSet.Where  = "Maindeptid == \"" + SessionBox.GetUserSession().DeptNumber + "\"";
         }
     }
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Ext.IsAjaxRequest)
        {
            #region 初始化单位
            MainDeptStore.DataSource = PublicCode.GetMaindept("");
            MainDeptStore.DataBind();

            if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
            {
                cbbKQ.Disabled     = true;
                cbbPerson.Disabled = true;
            }
            else
            {
                cbbMianDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
                cbbMianDept.Disabled           = true;
                KQStore.DataSource             = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber);
                KQStore.DataBind();
                cbbPerson.Disabled = true;
            }
            #endregion
        }
    }
Beispiel #5
0
    private void BaseStroeLoad()
    {
        var data = from m in dc.VMovefrequency
                   where m.Maindept == SessionBox.GetUserSession().DeptNumber
                   select new
        {
            FrequencyID = m.Frequencyid,
            DeptName    = m.Deptname,
            PlaceName   = m.Placename,
            PosName     = m.Posname,
            Frequency   = m.Frequency
        };

        #region 直接linq查询-数据搜索速度慢,先改成上述视图
        //var data = from m in dc.Movefrequency
        //           from pos in dc.Position
        //           from pl in dc.Place
        //           from d in dc.Department
        //           where m.Posid == pos.Posid && m.Placeid == pl.Placeid && m.Deptid == d.Deptnumber && m.Maindept==SessionBox.GetUserSession().DeptNumber
        //           select new
        //           {
        //               FrequencyID = m.Frequencyid,
        //               DeptName = d.Deptname,
        //               PlaceName = pl.Placename,
        //               PosName = pos.Posname,
        //               Frequency = m.Frequency
        //           };
        #endregion
        Store1.DataSource = data;
        Store1.DataBind();
        btn_update.Disabled = true;
        btn_delete.Disabled = true;
        RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;
        sm.SelectedRows.Clear();
        sm.UpdateSelection();
    }
Beispiel #6
0
 private void BindData()//基础信息绑定
 {
     if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1)
     {
         Store5.DataSource = PublicCode.GetMaindept("");
         Store5.DataBind();
         cbbDept.SelectedItem.Value = "241700000";
         cbbDept.Disabled           = false;
     }
     else
     {
         var dept = from d in db.Department
                    where d.Deptnumber == SessionBox.GetUserSession().DeptNumber
                    select new
         {
             d.Deptname,
             Deptid = d.Deptnumber
         };
         Store5.DataSource = dept;
         Store5.DataBind();
         cbbDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
         cbbDept.Disabled           = true;
     }
 }
Beispiel #7
0
    protected void BindOrder()
    {
        string        strWhere = "";
        List <string> lstRole  = new List <string>();

        lstRole.Add("2");
        lstRole.Add("46");
        if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "31")
        {
        }
        else if (lstRole.Contains(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0]))
        {
        }
        else
        {
            strWhere += "Maindeptid == \"" + SessionBox.GetUserSession().DeptNumber + "\"";//&& Placestatus=1";
        }
        if (ddlArea.SelectedValue != "-1")
        {
            strWhere += " && Pareasid=" + ddlArea.SelectedValue;
        }
        if (ddlLevel.SelectedValue != "-1")
        {
            strWhere += " && Plid=" + ddlLevel.SelectedValue;
        }
        if (txtPlace.Text != "")
        {
            strWhere += string.Format(" && Placename.Contains(\"{0}\")", txtPlace.Text.Trim());
        }
        if (ddlStatus.SelectedValue != "-1")
        {
            strWhere += " && Placestatus=" + ddlStatus.SelectedValue;
        }
        adsPlace.Where      = strWhere;
        adsPlaceAreas.Where = "Maindeptid == \"" + SessionBox.GetUserSession().DeptNumber + "\"";
    }
 public void AddDept()
 {
     if (cbbDept.SelectedIndex == -1)
     {
         return;
     }
     if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
     {
         var dept = dc.Department.First(p => p.Deptnumber == cbbDept.SelectedItem.Value);
         if (dept.Visualfield == 3)
         {
             Ext.Msg.Alert("提示", "已添加的部门!").Show();
             return;
         }
         dept.Visualfield = 3;
         dc.SubmitChanges();
         Ext.Msg.Alert("提示", "保存成功!").Show();
         Ext.DoScript("refreshTree(#{tpkind});");
     }
     else
     {
         Ext.Msg.Alert("提示", "非局端用户,不能进行该项操作!").Show();
     }
 }
Beispiel #9
0
    protected void SearchBLDblClick(object sender, AjaxEventArgs e)
    {
        RowSelectionModel sm = gpSearchBL.SelectionModel.Primary as RowSelectionModel;

        if (sm.SelectedRows.Count > 0)
        {
            //修改多列显示
            var yh = from hd in dc.Gethazardusing
                     where hd.HNumber == sm.SelectedRow.RecordID && hd.Deptnumber == SessionBox.GetUserSession().DeptNumber
                     select new
            {
                yhNumber  = hd.HNumber,
                yhContent = hd.HBm,
                hd.Gzrwname,
                hd.Gxname
            };
            yhStore.DataSource = yh;
            yhStore.DataBind();
            cbbyh.SelectedItem.Value = sm.SelectedRow.RecordID;
            SearchBLWindow.Hide();
            Ext.DoScript("#{cbbyh}.triggers[0].show();");
            SelectLoad();
        }
    }
Beispiel #10
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (!SessionBox.CheckUserSession())
         {
             Response.Redirect("~/Login.aspx");
         }
         else
         {
             UserHandle.InitModule(this.PageTag);                   //初始化此模块的权限。
             if (UserHandle.ValidationHandle(PermissionTag.Browse)) //是否有浏览权限
             {
                 txtSender.Text = "调度所";
                 GetPersonList();
             }
             else
             {
                 Session["ErrorNum"] = "0";
                 Response.Redirect("~/Error.aspx");
             }
         }
     }
 }
Beispiel #11
0
    //绑定待复查隐患
    private void bindYH()
    {
        //绑定隐患录入信息
        var query = from yh in dc.Nyhinput
                    from yu in dc.Getyhandhazusing
                    from d in dc.Department
                    from pl in dc.Place
                    from p in dc.Person
                    where yh.Yhid == yu.Yhid && yh.Deptid == d.Deptnumber && yh.Placeid == pl.Placeid && yu.Deptnumber == SessionBox.GetUserSession().DeptNumber &&
                    yh.Status == "隐患已整改" && yh.Placeid == int.Parse(cbbplace.SelectedItem.Value.Trim()) && yh.Personid == p.Personnumber
                    orderby yh.Intime descending
                    select new
        {
            YHPutinID = yh.Yhputinid,
            DeptName  = d.Deptname,
            PlaceName = pl.Placename,
            YHContent = yu.Yhcontent,
            Remarks   = yh.Remarks,
            BanCi     = yh.Banci,
            PCTime    = yh.Pctime,
            YHType    = yu.Typename,
            Status    = yh.Status,
            YHLevel   = yu.Levelname,
            INTime    = yh.Intime,
            Name      = p.Name
        };

        Store6.DataSource = query;
        Store6.DataBind();
    }
Beispiel #12
0
    public void AddClick(string action)
    {
        if (cbbBc.SelectedIndex == -1 || cbbDept.SelectedIndex == -1 || cbbplace.SelectedIndex == -1 || cbbyh.SelectedIndex == -1 || dfPCtime.SelectedValue == null || cbbPerson.SelectedIndex == -1)//hdnPerson.Value.ToString().Trim()=="")
        {
            Ext.Msg.Alert("提示", "请填写完整信息!").Show();
            return;
        }
        string[] pergroup = cbbPerson.SelectedItem.Value.Trim().Split(',');//hdnPerson.Value.ToString().Split(',');//排查人数组
        if (action == "new")
        {
            //获取各班次截止时间
            string time = "00:00:00";
            switch (cbbBc.SelectedItem.Value.Trim())
            {
            case "早班":
                time = PublicMethod.ReadXmlReturnNode("ZBSJ", this);
                break;

            case "中班":
                time = PublicMethod.ReadXmlReturnNode("ZHBSJ", this);
                break;

            case "夜班":
                time = PublicMethod.ReadXmlReturnNode("WBSJ", this);
                break;
            }
            //可录入时间为当班时间+4小时
            DateTime btime = DateTime.Parse(System.DateTime.Today.ToString("yyyy-MM-dd") + " " + time).AddHours(-10); //起始时间
            DateTime etime = DateTime.Parse(System.DateTime.Today.ToString("yyyy-MM-dd") + " " + time).AddHours(2);   //截止时间
            if (btime.Day < System.DateTime.Today.Day)
            {
                btime = btime.AddDays(1);
            }
            if (etime.Day > System.DateTime.Today.Day)
            {
                etime = etime.AddDays(-1);
            }
            if (etime > btime)
            {
                if (System.DateTime.Now < btime || System.DateTime.Now > etime)
                {
                    Ext.Msg.Alert("提示", "不在当日" + cbbBc.SelectedItem.Value.Trim() + "隐患提交时间!").Show();
                    return;
                }
            }
            else
            {
                if (System.DateTime.Now < btime && System.DateTime.Now > etime)
                {
                    Ext.Msg.Alert("提示", "不在当日" + cbbBc.SelectedItem.Value.Trim() + "隐患提交时间!").Show();
                    return;
                }
            }
            try
            {
                var yho = dc.Nyhinput.Where(
                    p =>
                    p.Yhid == decimal.Parse(cbbyh.SelectedItem.Value.Trim()) &&
                    p.Deptid == cbbDept.SelectedItem.Value.Trim() &&
                    p.Placeid == int.Parse(cbbplace.SelectedItem.Value.Trim()) &&
                    new string[] { "新增", "提交审批", "隐患未整改", "逾期未整改" }.Contains(p.Status));
                if (yho.Count() > 0)
                {
                    AddYhMorePerson(yho.First().Yhputinid, pergroup);

                    GhtnTech.SecurityFramework.BLL.LogManager.WriteLog(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().LoginName, "", DateTime.Now, GhtnTech.SecurityFramework.BLL.ActiveType.录入隐患, yho.First().Yhputinid.ToString(), "");
                    Ext.Msg.Alert("提示", "执行隐患合并操作!并入隐患编号为:" + yho.First().Yhputinid).Show(); //+ ";合并明细:<br>"+).Show();
                }
                else
                {
                    //现场整改隐患处理:同班下同一人判断为重复录入,多人或其他人录入并入隐患
                    var yho_s = dc.Nyhinput.Where(
                        p =>
                        p.Yhid == decimal.Parse(cbbyh.SelectedItem.Value.Trim()) &&
                        p.Deptid == cbbDept.SelectedItem.Value.Trim() &&
                        p.Placeid == int.Parse(cbbplace.SelectedItem.Value.Trim()) &&
                        p.Status == "现场整改" && p.Banci == cbbBc.SelectedItem.Value.Trim() && p.Pctime == Convert.ToDateTime(dfPCtime.Value));
                    if (yho_s.Count() > 0)
                    {
                        if (pergroup.Length == 1 && pergroup[0] == yho_s.First().Personid)
                        {
                            Ext.Msg.Alert("提示", "不能重复录入隐患信息!").Show();
                            return;
                        }
                        else
                        {
                            AddYhMorePerson(yho.First().Yhputinid, pergroup);


                            GhtnTech.SecurityFramework.BLL.LogManager.WriteLog(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().LoginName, "", DateTime.Now, GhtnTech.SecurityFramework.BLL.ActiveType.录入隐患, yho.First().Yhputinid.ToString(), "");
                            Ext.Msg.Alert("提示", "执行隐患合并操作!并入隐患编号为:" + yho.First().Yhputinid).Show();// + ";合并明细:<br>" + ).Show();
                            Ext.DoScript("#{YHputinStore}.reload();");
                            return;
                        }
                    }
                    var      lel = dc.Getyhandhazusing.Where(p => p.Yhid == decimal.Parse(cbbyh.SelectedItem.Value.Trim()) && p.Deptnumber == SessionBox.GetUserSession().DeptNumber);
                    Nyhinput yh  = new Nyhinput();
                    yh.Banci         = cbbBc.SelectedItem.Value.Trim();
                    yh.Deptid        = cbbDept.SelectedItem.Value.Trim();
                    yh.Inputpersonid = SessionBox.GetUserSession().PersonNumber; //cbbPerson.SelectedItem.Value.Trim();
                    DateTime dt = System.DateTime.Now;                           //当前时间 插入多人用
                    yh.Personid   = pergroup[0];                                 //cbbPerson.SelectedItem.Value.Trim();
                    yh.Intime     = dt;
                    yh.Pctime     = Convert.ToDateTime(dfPCtime.Value);
                    yh.Placeid    = int.Parse(cbbplace.SelectedItem.Value.Trim());
                    yh.Remarks    = TextArea1.Text.Trim();
                    yh.Status     = cbbStatus.SelectedItem.Value.Trim();
                    yh.Yhid       = decimal.Parse(cbbyh.SelectedItem.Value.Trim());
                    yh.Maindeptid = SessionBox.GetUserSession().DeptNumber;
                    yh.Jctype     = cbbJctype.SelectedIndex;
                    if (lel.Count() > 0)
                    {
                        yh.Levelid = lel.First().Levelid;
                    }
                    //修正状态为null的问题
                    if (string.IsNullOrEmpty(yh.Status))
                    {
                        yh.Status = "现场整改";
                    }
                    dc.Nyhinput.Insert(yh);
                    dc.SubmitChanges();

                    //if (cbbStatus.SelectedItem.Value.Trim() == "现场整改")
                    //{
                    //    string url = string.Format("FinePersonSelect.aspx?Post={0}&Mod={1}&Win={2}", dc.Nyhinput.First(p => p.Intime == dt && p.Inputpersonid == SessionBox.GetUserSession().PersonNumber).Yhputinid, "yh", FineWin.ClientID);
                    //    Ext.DoScript("#{FineWin}.load('" + url + "');#{FineWin}.show();");
                    //}
                    //else
                    //{
                    decimal yhinputid = dc.Nyhinput.First(p => p.Intime == dt && p.Inputpersonid == SessionBox.GetUserSession().PersonNumber).Yhputinid;
                    AddYhMorePerson(yhinputid, pergroup);
                    GhtnTech.SecurityFramework.BLL.LogManager.WriteLog(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().LoginName, "", DateTime.Now, GhtnTech.SecurityFramework.BLL.ActiveType.录入隐患, yhinputid.ToString(), "");
                    Ext.Msg.Alert("提示", "保存成功!").Show();//排查人员添加明细:<br>"+).Show();
                    //}
                }
                //Gridload();
                Ext.DoScript("#{YHputinStore}.reload();");
                //清空隐患信息
                cbbyh.SelectedItem.Value = "";
                TextArea2.Text           = "";
            }
            catch (Exception ex)
            {
                Ext.Msg.Alert("提示", string.Format("保存失败,请稍候重试!\n原因:{0}", ex.Message)).Show();
            }
        }
        else
        {
            var yh = dc.Nyhinput.First(p => p.Yhputinid == decimal.Parse(Hidden1.Value.ToString().Trim()));
            try
            {
                yh.Banci         = cbbBc.SelectedItem.Value.Trim();
                yh.Deptid        = cbbDept.SelectedItem.Value.Trim();
                yh.Inputpersonid = SessionBox.GetUserSession().PersonNumber; // cbbPerson.SelectedItem.Value.Trim();
                yh.Personid      = pergroup[0];                              //cbbPerson.SelectedItem.Value.Trim();
                //yh.Intime = System.DateTime.Today;
                //yh.Pctime = Convert.ToDateTime(dfPCtime.Value);
                yh.Placeid = int.Parse(cbbplace.SelectedItem.Value.Trim());
                yh.Remarks = TextArea1.Text.Trim();
                yh.Status  = cbbStatus.SelectedItem.Value.Trim();
                yh.Yhid    = decimal.Parse(cbbyh.SelectedItem.Value.Trim());
                yh.Jctype  = cbbJctype.SelectedIndex;
                //yh.Maindeptid = SessionBox.GetUserSession().DeptNumber;
                //dc.Yhinput.Insert(yh);
                dc.SubmitChanges();
                AddYhMorePerson(decimal.Parse(Hidden1.Value.ToString().Trim()), pergroup);
                Ext.Msg.Alert("提示", "修改成功!").Show();//排查人员添加明细:<br>" + ).Show();
                //Gridload();
                Ext.DoScript("#{YHputinStore}.reload();");
                //清空隐患信息
                cbbyh.SelectedIndex = -1;
                TextArea2.Text      = "";
            }
            catch
            {
                Ext.Msg.Alert("提示", "保存失败,请稍候重试!").Show();
            }
        }
    }
Beispiel #13
0
    public void PYsearch(string py, string store)
    {
        if (py.Trim() == "")
        {
            return;
        }
        switch (store.Trim())
        {
        case "deptStore":
            if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber))
            {
                string areadept = dc.Person.First(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber).Areadeptid;
                var    dept     = from d in dc.Department
                                  where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) &&
                                  d.Deptnumber != areadept && d.Fatherid != areadept &&
                                  (dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim()))
                                  select new
                {
                    deptID   = d.Deptnumber,
                    deptName = d.Deptname
                };
                deptStore.DataSource = dept.Distinct();
                deptStore.DataBind();
            }
            else
            {
                var dept = from d in dc.Department
                           where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) &&
                           (d.Deptnumber.Substring(7) == "00" || d.Deptlevel == "正科级") && d.Deptstatus == "1" &&
                           (dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim()))
                           select new
                {
                    deptID   = d.Deptnumber,
                    deptName = d.Deptname
                };
                deptStore.DataSource = dept.Distinct();
                deptStore.DataBind();
            }
            break;

        case "placeStore":
            if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber))
            {
                decimal areaid = (from p in dc.Person
                                  from d in dc.Department
                                  from a in dc.Placeareas
                                  where p.Personnumber == SessionBox.GetUserSession().PersonNumber &&
                                  p.Areadeptid == d.Deptnumber && d.Deptname.Replace(" ", "") == a.Pareasname
                                  select a).First().Pareasid;
                var place = from pl in dc.Place
                            where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber &&
                            pl.Pareasid != areaid && pl.Placestatus == 1 &&
                            (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim()))
                            select new
                {
                    placID   = pl.Placeid,
                    placName = pl.Placename
                };
                placeStore.DataSource = place;
                placeStore.DataBind();
            }
            else
            {
                var place = from pl in dc.Place
                            where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 &&
                            (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim()))
                            select new
                {
                    placID   = pl.Placeid,
                    placName = pl.Placename
                };
                placeStore.DataSource = place;
                placeStore.DataBind();
            }
            break;

        case "yhStore":    //修改多列显示
            var hazard = from yh in dc.Getyhandhazusing
                         where yh.Deptnumber == SessionBox.GetUserSession().DeptNumber &&
                         (yh.Conpyfirst.ToLower().Contains(py.ToLower()) || yh.Yhcontent.Contains(py.Trim()) || yh.Yhnumber.ToLower().Contains(py.ToLower()))
                         select new
            {
                yhNumber  = yh.Yhid,
                yhContent = yh.Yhcontent,
                Gzrwname  = yh.Levelname,
                Gxname    = yh.Typename
            };
            yhStore.DataSource = hazard;
            yhStore.DataBind();
            break;

        case "PCpersonStore":
            if (cbbJctype.SelectedItem.Value == "2")
            {
                //局端排查人
                var person = from p in dc.Person
                             from d in dc.Department
                             where p.Areadeptid == d.Deptnumber && p.Visualfield == 3 && p.Personstatus == 1 &&
                             (dc.F_PINYIN(p.Name).ToLower().Contains(py.ToLower()) || p.Name.Contains(py.Trim()))
                             select new
                {
                    p.Personnumber,
                    p.Name,
                    d.Deptname
                };
                PCpersonStore.DataSource = person;
                PCpersonStore.DataBind();
            }
            else
            {
                var person = from pl in dc.Vgetpl
                             from p in dc.Person
                             where pl.Moduletag == "HiddenDanage_HDprocess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber &&
                             (dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) &&
                             pl.Personnumber == p.Personnumber && p.Personstatus == 1
                             select new
                {
                    pl.Personnumber,
                    pl.Name
                };
                PCpersonStore.DataSource = person.Distinct();
                PCpersonStore.DataBind();
            }
            break;

        case "WorkTaskStore":
            var gzrw = dc.Worktasks.Where(
                p => p.Professionalid == decimal.Parse(cbbSbsdy.SelectedItem.Value) &&
                dc.F_PINYIN(p.Worktask).ToLower().Contains(py.ToLower())
                );
            WorkTaskStore.DataSource = gzrw;
            WorkTaskStore.DataBind();
            break;
        }
    }
Beispiel #14
0
    private void storeload()//数据绑定
    {
        //需要添加权限判断-判断是否为走动干部进入

        var data = from m in dc.VMoveplan
                   where m.Maindept == SessionBox.GetUserSession().DeptNumber
                   select new
        {
            Name      = m.Name,
            PlaceName = m.Placename,
            DeptName  = m.Deptname,
            PosName   = m.Posname,
            ID        = m.Id,
            PersonID  = m.Personid,
            StartTime = m.Starttime,
            EndTime   = m.Endtime,
            MoveState = m.Movestate,
            m.Posid,
            m.Placeid
        };

        if (df_begin.SelectedDate > df_end.SelectedDate)
        {
            Ext.Msg.Alert("提示", "日期选择有误!").Show();
            return;
        }
        #region 直接linq查询-数据搜索速度慢,先改成上述视图
        //var data = from m in dc.Moveplan
        //           from p in dc.Person
        //           from pl in dc.Place
        //           from d in dc.Department
        //           from pos in dc.Position
        //           where m.Personid == p.Personnumber && m.Placeid == pl.Placeid && p.Deptid == d.Deptnumber && p.Posid == pos.Posid && m.Maindept == SessionBox.GetUserSession().DeptNumber
        //           && m.Starttime.Value >= (df_begin.IsNull ? m.Starttime.Value : df_begin.SelectedDate.Date) && m.Endtime.Value <= (df_end.IsNull ? m.Endtime.Value : df_end.SelectedDate.Date)
        //               //&& pos.Posid == (cbb_zhiwu.SelectedIndex == -1 ? pos.Posid : Convert.ToInt32(cbb_zhiwu.SelectedItem.Value))
        //           && p.Personnumber == (cbb_person.SelectedIndex == -1 ? p.Personnumber : cbb_person.SelectedItem.Value.Trim())
        //           //&& pl.Placeid == (cbb_place.SelectedIndex == -1 ? pl.Placeid : Decimal.Parse(cbb_place.SelectedItem.Value.Trim()))
        //           select new
        //           {
        //               Name = p.Name,
        //               PlaceName = pl.Placename,
        //               DeptName = d.Deptname,
        //               PosName = pos.Posname,
        //               ID = m.Id,
        //               PersonID = m.Personid,
        //               StartTime = m.Starttime,
        //               EndTime = m.Endtime,
        //               MoveState = m.Movestate,
        //               pos.Posid,
        //               pl.Placeid
        //           };
        #endregion
        if (!df_begin.IsNull)
        {
            data = data.Where(p => p.StartTime >= df_begin.SelectedDate.Date);
        }
        if (!df_end.IsNull)
        {
            data = data.Where(p => p.EndTime <= df_end.SelectedDate.Date);
        }
        if (cbb_person.SelectedIndex > -1)
        {
            data = data.Where(p => p.PersonID == cbb_person.SelectedItem.Value.Trim());
        }
        if (cbb_place.SelectedIndex > -1)
        {
            data = data.Where(p => p.Placeid == Decimal.Parse(cbb_place.SelectedItem.Value.Trim()));
        }
        if (cbb_zhiwu.SelectedIndex > -1)
        {
            data = data.Where(p => p.Posid == Decimal.Parse(cbb_zhiwu.SelectedItem.Value.Trim()));
        }
        MoveStore.DataSource = data;
        MoveStore.DataBind();
    }
Beispiel #15
0
    private void SearchLoad()//查询窗口初始化
    {
        DBSCMDataContext dc = new DBSCMDataContext();

        //初始化地点
        var dep = from d in dc.Place
                  where d.Maindeptid == SessionBox.GetUserSession().DeptNumber
                  select new
        {
            PlaceName = d.Placename,
            PlaceID   = d.Placeid
        };

        Store4.DataSource = dep;
        Store4.DataBind();
        //初始化人员职务
        //需要添加权限判断-判断是否为走动干部进入
        var pos = from p in dc.Position
                  from per in dc.Person
                  where p.Posid == per.Posid && p.Maindeptid == per.Maindeptid && per.Maindeptid == SessionBox.GetUserSession().DeptNumber
                  select new
        {
            PosID   = p.Posid,
            PosName = p.Posname
        };

        PosStore.DataSource = pos;
        PosStore.DataBind();
    }
Beispiel #16
0
    public void YearDataLoad()
    {
        //获取当年全矿安全状况
        int    date     = System.DateTime.Today.Year;
        string textYear = @"<br /><b>" + date + "年全矿安全动态:</b><br /><br />";
        //var YHdata = from c in dc.Yhview
        //             where c.Pctime.Value.Year == System.DateTime.Today.Year && c.Maindeptid == SessionBox.GetUserSession().DeptNumber
        //             group c by c.Levelname into g
        //             orderby g.Key
        //             select new
        //             {
        //                 YHLevel = g.Key,
        //                 YHnum = g.Count()
        //             };
        //var SWdata = from c in dc.Getsanwei
        //             where c.Pctime.Value.Year == System.DateTime.Today.Year && c.Dwid == SessionBox.GetUserSession().DeptNumber
        //             group c by c.Levelname into g
        //             select new
        //             {
        //                 SWLevel = g.Key,
        //                 SWnum = g.Count()
        //             };
        DateTime daybegin = new DateTime(System.DateTime.Today.Year, 1, 1);
        DateTime dayend   = new DateTime(System.DateTime.Today.Year, 12, 31);
        var      YHdata   = GetSafeInfo.GetMainLeaderYH(daybegin, dayend, SessionBox.GetUserSession().DeptNumber).Tables[0];
        //var SWdata = GetSafeInfo.GetMainLeaderSW(daybegin, dayend, SessionBox.GetUserSession().DeptNumber).Tables[0];
        var SWdata = from s in dc.Getsanwei
                     where s.Pctime >= daybegin && s.Pctime <= dayend &&
                     s.Dwid == SessionBox.GetUserSession().DeptNumber
                     group s by s.Levelname into g
                     select new
        {
            g.Key,
            swnum = g.Count()
        };

        if (YHdata.Rows.Count <= 0 && SWdata.Count() <= 0)
        {
            textYear += "&nbsp;&nbsp;本年度无安全动态!";
        }
        else
        {
            if (YHdata.Rows.Count > 0)
            {
                textYear += "全矿隐患信息:<br />";
                for (int i = 0; i < YHdata.Rows.Count; i++)
                {
                    textYear += string.Format("&nbsp;&nbsp;&nbsp;&nbsp;<span align=left> <font color={2}><b>{0}</b></font>级隐患:{1}条 <br /></span>", YHdata.Rows[i]["LEVELNAME"].ToString().Trim(), YHdata.Rows[i]["YHNUM"].ToString().Trim(), GetColor(YHdata.Rows[i]["LEVELNAME"].ToString().Trim()));
                }
            }
            if (SWdata.Count() > 0)
            {
                textYear += "全矿三违信息:<br />";
                foreach (var r in SWdata)
                {
                    textYear += string.Format("&nbsp;&nbsp;&nbsp;&nbsp;<span align=left><font color={5}><b>{0}</b></font>级别三违:" + SWstr + "条 </span><br />", r.Key, Server.UrlEncode(r.Key), daybegin, dayend, r.swnum, GetColor1(r.Key));
                }
            }
        }
        this.YearPanel.Html = textYear;
    }
Beispiel #17
0
    public void MonthDataLoad()
    {
        //获取当月全矿安全状况
        DateTime start     = new DateTime(System.DateTime.Today.Year, System.DateTime.Today.Month, 1);
        DateTime end       = new DateTime(System.DateTime.Today.Year, System.DateTime.Today.Month, DateTime.DaysInMonth(System.DateTime.Today.Year, System.DateTime.Today.Month));
        string   textMonth = @"<br /><b>本月安全动态:</b><br /><br />";
        //var YHdataMonth = from c in dc.Yhview
        //                  where (c.Pctime.Value >= start && c.Pctime.Value <= end) && c.Maindeptid == SessionBox.GetUserSession().DeptNumber
        //                  group c by c.Levelname into g
        //                  orderby g.Key
        //                  select new
        //                  {
        //                      YHLevel = g.Key,
        //                      YHnum = g.Count()
        //                  };
        //var SWdataMonth = from c in dc.Getsanwei
        //                  where (c.Pctime.Value >= start && c.Pctime.Value <= end) && c.Dwid == SessionBox.GetUserSession().DeptNumber
        //                  group c by c.Levelname into g
        //                  select new
        //                  {
        //                      SWLevel = g.Key,
        //                      SWnum = g.Count()
        //                  };
        var YHdataMonth = GetSafeInfo.GetMainLeaderYH(start, end, SessionBox.GetUserSession().DeptNumber).Tables[0];
        //var SWdataMonth = GetSafeInfo.GetMainLeaderSW(start, end, SessionBox.GetUserSession().DeptNumber).Tables[0];
        var SWdataMonth = from s in dc.Getsanwei
                          where s.Pctime >= start && s.Pctime <= end &&
                          s.Dwid == SessionBox.GetUserSession().DeptNumber
                          group s by s.Levelname into g
                          select new
        {
            g.Key,
            swnum = g.Count()
        };

        if (YHdataMonth.Rows.Count <= 0 && SWdataMonth.Count() <= 0)
        {
            textMonth += "&nbsp;&nbsp;本月无安全动态!";
        }
        else
        {
            if (YHdataMonth.Rows.Count > 0)
            {
                textMonth += "全矿隐患信息:<br />";
                for (int i = 0; i < YHdataMonth.Rows.Count; i++)
                {
                    textMonth += string.Format("&nbsp;&nbsp;&nbsp;&nbsp;<span align=left><font color={5}><b>{0}</b></font>级隐患:" + YHstr + "条 </span><br />", YHdataMonth.Rows[i]["LEVELNAME"].ToString().Trim(), Server.UrlEncode(YHdataMonth.Rows[i]["LEVELNAME"].ToString().Trim()), System.DateTime.Today.AddDays(1 - System.DateTime.Today.Day).ToString("yyyy-MM-dd"), System.DateTime.Today.AddDays(1 - System.DateTime.Today.Day).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd"), YHdataMonth.Rows[i]["YHNUM"].ToString().Trim(), GetColor(YHdataMonth.Rows[i]["LEVELNAME"].ToString().Trim()));
                }
            }
            if (SWdataMonth.Count() > 0)
            {
                textMonth += "全矿三违信息:<br />";
                foreach (var r in SWdataMonth)
                {
                    textMonth += string.Format("&nbsp;&nbsp;&nbsp;&nbsp;<span align=left><font color={5}><b>{0}</b></font>级别三违:" + SWstr + "条 </span><br />", r.Key, Server.UrlEncode(r.Key), start, end, r.swnum, GetColor1(r.Key));
                }
                //for (int i = 0; i < SWdataMonth.Rows.Count;i++)
                //{
                //    textMonth += string.Format("&nbsp;&nbsp;&nbsp;&nbsp;<span align=left><font color={5}>{0}</font>级别三违:" + SWstr + "条 </span><br />", SWdataMonth.Rows[i]["LEVELNAME"].ToString().Trim(), Server.UrlEncode(SWdataMonth.Rows[i]["LEVELNAME"].ToString().Trim()), System.DateTime.Today.AddDays(1 - System.DateTime.Today.Day).ToString("yyyy-MM-dd"), System.DateTime.Today.AddDays(1 - System.DateTime.Today.Day).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd"), SWdataMonth.Rows[i]["SWNUM"].ToString().Trim(), GetColor1(SWdataMonth.Rows[i]["LEVELNAME"].ToString().Trim()));
                //}
            }
        }
        this.MonthPanel.Html = textMonth;
    }
Beispiel #18
0
    public void storebind()
    {
        if (dfBegin.SelectedDate > dfEnd.SelectedDate)
        {
            Ext.Msg.Alert("提示", "请选择正确日期").Show();
            return;
        }
        //var data = dc.GetAllSafetyCountByPAreas(dfBegin.SelectedDate, dfEnd.SelectedDate);

        if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
        {
            if (cbbUnit.SelectedIndex > -1 && cbbUnit.SelectedItem.Value != "-1")
            {
                var data = GetSafeInfo.GetAllSafetyCountByPAreas(dfBegin.SelectedDate, dfEnd.SelectedDate, cbbUnit.SelectedItem.Value);
                Store1.DataSource = data;
                Store1.DataBind();
            }
            else
            {
                var data = GetSafeInfo.GetAllSafetyCountByPAreas(dfBegin.SelectedDate, dfEnd.SelectedDate, "");
                Store1.DataSource = data;
                Store1.DataBind();
            }
        }
        else
        {
            var data = GetSafeInfo.GetAllSafetyCountByPAreas(dfBegin.SelectedDate, dfEnd.SelectedDate, SessionBox.GetUserSession().DeptNumber);
            Store1.DataSource = data;
            Store1.DataBind();
        }
    }
Beispiel #19
0
    private void StoreLoad()
    {
        var datayh = from yh in dc.Swbase
                     from d in dc.CsBaseinfoset
                     where yh.Typeid == d.Infoid && yh.Nstatus == 2
                     select new
        {
            yh.Swid,
            yh.Swnumber,
            yh.Swcontent,
            yh.Levelid,
            yh.Typeid,
            Typename = d.Infoname,
            yh.Conpyfirst,
            yh.Intime,
            yh.Nstatus
        };
        var data2 = from d in datayh
                    join yq in dc.Swquote.Where(p => p.Deptnumber == SessionBox.GetUserSession().DeptNumber) on d.Swid equals yq.Swid into gg
                    from g in gg.DefaultIfEmpty()
                    select new
        {
            d.Swid,
            d.Swnumber,
            d.Swcontent,
            Levelid = (g == null ? d.Levelid : g.Levelid),
            d.Typeid,
            d.Typename,
            d.Conpyfirst,
            Intime  = g.Quotetime,
            Nstatus = g == null ? 2 : g.Nstatus
        };

        var data = from d in data2
                   from c in dc.CsBaseinfoset
                   where d.Levelid == c.Infoid
                   select new
        {
            d.Swid,
            d.Swnumber,
            d.Swcontent,
            d.Levelid,
            Levelname = c.Infoname,
            d.Typeid,
            d.Typename,
            d.Conpyfirst,
            d.Intime,
            d.Nstatus
        };

        if (cbb_lavel.SelectedIndex > -1)
        {
            data = data.Where(p => p.Levelid == decimal.Parse(cbb_lavel.SelectedItem.Value));
        }
        if (cbb_kind.SelectedIndex > -1)
        {
            data = data.Where(p => p.Typeid == decimal.Parse(cbb_kind.SelectedItem.Value));
        }
        YHStore.DataSource = data;
        YHStore.DataBind();
    }
Beispiel #20
0
    public void Doquote()
    {
        RowSelectionModel sm = GridPanel3.SelectionModel.Primary as RowSelectionModel;

        if (sm.SelectedRows.Count > 0)
        {
            var yb = dc.Swquote.Where(p => p.Swid == decimal.Parse(sm.SelectedRow.RecordID) && p.Deptnumber == SessionBox.GetUserSession().DeptNumber);
            if (yb.Count() > 0)
            {
                yb.First().Nstatus = 1;
                dc.SubmitChanges();
            }
            else
            {
                var     yh = dc.Swbase.First(p => p.Swid == decimal.Parse(sm.SelectedRow.RecordID));
                Swquote yq = new Swquote
                {
                    Swid       = decimal.Parse(sm.SelectedRow.RecordID),
                    Levelid    = yh.Levelid,
                    Deptnumber = SessionBox.GetUserSession().DeptNumber,
                    Nstatus    = 1,
                    Quotetime  = System.DateTime.Today
                };
                dc.Swquote.InsertOnSubmit(yq);
                dc.SubmitChanges();
            }
            StoreLoad();
            Ext.Msg.Alert("提示", "引用成功!").Show();
        }
    }
Beispiel #21
0
    private void storeload()
    {
        var data = from m in dc.VMoveplan
                   from k in dc.Moveplan
                   where m.Maindept == SessionBox.GetUserSession().DeptNumber&& m.Id == k.Id
                   select new
        {
            m.Name,
            m.Placeid,
            m.Placename,
            m.Deptname,
            m.Posid,
            m.Posname,
            m.Id,
            m.Personid,
            m.Starttime,
            m.Endtime,
            m.Movestarttime,
            m.Movestate,
            Closeremarks = (k.Closeremarks == "录入隐患闭合" ? "" : k.Closeremarks)
        };

        if (!df_begin.IsNull)
        {
            data = data.Where(p => p.Starttime >= df_begin.SelectedDate.Date);
        }
        if (!df_end.IsNull)
        {
            data = data.Where(p => p.Starttime <= df_end.SelectedDate.Date);
        }
        if (cbb_person.SelectedIndex > -1)
        {
            data = data.Where(p => p.Personid == cbb_person.SelectedItem.Value.Trim());
        }
        if (cbb_place.SelectedIndex > -1)
        {
            data = data.Where(p => p.Placeid == Decimal.Parse(cbb_place.SelectedItem.Value.Trim()));
        }
        if (cbb_zhiwu.SelectedIndex > -1)
        {
            data = data.Where(p => p.Posid == Decimal.Parse(cbb_zhiwu.SelectedItem.Value.Trim()));
        }

        //var data = from a in dc.Moveplan
        //            from b in dc.Person
        //            from c in dc.Place
        //            from d in dc.Department
        //            from e in dc.Position
        //            where a.Personid == b.Personnumber && a.Placeid == c.Placeid && b.Deptid == d.Deptnumber && b.Posid==e.Posid &&
        //            a.Maindept == SessionBox.GetUserSession().DeptNumber && a.Starttime >= start && a.Starttime <= end
        //            select new
        //            {
        //                b.Name,
        //                c.Placename,
        //                d.Deptname,
        //                e.Posname,
        //                a.Id,
        //                a.Personid,
        //                a.Starttime,
        //                a.Endtime,
        //                a.Movestate
        //            };

        Store1.DataSource = data;
        Store1.DataBind();
        btn_delete.Disabled = true;
        RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;

        sm.SelectedRows.Clear();
        sm.UpdateSelection();
    }
Beispiel #22
0
    private Coolite.Ext.Web.TreeNodeCollection LoadTree(Coolite.Ext.Web.TreeNodeCollection nodes)
    {
        if (nodes == null)
        {
            nodes = new Coolite.Ext.Web.TreeNodeCollection();
        }//根节点为null时

        tpPerson.Root.Clear();
        Coolite.Ext.Web.TreeNode root = new Coolite.Ext.Web.TreeNode();
        if (cbbJctype.SelectedItem.Value == "2")
        {
            var dept = dc.Department.First(p => p.Deptnumber == "000000000");
            root = new Coolite.Ext.Web.TreeNode(dept.Deptnumber, dept.Deptname, Icon.UserHome);
            tpPerson.Root.Add(root);
            var per = (from d in dc.Department
                       where //d.Deptnumber.Substring(0, 4) == "1303"
                             //&& (d.Deptnumber.Substring(7) == "00" || d.Deptlevel == "正科级")
                             //&&
                       d.Visualfield == 3
                       select new
            {
                d.Deptnumber,
                d.Deptname
            }).OrderBy(p => p.Deptname);
            foreach (var r in per)
            {
                AsyncTreeNode asyncNode = new AsyncTreeNode(r.Deptnumber, r.Deptname);
                asyncNode.Icon = Icon.UserEarth;
                root.Nodes.Add(asyncNode);
            }

            //局端排查人
            var person = from p in dc.Person
                         from d in dc.Department
                         where p.Areadeptid == d.Deptnumber && p.Visualfield == 100//返回空结构
                         select new
            {
                p.Personnumber,
                p.Name,
                d.Deptname
            };
            SelectedStore.DataSource = person;
            SelectedStore.DataBind();
        }
        else
        {
            var dept = dc.Department.First(p => p.Deptnumber == SessionBox.GetUserSession().DeptNumber);
            root = new Coolite.Ext.Web.TreeNode(dept.Deptnumber, dept.Deptname, Icon.UserHome);
            tpPerson.Root.Add(root);
            var per = (from v in dc.Vgetpl
                       where v.Operatortag == "YH_fcfk" && v.Moduletag == "HiddenDanage_HDprocess" && v.Unitid == SessionBox.GetUserSession().DeptNumber
                       select new
            {
                v.Deptnumber,
                v.Deptname
            }).Distinct().OrderBy(p => p.Deptname);
            foreach (var r in per)
            {
                AsyncTreeNode asyncNode = new AsyncTreeNode(r.Deptnumber, r.Deptname);
                asyncNode.Icon = Icon.UserEarth;
                root.Nodes.Add(asyncNode);
            }

            //排查人初始绑定
            var person = (from pl in dc.Vgetpl
                          where pl.Moduletag == "YSNewProcess_YHProcess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber &&
                          pl.Personnumber == SessionBox.GetUserSession().PersonNumber
                          select new
            {
                pl.Personnumber,
                pl.Name,
                pl.Deptname
            }).Distinct();
            if (person.Where(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber).Count() > 0)
            {
                cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber;
                var person1 = person.Where(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber);
                SelectedStore.DataSource = person1;
                SelectedStore.DataBind();
            }
        }

        return(nodes);
    }
Beispiel #23
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Ext.IsAjaxRequest)
        {
            //改变走动状态
            //AutoDoSth();
            //待办事宜
            string   text    = "<ul>";
            string[] countYH = MainData.getYHDSP_kld(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber);
            text += string.Format("<span><font color=#cc0000><b>待办事宜:</b></font></span>您有待审批隐患:<a href={1}>{0}条</a>", countYH[0], "YSNewProcess/YHProcess.aspx?YHIDgroup=" + (countYH[1].Length == 0 ? "-1" : countYH[1]));
            //待督促隐患
            var sms = from s in dc.TblSmsendtask
                      from p in dc.Person
                      from yh in dc.Getyhinput
                      where s.Destaddr == p.Tel && s.Msgid == yh.Yhputinid.ToString() &&
                      p.Personnumber == SessionBox.GetUserSession().PersonNumber&& yh.Status == "隐患未整改"
                      group s by s.Msgid into g
                      select new
            {
                YHPutinID = g.Key
            };          //group by 不要重复数据
            string group = "";
            foreach (var r in sms)
            {
                group += r.YHPutinID.ToString() + ",";
            }
            if (group.Length > 0)
            {
                group = group.Substring(0, group.Length - 1);
            }
            else
            {
                group = "-1";
            }
            text += string.Format("&nbsp;&nbsp;&nbsp;&nbsp;<span>您有待督促隐患:<a href={1}>{0}条</a></span>", sms.Count(), "YSNewProcess/YHProcess.aspx?YHIDgroup=" + group);

            text += "</ul>";
            this.ScriptManager1.RegisterClientScriptBlock("part", string.Format("var part=\"{0}\";", text));
            lab.Html = "={part}";

            Ext.DoScript("Coolite.AjaxMethods.DayDataLoad();");
            Ext.DoScript("Coolite.AjaxMethods.WeekDataLoad();");
            Ext.DoScript("Coolite.AjaxMethods.MonthDataLoad();");
            Ext.DoScript("Coolite.AjaxMethods.YearDataLoad();");
        }
    }
Beispiel #24
0
    private void pcPersonLoad()
    {
        var person = (from pl in dc.Vgetpl
                      where pl.Moduletag == "YSNewProcess_YHProcess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber &&
                      pl.Personnumber == SessionBox.GetUserSession().PersonNumber
                      select new
        {
            pl.Personnumber,
            pl.Name,
            pl.Deptname
        }).Distinct();

        PCpersonStore.DataSource = person;
        PCpersonStore.DataBind();
        cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber;
    }
Beispiel #25
0
    public void DayDataLoad()
    {
        //获取当天全矿安全状况
        string textDay = @"<br /><b>今日安全动态:</b><br /><br />";

        //var YHdataDay = from c in dc.Yhview
        //                where c.Pctime == System.DateTime.Today && c.Maindeptid==SessionBox.GetUserSession().DeptNumber
        //                group c by c.Levelname into g
        //                orderby g.Key
        //                select new
        //                {
        //                    YHLevel = g.Key,
        //                    YHnum = g.Count()
        //                };
        //var SWdataDay = from c in dc.Getsanwei
        //                where c.Pctime == System.DateTime.Today && c.Dwid == SessionBox.GetUserSession().DeptNumber
        //                group c by c.Levelname into g
        //                select new
        //                {
        //                    SWLevel = g.Key,
        //                    SWnum = g.Count()
        //                };
        //几个视图未改成最新
        var YHdataDay = GetSafeInfo.GetMainLeaderYH(System.DateTime.Today, System.DateTime.Today, SessionBox.GetUserSession().DeptNumber).Tables[0];
        //var SWdataDay = GetSafeInfo.GetMainLeaderSW(System.DateTime.Today, System.DateTime.Today, SessionBox.GetUserSession().DeptNumber).Tables[0];
        var SWdataDay = from s in dc.Getsanwei
                        where s.Pctime == System.DateTime.Today &&
                        s.Dwid == SessionBox.GetUserSession().DeptNumber
                        group s by s.Levelname into g
                        select new
        {
            g.Key,
            swnum = g.Count()
        };

        if (YHdataDay.Rows.Count <= 0 && SWdataDay.Count() <= 0)
        {
            textDay += "&nbsp;&nbsp;今日无安全动态!";
        }
        else
        {
            if (YHdataDay.Rows.Count > 0)
            {
                //textDay += "<font color=red>全矿隐患信息:</font><br />";
                textDay += "全矿隐患信息:<br />";
                for (int i = 0; i < YHdataDay.Rows.Count; i++)
                {
                    textDay += string.Format("&nbsp;&nbsp;&nbsp;&nbsp;<span align=left><font color={5}><b>{0}</b></font>级隐患:" + YHstr + "条</span> <br />", YHdataDay.Rows[i]["LEVELNAME"].ToString().Trim(), Server.UrlEncode(YHdataDay.Rows[i]["LEVELNAME"].ToString().Trim()), System.DateTime.Today.ToString("yyyy-MM-dd"), System.DateTime.Today.ToString("yyyy-MM-dd"), YHdataDay.Rows[i]["YHNUM"].ToString().Trim(), GetColor(YHdataDay.Rows[i]["LEVELNAME"].ToString().Trim()));
                }
            }
            if (SWdataDay.Count() > 0)
            {
                textDay += "全矿三违信息:<br />";
                foreach (var r in SWdataDay)
                {
                    textDay += string.Format("&nbsp;&nbsp;&nbsp;&nbsp;<span align=left><font color={5}><b>{0}</b></font>级别三违:" + SWstr + "条 </span><br />", r.Key, Server.UrlEncode(r.Key), System.DateTime.Today.ToString("yyyy-MM-dd"), System.DateTime.Today.ToString("yyyy-MM-dd"), r.swnum, GetColor1(r.Key));
                }
            }
        }
        this.DayPanel.Html = textDay;
    }
Beispiel #26
0
    public void SelectLoad()
    {
        var    yh  = dc.Getyhandhazusing.First(p => p.Yhid == decimal.Parse(cbbyh.SelectedItem.Value) && p.Deptnumber == SessionBox.GetUserSession().DeptNumber);
        string msg = "危 险 源:" + yh.HContent;

        msg += "\r\n辨识单元:" + yh.Typename;
        msg += "\r\n风险类型:" + yh.Fxlx;
        msg += "\r\n风险等级:" + yh.Fxlevel;
        msg += "\r\n事故类型:" + yh.Sglx;
        msg += "\r\n隐患级别:" + yh.Levelname;
        try
        {
            msg += "\r\n矿查积分:" + yh.Kcscore;
        }
        catch
        {
            msg += "\r\n矿查积分:无";
        }
        TextArea2.Text = msg;
    }
Beispiel #27
0
    protected void PersonRefresh(object sender, StoreRefreshDataEventArgs e)
    {
        //需要添加权限判断-判断是否为走动干部进入

        //var q = dc.Person.Where(p => p.Posid == Convert.ToInt32(cbb_zhiwu.SelectedItem.Value) && p.Maindeptid == SessionBox.GetUserSession().DeptNumber);
        var q = from p in dc.Person
                where p.Posid == Convert.ToInt32(cbb_zhiwu.SelectedItem.Value) && p.Maindeptid == SessionBox.GetUserSession().DeptNumber
                orderby p.Name ascending
                select new
        {
            p.Personnumber,
            p.Name
        };

        PersonStore.DataSource = q;
        PersonStore.DataBind();
        cbb_person.Disabled = q.Count() > 0 ? false : true;
    }
Beispiel #28
0
    private void Gridload()
    {
        //绑定隐患录入信息
        var data = from yh in dc.Getyhinput
                   from ny in dc.Nyhinput
                   from m in dc.NyhinputMore
                   where yh.Yhputinid == ny.Yhputinid && yh.Unitid == SessionBox.GetUserSession().DeptNumber
                   //多人排查 如果为排查人也可看到
                   && yh.Yhputinid == m.Yhputinid &&
                   (ny.Inputpersonid == SessionBox.GetUserSession().PersonNumber || m.Personid == SessionBox.GetUserSession().PersonNumber) &&
                   yh.Intime >= System.DateTime.Today.AddDays(-7)   //查询最近7天的信息
                   orderby yh.Intime descending
                   select new
        {
            YHPutinID = yh.Yhputinid,
            DeptName  = yh.Deptname,
            PlaceName = yh.Placename,
            YHContent = yh.Yhcontent,
            Remarks   = yh.Remarks,
            BanCi     = yh.Banci,
            Name      = yh.Name,
            INTime    = yh.Intime,
            PCTime    = yh.Pctime,
            YHType    = yh.Typename,
            Status    = yh.Status
        };

        if (data.Count() > 0)
        {
            YHputinStore.DataSource = data;
            YHputinStore.DataBind();
        }
    }
Beispiel #29
0
 protected void gvSWPointSet_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
 {
     e.NewValues["Deptnumber"] = SessionBox.GetUserSession().DeptNumber;
     e.NewValues["Usingtime"]  = DateTime.Now;
 }
Beispiel #30
0
    protected void RowClick(object sender, AjaxEventArgs e)//流程处理
    {
        RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;

        if (sm.SelectedRows.Count > 0)
        {
            var data = dc.Nyhinput.First(p => p.Yhputinid == decimal.Parse(sm.SelectedRow.RecordID.Trim()));
            if (data.Status != "新增")
            {
                cbbDept.SelectedItem.Value  = "";
                cbbplace.SelectedItem.Value = "";
                cbbyh.SelectedItem.Value    = "";
                TextArea1.Text     = "";
                btnEdit.Disabled   = true;
                btnDelete.Disabled = true;
                TextArea2.Text     = "";
                return;
            }
            cbbBc.SelectedItem.Value = data.Banci;
            //部门------------------------
            cbbDept.Items.Clear();
            var dept = from d in dc.Department
                       where d.Deptnumber == data.Deptid
                       select new
            {
                deptID   = d.Deptnumber,
                deptName = d.Deptname
            };
            deptStore.DataSource = dept;
            deptStore.DataBind();
            cbbDept.SelectedItem.Value = data.Deptid;
            //cbbDept.SelectedItem.Text = dept.First().deptName;
            //------------------------
            //cbbPerson.SelectedItem.Value = data.Personid;
            GetPersonName(int.Parse(sm.SelectedRow.RecordID.Trim()));
            dfPCtime.Value = data.Pctime.Value;
            cbbplace.Items.Clear();
            //地点
            var place = from pl in dc.Place
                        where pl.Placeid == data.Placeid && pl.Placestatus == 1
                        select new
            {
                placID   = pl.Placeid,
                placName = pl.Placename
            };
            placeStore.DataSource = place;
            placeStore.DataBind();
            cbbplace.SelectedItem.Value = data.Placeid.ToString();
            //------------------------
            try
            {
                TextArea1.Text = data.Remarks.Trim();
            }
            catch
            {
                TextArea1.Text = "";
            }
            cbbStatus.SelectedItem.Value = data.Status;
            cbbJctype.SelectedItem.Value = data.Jctype.ToString();
            cbbyh.Items.Clear();
            //修改多列显示
            var yh = from hd in dc.Getyhandhazusing
                     where hd.Yhid == data.Yhid && hd.Deptnumber == SessionBox.GetUserSession().DeptNumber
                     select new
            {
                yhNumber  = hd.Yhid,
                yhContent = hd.Yhcontent,
                Gzrwname  = hd.Levelname,
                Gxname    = hd.Typename
            };
            //var yh = from ha in dc.Hazards
            //         from ore in dc.HazardsOre
            //         where ha.HNumber == ore.HNumber && ore.Deptnumber == SessionBox.GetUserSession().DeptNumber && ore.HBjw == "引用" //&& ore.YhSwBjw == "隐患"
            //         && ha.HNumber==data.Yhnumber
            //         select new
            //         {
            //             yhNumber = ha.HNumber,
            //             yhContent = ore.HBm
            //         };
            yhStore.DataSource = yh;
            yhStore.DataBind();
            cbbyh.SelectedItem.Value = data.Yhid.ToString();
            Hidden1.Value            = sm.SelectedRow.RecordID.Trim();
            btnEdit.Disabled         = false;
            btnDelete.Disabled       = false;

            SelectLoad();
        }
    }