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