/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.fenshu_tongji_fenxiang model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update fenshu_tongji_fenxiang set "); strSql.Append("name=@name,"); strSql.Append("kecheng=@kecheng,"); strSql.Append("jiangshi=@jiangshi,"); strSql.Append("text=@text,"); strSql.Append("count_fenshu=@count_fenshu,"); strSql.Append("avg_fenshu=@avg_fenshu,"); strSql.Append("shangke_id=@shangke_id,"); strSql.Append("peixunban_id=@peixunban_id"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NChar, 10), new SqlParameter("@kecheng", SqlDbType.NVarChar, 50), new SqlParameter("@jiangshi", SqlDbType.NChar, 10), new SqlParameter("@text", SqlDbType.NVarChar, 50), new SqlParameter("@count_fenshu", SqlDbType.Int, 4), new SqlParameter("@avg_fenshu", SqlDbType.Float, 8), new SqlParameter("@shangke_id", SqlDbType.Int, 4), new SqlParameter("@peixunban_id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.kecheng; parameters[2].Value = model.jiangshi; parameters[3].Value = model.text; parameters[4].Value = model.count_fenshu; parameters[5].Value = model.avg_fenshu; parameters[6].Value = model.shangke_id; parameters[7].Value = model.peixunban_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.fenshu_tongji_fenxiang DataRowToModel(DataRow row) { Maticsoft.Model.fenshu_tongji_fenxiang model = new Maticsoft.Model.fenshu_tongji_fenxiang(); if (row != null) { if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["kecheng"] != null) { model.kecheng = row["kecheng"].ToString(); } if (row["jiangshi"] != null) { model.jiangshi = row["jiangshi"].ToString(); } if (row["text"] != null) { model.text = row["text"].ToString(); } if (row["count_fenshu"] != null && row["count_fenshu"].ToString() != "") { model.count_fenshu = int.Parse(row["count_fenshu"].ToString()); } if (row["avg_fenshu"] != null && row["avg_fenshu"].ToString() != "") { model.avg_fenshu = decimal.Parse(row["avg_fenshu"].ToString()); } if (row["shangke_id"] != null && row["shangke_id"].ToString() != "") { model.shangke_id = int.Parse(row["shangke_id"].ToString()); } if (row["peixunban_id"] != null && row["peixunban_id"].ToString() != "") { model.peixunban_id = int.Parse(row["peixunban_id"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.fenshu_tongji_fenxiang model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fenshu_tongji_fenxiang("); strSql.Append("name,kecheng,jiangshi,text,count_fenshu,avg_fenshu,shangke_id,peixunban_id)"); strSql.Append(" values ("); strSql.Append("@name,@kecheng,@jiangshi,@text,@count_fenshu,@avg_fenshu,@shangke_id,@peixunban_id)"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NChar, 10), new SqlParameter("@kecheng", SqlDbType.NVarChar, 50), new SqlParameter("@jiangshi", SqlDbType.NChar, 10), new SqlParameter("@text", SqlDbType.NVarChar, 50), new SqlParameter("@count_fenshu", SqlDbType.Int, 4), new SqlParameter("@avg_fenshu", SqlDbType.Float, 8), new SqlParameter("@shangke_id", SqlDbType.Int, 4), new SqlParameter("@peixunban_id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.kecheng; parameters[2].Value = model.jiangshi; parameters[3].Value = model.text; parameters[4].Value = model.count_fenshu; parameters[5].Value = model.avg_fenshu; parameters[6].Value = model.shangke_id; parameters[7].Value = model.peixunban_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.fenshu_tongji_fenxiang GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 name,kecheng,jiangshi,text,count_fenshu,avg_fenshu,shangke_id,peixunban_id from fenshu_tongji_fenxiang "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.fenshu_tongji_fenxiang model = new Maticsoft.Model.fenshu_tongji_fenxiang(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }