public bool ModifyChangeshiftrecord(ParkChangeshiftrecord model, out string errorMsg)
{
errorMsg = "";
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 ParkChangeshiftrecord set BoxID=@BoxID,DataStatus=@DataStatus,EndWorkTime=@EndWorkTime,HaveUpdate=@HaveUpdate,LastUpdateTime=@LastUpdateTime,PKID=@PKID,StartWorkTime=@StartWorkTime,UserID=@UserID");
strSql.Append(" where RecordID=@RecordID");
dbOperator.ClearParameters();
dbOperator.AddParameter("BoxID", model.BoxID);
dbOperator.AddParameter("DataStatus", model.DataStatus);
dbOperator.AddParameter("EndWorkTime", model.EndWorkTime);
dbOperator.AddParameter("HaveUpdate", 1);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("PKID", model.PKID);
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("StartWorkTime", model.StartWorkTime);
dbOperator.AddParameter("UserID", model.UserID);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
}
catch (Exception e)
{
errorMsg = e.Message;
}
return(false);
}
public static bool ModifyChangeshiftrecord(ParkChangeshiftrecord mode, out string errorMsg)
{
if (mode == null)
{
throw new ArgumentNullException("mode");
}
IParkChangeshiftrecord factory = ParkChangeshiftrecordFactory.GetFactory();
return(factory.ModifyChangeshiftrecord(mode, out errorMsg));
}
public ParkChangeshiftrecord AddChangeshiftrecord(ParkChangeshiftrecord 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 ParkChangeshiftrecord(RecordID,UserID,StartWorkTime,EndWorkTime,BoxID,PKID,DataStatus,LastUpdateTime,HaveUpdate)");
strSql.Append(" values(@RecordID,@UserID,@StartWorkTime,@EndWorkTime,@BoxID,@PKID,@DataStatus,@LastUpdateTime,@HaveUpdate);");
strSql.Append(" select * from ParkChangeshiftrecord where RecordID=@RecordID;");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("UserID", model.UserID);
dbOperator.AddParameter("StartWorkTime", model.StartWorkTime);
if (model.EndWorkTime != null)
{
dbOperator.AddParameter("EndWorkTime", model.EndWorkTime);
}
else
{
dbOperator.AddParameter("EndWorkTime", DBNull.Value);
}
dbOperator.AddParameter("BoxID", model.BoxID);
dbOperator.AddParameter("PKID", model.PKID);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
if (reader.Read())
{
return(DataReaderToModel <ParkChangeshiftrecord> .ToModel(reader));
}
}
}
}
catch (Exception e)
{
ErrorMessage = e.Message;
}
return(null);
}
