//修改设备
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(""); };
}
public List <EQ> getguicheng()
{
List <EQ> c = new List <EQ>();
try
{
using (var db = base.NewDB())
{
List <File_Info> p = db.Files.Where(a => a.Self_Catalog.Catalog_Id == 28).ToList();//跨表查询Self_Catalog.Catalog_Id
for (int i = 0; i < p.Count; i++)
{
for (int k = 0; k < p[i].File_Equips.Count; k++)//存在文件对应的设备才进入，File_Equips.Count只可能等于一
{
Equip_Info[] zz = new Equip_Info[1];
p[i].File_Equips.CopyTo(zz, 0);
EQ temp = new EQ();
temp.sbGyCode = zz[0].Equip_GyCode;
temp.sbCode = zz[0].Equip_Code;
temp.sbType = zz[0].Equip_Type;
temp.GCnewname = p[i].File_NewName;
temp.GColdname = p[i].File_OldName;
c.Add(temp);
}
}
return(c);
}
}
catch
{
return(c);
}
}
//获得点击修改的设备的具体信息
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));
}
//修改设备信息相关信息
//参数：New_Equip_Info 新的设备信息
//装置 EA_Id 新的设备所属装置Id
public bool ModifyEquip(Equip_Info New_Equip_Info, int EA_Id)
{
using (var db = base.NewDB())
{
try
{
var E = db.Equips.Where(a => a.Equip_Code == New_Equip_Info.Equip_Code).First();
Equip_Archi eItem = db.EArchis.Where(a => a.EA_Id == EA_Id && a.EA_Title == "装置").First();
if (E == null || eItem == null)
{
return(false);
}
else
{
E.Equip_ABCmark = New_Equip_Info.Equip_ABCmark;
E.Equip_Code = New_Equip_Info.Equip_Code;
E.Equip_ManufactureDate = New_Equip_Info.Equip_ManufactureDate;
E.Equip_Manufacturer = New_Equip_Info.Equip_Manufacturer;
E.Equip_PhaseB = New_Equip_Info.Equip_PhaseB;
E.Equip_Specialty = New_Equip_Info.Equip_Specialty;
E.Equip_Type = New_Equip_Info.Equip_Type;
E.Equip_GyCode = New_Equip_Info.Equip_GyCode;
E.Equip_Location = New_Equip_Info.Equip_Location;
E.Equip_PerformanceParasJson = New_Equip_Info.Equip_PerformanceParasJson;
E.Equip_Location = eItem;
db.SaveChanges();
return(true);
}
}
catch { return(false); }
}
}
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");
}
//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");
}
//功能：修改设备信息
//参数： new_Equip 设备的修改信息
// Zz_Id 设备新的所属装置Id
// Person_Ids 设备所属的新管理者集合,该参数默认为null,当不改变设备所属用户时，该参数取默认值
//返回值：bool
public bool modifyEquip(Equip_Info new_Equip, int Zz_Id, List <int> Person_Ids = null)
{
try
{
Es.ModifyEquip(new_Equip, Zz_Id);
if (Person_Ids != null)
{
Es.Equip_LinkPersons(new_Equip.Equip_Id, Person_Ids);
}
return(true);
}
catch { return(false); }
}
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");
}
public bool AttachtoEuip(int fId, int EuipID)
{
try
{
using (var db = base.NewDB())
{
File_Info file = db.Files.Where(s => s.File_Id == fId).First();
Equip_Info equip = db.Equips.Where(s => s.Equip_Id == EuipID).First();
file.File_Equips.Add(equip);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool AddEA_Euip(int EA_Id, Equip_Info New_Equip_Info)
{
using (var db = base.NewDB())
{
try
{
Equip_Archi EA = db.EArchis.Where(a => a.EA_Id == EA_Id).First();
if (EA == null)
{
return(false);
}
EA.Equips_Belong.Add(New_Equip_Info);
db.SaveChanges();
return(true);
}
catch { return(false); }
}
}
//添加设备，并将其和装置建立链接
public bool AddEquip(Equip_Info New_Equip_Info, int ZzId)
{
try
{
using (var db = base.NewDB())
{
Equip_Info e = db.Equips.Add(New_Equip_Info);
Equip_Archi eItem = db.EArchis.Where(a => a.EA_Id == ZzId).First();
e.Equip_Location = eItem;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
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");
}
//添加新设备
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(""); };
}
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);
}
public Equip_Info getEquip_ByGyCode(string Equip_GyCode)
{
Equip_Info e = Es.getEquip_byGyCode(Equip_GyCode);
return(e);
}
//功能：获取某设备的详细信息
//参数： Equip_Id 整型 设备Id
//返回值：Equip_Info
public Equip_Info getEquip_Info(int Equip_Id)
{
Equip_Info e = Es.getEquip_Info(Equip_Id);
return(e);
}
//功能：获取某设备的详细信息 --xwm add
//参数： Equip_Code, string 设备编码
//返回值：Equip_Info
public Equip_Info getEquip_Info(string Equip_Code)
{
Equip_Info e = Es.getEquip_Info(Equip_Code);
return(e);
}
