/// <summary>
/// 获取窗口提醒名录
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>qipengfei 2011-11-23</remarks>
public DataTable GetReservationNow(E_Reservation data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@EPUserTMRID", SqlDbType.Int),
new SqlParameter("@NotClientInfoIDs", SqlDbType.NVarChar)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.EPUserTMRID;
parms[2].Value = data.ClientInfoIDs;
return(DbHelperSQL.RunProcedureTable("ProcEP_B_ReservationS_NowSelect", parms));
}
/// <summary>
/// 删除预约名录
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-07</remarks>
public bool DeleteReservation(E_Reservation data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@EPUserTMRID", SqlDbType.Int),
new SqlParameter("@ReservationID", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.EPUserTMRID;
parms[2].Value = data.ReservationID;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcEP_B_Reservation_Delete", parms, out ReturnValue);
return(ReturnValue > 0);
}
public String IUD_Reservation(E_Reservation objReservation, SqlConnection mycon, SqlTransaction trans)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "IUD_Reservation";
cmd.Connection = mycon;
cmd.Parameters.Add("@Reservation_ID", SqlDbType.BigInt).Value = objReservation.Reservation_ID;
cmd.Parameters.Add("@Room_ID", SqlDbType.BigInt).Value = objReservation.Room_ID;
cmd.Parameters.Add("@UserID", SqlDbType.BigInt).Value = objReservation.UserID;
cmd.Parameters.Add("@No_of_Guest", SqlDbType.Decimal).Value = objReservation.No_of_Guest;
cmd.Parameters.Add("@From", SqlDbType.Date).Value = objReservation.From;
cmd.Parameters.Add("@To", SqlDbType.Date).Value = objReservation.To;
cmd.Parameters.Add("@Action", SqlDbType.VarChar).Value = objReservation.Action;
cmd.Transaction = trans;
String i = objdac.iexecute(cmd, mycon);
return(i);
}
/// <summary>
/// 预约
/// </summary>
/// <returns></returns>
/// <remarks>qipengfei 2011-11-07</remarks>
public bool Reservation(E_Reservation data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@ClientInfoID", SqlDbType.Int),
new SqlParameter("@ReservationDate", SqlDbType.SmallDateTime),
new SqlParameter("@AdvanceMinute", SqlDbType.TinyInt),
new SqlParameter("@EPUserTMRID", SqlDbType.Int),
new SqlParameter("@ReType", SqlDbType.TinyInt)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.ClientInfoID;
parms[2].Value = data.ReservationDate;
parms[3].Value = data.AdvanceMinute;
parms[4].Value = data.EPUserTMRID;
parms[5].Value = (int)data.ReservationType;
int ReturnValue = 0;
DbHelperSQL.RunProcedures("ProcEP_B_Reservation_Insert", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 删除预约名录
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-07</remarks>
public bool DeleteReservation(E_Reservation data)
{
return(dal.DeleteReservation(data));
}
/// <summary>
/// 获取窗口提醒名录
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>qipengfei 2011-11-23</remarks>
public DataTable GetReservationNow(E_Reservation data)
{
return(dal.GetReservationNow(data));
}
/// <summary>
/// 预约
/// </summary>
/// <returns></returns>
/// <remarks>qipengfei 2011-11-07</remarks>
public bool Reservation(E_Reservation data)
{
return(dal.Reservation(data));
}
