public Equ_PmFisrtLevelRecordDetail GetFirstLevelDetail(Equ_PmFisrtLevelRecordDetail result) { DataTable dt = new DataTable(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ELCO_ConnectionString"].ToString())) { SqlCommand cmd = new SqlCommand(); conn.Open(); cmd.Connection = conn; string str1 = "select c.ProcessName,a.DeviceName,a.PmOper,b.InspectionProblem,b.FindProblem,b.RepairProblem,b.ReaminProblem from Equ_PmRecordList a left join Equ_FirstLevelInspectionProblem b on a.ID=b.PmRecordID left join Mes_Process_List c on a.ProcessCode =c.ProcessCode"; if (result.ID != "") { str1 += " WHERE a.ID = " + result.ID + " "; } cmd.CommandType = CommandType.Text; cmd.CommandText = str1; SqlDataAdapter Datapter = new SqlDataAdapter(cmd); Datapter.Fill(dt); if (dt != null && dt.Rows.Count > 0) { result.ProcessCode = dt.Rows[0]["ProcessName"].ToString(); result.DeviceName = dt.Rows[0]["DeviceName"].ToString(); result.PmOper = dt.Rows[0]["PmOper"].ToString(); result.PmComment = dt.Rows[0]["InspectionProblem"].ToString(); result.FindProblem = dt.Rows[0]["FindProblem"].ToString() == "" ? 0 : Convert.ToInt16(dt.Rows[0]["FindProblem"].ToString()); result.RepairProblem = dt.Rows[0]["RepairProblem"].ToString() == "" ? 0 : Convert.ToInt16(dt.Rows[0]["RepairProblem"].ToString()); result.ReaminProblem = dt.Rows[0]["ReaminProblem"].ToString() == "" ? 0 : Convert.ToInt16(dt.Rows[0]["ReaminProblem"].ToString()); } } return(result); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; if (context.Session["UserName"] != null) { UserName = context.Session["UserName"].ToString().ToUpper().Trim(); } else { UserName = ""; } Action = RequstString("Action"); if (Action.Length == 0) { Action = ""; } if (Action == "EquMaintenceExtraMan_Detail" || Action == "EquMaintenceMan_DetailFinish") { Equ_PmRecordInfo equinfo = new Equ_PmRecordInfo(); equinfo.ID = RequstString("EquID"); Equ_PmRecordInfo result = new Equ_PmRecordInfo(); result = GetEquPmRecordDetailObj(equinfo, result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "EquMaintenceExtraMan_Edit") { Equ_PmRecordInfo dataEntity = new Equ_PmRecordInfo(); dataEntity.ID = RequstString("EquID"); dataEntity.ProcessCode = RequstString("ProcessName"); dataEntity.DeviceName = RequstString("DeviceName"); dataEntity.PmSpecName = RequstString("PmSpecName"); dataEntity.PmStartDate = RequstString("PmStartDate"); dataEntity.PmFinishDate = RequstString("PmFinishDate"); dataEntity.PmOper = RequstString("PmOper"); dataEntity.PmComment = RequstString("PmComment"); ResultMsg_Equ_PmRecord result = new ResultMsg_Equ_PmRecord(); result = editEquMaintenceExtraManDataInDB(dataEntity, result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "EquMaintenceExtraMan_Add") { Equ_PmRecordInfo dataEntity = new Equ_PmRecordInfo(); //dataEntity.ID = RequstString("ProcId"); dataEntity.ProcessCode = RequstString("ProcessName"); dataEntity.DeviceName = RequstString("DeviceName"); dataEntity.PmType = RequstString("PmType"); dataEntity.PmSpecName = RequstString("PmSpecName"); dataEntity.PmStartDate = RequstString("PmStartDate"); dataEntity.PmFinishDate = RequstString("PmFinishDate"); dataEntity.PmComment = RequstString("PmComment"); dataEntity.PmOper = RequstString("PmOper"); ResultMsg_Equ_PmRecord result = new ResultMsg_Equ_PmRecord(); result = addEquMaintenceExtraManDataInDB(dataEntity, result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "EquMaintenceMan_DetailUnFinish") { Equ_PmRecordInfo equinfo = new Equ_PmRecordInfo(); equinfo.ID = RequstString("EquID"); Equ_PmRecordInfo result = new Equ_PmRecordInfo(); result = GetEquPmUnFinishRecordDetailObj(equinfo, result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "ExcuteEquMaintenceMan") { Equ_PmRecordInfo dataEntity = new Equ_PmRecordInfo(); //dataEntity.ID = RequstString("EquID"); dataEntity.ProcessCode = RequstString("ProcessName"); dataEntity.DeviceName = RequstString("DeviceName"); dataEntity.PmSpecName = RequstString("PmSpecName"); dataEntity.PmPlanName = RequstString("PmPlanName"); dataEntity.PmType = "计划内保养"; dataEntity.PmSpecName = RequstString("PmSpecName"); dataEntity.PmStartDate = RequstString("PmStartDate"); dataEntity.PmFinishDate = RequstString("PmFinishDate"); dataEntity.PmComment = RequstString("PmComment"); dataEntity.PmOper = RequstString("PmOper"); ResultMsg_Equ_PmRecord result = new ResultMsg_Equ_PmRecord(); result = ExcuteEquMaintenceManDataInDB(dataEntity, result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "EquMaintenceManEdit") { Equ_PmRecordInfo dataEntity = new Equ_PmRecordInfo(); dataEntity.ID = RequstString("EquID"); //dataEntity.ProcessCode = RequstString("ProcessName"); //dataEntity.DeviceName = RequstString("DeviceName"); //dataEntity.PmSpecName = RequstString("PmSpecName"); //dataEntity.PmPlanName = RequstString("PmPlanName"); //dataEntity.PmType = "计划内保养"; //dataEntity.PmSpecName = RequstString("PmSpecName"); dataEntity.PmStartDate = RequstString("PmStartDate"); dataEntity.PmFinishDate = RequstString("PmFinishDate"); dataEntity.PmComment = RequstString("PmComment"); dataEntity.PmOper = RequstString("PmOper"); ResultMsg_Equ_PmRecord result = new ResultMsg_Equ_PmRecord(); result = editEquMaintenceManDataInDB(dataEntity, result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "ExcuteFirstLevelEquMaintenceMan") { List <Equ_PmFisrtLevelRecordInfo> dataEntity = new List <Equ_PmFisrtLevelRecordInfo>(); string[] PmList = RequstString("PmList").Split(','); for (int i = 0; i < PmList.Length; i++) { Equ_PmFisrtLevelRecordInfo ep = new Equ_PmFisrtLevelRecordInfo(); ep.PmPlanCode = PmList[i].ToString(); ep.PmComment = RequstString("PmComment"); ep.PmOper = RequstString("PmOper"); ep.FindProblem = RequstString("FindProblem") == "" ? 0 : Convert.ToInt16(RequstString("FindProblem")); ep.RepairProblem = RequstString("RepairProblem") == "" ? 0 : Convert.ToInt16(RequstString("RepairProblem")); ep.ReaminProblem = RequstString("ReaminProblem") == "" ? 0 : Convert.ToInt16(RequstString("ReaminProblem")); dataEntity.Add(ep); } ResultMsg_Equ_PmFirstLevelRecord result = new ResultMsg_Equ_PmFirstLevelRecord(); result = ExcuteFirstLevelEquMaintenceMan(dataEntity, result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "ExcuteSecondLevelEquMaintenceMan") { List <Equ_PmFisrtLevelRecordInfo> dataEntity = new List <Equ_PmFisrtLevelRecordInfo>(); string[] PmList = RequstString("PmList").Split(','); for (int i = 0; i < PmList.Length; i++) { Equ_PmFisrtLevelRecordInfo ep = new Equ_PmFisrtLevelRecordInfo(); ep.PmPlanCode = PmList[i].ToString(); ep.PmOper = RequstString("PmOper"); dataEntity.Add(ep); } ResultMsg_Equ_PmFirstLevelRecord result = new ResultMsg_Equ_PmFirstLevelRecord(); result = ExcuteSecondLevelEquMaintenceMan(dataEntity, result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "CheckFirstLevelMaintence") { ResultMsg_Equ_PmFirstLevelRecord result = new ResultMsg_Equ_PmFirstLevelRecord(); result = CheckFirstLevelMaintence(result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "EquFirstLevelMaintenceMan_Detail") { Equ_PmFisrtLevelRecordDetail result = new Equ_PmFisrtLevelRecordDetail(); result.ID = RequstString("EquID"); result = GetFirstLevelDetail(result); context.Response.Write(jsc.Serialize(result)); } else if (Action == "AddSecondLevelProblem") { Equ_PmSecondLevelProblem dataEntity = new Equ_PmSecondLevelProblem(); //dataEntity.ID = RequstString("EquID"); dataEntity.PmOper = RequstString("PmOper"); dataEntity.PmDate = RequstString("PmDate"); dataEntity.DeviceCode = RequstString("DeviceCode"); dataEntity.MaintenceTime = RequstString("MaintenceTime"); dataEntity.PowerLine = RequstString("PowerLine"); dataEntity.GroundLead = RequstString("GroundLead"); dataEntity.ReplacePart = RequstString("ReplacePart"); dataEntity.ReplaceName = RequstString("ReplaceName"); dataEntity.ReplaceCount = RequstString("ReplaceCount"); dataEntity.InspectionProblem = RequstString("InspectionProblem"); ResultMsg_Equ_PmFirstLevelRecord result = new ResultMsg_Equ_PmFirstLevelRecord(); result = AddSecondLevelProblem(dataEntity, result); context.Response.Write(jsc.Serialize(result)); } #region//获取每日保养用时 if (Action == "GetDailyMaintenceTime") { Model.DailyMaintenceTime mb = new Model.DailyMaintenceTime(); mb.MaintenceDate = RequstString("CurrentMonth"); mb = GetDailyMaintenceTime(mb); context.Response.Write(jsc.Serialize(mb)); } #endregion #region //新增每日保养用时 if (Action == "DailyMaintenceTime_Add") { Model.DailyMaintenceTime mb = new Model.DailyMaintenceTime(); mb.MaintenceDate = RequstString("CurrentTime"); mb.TotalTime = RequstString("TotalTime"); Model.ResultMsg_DailyMaintenceTime result = new ResultMsg_DailyMaintenceTime(); result = DailyMaintenceTimeAdd(mb, result); context.Response.Write(jsc.Serialize(result)); } #endregion #region //更新每日保养用时 if (Action == "DailyMaintenceTime_Edit") { Model.DailyMaintenceTime mb = new Model.DailyMaintenceTime(); mb.MaintenceDate = RequstString("CurrentMonth"); mb.TotalTime = RequstString("TotalTime"); Model.ResultMsg_DailyMaintenceTime result = new Model.ResultMsg_DailyMaintenceTime(); result = DailyMaintenceTimeEdit(mb, result); context.Response.Write(jsc.Serialize(result)); } #endregion }