public Equ_PmPlanInfo GetEquDetailObj(Equ_PmPlanInfo equinfo, Equ_PmPlanInfo result)
{
DataTable dt = new DataTable();
string ReturnValue = string.Empty;
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ELCO_ConnectionString"].ToString()))
{
SqlCommand cmd = new SqlCommand();
conn.Open();
cmd.Connection = conn;
string str1 = "select ID,ProcessCode,PmLevel,DeviceName,PmSpecCode,PmPlanCode,PmPlanName,PmCycleTime,PmTimeUsage,FORMAT(PmFirstDate,'yyyy-MM-dd') as PmFirstDate,PmContinueTimes,PmPreAlarmDates,PmPlanComment from Equ_PmPlanList";
if (equinfo.ID != "")
{
str1 += " WHERE ID = " + equinfo.ID + " ";
}
cmd.CommandType = CommandType.Text;
cmd.CommandText = str1;
SqlDataAdapter Datapter = new SqlDataAdapter(cmd);
Datapter.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
result.ID = dt.Rows[0]["ID"].ToString();
result.ProcessCode = dt.Rows[0]["ProcessCode"].ToString();
result.PmLevel = dt.Rows[0]["PmLevel"].ToString();
result.DeviceName = dt.Rows[0]["DeviceName"].ToString();
result.PmSpecName = dt.Rows[0]["PmSpecCode"].ToString();
result.PmPlanCode = dt.Rows[0]["PmPlanCode"].ToString();
result.PmPlanName = dt.Rows[0]["PmPlanName"].ToString();
result.PmCycleTime = Convert.ToInt16(dt.Rows[0]["PmCycleTime"].ToString());
result.PmTimeUsage = Convert.ToInt16(dt.Rows[0]["PmTimeUsage"].ToString());
result.PmFirstDate = dt.Rows[0]["PmFirstDate"].ToString();
result.PmContinueTimes = Convert.ToInt16(dt.Rows[0]["PmContinueTimes"].ToString());
result.PmPreAlarmDates = Convert.ToInt16(dt.Rows[0]["PmPreAlarmDates"].ToString());
result.PmPlanComment = dt.Rows[0]["PmPlanComment"].ToString();
}
}
return(result);
}
public ResultMsg_Equ_PmPlan editEquMaintencePlanDataInDB(Equ_PmPlanInfo dataEntity, ResultMsg_Equ_PmPlan result)
{
if (dataEntity.ID.Length == 0)
{
dataEntity.ID = "0";
}
//if (dataEntity.ProcessCode.Length == 0) dataEntity.ProcessCode = "";
//if (dataEntity.ProcessName.Length == 0) dataEntity.ProcessName = "";
//if (dataEntity.ProcessBeat.Length == 0) dataEntity.ProcessBeat = "";
//if (dataEntity.ProcessDsca.Length == 0) dataEntity.ProcessDsca = "";
//if (dataEntity.InturnNumber.Length == 0) dataEntity.InturnNumber = "0";
//if (dataEntity.ProcessManual.Length == 0) dataEntity.ProcessManual = "";
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 = " SELECT COUNT(1) AS SM FROM Equ_PmPlanList WHERE PmPlanCode = '" + dataEntity.PmPlanCode + "' and ID <> " + dataEntity.ID;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strSql;
SqlDataAdapter Datapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
Datapter.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
if (Convert.ToInt32(dt.Rows[0]["SM"]) > 0)
{
result.result = "failed";
result.msg = "此保养计划编号已经存在, 请核对!";
}
else
{
result.result = "";
result.msg = "";
}
}
else
{
result.result = "failed";
result.msg = "数据重复性检查失败!";
}
if (result.result == "")
{
transaction = conn.BeginTransaction();
cmd.Transaction = transaction;
strSql = string.Format(
@" UPDATE Equ_PmPlanList SET
ProcessCode = '{0}'
, PmLevel ='{1}'
, DeviceName = '{2}'
, PmSpecCode = '{3}'
, PmPlanCode= '{4}'
, PmPlanName= '{5}'
, PmCycleTime= '{6}'
, PmTimeUsage= '{7}'
, PmFirstDate= '{8}'
, PmContinueTimes= '{9}'
, PmPreAlarmDates= '{10}'
, PmPlanComment= '{11}'
, UpdateUser = '******'
, UpdateTime = getdate()
WHERE id = {13}
",
dataEntity.ProcessCode,
dataEntity.PmLevel,
dataEntity.DeviceName,
dataEntity.PmSpecName,
dataEntity.PmPlanCode,
dataEntity.PmPlanName,
dataEntity.PmCycleTime,
dataEntity.PmTimeUsage,
dataEntity.PmFirstDate,
dataEntity.PmContinueTimes,
dataEntity.PmPreAlarmDates,
dataEntity.PmPlanComment,
UserName,
dataEntity.ID
);
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 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 == "EquMaintencePlan_Detail")
{
Equ_PmPlanInfo equinfo = new Equ_PmPlanInfo();
equinfo.ID = RequstString("EquID");
Equ_PmPlanInfo result = new Equ_PmPlanInfo();
result = GetEquDetailObj(equinfo, result);
context.Response.Write(jsc.Serialize(result));
}
else if (Action == "EquMaintencePlan_Add")
{
Equ_PmPlanInfo dataEntity = new Equ_PmPlanInfo();
//dataEntity.ID = RequstString("ProcId");
dataEntity.ProcessCode = RequstString("ProcessName");
dataEntity.PmLevel = RequstString("PmLevel");
dataEntity.DeviceName = RequstString("DeviceName");
dataEntity.PmSpecName = RequstString("PmSpecName");
dataEntity.PmPlanCode = RequstString("PmPlanCode");
dataEntity.PmPlanName = RequstString("PmPlanName");
dataEntity.PmFirstDate = RequstString("PmFirstDate");
if (RequstString("PmCycleTime").Length != 0)
{
dataEntity.PmCycleTime = Convert.ToInt16(RequstString("PmCycleTime"));
}
else
{
dataEntity.PmCycleTime = 0;
}
if (RequstString("PmTimeUsage").Length != 0)
{
dataEntity.PmTimeUsage = Convert.ToInt16(RequstString("PmTimeUsage"));
}
else
{
dataEntity.PmTimeUsage = 0;
}
if (RequstString("PmContinueTimes").Length != 0)
{
dataEntity.PmContinueTimes = Convert.ToInt16(RequstString("PmContinueTimes"));
}
else
{
dataEntity.PmContinueTimes = 0;
}
if (RequstString("PmPreAlarmDates").Length != 0)
{
dataEntity.PmPreAlarmDates = Convert.ToInt16(RequstString("PmPreAlarmDates"));
}
else
{
dataEntity.PmPreAlarmDates = 0;
}
//dataEntity.PmPreAlarmDates =Convert.ToInt16( RequstString("PmPreAlarmDates"));
dataEntity.PmPlanComment = RequstString("PmPlanComment");
ResultMsg_Equ_PmPlan result = new ResultMsg_Equ_PmPlan();
result = addEquMaintencePlanDataInDB(dataEntity, result);
context.Response.Write(jsc.Serialize(result));
}
else if (Action == "EquMaintencePlan_Edit")
{
Equ_PmPlanInfo dataEntity = new Equ_PmPlanInfo();
dataEntity.ID = RequstString("EquID");
dataEntity.ProcessCode = RequstString("ProcessName");
dataEntity.PmLevel = RequstString("PmLevel");
dataEntity.DeviceName = RequstString("DeviceName");
dataEntity.PmSpecName = RequstString("PmSpecName");
dataEntity.PmPlanCode = RequstString("PmPlanCode");
dataEntity.PmSpecName = RequstString("PmSpecName");
dataEntity.PmFirstDate = RequstString("PmFirstDate");
dataEntity.PmPlanName = RequstString("PmPlanName");
if (RequstString("PmCycleTime").Length != 0)
{
dataEntity.PmCycleTime = Convert.ToInt16(RequstString("PmCycleTime"));
}
else
{
dataEntity.PmCycleTime = 0;
}
if (RequstString("PmTimeUsage").Length != 0)
{
dataEntity.PmTimeUsage = Convert.ToInt16(RequstString("PmTimeUsage"));
}
else
{
dataEntity.PmTimeUsage = 0;
}
if (RequstString("PmContinueTimes").Length != 0)
{
dataEntity.PmContinueTimes = Convert.ToInt16(RequstString("PmContinueTimes"));
}
else
{
dataEntity.PmContinueTimes = 0;
}
if (RequstString("PmPreAlarmDates").Length != 0)
{
dataEntity.PmPreAlarmDates = Convert.ToInt16(RequstString("PmPreAlarmDates"));
}
else
{
dataEntity.PmPreAlarmDates = 0;
}
dataEntity.PmPlanComment = RequstString("PmPlanComment");
ResultMsg_Equ_PmPlan result = new ResultMsg_Equ_PmPlan();
result = editEquMaintencePlanDataInDB(dataEntity, result);
context.Response.Write(jsc.Serialize(result));
}
}