public string getA6dot2dot2Tab(string wfe_id)
{
List <object> or = new List <object>();
A6dot2Managment AM = new A6dot2Managment();
int i = 1;
List <A6dot2LsTaskTab> rList = AM.getLsTask(wfe_id);
foreach (var r in rList)
{
object o = new
{ ID = r.Id,
Zz_Name = r.Zz_Name,
Equip_Gybh = r.Equip_Gybh,
Equip_Code = r.Equip_Code,
Last_HY = r.lastOilTime,
HY_ZQ = r.oilInterval,
Next_HY = r.NextOilTime,
Problem_Cur = r.cur_problem,
ZG_status = r.cur_status,
Wfe_id = r.wfd_id };
i = i + 1;
or.Add(o);
}
string str = JsonConvert.SerializeObject(or);
return("{" + "\"data\": " + str + "}");
}
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 + "}");
}
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));
}
/// <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 { }
}
/// <summary>
/// 处理datatables请求
/// </summary>
/// <param name="data"></param>
private DtResponse ProcessRequest(List <KeyValuePair <string, string> > data, string wfe_id)
{
DtResponse dt = new DtResponse();
var http = DtRequest.HttpData(data);
if (http.ContainsKey("action"))
{
string action = http["action"] as string;
if (action == "edit")
{
var Data = http["data"] as Dictionary <string, object>;
foreach (var d in Data)
{
int id = Convert.ToInt32(d.Key);
List <string> pros = new List <string>();
List <object> vals = new List <object>();
Dictionary <string, object> m_kv = new Dictionary <string, object>();
foreach (var dd in d.Value as Dictionary <string, object> )
{
pros.Add(dd.Key);
vals.Add(dd.Value);
}
A6dot2Managment AM = new A6dot2Managment();
A6dot2LsTaskTab m = AM.UpdateA6dot2LsTask(id, pros, vals);
m_kv["ID"] = m.Id;
m_kv["Zz_Name"] = m.Zz_Name;
m_kv["Equip_Gybh"] = m.Equip_Gybh;
m_kv["Equip_Code"] = m.Equip_Code;
m_kv["Last_HY"] = m.lastOilTime;
m_kv["HY_ZQ"] = m.oilInterval;
m_kv["Next_HY"] = m.NextOilTime;
m_kv["Problem_Cur"] = m.cur_problem;
m_kv["ZG_status"] = m.cur_status;
m_kv["Wfe_id"] = m.wfd_id;
dt.data.Add(m_kv);
}
}
else if (action == "create") //新建工作流
{
A6dot2Managment AM = new A6dot2Managment();
A6dot2LsTaskTab rt = new A6dot2LsTaskTab();
rt.wfd_id = wfe_id;
A6dot2LsTaskTab m = AM.AddA6dot2LsTask(rt);
Dictionary <string, object> m_kv = new Dictionary <string, object>();
m_kv["ID"] = m.Id;
m_kv["Zz_Name"] = m.Zz_Name;
m_kv["Equip_Gybh"] = m.Equip_Gybh;
m_kv["Equip_Code"] = m.Equip_Code;
m_kv["Last_HY"] = m.lastOilTime;
m_kv["HY_ZQ"] = m.oilInterval;
m_kv["Next_HY"] = m.NextOilTime;
m_kv["Problem_Cur"] = m.cur_problem;
m_kv["ZG_status"] = m.cur_status;
m_kv["Wfe_id"] = m.wfd_id;
dt.data.Add(m_kv);
}
else if (action == "remove")
{
var Data = http["data"] as Dictionary <string, object>;
foreach (var d in Data)
{
int id = Convert.ToInt32(d.Key);
A6dot2Managment AM = new A6dot2Managment();
AM.RemoveA6dot2LsTask(id);
}
}
}
return(dt);
}
public string JdcConfirm_submitsignal(string json1)
{
JObject item = (JObject)JsonConvert.DeserializeObject(json1);
string flowname = item["Flow_Name"].ToString();
A6dot2Managment WM = new A6dot2Managment();
FileItem file = new FileItem();
int Equip_Id = 0;
Dictionary <string, string> signal = new Dictionary <string, string>();
//new input paras
signal["JdcConfirm_Result"] = item["JdcConfirm_Result"].ToString();
signal["JdcSupplement"] = item["JdcSupplement"].ToString();
//上传到File_Info
if (signal["JdcConfirm_Result"] == "通过")
{
//向File_Info里写文件信息
WorkFlows wfsd = new WorkFlows();
List <Mission> db_miss = wfsd.GetWFEntityMissions(Convert.ToInt32(flowname));//获取该实体的所有任务
for (int i = 0; i < db_miss.Count; i++)
{
if (db_miss[i].Miss_Desc == "可靠性工程师修改再上传")
{
UI_MISSION ui_mi = new UI_MISSION();
ui_mi.WE_Entity_Id = Convert.ToInt32(flowname);
ui_mi.WE_Event_Desc = db_miss[i].Miss_Desc;
ui_mi.WE_Event_Name = db_miss[i].Event_Name;
ui_mi.WE_Name = db_miss[i].Miss_Name;
ui_mi.Mission_Url = ""; //历史任务的页面至空
ui_mi.Miss_Id = db_miss[i].Miss_Id;
List <Mission_Param> mis_pars = wfsd.GetMissParams(db_miss[i].Miss_Id);//获取当前任务参数
foreach (var par in mis_pars)
{
CParam cp = new CParam();
cp.type = par.Param_Type;
cp.name = par.Param_Name;
cp.value = par.Param_Value;
cp.description = par.Param_Desc;
ui_mi.Miss_Params[cp.name] = cp.value;
// ui_mi.Miss_ParamsAppRes[cp.name] = wf.paramstable[cp.name].linkEventsApp_res[ui_mi.WE_Event_Name];
ui_mi.Miss_ParamsDesc[cp.name] = cp.description;//xwm modified
}
Equip_Id = WM.GetEquipIdBySbCode(ui_mi.Miss_Params["Equip_Code"].ToString());
string[] File_AllName = ui_mi.Miss_Params["ModifyOperInstruc"].ToString().Split(new char[] { '$' });
file.fileName = File_AllName[0];
file.fileNamePresent = File_AllName[1];
file.ext = Path.GetExtension(ui_mi.Miss_Params["ModifyOperInstruc"].ToString());
file.updateTime = DateTime.Now.ToString();
file.Mission_Id = db_miss[i].Miss_Id;
file.WfEntity_Id = Convert.ToInt32(flowname);
//file.Self_Catalog_Catalog_Id = 28;
file.path = @"/Upload/A3dot3";
bool res = WM.AddNewFile(28, file);
break;
}
}
//通过上传时间找到刚才上传到File_Info的文件的File_Id
int File_Id = WM.GetFileIdByUpdateTime(Convert.ToDateTime(file.updateTime));
//调用File.cs里的AttachtoEuip使连接表产生数据，让设备与操作规程勾连,需要用到Equip_Id和File_Id
bool les = WM.AttachtoEuipAndFile(File_Id, Equip_Id);
}
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);
return("/A6dot1/Index");
}
