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); }