/// <summary>
        /// 添加片场
        /// </summary>
        /// <param name="pc"></param>
        /// <returns></returns>

        public static bool Insert_DianYingTing(PianChang pc)
        {
            SqlParameter[] p =
            {
                new SqlParameter("@t_id",    pc.T_id),
                new SqlParameter("@m_id",    pc.M_id),
                new SqlParameter("@p_time",  pc.P_time),
                new SqlParameter("@p_price", pc.P_price)
            };
            int i = DBHelper.ExecuteNonQuery("InsertPianChang", CommandType.StoredProcedure, p);

            return(i > 0);
        }
        public static PianChang search_pianChang_byP_id(int p_id)
        {
            string str = "select * from PianChang where p_id=@id";

            SqlParameter[] p =
            {
                new SqlParameter("@id", p_id)
            };
            SqlDataReader sr = DBHelper.ExecuteReader(str, CommandType.Text, p);
            PianChang     pc = new PianChang();

            if (sr.Read())
            {
                pc.P_price = Convert.ToDouble(sr["p_price"]);
                pc.P_time  = Convert.ToDateTime(sr["p_time"]);
            }
            sr.Close();
            return(pc);
        }
Example #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        p_id = 1032;
        String       Y_name = DAL.PianChangServer.search_DianYingYuanName_byP_id(p_id);
        DianYingTing dyt    = DAL.PianChangServer.search_DianYingTing_byP_id(p_id);
        Movie        movie  = DAL.PianChangServer.search_Movie_byP_id(p_id);
        PianChang    pc     = DAL.PianChangServer.search_pianChang_byP_id(p_id);

        s_width = Convert.ToInt32(Math.Floor((double)(600 / (dyt.T_line))));
        //s_heigh = Convert.ToInt32(Math.Floor((double)(600 / (dyt.T_line))));
        p_name.Text       = Y_name + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + dyt.T_name;
        m_name.InnerText  = movie.M_name;
        m_time.InnerText  = "片长:" + movie.M_minute + "分钟";
        m_voice.InnerText = "版本:" + movie.M_voice;

        yY_name.InnerText = Y_name;
        yT_name.InnerText = dyt.T_name;
        jiaGe.Text        = pc.P_price.ToString();

        string[] Day  = new string[] { "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" };
        string   week = Day[Convert.ToInt32(pc.P_time.DayOfWeek.ToString("d"))].ToString();

        p_time.InnerText = pc.P_time.Date.ToShortDateString() + "(" + week + ")" + pc.P_time.Hour + ":" + pc.P_time.Minute;

        for (int n = 1; n <= dyt.T_row; n++)
        {
            createCoulmn(n);
        }

        for (int n = 1; n <= dyt.T_row; n++)
        {
            for (int m = 1; m <= dyt.T_line; m++)
            {
                createSeat(n, m);
            }
        }
    }
Example #4
0
        /// <summary>
        /// 添加片场
        /// </summary>
        /// <param name="pc"></param>
        /// <returns></returns>

        public static bool Insert_DianYingTing(PianChang pc)
        {
            return(DAL.PianChangServer.Insert_DianYingTing(pc));
        }