/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public int Update(clsATP model, out string errMsg)
{
errMsg = string.Empty;
int rtn = 0;
try
{
sb.Length = 0;
sb.Append("UPDATE tAtp SET ");
sb.AppendFormat("USER='******',", model.Atp_CheckName);
sb.AppendFormat("RLU='{0}',", model.Atp_RLU);
sb.AppendFormat("RESULT='{0}',", model.Atp_Result);
sb.AppendFormat("DATA='{0}',", model.Atp_CheckData);
sb.AppendFormat("TIME='{0}',", model.Atp_CheckTime);
sb.AppendFormat("UPPER='{0}',", model.Atp_Upper);
sb.AppendFormat("LOWER='{0}',", model.Atp_Lower);
sb.AppendFormat(" WHERE DATA='{0}' AND TIME='{1}' AND USER='******'",
model.Atp_CheckData, model.Atp_CheckTime, model.Atp_CheckName);
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
errMsg = e.Message;
}
return(rtn);
}
/// <summary>
/// 插入一条明细记录
/// </summary>
/// <param name="model">ID>0为修改 ID=0为新增</param>
/// <returns></returns>
public int Insert(clsATP model, out string errMsg)
{
errMsg = string.Empty;
int rtn = 0;
try
{
sb.Length = 0;
sb.Append("INSERT INTO tAtp ");
sb.Append("(ATP_CHECKNAME,ATP_RLU,ATP_RESULT,ATP_CHECKDATA,ATP_CHECKTIME,ATP_UPPER,ATP_LOWER) ");
sb.Append("VALUES(");
sb.AppendFormat("'{0}',", model.Atp_CheckName);
sb.AppendFormat("'{0}',", model.Atp_RLU);
sb.AppendFormat("'{0}',", model.Atp_Result);
sb.AppendFormat("'{0}',", model.Atp_CheckData);
sb.AppendFormat("'{0}',", model.Atp_CheckTime);
sb.AppendFormat("'{0}',", model.Atp_Upper);
sb.AppendFormat("'{0}'", model.Atp_Lower);
sb.Append(")");
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
errMsg = e.Message;
}
return(rtn);
}