/// <summary> /// 增加一条数据 /// </summary> public int Add(XCWeiXin.Model.wx_dati_base model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into wx_dati_base("); strSql.Append("wid,title,bjcolor,summary,dttime,isshowend,addtime,dxtitle,dxgetnum,dxscore,headimg,starttime,endtime,jftype,jfval)"); strSql.Append(" values ("); strSql.Append("@wid,@title,@bjcolor,@summary,@dttime,@isshowend,@addtime,@dxtitle,@dxgetnum,@dxscore,@headimg,@starttime,@endtime,@jftype,@jfval)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@wid", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 200), new SqlParameter("@bjcolor", SqlDbType.VarChar, 200), new SqlParameter("@summary", SqlDbType.VarChar, 500), new SqlParameter("@dttime", SqlDbType.Int, 4), new SqlParameter("@isshowend", SqlDbType.Bit), new SqlParameter("@addtime", SqlDbType.DateTime), new SqlParameter("@dxtitle", SqlDbType.VarChar, 50), new SqlParameter("@dxgetnum", SqlDbType.Int, 4), new SqlParameter("@dxscore", SqlDbType.Int, 4), new SqlParameter("@headimg", SqlDbType.VarChar, 200), new SqlParameter("@starttime", SqlDbType.DateTime), new SqlParameter("@endtime", SqlDbType.DateTime), new SqlParameter("@jftype", SqlDbType.Int, 4), new SqlParameter("@jfval", SqlDbType.Int, 4), }; parameters[0].Value = model.wid; parameters[1].Value = model.title; parameters[2].Value = model.bjcolor; parameters[3].Value = model.summary; parameters[4].Value = model.dttime; parameters[5].Value = model.isshowend; parameters[6].Value = model.addtime; parameters[7].Value = model.dxtitle; parameters[8].Value = model.dxgetnum; parameters[9].Value = model.dxscore; parameters[10].Value = model.headimg; parameters[11].Value = model.starttime; parameters[12].Value = model.endtime; parameters[13].Value = model.jftype; parameters[14].Value = model.jfval; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XCWeiXin.Model.wx_dati_base GetModel(string whereStr) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from wx_dati_base "); if (whereStr.Trim() != "") { strSql.Append(" where " + whereStr); } XCWeiXin.Model.wx_dati_base model = new XCWeiXin.Model.wx_dati_base(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XCWeiXin.Model.wx_dati_base GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from wx_dati_base "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; XCWeiXin.Model.wx_dati_base model = new XCWeiXin.Model.wx_dati_base(); 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 XCWeiXin.Model.wx_dati_base DataRowToModel(DataRow row) { XCWeiXin.Model.wx_dati_base model = new XCWeiXin.Model.wx_dati_base(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["wid"] != null && row["wid"].ToString() != "") { model.wid = int.Parse(row["wid"].ToString()); } if (row["title"] != null) { model.title = row["title"].ToString(); } if (row["bjcolor"] != null) { model.bjcolor = row["bjcolor"].ToString(); } if (row["summary"] != null) { model.summary = row["summary"].ToString(); } if (row["isshowend"] != null && row["isshowend"].ToString() != "") { if ((row["isshowend"].ToString() == "1") || (row["isshowend"].ToString().ToLower() == "true")) { model.isshowend = true; } else { model.isshowend = false; } } if (row["dttime"] != null) { model.dttime = int.Parse(row["dttime"].ToString()); } if (row["addtime"] != null) { model.addtime = DateTime.Parse(row["addtime"].ToString()); } if (row["dxtitle"] != null) { model.dxtitle = row["dxtitle"].ToString(); } if (row["dxgetnum"] != null && row["dxgetnum"].ToString() != "") { model.dxgetnum = int.Parse(row["dxgetnum"].ToString()); } if (row["dxscore"] != null) { model.dxscore = int.Parse(row["dxscore"].ToString()); } if (row["starttime"] != null) { model.starttime = DateTime.Parse(row["starttime"].ToString()); } if (row["endtime"] != null) { model.endtime = DateTime.Parse(row["endtime"].ToString()); } if (row["headimg"] != null) { model.headimg = row["headimg"].ToString(); } if (row["jftype"] != null) { model.jftype = int.Parse(row["jftype"].ToString()); } if (row["jfval"] != null) { model.jfval = int.Parse(row["jfval"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XCWeiXin.Model.wx_dati_base model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update wx_dati_base set "); strSql.Append("wid=@wid,"); strSql.Append("title=@title,"); strSql.Append("bjcolor=@bjcolor,"); strSql.Append("summary=@summary,"); strSql.Append("dttime=@dttime,"); strSql.Append("isshowend=@isshowend,"); strSql.Append("addtime=@addtime,"); strSql.Append("dxtitle=@dxtitle,"); strSql.Append("dxgetnum=@dxgetnum,"); strSql.Append("dxscore=@dxscore,"); strSql.Append("headimg=@headimg,"); strSql.Append("starttime=@starttime,"); strSql.Append("endtime=@endtime,"); strSql.Append("jftype=@jftype,"); strSql.Append("jfval=@jfval"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@wid", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 200), new SqlParameter("@bjcolor", SqlDbType.VarChar, 200), new SqlParameter("@summary", SqlDbType.VarChar, 500), new SqlParameter("@dttime", SqlDbType.Int, 4), new SqlParameter("@isshowend", SqlDbType.Bit), new SqlParameter("@addtime", SqlDbType.DateTime), new SqlParameter("@dxtitle", SqlDbType.VarChar, 50), new SqlParameter("@dxgetnum", SqlDbType.Int, 4), new SqlParameter("@dxscore", SqlDbType.Int, 4), new SqlParameter("@headimg", SqlDbType.VarChar, 200), new SqlParameter("@starttime", SqlDbType.DateTime), new SqlParameter("@endtime", SqlDbType.DateTime), new SqlParameter("@jftype", SqlDbType.Int, 4), new SqlParameter("@jfval", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.wid; parameters[1].Value = model.title; parameters[2].Value = model.bjcolor; parameters[3].Value = model.summary; parameters[4].Value = model.dttime; parameters[5].Value = model.isshowend; parameters[6].Value = model.addtime; parameters[7].Value = model.dxtitle; parameters[8].Value = model.dxgetnum; parameters[9].Value = model.dxscore; parameters[10].Value = model.headimg; parameters[11].Value = model.starttime; parameters[12].Value = model.endtime; parameters[13].Value = model.jftype; parameters[14].Value = model.jfval; parameters[15].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }