/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(entity_ScheduleDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_ScheduleDetail set ");
strSql.Append("HomeCourt=@HomeCourt,");
strSql.Append("HomeCourtName=@HomeCourtName,");
strSql.Append("HomeCourt_Fraction=@HomeCourt_Fraction,");
strSql.Append("away=@away,");
strSql.Append("awayName=@awayName,");
strSql.Append("away_Fraction=@away_Fraction,");
strSql.Append("State=@State,");
strSql.Append("StartTime=@StartTime,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("T_Extend1=@T_Extend1,");
strSql.Append("T_Extend2=@T_Extend2,");
strSql.Append("T_Extend3=@T_Extend3");
strSql.Append(" where SID=@SID ");
SqlParameter[] parameters =
{
new SqlParameter("@HomeCourt", SqlDbType.NVarChar, 50),
new SqlParameter("@HomeCourtName", SqlDbType.NVarChar, 50),
new SqlParameter("@HomeCourt_Fraction", SqlDbType.Int, 4),
new SqlParameter("@away", SqlDbType.NVarChar, 50),
new SqlParameter("@awayName", SqlDbType.NVarChar, 50),
new SqlParameter("@away_Fraction", SqlDbType.Int, 4),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@T_Extend1", SqlDbType.NVarChar, 50),
new SqlParameter("@T_Extend2", SqlDbType.NVarChar, 50),
new SqlParameter("@T_Extend3", SqlDbType.NVarChar, 50),
new SqlParameter("@SID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.HomeCourt;
parameters[1].Value = model.HomeCourtName;
parameters[2].Value = model.HomeCourt_Fraction;
parameters[3].Value = model.away;
parameters[4].Value = model.awayName;
parameters[5].Value = model.away_Fraction;
parameters[6].Value = model.State;
parameters[7].Value = model.StartTime;
parameters[8].Value = model.EndTime;
parameters[9].Value = model.T_Extend1;
parameters[10].Value = model.T_Extend2;
parameters[11].Value = model.T_Extend3;
parameters[12].Value = model.SID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void DataBind()
{
entity_ScheduleDetail entity = new entity_ScheduleDetail();
entity = bll_sd.GetModel(pid);
this.lab_zhu.Text = entity.HomeCourtName;
this.lab_ke.Text = entity.awayName;
}
protected void Submit_Click(object sender, EventArgs e)
{
if (this.ddl_zhudui.SelectedValue == this.ddl_kedui.SelectedValue)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('主队跟客队不能选择同一个实验室');</script>");
return;
}
if (this.CreateTime.Value == "")
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('开始时间不能空');</script>");
return;
}
entity_ScheduleDetail entity = new entity_ScheduleDetail();
bool Success = false;
if (type == "add")
{
entity.SID = Guid.NewGuid().ToString();
entity.T_Extend1 = pid;
entity.HomeCourt = this.ddl_zhudui.SelectedValue;
entity.HomeCourtName = this.ddl_zhudui.Text;
entity.away = this.ddl_kedui.SelectedValue;
entity.awayName = this.ddl_kedui.Text;
entity.StartTime = DateTime.Parse(this.CreateTime.Value);
entity.CreaterTime = DateTime.Now;
Success = ScheduleDetail.Add(entity);
if (Success)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加成功');</script>");
Response.Redirect("MatchList.aspx?mm=" + new Random().Next() + "&sid=" + entity.T_Extend1);
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加失败');</script>");
}
}
if (type == "update")
{
entity = ScheduleDetail.GetModel(sid);
entity.HomeCourt = this.ddl_zhudui.SelectedValue;
entity.HomeCourtName = this.ddl_zhudui.Text;
entity.away = this.ddl_kedui.SelectedValue;
entity.awayName = this.ddl_kedui.Text;
entity.StartTime = DateTime.Parse(this.CreateTime.Value);
Success = ScheduleDetail.Update(entity);
if (Success)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('修改成功');</script>");
Response.Redirect("MatchList.aspx?mm=" + new Random().Next() + "&sid=" + entity.T_Extend1);
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('修改失败');</script>");
}
}
}
private void DataBind(string sid)
{
entity_ScheduleDetail news = bll.GetModel(sid);
this.title.Text = news.HomeCourtName + " VS " + news.awayName;
ReleaseDate.Text = news.StartTime.ToString();
ReleaseDate2.Text = news.EndTime.ToString();
lab_one.Text = news.HomeCourt_Fraction.ToString();
lab_two.Text = news.away_Fraction.ToString();
lab_zt.Text = news.hh_State;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(entity_ScheduleDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_ScheduleDetail(");
strSql.Append("SID,HomeCourt,HomeCourtName,HomeCourt_Fraction,away,awayName,away_Fraction,State,StartTime,EndTime,T_Extend1,T_Extend2,T_Extend3)");
strSql.Append(" values (");
strSql.Append("@SID,@HomeCourt,@HomeCourtName,@HomeCourt_Fraction,@away,@awayName,@away_Fraction,@State,@StartTime,@EndTime,@T_Extend1,@T_Extend2,@T_Extend3,@CreaterTime)");
SqlParameter[] parameters =
{
new SqlParameter("@SID", SqlDbType.NVarChar, 50),
new SqlParameter("@HomeCourt", SqlDbType.NVarChar, 50),
new SqlParameter("@HomeCourtName", SqlDbType.NVarChar, 50),
new SqlParameter("@HomeCourt_Fraction", SqlDbType.Int, 4),
new SqlParameter("@away", SqlDbType.NVarChar, 50),
new SqlParameter("@awayName", SqlDbType.NVarChar, 50),
new SqlParameter("@away_Fraction", SqlDbType.Int, 4),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@T_Extend1", SqlDbType.NVarChar, 50),
new SqlParameter("@T_Extend2", SqlDbType.NVarChar, 50),
new SqlParameter("@T_Extend3", SqlDbType.NVarChar, 50),
new SqlParameter("@CreaterTime", SqlDbType.DateTime)
};
parameters[0].Value = model.SID;
parameters[1].Value = model.HomeCourt;
parameters[2].Value = model.HomeCourtName;
parameters[3].Value = model.HomeCourt_Fraction;
parameters[4].Value = model.away;
parameters[5].Value = model.awayName;
parameters[6].Value = model.away_Fraction;
parameters[7].Value = model.State;
parameters[8].Value = model.StartTime;
parameters[9].Value = model.EndTime;
parameters[10].Value = model.T_Extend1;
parameters[11].Value = model.T_Extend2;
parameters[12].Value = model.T_Extend3;
parameters[13].Value = model.CreaterTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
entity_ScheduleDetail entity = new entity_ScheduleDetail();
entity = bll_sd.GetModel(pid);
entity.EndTime = DateTime.Now;
entity.HomeCourt_Fraction = Int32.Parse(this.tbx_Fraction1.Text);
entity.away_Fraction = Int32.Parse(this.tbx_Fraction2.Text);
entity.State = 2;
bll_sd.Update(entity);
Response.Redirect("MatchList.aspx?mm=" + new Random().Next() + "&sid=" + entity.T_Extend1);
}
protected void btn_3_Click(object sender, EventArgs e)
{
entity_ScheduleDetail entity = new entity_ScheduleDetail();
entity = bll_sd.GetModel(pid);
entity_gameLog model = new entity_gameLog();
model.SID = Guid.NewGuid().ToString();
model.PID = pid;
model.CreateTime = DateTime.Now;
model.Score = 2;
model.TeamID = entity.HomeCourt;
model.TeamName = entity.HomeCourtName;
bll_gl.Add(model);
Additive(this.tbx_Fraction1.Text, 3);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public entity_ScheduleDetail GetModel(string SID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from T_ScheduleDetail ");
strSql.Append(" where SID=@SID ");
SqlParameter[] parameters =
{
new SqlParameter("@SID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = SID;
entity_ScheduleDetail model = new entity_ScheduleDetail();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public entity_ScheduleDetail DataRowToModel(DataRow row)
{
entity_ScheduleDetail model = new entity_ScheduleDetail();
if (row != null)
{
if (row["SID"] != null)
{
model.SID = row["SID"].ToString();
}
if (row["HomeCourt"] != null)
{
model.HomeCourt = row["HomeCourt"].ToString();
}
if (row["HomeCourtName"] != null)
{
model.HomeCourtName = row["HomeCourtName"].ToString();
}
if (row["HomeCourt_Fraction"] != null && row["HomeCourt_Fraction"].ToString() != "")
{
model.HomeCourt_Fraction = int.Parse(row["HomeCourt_Fraction"].ToString());
}
if (row["away"] != null)
{
model.away = row["away"].ToString();
}
if (row["awayName"] != null)
{
model.awayName = row["awayName"].ToString();
}
if (row["away_Fraction"] != null && row["away_Fraction"].ToString() != "")
{
model.away_Fraction = int.Parse(row["away_Fraction"].ToString());
}
if (row["State"] != null && row["State"].ToString() != "")
{
model.State = int.Parse(row["State"].ToString());
}
if (row["StartTime"] != null && row["StartTime"].ToString() != "")
{
model.StartTime = DateTime.Parse(row["StartTime"].ToString());
}
if (row["EndTime"] != null && row["EndTime"].ToString() != "")
{
model.EndTime = DateTime.Parse(row["EndTime"].ToString());
}
if (row["T_Extend1"] != null)
{
model.T_Extend1 = row["T_Extend1"].ToString();
}
if (row["T_Extend2"] != null)
{
model.T_Extend2 = row["T_Extend2"].ToString();
}
if (row["T_Extend3"] != null)
{
model.T_Extend3 = row["T_Extend3"].ToString();
}
if (row["CreaterTime"] != null)
{
model.CreaterTime = DateTime.Parse(row["CreaterTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(entity_ScheduleDetail model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(entity_ScheduleDetail model)
{
return(dal.Add(model));
}
