public ResultMsg_Equ_PmFirstLevelRecord CheckFirstLevelMaintence(ResultMsg_Equ_PmFirstLevelRecord result)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ELCO_ConnectionString"].ToString()))
{
SqlCommand cmd = new SqlCommand();
SqlTransaction transaction = null;
try
{
conn.Open();
transaction = conn.BeginTransaction();
cmd.Transaction = transaction;
cmd.Connection = conn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@CatchFlag", 0);
sqlPara[0].Size = 10;
sqlPara[0].Direction = System.Data.ParameterDirection.Output;
foreach (SqlParameter para in sqlPara)
{
cmd.Parameters.Add(para);
}
cmd.CommandText = "[usp_Equ_CheckFirstLevelMaintence]";
cmd.ExecuteNonQuery();
transaction.Commit();
if (sqlPara[0].Value.ToString() == "1")
{
result.result = "1";
result.msg = "当日已完成两次维护，不需要再次维护";
}
else if (sqlPara[0].Value.ToString() == "0")
{
result.result = "0";
result.msg = "需要维护!";
}
}
catch (Exception ex)
{
transaction.Rollback();
result.result = "failed";
result.msg = "数据异常! \n" + ex.Message;
}
}
return(result);
}
public ResultMsg_Equ_PmFirstLevelRecord AddSecondLevelProblem(Equ_PmSecondLevelProblem dataEntity, ResultMsg_Equ_PmFirstLevelRecord result)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ELCO_ConnectionString"].ToString()))
{
SqlCommand cmd = new SqlCommand();
SqlTransaction transaction = null;
try
{
conn.Open();
cmd.Connection = conn;
string strSql = "";
transaction = conn.BeginTransaction();
cmd.Transaction = transaction;
strSql = string.Format(
@" INSERT INTO Equ_SecondLevelInspectionProblem
( InspectionProblem, InspectionDate,DeviceCode,MaintenceTime,PowerLine,GroundLead,ReplacePart,ReplaceName,ReplaceCount)VALUES (
'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')",
dataEntity.InspectionProblem,
dataEntity.PmDate,
dataEntity.DeviceCode,
dataEntity.MaintenceTime,
dataEntity.PowerLine,
dataEntity.GroundLead,
dataEntity.ReplacePart,
dataEntity.ReplaceName,
dataEntity.ReplaceCount
);
cmd.CommandType = CommandType.Text;
cmd.CommandText = strSql;
cmd.ExecuteNonQuery();
transaction.Commit();
result.result = "success";
result.msg = "保存数据成功!";
}
catch (Exception ex)
{
transaction.Rollback();
result.result = "failed";
result.msg = "保存失败! \n" + ex.Message;
}
}
return(result);
}
public ResultMsg_Equ_PmFirstLevelRecord ExcuteSecondLevelEquMaintenceMan(List <Equ_PmFisrtLevelRecordInfo> dataEntity, ResultMsg_Equ_PmFirstLevelRecord result)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ELCO_ConnectionString"].ToString()))
{
SqlCommand cmd = new SqlCommand();
SqlTransaction transaction = null;
try
{
conn.Open();
transaction = conn.BeginTransaction();
cmd.Transaction = transaction;
cmd.Connection = conn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter[] sqlPara = new SqlParameter[2];
for (int i = 0; i < dataEntity.Count; i++)
{
if (i == 0)
{
sqlPara[0] = new SqlParameter("@PmPlanCode", dataEntity[i].PmPlanCode);
sqlPara[0].Direction = System.Data.ParameterDirection.Input;
//sqlPara[1] = new SqlParameter("@PmStartDate", dataEntity[i].PmStartDate);
//sqlPara[1].Direction = System.Data.ParameterDirection.Input;
//sqlPara[2] = new SqlParameter("@PmFinishDate", dataEntity[i].PmFinishDate);
//sqlPara[2].Direction = System.Data.ParameterDirection.Input;
sqlPara[1] = new SqlParameter("@PmOper", dataEntity[i].PmOper);
sqlPara[1].Direction = System.Data.ParameterDirection.Input;
foreach (SqlParameter para in sqlPara)
{
cmd.Parameters.Add(para);
}
}
else
{
cmd.Parameters[0].Value = dataEntity[i].PmPlanCode;
}
cmd.CommandText = "[usp_EquExcuteSecondMaintence]";
cmd.ExecuteNonQuery();
}
transaction.Commit();
result.result = "success";
result.msg = "保存数据成功!";
}
catch (Exception ex)
{
transaction.Rollback();
result.result = "failed";
result.msg = "保存失败! \n" + ex.Message;
}
}
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
}