/// <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)); }