/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.BF_ZD_CITY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [BF_ZD_CITY] set "); strSql.Append("[PROVID]=@PROVID,"); strSql.Append("[CITYCODE]=@CITYCODE,"); strSql.Append("[CITYNAME]=@CITYNAME,"); strSql.Append("[CITYORD]=@CITYORD,"); strSql.Append("[SPEC16]=@SPEC16,"); strSql.Append("[SPEC32]=@SPEC32"); strSql.Append(" where [CITYID]=@CITYID"); SqlParameter[] parameters = { new SqlParameter("@CITYID", SqlDbType.Int), new SqlParameter("@PROVID", SqlDbType.Int), new SqlParameter("@CITYCODE", SqlDbType.VarChar, 100), new SqlParameter("@CITYNAME", SqlDbType.VarChar, 100), new SqlParameter("@CITYORD", SqlDbType.Int), new SqlParameter("@SPEC16", SqlDbType.VarChar, 16), new SqlParameter("@SPEC32", SqlDbType.VarChar, 32) }; parameters[0].Value = model.CITYID; parameters[1].Value = model.PROVID; parameters[2].Value = model.CITYCODE; parameters[3].Value = model.CITYNAME; parameters[4].Value = model.CITYORD; parameters[5].Value = model.SPEC16; parameters[6].Value = model.SPEC32; return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private Hi.Model.BF_ZD_CITY GetModel(DataRow r) { Hi.Model.BF_ZD_CITY model = new Hi.Model.BF_ZD_CITY(); model.CITYID = SqlHelper.GetInt(r["CITYID"]); model.PROVID = SqlHelper.GetInt(r["PROVID"]); model.CITYCODE = SqlHelper.GetString(r["CITYCODE"]); model.CITYNAME = SqlHelper.GetString(r["CITYNAME"]); model.CITYORD = SqlHelper.GetInt(r["CITYORD"]); model.SPEC16 = SqlHelper.GetString(r["SPEC16"]); model.SPEC32 = SqlHelper.GetString(r["SPEC32"]); return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.BF_ZD_CITY model) { model.CITYID = GetMaxId() + 1; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [BF_ZD_CITY]("); strSql.Append("[CITYID])"); strSql.Append(" values ("); strSql.Append("@CITYID)"); SqlParameter[] parameters = { new SqlParameter("@CITYID", SqlDbType.Int) }; parameters[0].Value = model.CITYID; if (SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0) { return(model.CITYID); } else { return(0); } }