/// <summary> /// 增加一条数据 /// </summary> public int Add(SolutionModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Solutions("); strSql.Append("SlnName,Namespace,RefNamespace,Url,GameID)"); strSql.Append(" values ("); strSql.Append("@SlnName,@Namespace,@RefNamespace,@Url,@GameID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SlnName", SqlDbType.VarChar, 0), new SqlParameter("@Namespace", SqlDbType.VarChar, 0), new SqlParameter("@RefNamespace", SqlDbType.VarChar, 0), new SqlParameter("@Url", SqlDbType.VarChar, 0), new SqlParameter("@GameID", SqlDbType.Int, 4) }; parameters[0].Value = model.SlnName; parameters[1].Value = model.Namespace; parameters[2].Value = model.RefNamespace; parameters[3].Value = model.Url; parameters[4].Value = model.GameID; object obj = SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); string SlnName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("SlnName")).Text; string Namespace = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Namespace")).Text; string RefNamespace = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("RefNamespace")).Text; string url = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Url")).Text; string gameid = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("gameid")).Text; SolutionModel mode = new SolutionModel(); mode.SlnID = id; mode.SlnName = SlnName; mode.Namespace = Namespace; mode.RefNamespace = RefNamespace; mode.Url = url; mode.GameID = Convert.ToInt32(gameid); SolutionBLL Pinfo = new SolutionBLL(); if (Pinfo.Update(mode)) { GridView1.EditIndex = -1; BindData(); } } catch (Exception erro) { Response.Write("错误信息:" + erro.Message); } }
protected void butSubmit_Click(object sender, EventArgs e) { try { SolutionBLL con = new SolutionBLL(); SolutionModel model = new SolutionModel(); model.SlnName = txtDescption.Text.Trim(); model.Namespace = txtNamespace.Text.Trim(); model.RefNamespace = txtRefNamespace.Text.Trim(); model.GameID = Convert.ToInt32(txtGameID.Text); model.Url = txtUrl.Text.Trim(); if (con.Add(model) > 0) { Response.Redirect("SolutionsList.aspx"); } } catch(Exception ex) { Page.RegisterStartupScript("", "<script language=javascript>alert('添加失败,填写重复!')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { this.txtServerUrl.Text = GetCookies(string.Empty); if (this.txtServerUrl.Text.Length == 0) { this.txtServerUrl.Text = new SolutionBLL().GetUrl(SlnID); } SolutionModel solutionModel = new SolutionModel(); this.lbtGmeID.Text = new SolutionBLL().GetGameID(SlnID); ddlServerID.Items.Clear(); DataSet ds = new SolutionBLL().GetServerList(" GameID="+lbtGmeID.Text); ddlServerID.DataSource = ds; ddlServerID.DataTextField = "ServerName"; ddlServerID.DataValueField = "ID"; ddlServerID.DataBind(); BindContract(); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SolutionModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Solutions set "); strSql.Append("SlnName=@SlnName,Namespace=@Namespace,RefNamespace=@RefNamespace,Url=@Url,GameID=@GameID"); strSql.Append(" where SlnID=@SlnID"); SqlParameter[] parameters = { new SqlParameter("@SlnID", SqlDbType.Int,4), new SqlParameter("@SlnName", SqlDbType.VarChar, 0), new SqlParameter("@Namespace", SqlDbType.VarChar, 0), new SqlParameter("@RefNamespace", SqlDbType.VarChar, 0), new SqlParameter("@Url", SqlDbType.VarChar, 0), new SqlParameter("@GameID", SqlDbType.Int, 4) }; parameters[0].Value = model.SlnID; parameters[1].Value = model.SlnName; parameters[2].Value = model.Namespace; parameters[3].Value = model.RefNamespace; parameters[4].Value = model.Url; parameters[5].Value = model.GameID; int rows = SqlHelper.ExecuteNonQuery(connectionString,CommandType.Text,strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SolutionModel model) { return dal.Update(model); }
/// <summary> /// 添加一条数据 /// </summary> public int Add(SolutionModel model) { return dal.Add(model); }