public static ShowPlan RetrieveObj(string szShowPlanId) { ShowPlanDbo dbo = new ShowPlanDbo(); DataTable dt = dbo.RetrieveALLItems(szShowPlanId); if (dt == null || dt.Rows.Count <= 0) { return(null); } ShowPlan obj = ChangeObj(dt.Rows[0]); return(obj); }
public static ShowPlan ChangeObj(DataRow dr) { ShowPlan obj = new ShowPlan(); obj.ShowPlanId = dr["ShowPlanId"] == DBNull.Value ? "" : dr["ShowPlanId"].ToString(); obj.ShowPlanName = dr["ShowPlanName"] == DBNull.Value ? "" : dr["ShowPlanName"].ToString(); obj.FilmId = dr["FilmId"] == DBNull.Value ? "" : dr["FilmId"].ToString(); obj.Film_FilmModeId = dr["Film_FilmModeId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Film_FilmModeId"]); obj.Position = dr["Position"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Position"]); obj.StartTime = dr["StartTime"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["StartTime"]); obj.EndTime = dr["EndTime"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["EndTime"]); obj.FilmLength = dr["FilmLength"] == DBNull.Value ? 0 : Convert.ToInt32(dr["FilmLength"]); obj.HallId = dr["HallId"] == DBNull.Value ? "" : dr["HallId"].ToString(); obj.DailyPlanId = dr["DailyPlanId"] == DBNull.Value ? "" : dr["DailyPlanId"].ToString(); obj.Timespan = dr["Timespan"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Timespan"]); obj.Ratio = dr["Ratio"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["Ratio"]); obj.LowestPrice = dr["LowestPrice"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["LowestPrice"]); obj.FareSettingId = dr["FareSettingId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["FareSettingId"]); obj.SinglePrice = dr["SinglePrice"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["SinglePrice"]); obj.DoublePrice = dr["DoublePrice"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["DoublePrice"]); obj.BoxPrice = dr["BoxPrice"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["BoxPrice"]); obj.StudentPrice = dr["StudentPrice"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["StudentPrice"]); obj.GroupPrice = dr["GroupPrice"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["GroupPrice"]); obj.MemberPrice = dr["MemberPrice"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["MemberPrice"]); obj.DiscountPrice = dr["DiscountPrice"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["DiscountPrice"]); obj.ShowStatus = dr["ShowStatus"] == DBNull.Value ? 0 : Convert.ToInt32(dr["ShowStatus"]); obj.ShowTypeId = dr["ShowTypeId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["ShowTypeId"]); obj.ShowGroup = dr["ShowGroup"] == DBNull.Value ? 0 : Convert.ToInt32(dr["ShowGroup"]); obj.IsDiscounted = dr["IsDiscounted"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsDiscounted"]); obj.IsCheckingNumber = dr["IsCheckingNumber"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsCheckingNumber"]); obj.IsTicketChecking = dr["IsTicketChecking"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsTicketChecking"]); obj.IsOnlineTicketing = dr["IsOnlineTicketing"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsOnlineTicketing"]); obj.IsApproved = dr["IsApproved"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsApproved"]); obj.IsSalable = dr["IsSalable"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsSalable"]); obj.IsLocked = dr["IsLocked"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsLocked"]); obj.Stagehand = dr["Stagehand"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Stagehand"]); obj.Projectionist = dr["Projectionist"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Projectionist"]); obj.Created = dr["Created"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["Created"]); obj.Updated = dr["Updated"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["Updated"]); obj.ActiveFlag = dr["ActiveFlag"] == DBNull.Value ? 1 : Convert.ToInt32(dr["ActiveFlag"]); return(obj); }
public static ShowPlanRich RetrieveObj(string szShowPlanId) { ShowPlanDbo dbo = new ShowPlanDbo(); DataTable dt = dbo.RetrieveALLItems_Ext(szShowPlanId); if (dt == null || dt.Rows.Count <= 0) { return(null); } ShowPlanRich spR = new ShowPlanRich(); spR._ObjShowPlan = ShowPlan.ChangeObj(dt.Rows[0]); spR._HallName = dt.Rows[0]["HallName"] == DBNull.Value ? "" : dt.Rows[0]["HallName"].ToString(); spR._FilmCode = dt.Rows[0]["FilmCode"] == DBNull.Value ? "" : dt.Rows[0]["FilmCode"].ToString(); spR._FilmName = dt.Rows[0]["FilmName"] == DBNull.Value ? "" : dt.Rows[0]["FilmName"].ToString(); return(spR); }