/// <summary> /// 更新一条数据 /// </summary> public bool Update(Cms.Model.sc_statistics model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update sc_statistics set "); strSql.Append("typename=@typename,"); strSql.Append("typecontents=@typecontents,"); strSql.Append("msgnumber=@msgnumber,"); strSql.Append("visitnumber=@visitnumber,"); strSql.Append("gznumber=@gznumber,"); strSql.Append("qxnumber=@qxnumber,"); strSql.Append("doingnumber=@doingnumber,"); strSql.Append("zfnumber=@zfnumber,"); strSql.Append("updatetime=@updatetime"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@typename", SqlDbType.NVarChar, 50), new SqlParameter("@typecontents", SqlDbType.Text), new SqlParameter("@msgnumber", SqlDbType.Int, 4), new SqlParameter("@visitnumber", SqlDbType.Int, 4), new SqlParameter("@gznumber", SqlDbType.Int, 4), new SqlParameter("@qxnumber", SqlDbType.Int, 4), new SqlParameter("@doingnumber", SqlDbType.Int, 4), new SqlParameter("@zfnumber", SqlDbType.Int, 4), new SqlParameter("@updatetime", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.typename; parameters[1].Value = model.typecontents; parameters[2].Value = model.msgnumber; parameters[3].Value = model.visitnumber; parameters[4].Value = model.gznumber; parameters[5].Value = model.qxnumber; parameters[6].Value = model.doingnumber; parameters[7].Value = model.zfnumber; parameters[8].Value = model.updatetime; parameters[9].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.sc_statistics DataRowToModel(DataRow row) { Cms.Model.sc_statistics model = new Cms.Model.sc_statistics(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["typename"] != null) { model.typename = row["typename"].ToString(); } if (row["typecontents"] != null) { model.typecontents = row["typecontents"].ToString(); } if (row["msgnumber"] != null && row["msgnumber"].ToString() != "") { model.msgnumber = int.Parse(row["msgnumber"].ToString()); } if (row["visitnumber"] != null && row["visitnumber"].ToString() != "") { model.visitnumber = int.Parse(row["visitnumber"].ToString()); } if (row["gznumber"] != null && row["gznumber"].ToString() != "") { model.gznumber = int.Parse(row["gznumber"].ToString()); } if (row["qxnumber"] != null && row["qxnumber"].ToString() != "") { model.qxnumber = int.Parse(row["qxnumber"].ToString()); } if (row["doingnumber"] != null && row["doingnumber"].ToString() != "") { model.doingnumber = int.Parse(row["doingnumber"].ToString()); } if (row["zfnumber"] != null && row["zfnumber"].ToString() != "") { model.zfnumber = int.Parse(row["zfnumber"].ToString()); } if (row["updatetime"] != null && row["updatetime"].ToString() != "") { model.updatetime = DateTime.Parse(row["updatetime"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Cms.Model.sc_statistics model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sc_statistics("); strSql.Append("typename,typecontents,msgnumber,visitnumber,gznumber,qxnumber,doingnumber,zfnumber,updatetime)"); strSql.Append(" values ("); strSql.Append("@typename,@typecontents,@msgnumber,@visitnumber,@gznumber,@qxnumber,@doingnumber,@zfnumber,@updatetime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@typename", SqlDbType.NVarChar, 50), new SqlParameter("@typecontents", SqlDbType.Text), new SqlParameter("@msgnumber", SqlDbType.Int, 4), new SqlParameter("@visitnumber", SqlDbType.Int, 4), new SqlParameter("@gznumber", SqlDbType.Int, 4), new SqlParameter("@qxnumber", SqlDbType.Int, 4), new SqlParameter("@doingnumber", SqlDbType.Int, 4), new SqlParameter("@zfnumber", SqlDbType.Int, 4), new SqlParameter("@updatetime", SqlDbType.DateTime) }; parameters[0].Value = model.typename; parameters[1].Value = model.typecontents; parameters[2].Value = model.msgnumber; parameters[3].Value = model.visitnumber; parameters[4].Value = model.gznumber; parameters[5].Value = model.qxnumber; parameters[6].Value = model.doingnumber; parameters[7].Value = model.zfnumber; parameters[8].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.sc_statistics GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,typename,typecontents,msgnumber,visitnumber,gznumber,qxnumber,doingnumber,zfnumber,updatetime from sc_statistics "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Cms.Model.sc_statistics model = new Cms.Model.sc_statistics(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }