/// <summary> /// 得到一个对象实体 /// </summary> public Models.m_worker_history DataRowToModel(DataRow row) { Models.m_worker_history model = new Models.m_worker_history(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["WORKER_ID"] != null && row["WORKER_ID"].ToString() != "") { model.WORKER_ID = new Guid(row["WORKER_ID"].ToString()); } if (row["COMMENTS"] != null) { model.COMMENTS = row["COMMENTS"].ToString(); } if (row["CREATE_USER_ID"] != null && row["CREATE_USER_ID"].ToString() != "") { model.CREATE_USER_ID = new Guid(row["CREATE_USER_ID"].ToString()); } if (row["CREATE_DATETIME"] != null && row["CREATE_DATETIME"].ToString() != "") { model.CREATE_DATETIME = DateTime.Parse(row["CREATE_DATETIME"].ToString()); } if (row["UPDATE_USER_ID"] != null && row["UPDATE_USER_ID"].ToString() != "") { model.UPDATE_USER_ID = new Guid(row["UPDATE_USER_ID"].ToString()); } if (row["UPDATE_DATETIME"] != null && row["UPDATE_DATETIME"].ToString() != "") { model.UPDATE_DATETIME = DateTime.Parse(row["UPDATE_DATETIME"].ToString()); } if (row["DELETE_FLG"] != null) { model.DELETE_FLG = row["DELETE_FLG"].ToString(); } try { if (row["CREATE_USER"] != null) { model.CREATE_USER = row["CREATE_USER"].ToString(); } } catch { } try { if (row["UPDATE_USER"] != null) { model.UPDATE_USER = row["UPDATE_USER"].ToString(); } } catch { } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Models.m_worker_history GetModel(Guid ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,WORKER_ID,COMMENTS,CREATE_USER_ID,CREATE_DATETIME,UPDATE_USER_ID,UPDATE_DATETIME,DELETE_FLG from m_worker_history "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier,16) }; parameters[0].Value = ID; Models.m_worker_history model = new Models.m_worker_history(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 删除一条数据 /// </summary> public bool saveHistory(Guid ID, Guid UserID) { DAL.m_worker_history dal_m_worker_history = new m_worker_history(); Models.m_worker model_m_worker = GetModel(ID); Models.m_worker_history model_m_worker_history = new Models.m_worker_history(); model_m_worker_history.ID = Guid.NewGuid(); model_m_worker_history.WORKER_ID = ID; model_m_worker_history.COMMENTS = model_m_worker.COMMENTS; model_m_worker_history.CREATE_USER_ID = UserID; model_m_worker_history.CREATE_DATETIME = DateTime.Now; model_m_worker_history.UPDATE_USER_ID = UserID; model_m_worker_history.UPDATE_DATETIME = DateTime.Now; model_m_worker_history.DELETE_FLG = "0"; dal_m_worker_history.Add(model_m_worker_history); model_m_worker.STATUS = Common.Variables.WORKER_STATUS_IN_POOL; model_m_worker.COMMENTS = ""; model_m_worker.UPDATE_USER_ID = UserID; model_m_worker.UPDATE_DATETIME = DateTime.Now; return Update(model_m_worker); }