public bool ModifyInterim(ParkInterim model, out string ErrorMessage)
{
ErrorMessage = "";
try
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
model.DataStatus = DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("update ParkInterim set IORecordID=@IORecordID,StartInterimTime=@StartInterimTime,EndInterimTime=@EndInterimTime,HaveUpdate=@HaveUpdate,LastUpdateTime=@LastUpdateTime,DataStatus=@DataStatus,Remark=@Remark");
strSql.Append(" where RecordID=@RecordID");
dbOperator.ClearParameters();
dbOperator.AddParameter("IORecordID", model.IORecordID);
dbOperator.AddParameter("StartInterimTime", model.StartInterimTime);
dbOperator.AddParameter("EndInterimTime", model.EndInterimTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
dbOperator.AddParameter("Remark", model.Remark);
dbOperator.AddParameter("RecordID", model.RecordID);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
}
catch (Exception e)
{
ErrorMessage = e.Message;
}
return(false);
}
public static ParkInterim AddInterim(ParkInterim mode, out string ErrorMessage)
{
if (mode == null)
{
throw new ArgumentNullException("mode");
}
IParkInterim factory = ParkInterimFactory.GetFactory();
return(factory.AddInterim(mode, out ErrorMessage));
}
public ParkInterim AddInterim(ParkInterim model, out string ErrorMessage)
{
ErrorMessage = "";
try
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
model.DataStatus = DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
model.RecordID = GuidGenerator.GetGuidString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ParkInterim(RecordID,IORecordID,StartInterimTime,EndInterimTime,LastUpdateTime,HaveUpdate,DataStatus,Remark)");
strSql.Append(" values(@RecordID,@IORecordID,@StartInterimTime,@EndInterimTime,@LastUpdateTime,@HaveUpdate,@DataStatus,@Remark);");
strSql.Append(" select * from ParkInterim where RecordID=@RecordID ");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("IORecordID", model.IORecordID);
dbOperator.AddParameter("StartInterimTime", model.StartInterimTime);
if (model.EndInterimTime == null)
{
dbOperator.AddParameter("EndInterimTime", DBNull.Value);
}
else
{
dbOperator.AddParameter("EndInterimTime", model.EndInterimTime);
}
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", (int)model.HaveUpdate);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
dbOperator.AddParameter("Remark", model.Remark);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
if (reader.Read())
{
return(DataReaderToModel <ParkInterim> .ToModel(reader));
}
}
}
}
catch (Exception e)
{
ErrorMessage = e.Message;
}
return(null);
}
