public static int Add(AgreementModel model) { var command = _dbBaseProvider.CreateCommandStruct("AgreementClass", CommandMode.Insert); command.AddParameter("GameID", model.GameID); command.AddParameter("Title", model.Title); command.AddParameter("Describe", model.Describe); command.ReturnIdentity = true; command.Parser(); using (var reader = _dbBaseProvider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { if (reader.Read()) { model.AgreementID = reader[0].ToInt(); } } return model.AgreementID; }
protected void butSubmit_Click(object sender, EventArgs e) { try { AgreementModel model = new AgreementModel(); model.Title = Title.Text.Trim(); model.Describe = Describe.Text.Trim(); model.GameID = Convert.ToInt32(Request.QueryString["gameid"]); if (DbDataLoader.Add(model) > 0) { Page.RegisterStartupScript("", "<script language=javascript>alert('添加成功!')</script>"); } } catch(Exception ex) { Page.RegisterStartupScript("", "<script language=javascript>alert('添加失败,填写重复!')</script>"); } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); string Title = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Title")).Text; string Describe = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Describe")).Text; AgreementModel mode = new AgreementModel(); mode.AgreementID = id; mode.Title = Title; mode.Describe = Describe; if (DbDataLoader.Update(mode)) { GridView1.EditIndex = -1; BindData(); } } catch (Exception erro) { Response.Write("错误信息:" + erro.Message); } }
public static bool Update(AgreementModel model) { var command = _dbBaseProvider.CreateCommandStruct("AgreementClass", CommandMode.Modify); command.AddParameter("Title", model.Title); command.AddParameter("Describe", model.Describe); command.Filter = _dbBaseProvider.CreateCommandFilter(); command.Filter.Condition = _dbBaseProvider.FormatFilterParam("AgreementID"); command.Filter.AddParam("AgreementID", model.AgreementID); command.Parser(); return _dbBaseProvider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters) > 0; }
public static List<AgreementModel> GetAgreement(Action<CommandFilter> match) { var command = _dbBaseProvider.CreateCommandStruct("AgreementClass", CommandMode.Inquiry); command.Columns = string.Format("AgreementID,GameID,Title,Describe,CreateDate,(SELECT SLNNAME FROM SOLUTIONS WHERE SLNID={0}.GAMEID) SlnName", command.TableName); command.OrderBy = "AgreementID ASC"; command.Filter = _dbBaseProvider.CreateCommandFilter(); if (match != null) { match(command.Filter); } command.Parser(); var list = new List<AgreementModel>(); using (var reader = _dbBaseProvider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { while (reader.Read()) { AgreementModel model = new AgreementModel(); model.AgreementID = reader["AgreementID"].ToInt(); model.GameID = reader["GameID"].ToInt(); model.Title = reader["Title"].ToNotNullString(); model.Describe = reader["Describe"].ToNotNullString(); model.CreateDate = reader["CreateDate"].ToDateTime(); model.SlnName = reader["SlnName"].ToNotNullString(); list.Add(model); } } return list; }