/// <summary> /// 更新一条数据 /// </summary> public bool Update(Cms.Model.ws_Lottery model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ws_Lottery set "); strSql.Append("lname=@lname,"); strSql.Append("picurl=@picurl,"); strSql.Append("stime=@stime,"); strSql.Append("etime=@etime,"); strSql.Append("info=@info,"); strSql.Append("isnum=@isnum,"); strSql.Append("total=@total,"); strSql.Append("daynum=@daynum,"); strSql.Append("typeid=@typeid,"); strSql.Append("updatetime=@updatetime"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@lname", SqlDbType.NVarChar, 100), new SqlParameter("@picurl", SqlDbType.NVarChar, 50), new SqlParameter("@stime", SqlDbType.DateTime), new SqlParameter("@etime", SqlDbType.DateTime), new SqlParameter("@info", SqlDbType.NVarChar, 500), new SqlParameter("@isnum", SqlDbType.Int, 4), new SqlParameter("@total", SqlDbType.Int, 4), new SqlParameter("@daynum", SqlDbType.Int, 4), new SqlParameter("@typeid", SqlDbType.Int, 4), new SqlParameter("@updatetime", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.lname; parameters[1].Value = model.picurl; parameters[2].Value = model.stime; parameters[3].Value = model.etime; parameters[4].Value = model.info; parameters[5].Value = model.isnum; parameters[6].Value = model.total; parameters[7].Value = model.daynum; parameters[8].Value = model.typeid; parameters[9].Value = model.updatetime; parameters[10].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.ws_Lottery DataRowToModel(DataRow row) { Cms.Model.ws_Lottery model = new Cms.Model.ws_Lottery(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["lname"] != null) { model.lname = row["lname"].ToString(); } if (row["picurl"] != null) { model.picurl = row["picurl"].ToString(); } if (row["stime"] != null && row["stime"].ToString() != "") { model.stime = DateTime.Parse(row["stime"].ToString()); } if (row["etime"] != null && row["etime"].ToString() != "") { model.etime = DateTime.Parse(row["etime"].ToString()); } if (row["info"] != null) { model.info = row["info"].ToString(); } if (row["isnum"] != null && row["isnum"].ToString() != "") { model.isnum = int.Parse(row["isnum"].ToString()); } if (row["total"] != null && row["total"].ToString() != "") { model.total = int.Parse(row["total"].ToString()); } if (row["daynum"] != null && row["daynum"].ToString() != "") { model.daynum = int.Parse(row["daynum"].ToString()); } if (row["typeid"] != null && row["typeid"].ToString() != "") { model.typeid = int.Parse(row["typeid"].ToString()); } if (row["updatetime"] != null && row["updatetime"].ToString() != "") { model.updatetime = DateTime.Parse(row["updatetime"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Cms.Model.ws_Lottery model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ws_Lottery("); strSql.Append("lname,picurl,stime,etime,info,isnum,total,daynum,typeid,updatetime)"); strSql.Append(" values ("); strSql.Append("@lname,@picurl,@stime,@etime,@info,@isnum,@total,@daynum,@typeid,@updatetime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@lname", SqlDbType.NVarChar, 100), new SqlParameter("@picurl", SqlDbType.NVarChar, 50), new SqlParameter("@stime", SqlDbType.DateTime), new SqlParameter("@etime", SqlDbType.DateTime), new SqlParameter("@info", SqlDbType.NVarChar, 500), new SqlParameter("@isnum", SqlDbType.Int, 4), new SqlParameter("@total", SqlDbType.Int, 4), new SqlParameter("@daynum", SqlDbType.Int, 4), new SqlParameter("@typeid", SqlDbType.Int, 4), new SqlParameter("@updatetime", SqlDbType.DateTime) }; parameters[0].Value = model.lname; parameters[1].Value = model.picurl; parameters[2].Value = model.stime; parameters[3].Value = model.etime; parameters[4].Value = model.info; parameters[5].Value = model.isnum; parameters[6].Value = model.total; parameters[7].Value = model.daynum; parameters[8].Value = model.typeid; parameters[9].Value = model.updatetime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.ws_Lottery GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,lname,picurl,stime,etime,info,isnum,total,daynum,typeid,updatetime from ws_Lottery "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Cms.Model.ws_Lottery model = new Cms.Model.ws_Lottery(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }