/// <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);
}
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 + " " + 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);
}
}
}
/// <summary>
/// 添加片场
/// </summary>
/// <param name="pc"></param>
/// <returns></returns>
public static bool Insert_DianYingTing(PianChang pc)
{
return(DAL.PianChangServer.Insert_DianYingTing(pc));
}