/// <summary> /// 增加一条数据 /// </summary> public void Add(SeoWebSite.Model.BettingLine model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into bettingline("); strSql.Append("id,betmoney,returnmoney,profit,state,formulaid,userid)"); strSql.Append(" values ("); strSql.Append("@id,@betmoney,@returnmoney,@profit,@state,@formulaid,@userid)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar, 20), new SqlParameter("@betmoney", SqlDbType.Decimal, 9), new SqlParameter("@returnmoney", SqlDbType.Decimal, 9), new SqlParameter("@profit", SqlDbType.Decimal, 9), new SqlParameter("@state", SqlDbType.NVarChar, 50), new SqlParameter("@formulaid", SqlDbType.VarChar, 20), new SqlParameter("@userid", SqlDbType.VarChar, 20) }; parameters[0].Value = model.id; parameters[1].Value = model.betmoney; parameters[2].Value = model.returnmoney; parameters[3].Value = model.profit; parameters[4].Value = model.state; parameters[5].Value = model.formulaid; parameters[6].Value = model.userid; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SeoWebSite.Model.BettingLine model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update bettingline set "); strSql.Append("betmoney=@betmoney,"); strSql.Append("returnmoney=@returnmoney,"); strSql.Append("profit=@profit,"); strSql.Append("state=@state,"); strSql.Append("formulaid=@formulaid,"); strSql.Append("userid=@userid"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar, 20), new SqlParameter("@betmoney", SqlDbType.Decimal, 9), new SqlParameter("@returnmoney", SqlDbType.Decimal, 9), new SqlParameter("@profit", SqlDbType.Decimal, 9), new SqlParameter("@state", SqlDbType.NVarChar, 50), new SqlParameter("@formulaid", SqlDbType.VarChar, 20), new SqlParameter("@userid", SqlDbType.VarChar, 20) }; parameters[0].Value = model.id; parameters[1].Value = model.betmoney; parameters[2].Value = model.returnmoney; parameters[3].Value = model.profit; parameters[4].Value = model.state; parameters[5].Value = model.formulaid; parameters[6].Value = model.userid; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public SeoWebSite.Model.BettingLine GetModel(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,betmoney,returnmoney,profit,state,formulaid,userid from bettingline "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar, 50) }; parameters[0].Value = id; SeoWebSite.Model.BettingLine model = new SeoWebSite.Model.BettingLine(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.id = ds.Tables[0].Rows[0]["id"].ToString(); if (ds.Tables[0].Rows[0]["betmoney"].ToString() != "") { model.betmoney = decimal.Parse(ds.Tables[0].Rows[0]["betmoney"].ToString()); } if (ds.Tables[0].Rows[0]["returnmoney"].ToString() != "") { model.returnmoney = decimal.Parse(ds.Tables[0].Rows[0]["returnmoney"].ToString()); } if (ds.Tables[0].Rows[0]["profit"].ToString() != "") { model.profit = decimal.Parse(ds.Tables[0].Rows[0]["profit"].ToString()); } model.state = ds.Tables[0].Rows[0]["state"].ToString(); model.formulaid = ds.Tables[0].Rows[0]["formulaid"].ToString(); model.userid = ds.Tables[0].Rows[0]["userid"].ToString(); return(model); } else { return(null); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public SeoWebSite.Model.BettingLine GetModel(string id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 id,betmoney,returnmoney,profit,state,formulaid,userid from bettingline "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar,50)}; parameters[0].Value = id; SeoWebSite.Model.BettingLine model=new SeoWebSite.Model.BettingLine(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { model.id=ds.Tables[0].Rows[0]["id"].ToString(); if(ds.Tables[0].Rows[0]["betmoney"].ToString()!="") { model.betmoney=decimal.Parse(ds.Tables[0].Rows[0]["betmoney"].ToString()); } if(ds.Tables[0].Rows[0]["returnmoney"].ToString()!="") { model.returnmoney=decimal.Parse(ds.Tables[0].Rows[0]["returnmoney"].ToString()); } if(ds.Tables[0].Rows[0]["profit"].ToString()!="") { model.profit=decimal.Parse(ds.Tables[0].Rows[0]["profit"].ToString()); } model.state=ds.Tables[0].Rows[0]["state"].ToString(); model.formulaid=ds.Tables[0].Rows[0]["formulaid"].ToString(); model.userid=ds.Tables[0].Rows[0]["userid"].ToString(); return model; } else { return null; } }