/// <summary> /// 更新 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Edit(TB_Bed info) { try { Database db = DBO.CreateDatabase(); return(this.Edit(info, (DbTransaction)null, db)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Create(TB_RoleConnectModule info) { try { Database db = DBO.CreateDatabase(); return(this.Create(info, (DbTransaction)null, db)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除 /// </summary> /// <param name="strID"></param> public int Delete(string strID) { try { Database db = DBO.CreateDatabase(); return(this.Delete(strID, (DbTransaction)null, db)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Create(TB_Charging info, DbTransaction tran) { try { Database db = DBO.CreateDatabase(); return(this.Create(info, tran, db)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Create(TB_AllowanceApply info) { try { Database db = DBO.CreateDatabase(); return(this.Create(info, (DbTransaction)null, db)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Create(TB_EmployeeCheckOut info) { try { Database db = DBO.CreateDatabase(); return(this.Create(info, (DbTransaction)null, db)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Create(TB_ChangeRoomRecord info) { try { Database db = DBO.CreateDatabase(); return(this.Create(info, (DbTransaction)null, db)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新 /// </summary> /// <param name="info"></param> /// <param name="tran"></param> /// <param name="db"></param> /// <returns></returns> public int EditTB_EmployeeCheckIn(TB_EmployeeCheckIn info) { Database db = DBO.CreateDatabase(); DbCommand dbCommandWrapper = null; string strUpdateSql = @"UPDATE TB_EmployeeCheckIn SET [EmployeeNo]=@EmployeeNo ,[BU]=@BU ,[Telephone]=@Telephone ,[CheckInDate]=@CheckInDate ,[UpdateBy]=@UpdateBy ,[UpdateDate]=@UpdateDate ,EmployeeTypeName=@EmployeeTypeName WHERE ID=@ID"; try { dbCommandWrapper = db.GetSqlStringCommand(strUpdateSql); #region Add parameters db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, info.ID); db.AddInParameter(dbCommandWrapper, "@EmployeeNo", DbType.String, info.EmployeeNo); db.AddInParameter(dbCommandWrapper, "@BU", DbType.String, info.BU); db.AddInParameter(dbCommandWrapper, "@CardNo", DbType.String, info.CardNo); db.AddInParameter(dbCommandWrapper, "@Telephone", DbType.String, info.Telephone); db.AddInParameter(dbCommandWrapper, "@CheckInDate", DbType.DateTime, info.CheckInDate); db.AddInParameter(dbCommandWrapper, "@UpdateBy", DbType.String, info.UpdateBy); db.AddInParameter(dbCommandWrapper, "@UpdateDate", DbType.DateTime, DateTime.Now); db.AddInParameter(dbCommandWrapper, "@EmployeeTypeName", DbType.String, info.EmployeeTypeName); #endregion return(db.ExecuteNonQuery(dbCommandWrapper)); } catch (Exception ex) { throw ex; } finally { if (dbCommandWrapper != null) { dbCommandWrapper.Dispose(); dbCommandWrapper = null; } } }