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