Example #1
0
        public ActionResult LsTaskHistoryDetail(string wfe_id)
        {
            EquipArchiManagment Em = new EquipArchiManagment();
            UI_MISSION          mi = new UI_MISSION();

            List <UI_MISSION> t = CWFEngine.GetHistoryMissions(int.Parse(wfe_id));

            mi = (UI_MISSION)t.ElementAt(1);
            Dictionary <string, object> mi_params = mi.Miss_Params;
            string cj_name      = mi.Miss_Params["Cj_Name"].ToString();
            string tempjob_name = mi.Miss_Params["Job_Name"].ToString();


            ViewBag.wfe_id = wfe_id;
            A6dot2dot2InfoModal infoModal = new A6dot2dot2InfoModal();

            infoModal.tempjob_name = tempjob_name;
            infoModal.cj_name      = cj_name;
            infoModal.wfe_id       = wfe_id;
            EquipManagment EM = new EquipManagment();

            infoModal.All_Zz = EM.getZzs_ofCj(Convert.ToInt32(cj_name));

            return(View(infoModal));
        }
Example #2
0
        //获得点击修改的设备的具体信息
        public JsonResult List_Equipinfo(string json1)
        {
            JObject item = (JObject)JsonConvert.DeserializeObject(json1);
            //取得设备编号
            string              e_code = item["equip_code"].ToString();
            EquipManagment      EM     = new EquipManagment();
            int                 EA_id  = EM.getEA_id_byCode(e_code);
            EquipArchiManagment EAM    = new EquipArchiManagment();

            Equip_Info mod_equip = new Equip_Info();

            mod_equip = EM.getEquip_Info(e_code);

            object mod = new
            {
                e_abc    = mod_equip.Equip_ABCmark,
                e_code   = mod_equip.Equip_Code,
                e_gycode = mod_equip.Equip_GyCode,
                e_man    = mod_equip.Equip_Manufacturer,
                e_phaseB = mod_equip.Equip_PhaseB,
                e_sp     = mod_equip.Equip_Specialty,
                e_type   = mod_equip.Equip_Type,
                e_Achi   = EAM.getEa_namebyId(EA_id)
            };

            return(Json(mod));
        }
        public List <EquipListModel> Zz_Equips(string Zz_name)
        {
            EquipManagment pm = new EquipManagment();

            EquipArchiManagment em = new EquipArchiManagment();



            List <Equip_Info>     Equips_of_Zz = new List <Equip_Info>();
            List <EquipListModel> Equip_obj    = new List <EquipListModel>();


            Equips_of_Zz = pm.getEquips_OfZz(em.getEa_idbyname(Zz_name.ToString()));
            foreach (var item in Equips_of_Zz)
            {
                EquipListModel io = new EquipListModel();
                io.Equip_Id        = item.Equip_Id;
                io.Equip_GyCode    = item.Equip_GyCode;
                io.Equip_Code      = item.Equip_Code;
                io.Equip_Type      = item.Equip_Type;
                io.Equip_Specialty = item.Equip_Specialty;
                io.Equip_ABCMark   = item.Equip_ABCmark;
                Equip_obj.Add(io);
            }

            return(Equip_obj);
        }
 public string submitsignal(string json1)
 {
     try
     {
         JObject item     = (JObject)JsonConvert.DeserializeObject(json1);
         string  flowname = item["Flow_Name"].ToString();
         Dictionary <string, string> signal = new Dictionary <string, string>();
         signal["SubmitJxPlan_Done"] = "true";
         signal["Cj_Name"]           = item["Cj_Name"].ToString();
         signal["Zz_Name"]           = item["Zz_Name"].ToString();
         signal["Equip_GyCode"]      = item["Equip_GyCode"].ToString();
         signal["Equip_Code"]        = item["Equip_Code"].ToString();
         signal["Equip_Type"]        = item["Equip_Type"].ToString();
         signal["Zy_Type"]           = item["Zy_Type"].ToString();
         signal["Zy_SubType"]        = item["Zy_SubType"].ToString();
         EquipManagment em = new EquipManagment();
         signal["Equip_ABCMark"] = em.getEquip_Info(item["Equip_Code"].ToString()).Equip_ABCmark;
         signal["Plan_Name"]     = item["Plan_Name"].ToString();
         signal["JxCauseDesc"]   = item["JxCauseDesc"].ToString();
         signal["Data_Src"]      = "月度计划DRBPM";
         Dictionary <string, string> record = new Dictionary <string, string>();
         record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
         record["time"]     = DateTime.Now.ToString();
         CWFEngine.SubmitSignal(Convert.ToInt32(flowname), signal, record);
     }
     catch (Exception e)
     {
         return("");
     }
     return("/A14dot3/Index");
 }
Example #5
0
        public string A6guicheng()
        {
            List <EQ>       list = new List <EQ>();     //接收结果
            List <object>   r    = new List <object>(); //输出结果
            A6dot2Managment tm   = new A6dot2Managment();

            list = tm.caozuoguicheng();
            for (int i = 0; i < list.Count; i++)
            {
                EquipManagment zm = new EquipManagment();
                //string zzname
                object o = new
                {
                    index     = i + 1,
                    sbGyCode  = list[i].sbGyCode,
                    sbCode    = list[i].sbCode,
                    sbType    = list[i].sbType,
                    GCnewname = Path.Combine("/Upload/A3dot3", list[i].GCnewname) + "$$" + list[i].GColdname
                };
                r.Add(o);
            }



            string str = JsonConvert.SerializeObject(r);

            return("{" + "\"data\": " + str + "}");
        }
Example #6
0
 //修改设备
 public string modifyEquip(string json1)
 {
     try
     {
         EquipManagment EM        = new EquipManagment();
         Equip_Info     new_equip = new Equip_Info();
         string         Ea_name;
         JObject        item = (JObject)JsonConvert.DeserializeObject(json1);
         Ea_name = item["Equip_Archi"].ToString();
         EquipArchiManagment EAM = new EquipArchiManagment();
         int Zz_Id = EAM.getEa_idbyname(Ea_name);
         new_equip.Equip_ABCmark      = item["EquipABCMark"].ToString();
         new_equip.Equip_GyCode       = item["EquipName"].ToString();
         new_equip.Equip_Code         = item["EquipCode"].ToString();
         new_equip.Equip_Type         = item["EquipType"].ToString();
         new_equip.Equip_Specialty    = item["EquipSpecialty"].ToString();
         new_equip.Equip_PhaseB       = item["EquipPhaseB"].ToString();
         new_equip.Equip_Manufacturer = item["EquipManufacturer"].ToString();
         if (EM.modifyEquip(new_equip, Zz_Id))
         {
             return("保存成功!");
         }
         else
         {
             return("保存失败!");
         }
     }
     catch { return(""); };
 }
Example #7
0
 public string JxSubmit_submitsignal(string json1)
 {
     try
     {
         JObject item     = (JObject)JsonConvert.DeserializeObject(json1);
         string  flowname = item["Flow_Name"].ToString();
         //paras
         Dictionary <string, string> signal = new Dictionary <string, string>();
         signal["JxSubmit_done"] = "true";
         signal["Cj_Name"]       = item["Cj_Name"].ToString();
         signal["Zz_Name"]       = item["Zz_Name"].ToString();
         signal["Equip_GyCode"]  = item["Equip_GyCode"].ToString();
         signal["Equip_Code"]    = item["Equip_Code"].ToString();
         signal["Equip_Type"]    = item["Equip_Type"].ToString();
         signal["Jx_Reason"]     = item["Jx_Reason"].ToString();
         //signal["Data_Src"] = item["Data_Src"].ToString();
         signal["Zy_Type"]    = item["Zy_Type"].ToString();
         signal["Zy_SubType"] = item["Zy_SubType"].ToString();
         EquipManagment em = new EquipManagment();
         signal["Equip_ABCMark"] = em.getEquip_Info(item["Equip_Code"].ToString()).Equip_ABCmark;
         signal["Job_Name"]      = "";
         signal["Job_Order"]     = "";
         //record
         Dictionary <string, string> record = new Dictionary <string, string>();
         record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
         record["time"]     = DateTime.Now.ToString();
         //submit
         CWFEngine.SubmitSignal(Convert.ToInt32(flowname), signal, record);
     }
     catch (Exception e)
     {
         return("");
     }
     return("/A8dot2/Index");
 }
Example #8
0
        public string click_submitsignal(string wfe_id)
        {
            try
            {
                Dictionary <string, string> signal = new Dictionary <string, string>();
                //补充跳转A8dot2的变量,Cj_Name,Zy_Type,Zy_SubType
                Dictionary <string, object> paras1 = new Dictionary <string, object>();
                paras1["Zz_Name"]      = null;
                paras1["Equip_GyCode"] = null;
                paras1["Equip_Code"]   = null;
                paras1["Plan_Name"]    = null;
                paras1["JobOrder"]     = null;
                UI_WFEntity_Info wfei = CWFEngine.GetWorkFlowEntityWithParams(Convert.ToInt32(wfe_id), paras1);
                //获取设备专业类别和子类别及设备所属车间
                EquipManagment    tm  = new EquipManagment();
                ERPInfoManagement erp = new ERPInfoManagement();
                GD_InfoModal      res = erp.getGD_Modal_GDId(paras1["JobOrder"].ToString());
                if (res != null)
                {
                    //if (String.Compare(res.GD_EquipCode.Trim(), paras1["Equip_Code"].ToString().Trim()) != 0)
                    if (!res.GD_EquipCode.Contains(paras1["Equip_Code"].ToString()))
                    {
                        return("工单号与设备不匹配");
                    }
                }
                else
                {
                    return("系统中无此工单");
                }


                Equip_Info getZy = tm.getEquip_ByGyCode(paras1["Equip_GyCode"].ToString());
                signal["Zy_Type"]    = getZy.Equip_Specialty;
                signal["Zy_SubType"] = getZy.Equip_PhaseB;
                signal["Equip_Type"] = getZy.Equip_Type;
                //EA_Name_EA_Id= tm.getEquip(paras1["Zz_Name"].ToString()).EA_Parent.EA_Id;
                signal["Cj_Name"]   = tm.getEquip(paras1["Zz_Name"].ToString());
                signal["Plan_Name"] = paras1["Plan_Name"].ToString();
                signal["JxdwAttachPlanOrder_Done"] = "true";
                signal["Data_Src"] = "计划管理";
                //record
                Dictionary <string, string> record1 = new Dictionary <string, string>();
                record1["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                record1["time"]     = DateTime.Now.ToString();
                //submit
                CWFEngine.SubmitSignal(Convert.ToInt32(wfe_id), signal, record1);
                return("/A14dot3/Index");
            }
            catch (Exception e)
            {
                return("");
            }

            //return ("/A13dot2/Index");
        }
Example #9
0
        //DRBPM平台低能效机泵-筛选-自动提报-2016.07.25
        public string Auto_ZzSubmit_submitsignal(string json1)
        {
            try
            {
                JObject item       = (JObject)JsonConvert.DeserializeObject(json1);
                string  Equip_Code = item["Equip_Code"].ToString();
                //string Problem_Desc = item["gyState_PMGList"].ToString();
                string             flowname = "A7dot2";
                UI_WorkFlow_Entity wfe      = CWFEngine.CreateAWFEntityByName(flowname);
                if (wfe != null)
                {
                    EquipManagment              em             = new EquipManagment();
                    Equip_Info                  eqinfo         = em.getEquip_Info(Equip_Code);
                    List <Equip_Archi>          Equip_ZzBelong = em.getEquip_ZzBelong(eqinfo.Equip_Id);
                    Dictionary <string, string> record         = wfe.GetRecordItems();
                    record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    record["time"]     = DateTime.Now.ToString();
                    wfe.Start(record);
                    int flow_id = wfe.EntityID;

                    Dictionary <string, string> signal1 = new Dictionary <string, string>();
                    signal1["start_done"] = "true";
                    CWFEngine.SubmitSignal(flow_id, signal1, record);

                    //paras
                    Dictionary <string, string> signal = new Dictionary <string, string>();
                    signal["ZzSubmit_done"] = "true";
                    signal["Cj_Name"]       = Equip_ZzBelong[1].EA_Name; //Cj_Name
                    signal["Zz_Name"]       = Equip_ZzBelong[0].EA_Name; //Zz_Name
                    signal["Equip_GyCode"]  = eqinfo.Equip_GyCode;
                    signal["Equip_Code"]    = eqinfo.Equip_Code;
                    signal["Equip_Type"]    = eqinfo.Equip_Type;
                    signal["Zy_Type"]       = eqinfo.Equip_Specialty;
                    signal["Zy_SubType"]    = eqinfo.Equip_PhaseB;
                    signal["Equip_ABCMark"] = eqinfo.Equip_ABCmark;
                    signal["Data_Src"]      = "DRBPM平台低能效机泵";
                    signal["Problem_Desc"]  = GetGyStateDescription(item["gyState_PMGList"].ToString(), true);

                    //record
                    record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    record["time"]     = DateTime.Now.ToString();
                    //submit
                    CWFEngine.SubmitSignal(flow_id, signal, record);
                    return("/A7dot2/Index");
                }
            }
            catch (Exception e)
            {
                return("");
            }
            return("/A7dot2/Index");
        }
Example #10
0
        public string click_submitsignal(string json1)
        {
            try
            {
                JObject            item       = (JObject)JsonConvert.DeserializeObject(json1);
                string             Equip_Code = item["Equip_Code"].ToString();
                string             Jx_Reason  = item["Jx_Reason"].ToString();
                string             flowname   = "A8dot2";
                UI_WorkFlow_Entity wfe        = CWFEngine.CreateAWFEntityByName(flowname);
                if (wfe != null)
                {
                    EquipManagment              em             = new EquipManagment();
                    Equip_Info                  eqinfo         = em.getEquip_Info(Equip_Code);
                    List <Equip_Archi>          Equip_ZzBelong = em.getEquip_ZzBelong(eqinfo.Equip_Id);
                    Dictionary <string, string> record         = wfe.GetRecordItems();
                    record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    record["time"]     = DateTime.Now.ToString();
                    wfe.Start(record);
                    int flow_id = wfe.EntityID;
                    //paras
                    Dictionary <string, string> signal = new Dictionary <string, string>();
                    signal["JxSubmit_done"] = "true";
                    signal["Cj_Name"]       = Equip_ZzBelong[1].EA_Name; //Cj_Name
                    signal["Zz_Name"]       = Equip_ZzBelong[0].EA_Name; //Zz_Name
                    signal["Equip_GyCode"]  = eqinfo.Equip_GyCode;
                    signal["Equip_Code"]    = eqinfo.Equip_Code;
                    signal["Equip_Type"]    = eqinfo.Equip_Type;
                    signal["Zy_Type"]       = eqinfo.Equip_Specialty;
                    signal["Zy_SubType"]    = eqinfo.Equip_PhaseB;
                    signal["Equip_ABCMark"] = eqinfo.Equip_ABCmark;
                    signal["Jx_Reason"]     = Jx_Reason;//计划检修原因 PM?
                    signal["Data_Src"]      = "A14dot1";
                    //record
                    record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    record["time"]     = DateTime.Now.ToString();
                    //submit
                    CWFEngine.SubmitSignal(flow_id, signal, record);
                    return("/A8dot2/Index");
                }
                else
                {
                    return("/A14dot1/Index");
                }
            }
            catch (Exception e)
            {
                return("");
            }

            //return ("/A14dot1/Index");
        }
Example #11
0
        //功能:根据查询信息查询设备
        //参数:设备工艺编号,设备位置,设备专业分类
        //返回:数据拼接string
        public string Query_Equip(string equip_gycode, int equiparchi_id, string equip_specialty)//string json1)//,)
        {
            List <object>     r = new List <object>();
            List <Equip_Info> e = new List <Equip_Info>();

            if (equip_gycode != "" || equiparchi_id != 0 || equip_specialty != "")
            {
                EquipManagment EM = new EquipManagment();
                e = EM.getAllEquips_byinfo(equip_gycode, equiparchi_id, equip_specialty);

                for (var i = 0; i < e.Count; i++)
                {
                    //数据库中可能为空这些数据做些处理在赋值给o
                    string ecode;
                    string manuf;
                    if (e[i].Equip_Code == null)
                    {
                        ecode = "无";
                    }
                    else
                    {
                        ecode = e[i].Equip_Code;
                    }
                    if (e[i].Equip_Manufacturer == null)
                    {
                        manuf = "无";
                    }
                    else
                    {
                        manuf = e[i].Equip_Manufacturer;
                    }
                    //返回前台显示的数据
                    object o = new
                    {
                        index              = i + 1,
                        equip_gycode       = e[i].Equip_GyCode.ToString(),
                        equip_code         = ecode,
                        equip_specialty    = e[i].Equip_Specialty.ToString(),
                        equip_phaseB       = e[i].Equip_PhaseB.ToString(),
                        equip_manufacturer = manuf
                    };
                    r.Add(o);
                }
            }
            string str = JsonConvert.SerializeObject(r);

            return("{" + "\"data\": " + str + "}");
        }
Example #12
0
        public JsonResult List_Equips(string Zz_Id)
        {
            EquipManagment    EM    = new EquipManagment();
            List <Equip_Info> e_obj = EM.getEquips_OfZz(Convert.ToInt32(Zz_Id));
            List <object>     r     = new List <object>();

            foreach (Equip_Info item in e_obj)
            {
                object o = new
                {
                    Equip_Id     = item.Equip_Id,
                    Equip_GyCode = item.Equip_GyCode,
                };
                r.Add(o);
            }

            return(Json(r.ToArray()));
        }
Example #13
0
        public string ZzSubmit_submitsignal(string json1)
        {
            try
            {
                JObject item     = (JObject)JsonConvert.DeserializeObject(json1);
                string  flowname = item["Flow_Name"].ToString();
                //paras
                Dictionary <string, string> signal = new Dictionary <string, string>();
                signal["ZzSubmit_done"] = "true";
                signal["Cj_Name"]       = item["Cj_Name"].ToString();
                signal["Zz_Name"]       = item["Zz_Name"].ToString();
                signal["Equip_GyCode"]  = item["Equip_GyCode"].ToString();
                signal["Equip_Code"]    = item["Equip_Code"].ToString();
                signal["Equip_Type"]    = item["Equip_Type"].ToString();
                EquipManagment em     = new EquipManagment();
                Equip_Info     eqinfo = em.getEquip_Info(item["Equip_Code"].ToString());
                signal["Equip_ABCMark"] = eqinfo.Equip_ABCmark;
                signal["Zy_Type"]       = eqinfo.Equip_Type;
                signal["Zy_SubType"]    = eqinfo.Equip_PhaseB;
                signal["Data_Src"]      = "特护记录";
                signal["Th_CheckTime"]  = DateTime.Now.ToString();
                signal["Th_CheckMen"]   = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                signal["Group_State"]   = item["Group_State"].ToString();
                //string Thjl_data = item["Thjl_data"].ToString();
                //string Problem_data = item["Problem_data"].ToString();
                //string workdetail = item["workdetail"].ToString();

                signal["Th_ItemRecord"]     = item["Thjl_data"].ToString();
                signal["Th_WorkDetail"]     = item["workdetail"].ToString();
                signal["Th_ProblemRecords"] = item["Problem_data"].ToString();
                //record
                Dictionary <string, string> record = new Dictionary <string, string>();
                record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                record["time"]     = DateTime.Now.ToString("yyyyMMddhhmmss");
                //submit
                //由于DongZyConfirm_done 等变量未与该Event关联, 所以submitSignal不会将确认信息提交到工作流
                CWFEngine.SubmitSignal(Convert.ToInt32(flowname), signal, record);
            }
            catch (Exception e)
            {
                return("");
            }
            return("/A7dot1dot1/Index");
        }
Example #14
0
        public JsonResult A7Zz_Equips(int Zz_id)
        {
            EquipManagment    pm           = new EquipManagment();
            List <Equip_Info> Equips_of_Zz = pm.getThEquips_OfZz(Zz_id);
            List <object>     Equip_obj    = new List <object>();

            foreach (var item in Equips_of_Zz)
            {
                object o = new
                {
                    Equip_Id     = item.Equip_Id,
                    Equip_GyCode = item.Equip_GyCode,
                    // Equip_Code=item.Equip_Code,
                    //  Equip_Type=item.Equip_Type,
                    // Equip_Specialty=item.Equip_Specialty
                };
                Equip_obj.Add(o);
            }
            return(Json(Equip_obj.ToArray()));
        }
Example #15
0
 //删除设备
 public string delete_equip(string json1)
 {
     try
     {
         JObject        item     = (JObject)JsonConvert.DeserializeObject(json1);
         EquipManagment EM       = new EquipManagment();
         string         equip_id = item["equip_id"].ToString();
         int            E_id     = EM.getE_id_byGybh(equip_id);
         bool           del      = EM.deleteEquip(E_id);
         if (del)
         {
             return("删除成功!");
         }
         else
         {
             return("删除失败!");
         }
     }
     catch { return("error"); }
 }
        public string CreateA12dot2_submitsignal(string json1)
        {
            try
            {
                JObject        item    = (JObject)JsonConvert.DeserializeObject(json1);
                EquipManagment tm      = new EquipManagment();
                string         temp    = item["sample"].ToString();
                JArray         jsonVal = JArray.Parse(temp) as JArray;
                dynamic        table2  = jsonVal;
                foreach (dynamic T in table2)
                {
                    UI_WorkFlow_Entity          wfe    = CWFEngine.CreateAWFEntityByName("A12dot2");
                    Dictionary <string, string> record = wfe.GetRecordItems();
                    record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    record["time"]     = DateTime.Now.ToString();

                    string returl = wfe.Start(record);
                    Dictionary <string, string> signal = new Dictionary <string, string>();
                    string Equip_Code           = T.Equip_Code;
                    int    Equip_location_EA_Id = tm.getEA_id_byCode(Equip_Code);
                    signal["currentuser"]   = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    signal["start_done"]    = "true";
                    signal["Zz_Name"]       = tm.getZzName(Equip_location_EA_Id);
                    signal["Equip_GyCode"]  = T.Equip_GyCode;
                    signal["Equip_Code"]    = T.Equip_Code;
                    signal["Equip_ABCMark"] = T.Equip_ABCMark;

                    //record
                    Dictionary <string, string> record1 = new Dictionary <string, string>();
                    record1["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    record1["time"]     = DateTime.Now.ToString();
                    //submit
                    CWFEngine.SubmitSignal(Convert.ToInt32(wfe.EntityID), signal, record1);
                }
            }
            catch (Exception e)
            {
                return("");
            }
            return("/A12dot2/Index");
        }
Example #17
0
 //添加新设备
 public string submitNewEquip(string json1)
 {
     try
     {
         EquipManagment EM        = new EquipManagment();
         Equip_Info     new_equip = new Equip_Info();
         int            Zz_Id;
         JObject        item = (JObject)JsonConvert.DeserializeObject(json1);
         Zz_Id = Convert.ToInt16(item["Equip_Archi_Id"]);
         new_equip.Equip_ABCmark      = item["EquipABCMark"].ToString();
         new_equip.Equip_GyCode       = item["EquipName"].ToString();
         new_equip.Equip_Code         = item["EquipCode"].ToString();
         new_equip.Equip_Type         = item["EquipType"].ToString();
         new_equip.Equip_Specialty    = item["EquipSpecialty"].ToString();
         new_equip.Equip_PhaseB       = item["EquipPhaseB"].ToString();
         new_equip.Equip_Manufacturer = item["EquipManufacturer"].ToString();
         EM.addEquip(new_equip, Zz_Id);
         return("保存成功!");
     }
     catch { return(""); };
 }
Example #18
0
        public string ZzSubmit_submitsignal(string json1)
        {
            try
            {
                JObject item     = (JObject)JsonConvert.DeserializeObject(json1);
                string  flowname = item["Flow_Name"].ToString();
                //paras
                Dictionary <string, string> signal = new Dictionary <string, string>();
                signal["ZzSubmit_done"] = "true";
                signal["Cj_Name"]       = item["Cj_Name"].ToString();
                signal["Zz_Name"]       = item["Zz_Name"].ToString();
                signal["Equip_GyCode"]  = item["Equip_GyCode"].ToString();
                signal["Equip_Code"]    = item["Equip_Code"].ToString();
                signal["Equip_Type"]    = item["Equip_Type"].ToString();
                //signal["Data_Src"] = "";
                signal["Plan_Desc"] = item["Plan_Desc"].ToString();
                //string  filename = Path.Combine(Request.MapPath("~/Upload"),item["Plan_DescFilePath"].ToString());
                signal["Plan_DescFilePath"] = item["Plan_DescFilePath"].ToString();
                signal["Zy_Type"]           = item["Zy_Type"].ToString();
                signal["Zy_SubType"]        = item["Zy_SubType"].ToString();
                EquipManagment em = new EquipManagment();
                signal["Equip_ABCMark"] = em.getEquip_Info(item["Equip_Code"].ToString()).Equip_ABCmark;
                //signal["Equip_ABCMark"] = "A";//for test

                //record
                Dictionary <string, string> record = new Dictionary <string, string>();
                record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                record["time"]     = DateTime.Now.ToString();
                //submit
                CWFEngine.SubmitSignal(Convert.ToInt32(flowname), signal, record);
            }
            catch (Exception e)
            {
                return("");
            }
            return("/A7dot3/Index");
        }
Example #19
0
        public List <EquipListModel> Zz_Equips(string Zz_id)
        {
            EquipManagment        pm           = new EquipManagment();
            List <Equip_Info>     Equips_of_Zz = new List <Equip_Info>();
            List <EquipListModel> Equip_obj    = new List <EquipListModel>();

            string[] Zhuangzhi_id = Zz_id.Split(',');
            for (int i = 0; i < Zhuangzhi_id.Length; i++)
            {
                Equips_of_Zz = pm.getEquips_OfZz(Convert.ToInt32(Zhuangzhi_id[i]));
                foreach (var item in Equips_of_Zz)
                {
                    EquipListModel io = new EquipListModel();
                    io.Equip_Id        = item.Equip_Id;
                    io.Equip_GyCode    = item.Equip_GyCode;
                    io.Equip_Code      = item.Equip_Code;
                    io.Equip_Type      = item.Equip_Type;
                    io.Equip_Specialty = item.Equip_Specialty;
                    io.Equip_ABCMark   = item.Equip_ABCmark;
                    Equip_obj.Add(io);
                }
            }
            return(Equip_obj);
        }
Example #20
0
        public ActionResult Submit(string wfe_id)
        {
            EquipManagment EM = new EquipManagment();

            UI_MISSION mi = CWFEngine.GetActiveMission <Person_Info>(int.Parse(wfe_id), ((IObjectContextAdapter)(new EquipWebContext())).ObjectContext);
            Dictionary <string, object> mi_params = mi.Miss_Params;
            string                 cj_name        = mi.Miss_Params["Cj_Name"].ToString();
            string                 tempjob_name   = mi.Miss_Params["Job_Name"].ToString();
            A6dot2Managment        AM             = new A6dot2Managment();
            int                    i     = 1;
            List <A6dot2LsTaskTab> rList = AM.getLsTask(wfe_id);

            //string cj_name = "2";
            //string tempjob_name = "test";
            ViewBag.wfe_id = wfe_id;
            A6dot2dot2InfoModal infoModal = new A6dot2dot2InfoModal();

            infoModal.tempjob_name = tempjob_name;
            infoModal.cj_name      = cj_name;
            infoModal.wfe_id       = wfe_id;
            infoModal.All_Zz       = EM.getZzs_ofCj(Convert.ToInt32(cj_name));

            return(View(infoModal));
        }
Example #21
0
        private DtResponse ProcessRequest(List <KeyValuePair <string, string> > data)
        {
            DtResponse dt     = new DtResponse();
            var        http   = DtRequest.HttpData(data);
            var        Data   = http["data"] as Dictionary <string, object>;
            int        wfe_id = -1;

            foreach (var d in Data)
            {
                wfe_id = Convert.ToInt32(d.Key);
            }
            string jx_reason    = "";
            string E_code       = "";
            string job_order    = "";
            string notice_order = "";

            foreach (var d in Data)
            {
                int id = Convert.ToInt32(d.Key);
                foreach (var dd in d.Value as Dictionary <string, object> )
                {
                    ERPInfoManagement erp = new ERPInfoManagement();

                    //sb_code、jxreason与设备绑定在一起传过来,当通知单号工单号填完后满足向A8.2跳转条件
                    if (dd.Key == "sb_code")
                    {
                        E_code = dd.Value.ToString();
                    }
                    if (dd.Key == "jxreason")
                    {
                        jx_reason = dd.Value.ToString();
                    }
                    if (dd.Key == "notice_order2")
                    {
                        if (dd.Value.ToString() == "")
                        {
                            continue;
                        }
                        notice_order = "00" + dd.Value.ToString();
                        GD_InfoModal res = erp.getGD_Modal_Notice(notice_order);
                        if (res != null)
                        {
                            job_order = res.GD_Id;
                        }
                    }
                    if (dd.Key == "job_order2")
                    {
                        if (dd.Value.ToString() == "")
                        {
                            continue;
                        }
                        job_order = "00" + dd.Value.ToString();
                        GD_InfoModal res = erp.getGD_Modal_GDId(job_order);
                        if (res != null)
                        {
                            notice_order = res.GD_Notice_Id;
                        }
                    }
                    //if (dd.Key == "JumpA8dot2DR")
                    //{
                    //    string Equip_Code = E_code;
                    //    string Jx_Reason = jx_reason;
                    //    string flowname = "A8dot2";
                    //    UI_WorkFlow_Entity wfe = CWFEngine.CreateAWFEntityByName(flowname);
                    //    if (wfe != null)
                    //    {
                    //        EquipManagment em = new EquipManagment();
                    //        Equip_Info eqinfo = em.getEquip_Info(Equip_Code);
                    //        List<Equip_Archi> Equip_ZzBelong = em.getEquip_ZzBelong(eqinfo.Equip_Id);
                    //        Dictionary<string, string> record = wfe.GetRecordItems();
                    //        record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    //        record["time"] = DateTime.Now.ToString();
                    //        wfe.Start(record);
                    //        int flow_id = wfe.EntityID;
                    //        //paras
                    //        Dictionary<string, string> signal = new Dictionary<string, string>();
                    //        signal["JxSubmit_done"] = "true";
                    //        signal["Cj_Name"] = Equip_ZzBelong[1].EA_Name; //Cj_Name
                    //        signal["Zz_Name"] = Equip_ZzBelong[0].EA_Name; //Zz_Name
                    //        signal["Equip_GyCode"] = eqinfo.Equip_GyCode;
                    //        signal["Equip_Code"] = eqinfo.Equip_Code;
                    //        signal["Equip_Type"] = eqinfo.Equip_Type;
                    //        signal["Zy_Type"] = eqinfo.Equip_Specialty;
                    //        signal["Zy_SubType"] = eqinfo.Equip_PhaseB;
                    //        signal["Equip_ABCMark"] = eqinfo.Equip_ABCmark;
                    //        signal["Jx_Reason"] = Jx_Reason;//计划检修原因 PM?
                    //        signal["Job_Name"] = "来自DRBPM";
                    //        signal["Job_Order"] = job_order;
                    //        //record
                    //        record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    //        record["time"] = DateTime.Now.ToString();
                    //        //submit
                    //        CWFEngine.SubmitSignal(flow_id, signal, record);

                    //    }
                    //}
                }
            }


            Dictionary <string, object> m_kv   = new Dictionary <string, object>();
            EquipManagment     em1             = new EquipManagment();
            Equip_Info         eqinfo1         = em1.getEquip_Info(E_code);
            List <Equip_Archi> Equip_ZzBelong1 = em1.getEquip_ZzBelong(eqinfo1.Equip_Id);


            int             UserId = (Session["User"] as EquipModel.Entities.Person_Info).Person_Id;
            PersonManagment pm     = new PersonManagment();

            EquipBLL.AdminManagment.PersonManagment.P_viewModal pv = pm.Get_PersonModal(UserId);

            m_kv["index_Id"]      = wfe_id;
            m_kv["zz_name"]       = Equip_ZzBelong1[0].EA_Name; //Zz_Name
            m_kv["sb_gycode"]     = eqinfo1.Equip_GyCode;
            m_kv["sb_code"]       = E_code;
            m_kv["sb_type"]       = eqinfo1.Equip_Type;
            m_kv["sb_ABCMark"]    = eqinfo1.Equip_ABCmark;
            m_kv["plan_name"]     = "来自DRBPM";
            m_kv["jxreason"]      = jx_reason;
            m_kv["kkconfirm2"]    = "同意";
            m_kv["zytdconfirm2"]  = "同意";
            m_kv["job_order2"]    = job_order;
            m_kv["notice_order2"] = notice_order;
            m_kv["missionname"]   = "完善工单与通知单后跳转";
            m_kv["role"]          = pv.Role_Names;
            dt.data.Add(m_kv);


            return(dt);
        }
Example #22
0
        //zxh

        public string ListMission_zxh()
        {
            try
            {
                IObjectContextAdapter IOca = new EquipWebContext();

                List <UI_MISSION> miss = CWFEngine.GetActiveMissions <Person_Info>(IOca.ObjectContext);


                List <Object> miss_obj = new List <object>();
                string        userName = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name.ToString();
                foreach (UI_MISSION item in miss)
                {
                    MainMissionsModel mm = GetMainMissionsInfo(item.WE_Entity_Id);


                    Jobs   js      = new Jobs();
                    string endtime = "";
                    string lsh_xy  = "1";


                    if (js.GetDSnexttime(mm.jobname, item.WE_Entity_Id) != null)
                    {
                        if (js.GetDSnexttime(mm.jobname, item.WE_Entity_Id).PreTime == null)
                        {
                            string        end_corn = js.GetDSnexttime(mm.jobname, item.WE_Entity_Id).corn_express;
                            TriggerTiming TT       = new TriggerTiming();
                            TT.FromString(end_corn);
                            TT.RefreshNextTiming(DateTime.Now);
                            endtime = TT.NextTiming.ToString();
                        }
                        else
                        {
                            endtime = js.GetDSnexttime(mm.jobname, item.WE_Entity_Id).PreTime.ToString();
                        }
                    }


                    if (mm.Equip_GyCode == null || mm.Equip_GyCode == "")
                    {
                        lsh_xy = "0";
                    }
                    object o = new
                    {
                        WF_ICON    = "fa fa-flash text-text-aqua",
                        MISS_Url   = item.Mission_Url,
                        WF_Name    = mm.WF_Name,
                        MISS_Name  = item.WE_Event_Desc,
                        wfe_serial = mm.wfe_serial,
                        sbCode     = mm.Equip_GyCode,
                        time       = mm.time,
                        endtime    = endtime,
                        lsh_xy     = lsh_xy
                    };
                    EquipManagment em = new EquipManagment();
                    if (mm.WF_Name.Contains("定时KPI月报"))
                    {
                        if (userName == "龚海桥" && mm.WF_Name.Contains("联合一片区"))
                        {
                            miss_obj.Add(o);
                        }
                        else if (userName == "丁一刚" && mm.WF_Name.Contains("联合二片区"))
                        {
                            miss_obj.Add(o);
                        }
                        else if (userName == "邓杰" && (mm.WF_Name.Contains("联合三片区") || mm.WF_Name.Contains("化工片区")))
                        {
                            miss_obj.Add(o);
                        }
                        else if (userName == "杨书毅" && mm.WF_Name.Contains("联合四片区"))
                        {
                            miss_obj.Add(o);
                        }
                        else if (userName == "武文斌" && (mm.WF_Name.Contains("综合片区") || mm.WF_Name.Contains("系统片区")))
                        {
                            miss_obj.Add(o);
                        }
                    }
                    else
                    {
                        if (userName == "sa" || userName == "程聂")
                        {
                            miss_obj.Add(o);
                        }
                        else
                        {
                            if (lsh_xy == "1")
                            {
                                if (em.getEquip_ByGyCode(mm.Equip_GyCode).Equip_Specialty == "动")
                                {
                                    miss_obj.Add(o);
                                }
                            }
                            else
                            {
                                miss_obj.Add(o);
                            }
                        }
                    }
                }

                TablesManagment tm     = new TablesManagment();
                int             UserId = (Session["User"] as EquipModel.Entities.Person_Info).Person_Id;
                PersonManagment pm     = new PersonManagment();
                EquipBLL.AdminManagment.PersonManagment.P_viewModal pv = pm.Get_PersonModal(UserId);
                if (pv.Role_Names.Contains("可靠性工程师"))
                {
                    string             wfe_ser = "";
                    List <string>      cjname  = new List <string>();
                    List <Equip_Archi> EA      = pm.Get_Person_Cj(UserId);
                    foreach (var ea in EA)
                    {
                        cjname.Add(ea.EA_Name);
                    }
                    List <A5dot1Tab1> E = tm.Getdcl_listbyisZG(0, cjname);

                    for (int i = 0; i < E.Count; i++)
                    {
                        if (E[i].dataSource != null)
                        {
                            wfe_ser = E[i].dataSource;
                        }
                        object o = new
                        {
                            WF_ICON    = "fa fa-flash text-text-aqua",
                            MISS_Url   = "/A5dot1/Index",
                            WF_Name    = "设备完好",
                            MISS_Name  = "可靠性工程师确认整改",
                            wfe_serial = wfe_ser,
                            sbCode     = E[i].sbGyCode.ToString(),
                            time       = E[i].zzSubmitTime.ToString(),
                            endtime    = "",
                            lsh_xy     = 1
                        };
                        miss_obj.Add(o);
                    }
                    SxglManagment     Sx = new SxglManagment();
                    List <A5dot2Tab1> EE = Sx.GetSxItem(cjname);
                    foreach (var item in EE)
                    {
                        if (item.temp2 != null)
                        {
                            wfe_ser = item.temp2;
                        }
                        object o = new
                        {
                            WF_ICON    = "fa fa-flash text-text-aqua",
                            MISS_Url   = "/A5dot2/Index",
                            WF_Name    = "竖向问题",
                            MISS_Name  = "可靠性工程师确认整改",
                            wfe_serial = wfe_ser,
                            sbCode     = item.sbGyCode.ToString(),
                            time       = item.jxSubmitTime.ToString(),
                            endtime    = "",
                            lsh_xy     = 1
                        };
                        miss_obj.Add(o);
                    }
                }

                string str = JsonConvert.SerializeObject(miss_obj);
                return("{" + "\"data\": " + str + "}");
            }
            catch (Exception e)
            {
                return(null);
            }
        }
Example #23
0
        public string CreateA14dot3s_submitsignal(string json1)
        {
            try
            {
                JObject        item    = (JObject)JsonConvert.DeserializeObject(json1);
                EquipManagment tm      = new EquipManagment();
                string         temp    = item["sample"].ToString();
                JArray         jsonVal = JArray.Parse(temp) as JArray;
                dynamic        table2  = jsonVal;
                foreach (dynamic T in table2)
                {
                    //加载原工作流工作流
                    CWorkFlow       m_workFlow = new CWorkFlow();
                    WorkFlows       wfs        = new WorkFlows();
                    WorkFlow_Define wf_define  = wfs.GetWorkFlowDefine("A14dot3dot3");
                    m_workFlow = null;
                    if (wf_define != null)
                    {
                        XmlDocument doc = new XmlDocument();
                        doc.LoadXml(Encoding.Default.GetString(wf_define.W_Xml));
                        m_workFlow = new CWorkFlow();
                        m_workFlow.InstFromXmlNode((XmlNode)doc.DocumentElement);
                        m_workFlow.DefineID = wf_define.W_ID;
                    }

                    //加载超时属性数据
                    TimerCreateWFPa TCP = new TimerCreateWFPa();
                    TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                    time_set.Time_start  = "wf_create";
                    time_set.Exact_time  = "";
                    time_set.Offset_time = (DateTime.Now.AddDays(5) - DateTime.Now).ToString();
                    //time_set.Offset_time = (DateTime.Now.AddMinutes(3) - DateTime.Now).ToString();
                    time_set.Action    = "INVILID";
                    time_set.Call_back = "http://localhost/CallBack/testCallBack";
                    TCP.AppendTimer("PqAssess", time_set);

                    //创建写入timeout属性的工作流
                    CWorkFlow wf = new CWorkFlow();

                    wf.InstFromXmlNode(m_workFlow.WriteToXmlNode());

                    //修改定时器
                    foreach (var ti in TCP.wf_timer)
                    {
                        try
                        {
                            DateTime?dt = null;

                            if (ti.Value["ExactTime"] != "")
                            {
                                dt = DateTime.Parse(ti.Value["ExactTime"]);
                            }
                            wf.events[ti.Key].TimeOutProperty.SetAttribute("exact_time", dt);

                            TimeSpan?ts = null;
                            if (ti.Value["OffsetTime"] != "")
                            {
                                ts = TimeSpan.Parse(ti.Value["OffsetTime"]);
                            }
                            wf.events[ti.Key].TimeOutProperty.SetAttribute("offset_time", ts);

                            wf.events[ti.Key].TimeOutProperty.SetAttribute("time_start", ti.Value["TimeStart"]);

                            wf.events[ti.Key].TimeOutProperty.SetAttribute("action", ti.Value["Action"]);
                            wf.events[ti.Key].TimeOutProperty.SetAttribute("call_back", ti.Value["CallBack"]);
                        }
                        catch
                        {
                            continue;
                        }
                    }

                    //创建工作流
                    wf.CreateEntityBySelf();
                    //开启工作流
                    Dictionary <string, string> record = new Dictionary <string, string>();
                    record.Add("username", "system_temporary");
                    record.Add("time", DateTime.Now.ToString());
                    TCP.wf_record = record;
                    wf.Start((IDictionary <string, string>)(TCP.wf_record));


                    Dictionary <string, string> signal = new Dictionary <string, string>();
                    string Equip_Code           = T.Equip_Code;
                    int    Equip_location_EA_Id = tm.getEA_id_byCode(Equip_Code);

                    signal["Zz_Name"]           = tm.getZzName(Equip_location_EA_Id);
                    signal["Equip_GyCode"]      = T.Equip_GyCode;
                    signal["Equip_Code"]        = T.Equip_Code;
                    signal["Equip_ABCMark"]     = T.Equip_ABCMark;
                    signal["SubmitJxPlan_Done"] = "true";
                    //record
                    Dictionary <string, string> record1 = new Dictionary <string, string>();
                    record1["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                    record1["time"]     = DateTime.Now.ToString();
                    //submit
                    CWFEngine.SubmitSignal(Convert.ToInt32(wf.EntityID), signal, record1);
                }
            }
            catch (Exception e)
            {
                return("");
            }
            return("/A14dot3/Index");
        }
Example #24
0
          public ActionResult DSZzSubmit(string wfe_id)
          {
              submitmodel sm = new submitmodel();
              ViewBag.curtime = DateTime.Now;
              ViewBag.curuser = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
              int UserId = (Session["User"] as EquipModel.Entities.Person_Info).Person_Id;
              PersonManagment pm = new PersonManagment();
              EquipBLL.AdminManagment.PersonManagment.P_viewModal pv = pm.Get_PersonModal(UserId);
              if (pv.Role_Names.Contains("可靠性工程师"))
                  sm.kkxgcs = 1;
              if (pv.Role_Names.Contains("检维修人员"))
                  sm.jwxry = 1;
              ERPInfoManagement erp = new ERPInfoManagement();
              EquipArchiManagment em = new EquipArchiManagment();
              UI_MISSION mi = CWFEngine.GetActiveMission<Person_Info>(int.Parse(wfe_id), ((IObjectContextAdapter)(new EquipWebContext())).ObjectContext);
              Dictionary<string, object> mi_params = mi.Miss_Params;
              ViewBag.Pqname = mi.Miss_Params["Pqname"].ToString();
              string ea_code = em.getEa_codebyname(mi.Miss_Params["Pqname"].ToString());
              ViewBag.timesNonPlanStop=erp.getNoticesYx_1(mi.Miss_Params["Pqname"].ToString());
              ViewBag.scoreDeductFaultIntensity = (erp.getNoticesYx_1(mi.Miss_Params["Pqname"].ToString()) * 50) + (erp.getNoticeYx_2(mi.Miss_Params["Pqname"].ToString()) * 30) + (erp.getNoticeYx_3(mi.Miss_Params["Pqname"].ToString()) * 20) + (erp.getNoticeYx_4(mi.Miss_Params["Pqname"].ToString()) * 5);
              ViewBag.rateFaultMaintenance = erp.getFaultRation(mi.Miss_Params["Pqname"].ToString());
              ViewBag.MTBF = erp.getNonFaultInterVal(mi.Miss_Params["Pqname"].ToString());
              ViewBag.rateEquipUse = erp.DeliverRatio(mi.Miss_Params["Pqname"].ToString());
              ViewBag.rateBigUnitFault = erp.bigEquipsRatio(mi.Miss_Params["Pqname"].ToString());
              ViewBag.wfe_id = wfe_id;
              TablesManagment tm = new TablesManagment();
              EquipManagment Em = new EquipManagment();
              List<EANummodel> E = Em.getequipnum_byarchi();
              List<Equip_Archi> AllCj_List = Em.GetAllCj();

              List<WebApp.Controllers.A5dot1Controller.NameandNum> cj = new List<WebApp.Controllers.A5dot1Controller.NameandNum>();
              List<WebApp.Controllers.A5dot1Controller.NameandNum> pq = new List<WebApp.Controllers.A5dot1Controller.NameandNum>();




              for (int i = 0; i < AllCj_List.Count; i++)
              {
                  int count = 0;
                  WebApp.Controllers.A5dot1Controller.NameandNum temp1 = new WebApp.Controllers.A5dot1Controller.NameandNum();
                  temp1.name = AllCj_List[i].EA_Name;
                  for (int j = 0; j < E.Count; j++)
                  {
                      if (AllCj_List[i].EA_Id == Em.getEA_parentid(E[j].EA_Id))
                          count += E[j].Equip_Num;
                  }
                  temp1.Equip_Num = count;
                  cj.Add(temp1);
                  count = 0;
              }
            
              WebApp.Controllers.A5dot1Controller.NameandNum temp = new WebApp.Controllers.A5dot1Controller.NameandNum();
              temp.name = mi.Miss_Params["Pqname"].ToString();
              List<Pq_Zz_map> Pq_Zz_map = Em.GetZzsofPq(mi.Miss_Params["Pqname"].ToString());
              int count1 = 0;
              for (int j = 0; j < Pq_Zz_map.Count; j++)
              {
                 
                  for (int z = 0; z < E.Count; z++)
                  {
                      if (Pq_Zz_map[j].Zz_Name == Em.getEa_namebyid(E[z].EA_Id))
                          count1 += E[z].Equip_Num;
                  }
              }
              temp.Equip_Num = count1;
              pq.Add(temp);

              double pq_bwh = 0.00;
              for (int i = 0; i < pq.Count; i++)
              {
                  List<A5dot1Tab1> pq_list = tm.get_pq_bwh(pq[i].name, pq[i].Equip_Num);
                  double pq_bxhcount = 0;
                  int wzg_count = 0;
                  if (pq_list.Count > 0)
                  {
                      pq_bxhcount = 0;
                      wzg_count = 0;
                      string sbcode_temp = pq_list[0].sbCode;
                      for (int j = 0; j < pq_list.Count; j++)
                      {
                          pq_list = tm.get_cj_bwh(cj[i].name, cj[i].Equip_Num);
                          if (pq_list[j].temp1 == null)
                          {
                              List<A5dot1Tab1> cj_bycode = tm.GetAll1_bycode(pq_list[j].sbCode);
                              for (int k = 0; k < cj_bycode.Count; k++)
                              {
                                  if (cj_bycode[k].isRectified == 0)
                                  {
                                      wzg_count++;
                                  }
                                  tm.modifytemp1_byid(cj_bycode[k].Id, "已合并");

                              }
                              if (wzg_count > 0)
                              {
                                  pq_bxhcount++;
                              }
                              wzg_count = 0;
                          }

                          // cjbwh.Add(f);
                      }
                  }

                  for (int n = 0; n < pq_list.Count; n++)
                  {
                      tm.modifytemp1_byid(pq_list[n].Id, null);
                  }
                  pq_bwh=Math.Round(((double)pq_bxhcount / pq[i].Equip_Num), 6);
              }
              ViewBag.Pq_bwh = (1-pq_bwh)*100;
              return View(sm);
          }
Example #25
0
        /// <summary>
        /// 有以前的通过Excel表读取数据模式改为现在的直接读取ERP中数据,通过周期调用此函数,周期存库
        /// </summary>
        /// <param name="json1"></param>
        /// <returns></returns>
        public void ERPSubmit()
        {
            try
            {
                PersonManagment   PM       = new PersonManagment();
                A6dot2Managment   WM       = new A6dot2Managment();
                A6dot2Tab1        WDT_list = new A6dot2Tab1();
                ERPInfoManagement erp      = new ERPInfoManagement();
                EquipManagment    EM       = new EquipManagment();

                string EquipPhaseB;
                WDT_list.uploadDesc      = ""; //字段保留,(以前用于上传五定表的描述)
                WDT_list.uuploadFileName = ""; //字段保留,(以前用于上传五定表的名字)
                //string[] savedFileName = WDT_list.uuploadFileName.Split(new char[] { '$' });
                //string wdt_filename = Path.Combine(Request.MapPath("~/Upload"), savedFileName[1]);//没有用到的变量
                //WDT_list.userName = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
                WDT_list.userName   = "******";
                WDT_list.uploadtime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
                //WDT_list.pqName = PM.Get_Person_Depart((Session["User"] as EquipModel.Entities.Person_Info).Person_Id).Depart_Name;
                WDT_list.pqName = "待定";
                int WDT_ID = WM.add_WDT_list(WDT_list);

                List <OilInfo> OilInfo_Overdue = erp.getOilInfo_overdue();

                List <A6dot2Tab2> wdt_list = new List <A6dot2Tab2>();
                foreach (var i in OilInfo_Overdue)
                {
                    A6dot2Tab2 tmp = new A6dot2Tab2();
                    tmp.isValid            = 1;
                    tmp.equipCode          = i.oil_EquipCode;
                    tmp.equipDesc          = i.oil_EquipDesc;
                    tmp.funLoc             = i.oil_Fun_Loc;
                    tmp.funLoc_desc        = i.oil_Fun_LocDesc;
                    tmp.oilLoc             = i.oil_Loc;
                    tmp.oilLoc_desc        = i.oil_Loc;
                    tmp.oilInterval        = Convert.ToInt32(i.oil_Interval);
                    tmp.unit               = i.oil_Unit;
                    tmp.lastOilTime        = i.oil_LastDate;
                    tmp.lastOilNumber      = Convert.ToDouble(i.oil_LastNum);
                    tmp.lastOilUnit        = i.oil_Unit;
                    tmp.NextOilTime        = i.oil_NextDate.ToString();
                    tmp.NextOilNumber      = Convert.ToDouble(i.oil_NextNum);
                    tmp.NextOilUnit        = i.oil_Unit2;
                    tmp.oilCode            = i.oil_Code;
                    tmp.oilCode_desc       = i.oil_Desc;
                    tmp.substiOilCode      = "";
                    tmp.substiOilCode_desc = "";
                    if (EM.getEquip_Info(tmp.equipCode) != null)
                    {
                        EquipPhaseB = EM.getEquip_Info(tmp.equipCode).Equip_PhaseB;
                        if (EquipPhaseB == null)
                        {
                            tmp.isOilType = 0;
                        }
                        else
                        {
                            if (EquipPhaseB.Equals("机泵") || EquipPhaseB.Equals("风机"))
                            {
                                tmp.isOilType = 1;
                            }
                            else
                            {
                                tmp.isOilType = 0;
                            }
                        }
                        List <Equip_Archi> ZzCj = EM.getEquip_ZzBelong(EM.getEquip_Info(tmp.equipCode).Equip_Id);
                        tmp.equip_ZzName = ZzCj.First().EA_Name;
                        tmp.equip_CjName = ZzCj.Last().EA_Name;
                        tmp.equip_PqName = EM.GetPqofZz(tmp.equip_ZzName).Pq_Name;
                    }

                    tmp.isExceed = 1;
                    tmp.Tab1_Id  = WDT_ID;
                    wdt_list.Add(tmp);
                }
                WM.add_WDT_content(WDT_ID, wdt_list);

                /*  foreach(var i in wdt_content)
                 * {
                 *    return i.equip_CjName;
                 * }
                 * */

                // return "/A6dot2/Index_Tj";
            }
            catch { }
        }
Example #26
0
        public string DSJob_Submit(string json1)
        {
            JObject item         = (JObject)JsonConvert.DeserializeObject(json1);
            string  WorkFlowName = item["Work_Name"].ToString();
            // WorkFlows ws = new WorkFlows();
            int  workflow_id           = wfs.GetWorkFlowDefine(WorkFlowName).W_ID;
            Jobs job                   = new Jobs();
            List <Timer_Jobs> job_list = job.GetDSbyWorkflow(workflow_id);

            if (job_list.Count == 0)
            {
                string         cj_ids = item["Cj_Name"].ToString();
                string         Zz_ids = item["Zz_Name"].ToString();
                string[]       cjids  = cj_ids.Split(new char[] { ',' });
                string[]       zzids  = Zz_ids.Split(new char[] { ',' });
                CTimerCreateWF m      = new CTimerCreateWF();
                //这里需要创建一个回调函数
                string DingShiJobName = item["Job_Name"].ToString();

                //使用lambda表达式过滤掉空字符串
                zzids = zzids.Where(s => !string.IsNullOrEmpty(s)).ToArray();
                //未写
                if (WorkFlowName == "A6dot2")
                {
                    for (int i = 0; i < cjids.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Cj_Name", Em.getEa_namebyId(Convert.ToInt16(cjids[i])));
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(5) - DateTime.Now).ToString();
                        //time_set.Offset_time = (DateTime.Now.AddMinutes(3) - DateTime.Now).ToString();
                        time_set.Action    = "INVILID";
                        time_set.Call_back = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("Xc_Sample", time_set);
                    }
                }
                if (WorkFlowName == "A15dot1")
                {
                    List <string> pq_list = new List <string>();
                    pq_list.Add("联合一片区");
                    pq_list.Add("联合二片区");
                    pq_list.Add("联合三片区");
                    pq_list.Add("联合四片区");
                    pq_list.Add("化工片区");
                    pq_list.Add("综合片区");
                    pq_list.Add("其他");
                    //pq_list.Add("检修单位");
                    for (int i = 0; i < pq_list.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Pqname", pq_list[i]);
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);


                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(1) - DateTime.Now).ToString();
                        //time_set.Offset_time = (DateTime.Now.AddMinutes(3) - DateTime.Now).ToString();
                        time_set.Action    = "INVILID";
                        time_set.Call_back = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("ZzSubmit", time_set);
                    }
                }
                else if (WorkFlowName == "A5dot1dot2")
                {
                    for (int i = 0; i < zzids.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Zz_Name", Em.getEa_namebyId(Convert.ToInt16(zzids[i])));
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(5) - DateTime.Now).ToString();
                        //time_set.Offset_time = (DateTime.Now.AddMinutes(3) - DateTime.Now).ToString();
                        time_set.Action    = "INVILID";
                        time_set.Call_back = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("ZzSubmit", time_set);
                    }
                }
                else if (WorkFlowName == "A5dot2dot2")
                {
                    for (int i = 0; i < zzids.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Zz_Name", Em.getEa_namebyId(Convert.ToInt16(zzids[i])));
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(5) - DateTime.Now).ToString();
                        //time_set.Offset_time = (DateTime.Now.AddMinutes(3) - DateTime.Now).ToString();
                        time_set.Action    = "INVILID";
                        time_set.Call_back = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("ZzSubmit", time_set);
                    }
                }
                else if (WorkFlowName == "A11dot2dot2")
                {
                    for (int i = 0; i < zzids.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Zz_Name", Em.getEa_namebyId(Convert.ToInt16(zzids[i])));
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(5) - DateTime.Now).ToString();
                        //time_set.Offset_time = (DateTime.Now.AddMinutes(3) - DateTime.Now).ToString();
                        time_set.Action    = "INVILID";
                        time_set.Call_back = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("ZzSubmit", time_set);
                    }
                }
                if (WorkFlowName == "A12dot2dot1")
                {
                    for (int i = 0; i < zzids.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Zz_Name", Em.getEa_namebyId(Convert.ToInt16(zzids[i])));
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(5) - DateTime.Now).ToString();
                        time_set.Action      = "INVILID";
                        time_set.Call_back   = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("ZzSubmit", time_set);
                    }
                }
                else if (WorkFlowName == "A6dot3")
                {
                    for (int i = 0; i < cjids.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Zz_Name", Em.getEa_namebyId(Convert.ToInt16(zzids[i])));
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(1) - DateTime.Now).ToString();
                        time_set.Action      = "INVILID";
                        time_set.Call_back   = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("Ineligible_Submit", time_set);
                    }
                }
                else if (WorkFlowName == "A7dot1dot1")
                {
                    List <Equip_Info> Th_sb = new List <Equip_Info>();
                    EquipManagment    Epm   = new EquipManagment();
                    Th_sb = Epm.getAllThEquips();
                    for (int i = 0; i < Th_sb.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Equip_GyCode", Th_sb[i].Equip_GyCode);
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(1) - DateTime.Now).ToString();
                        time_set.Action      = "INVILID";
                        time_set.Call_back   = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("ZzSubmit", time_set);
                    }
                }
                else if (WorkFlowName == "A14dot2")
                {
                    for (int i = 0; i < zzids.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Zz_Name", Em.getEa_namebyId(Convert.ToInt16(zzids[i])));
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Action      = "INVILID";
                        time_set.Call_back   = "http://localhost/CallBack/testCallBack";
                        time_set.Offset_time = (DateTime.Now.AddDays(5) - DateTime.Now).ToString();
                        TCP.AppendTimer("JxdwSubmit", time_set);
                        //TCP.AppendTimer("ZzConfirm", time_set);
                    }
                }
                else if (WorkFlowName == "A14dot3dot2")
                {
                    for (int i = 0; i < zzids.Count(); i++)
                    {
                        TimerCreateWFPa             TCP    = new TimerCreateWFPa();//
                        Dictionary <string, string> param  = new Dictionary <string, string>();
                        Dictionary <string, string> record = new Dictionary <string, string>();
                        param.Add("Zz_Name", Em.getEa_namebyId(Convert.ToInt16(zzids[i])));
                        record.Add("username", "system_scheduled");
                        record.Add("time", DateTime.Now.ToString());
                        TCP.wf_params = param;
                        TCP.wf_record = record;
                        m.AppendCreateParam(TCP);

                        TimerCreateWFPa.TimerSetting time_set = new TimerCreateWFPa.TimerSetting();
                        time_set.Time_start  = "wf_create";
                        time_set.Exact_time  = "";
                        time_set.Offset_time = (DateTime.Now.AddDays(5) - DateTime.Now).ToString();
                        time_set.Action      = "SUSPEND";
                        time_set.Call_back   = "http://localhost/CallBack/testCallBack";
                        TCP.AppendTimer("ZzSubmit", time_set);
                    }
                }



                string corn            = "0 0 0 * * ?";
                string corn_express    = item["corn_express"].ToString();
                string ReservationTime = item["reservationtime"].ToString();
                m.Set_Res_Value("STR_RES_2", ReservationTime);
                corn         = corn_express;
                m.for_using  = TIMER_USING.FOR_CUSTOM;
                m.CreateTime = DateTime.Now;
                m.SetTriggerTiming(corn);
                m.mission_name = item["Job_Name"].ToString();
                m.status       = TM_STATUS.TM_STATUS_ACTIVE;
                //m.CreateCallback = "/zxhtest/QxFunction?depts="+Depts+"";//和权限有关的回调函数
                m.CustomFlag = 0;

                WorkFlow_Define wfd = wfs.GetWorkFlowDefineByID(workflow_id);

                m.attachTarget(wfd);
                m.GetAttachWorkFlow();//0910
                m.Save();

                CTimerManage.ActiveListActionForMission(m);
                return("成功发起定时任务");
            }
            else
            {
                return("该工作流已经提报过,请删除后再发起");
            }
        }