Exemplo n.º 1
0
 private void btnOpen_Click(object sender, EventArgs e)
 {
     try
     {
         string    sql = @"select * from CaseNumber";
         DataTable dt  = db.ExecuteDataTable(sql, null);
         if (dt != null && dt.Rows.Count > 0)
         {
             if (!CheckLoginInfo())
             {
                 hkMain.Stop();
                 UserLogin loginFrm = new UserLogin();
                 loginFrm.LoginSelectionDelegate += delegate(int selection, string loginID)
                 {
                     if (selection == 1)
                     {
                         AddLoginInfo(loginID);
                         hkMain.Stop();
                         CaseMgr caseMgrFrm = new CaseMgr(1);
                         caseMgrFrm.Show();
                     }
                     else
                     {
                         hkMain.Start();
                         //msgDialog.ShowMessage("登录失败", 1);
                     }
                 };
                 loginFrm.Show();
             }
             else
             {
                 hkMain.Stop();
                 CaseMgr caseMgrFrm = new CaseMgr(1);
                 caseMgrFrm.Show();
             }
         }
         else
         {
             msgDialog.ShowMessage("没有单据", 1);
         }
     }
     catch (Exception ex)
     {
     }
 }
Exemplo n.º 2
0
 public void DownloadDetailHandler(Scanner.CodeInfo obj)
 {
     #region 记录发货单条码
     string            sql        = @"delete from AppConfig where Key=@Key";
     SQLiteParameter[] parameters = new SQLiteParameter[] {
         new SQLiteParameter("@Key", "CaseBarcode"),
         new SQLiteParameter("@Value", obj.barcode)
     };
     try
     {
         db.ExecuteNonQuery(sql, parameters);
         sql = @"insert into AppConfig(Key,Value) values(@Key,@Value)";
         //parameters = new SQLiteParameter[]{
         //    new SQLiteParameter("@Key", "CaseBarcode"),
         //    new SQLiteParameter("@Value", "0000000004-01")
         // };
         db.ExecuteNonQuery(sql, parameters);
     }
     catch (Exception ex)
     {
     }
     #endregion
     #region   条码,下载发货单明细
     if (D300SysUI.CheckNetworkStatus())
     {
         string      detailStrJson = DataUpDownload.DownloadInvoiceDetail(obj.barcode);
         FromERPJson model         = JsonConvert.DeserializeObject <FromERPJson>(detailStrJson);
         if (model.IsSuccess)
         {
             msgDialog.ShowMessage("正在处理中,请稍后···", 1);
             sql = @"delete from FromERPDetail";
             try
             {
                 db.ExecuteNonQuery(sql, null);
             }
             catch (Exception ex)
             {
             }
             if (model.ReturnData.Count > 0)
             {
                 bool isSuccess = false;
                 using (SQLiteConnection connection = new SQLiteConnection(db.ConnectionString))
                 {
                     connection.Open();
                     using (DbTransaction transaction = connection.BeginTransaction())
                     {
                         using (SQLiteCommand command = new SQLiteCommand(connection))
                         {
                             try
                             {
                                 for (int i = 0; i < model.ReturnData.Count; i++)
                                 {
                                     command.CommandText = @"insert into FromERPDetail(InvoiceID,ProdID,Model,ProdName,Num,Barcode,BoxBarcode,NormNum,Title,bJianMaInBox,siteCode,ModType,ModID,DH) values (@InvoiceID,@ProdID,@Model,@ProdName,@Num,@Barcode,@BoxBarcode,@NormNum,@Title,@bJianMaInBox,@siteCode,@ModType,@ModID,@DH)";
                                     parameters          = new SQLiteParameter[] {
                                         new SQLiteParameter("@InvoiceID", model.ReturnData[i].InvoiceID),
                                         new SQLiteParameter("@ProdID", model.ReturnData[i].ProdID),
                                         new SQLiteParameter("@Model", model.ReturnData[i].Model),
                                         new SQLiteParameter("@ProdName", model.ReturnData[i].ProdName),
                                         new SQLiteParameter("@Num", model.ReturnData[i].Num),
                                         new SQLiteParameter("@Barcode", model.ReturnData[i].Barcode),
                                         new SQLiteParameter("@BoxBarcode", model.ReturnData[i].BoxBarcode),
                                         new SQLiteParameter("@NormNum", model.ReturnData[i].NormNum),
                                         new SQLiteParameter("@Title", model.ReturnData[i].Title),
                                         new SQLiteParameter("@bJianMaInBox", model.ReturnData[i].bJianMaInBox),
                                         new SQLiteParameter("@siteCode", model.ReturnData[i].siteCode),
                                         new SQLiteParameter("@ModType", model.ReturnData[i].ModType),
                                         new SQLiteParameter("@ModID", model.ReturnData[i].ModID),
                                         new SQLiteParameter("@DH", model.ReturnData[i].DH)
                                     };
                                     if (parameters != null)
                                     {
                                         command.Parameters.AddRange(parameters);
                                     }
                                     command.ExecuteNonQuery();
                                 }
                                 transaction.Commit();
                                 isSuccess = true;
                             }
                             catch (Exception ex)
                             {
                                 transaction.Rollback();
                                 isSuccess = false;
                             }
                         }
                     }
                 }
                 if (isSuccess)
                 {
                     CaseMgr caseMgrFrm = new CaseMgr(0);
                     caseMgrFrm.Show();
                 }
             }
         }
         else
         {
             msgDialog.ShowMessage("没有该发货草稿单据", 1);
         }
     }
     else
     {
         msgDialog.ShowMessage("网络没有连接", 1);
     }
     #endregion
 }