C#读取SQL数据库，并将读取的数据上传至服务简易Demo

1.使用的NuGet包

2.IRepository 接口

{
      
       IEnumerable<Package> GetAllPackages();
       void DeleteByCodePackages(string code);
       // void InitRepository();
 
   }

　　3.SimpleRepository类

public class SimpleRepository : IRepository
   {
 
       public IDbConnection PicInfoConnection => new SQLiteConnection($"datasource=\"{AppDomain.CurrentDomain.BaseDirectory}\\PicUp\\picinfos.db\";cache_size=10000");
 
       /// <summary>
       /// 获取所有数据
       /// </summary>
       /// <returns></returns>
       public IEnumerable<Package> GetAllPackages()
       {
           return PicInfoConnection.Query<Package>("select * from packages order by id desc");
       }
 
       //public void InitRepository()
       //{
       //    try
       //    {
 
       //        if (!File.Exists(AppDomain.CurrentDomain.BaseDirectory + "picinfos.db"))
       //            PicInfoConnection.Execute(createPicInfoSQL);
       //    }
       //    catch (Exception ex)
       //    {
 
       //    }
       //}
 
       //private string createPicInfoSQL =
       //   "-- ----------------------------\n-- Table structure for picinfos\n-- ----------------------------\nDROP TABLE IF EXISTS \"picinfos\";\nCREATE TABLE \"picinfos\" (\n  \"id\" INTEGER NOT NULL,\n  \"barcode\" TEXT,\n  \"pic_path\" TEXT,\n  \"update_time\" text,\n  \"mark\" integer,\n  PRIMARY KEY (\"id\")\n);";
 
 
       /// <summary>
       /// 清除指定条码的数据
       /// </summary>
       /// <returns></returns>
       public void DeleteByCodePackages(string code)
       {
           string sqlStr = $"DELETE  from packages WHERE barcode = '{code}'";
           PicInfoConnection.Execute(sqlStr);
       }
   }
 
 
  
   public class Package
   {
       public int Id { get; set; }
 
       public string barcode { get; set; }
 
       public string pic_path { get; set; }
 
       public DateTime? update_time { get; set; }
 
       public string? mark { get; set; }
 
   }
   

　　4.App.xaml.cs

   public partial class App : Application
    {
        public static Autofac.IContainer Container { get; set; }
        public App()
        {
            InitializeComponent();
            BuildDependency();

        }
        public static void BuildDependency()
        {
            var Builder = new ContainerBuilder();

          
            Builder.RegisterType<picUp.SimpleRepository>().As<IRepository>().SingleInstance();
          

            Container = Builder.Build();

          //  Container.Resolve<IRepository>().InitRepository();
            //Container.Resolve<UploadJob>();
        }

5.MainWindow.xaml

 <Grid>
        <Grid.RowDefinitions>
            <RowDefinition/>
            <RowDefinition/>
            <RowDefinition/>
            <RowDefinition/>
        </Grid.RowDefinitions>
        <Grid.ColumnDefinitions>
            <ColumnDefinition/>
            <ColumnDefinition/>
        </Grid.ColumnDefinitions>
        <TextBlock Text="图片上传服务地址:"  VerticalAlignment="Center" FontWeight="Bold" />
        <TextBox x:Name="txtBaseUrl" Margin="3" Height="25" Width="350" Grid.Row="1" Grid.ColumnSpan="2" HorizontalAlignment="Left"/>
        <Button x:Name="btUpload" Click="btUpload_Click"  Grid.Row="3" Style="{StaticResource ButtonPrimary}" Margin="10" Grid.Column="0" Content="上传"/>
        <Button x:Name="btClose" Click="btClose_Click"  Grid.Row="3"  Style="{StaticResource ButtonPrimary}" Margin="10" Grid.Column="1" Content="退出"/>
    </Grid>

6.MainWindow.xaml.cs

  public partial class MainWindow : Window
    {
        private IRepository _repository;
        public MainWindow( )
        {         
            InitializeComponent();
            _repository = App.Container.Resolve<IRepository>();
           var picinfo=  _repository.GetAllPackages();
           IEnumerator enumerator= picinfo.GetEnumerator();

            var piclist=new List<Package>();
            while (enumerator.MoveNext())
            {
                Package item = (Package)enumerator.Current;
                piclist.Add(item);
            }

            for (int i = 0; i < piclist.Count; i++)
            {
                string barcode = piclist[i].barcode;
                string picUrl = piclist[i].pic_path;
                //  Upload(txtBaseUrl.Text, barcode, picUrl);

                MessageBox.Show(barcode);
            }

          
        }

        /// <summary>
        /// 例子
        /// </summary>
        /// <param name="url"></param>
        /// <param name="barcode"></param>
        /// <param name="picUrl"></param>
        /// <returns></returns>
        private static bool Upload(string url, string barcode, string picUrl)
        {

            RestClient client = new RestClient();
            client.Timeout = 5000;
            client.ReadWriteTimeout = 5000;

            client.BaseUrl = new Uri($"http://{url}/ydadl/public/common/commitScanInfo.do");
            var request = new RestRequest();
            request.Method = Method.POST;
            request.AddParameter("shipId", barcode, ParameterType.GetOrPost);
            request.AddParameter("weight", 0, ParameterType.GetOrPost);
            request.AddParameter("inductionId","", ParameterType.GetOrPost);
     
            if (true)
            {
                client.ExecutePostTaskAsync(request);
                Thread.Sleep(200);
                return true;
            }
            else
            {
                var result = client.Post(request);
                if (result.StatusCode != System.Net.HttpStatusCode.OK)
                {

                    return false;
                }
            
                Thread.Sleep(200);
            }
            return true;
        }


        /// <summary>
        /// 上传图片
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        private void btUpload_Click(object sender, RoutedEventArgs e)
        {
            _repository.DeleteByCodePackages("20003456");


        }
        int i = 0;
        private void btClose_Click(object sender, RoutedEventArgs e)
        {    
             btClose.IsEnabled= false;         
        }
    }