private void ParsePresentation(PresentationData presData) { BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += worker_DoWork; worker.RunWorkerCompleted += worker_RunWorkerCompleted; worker.WorkerReportsProgress = true; worker.ProgressChanged += worker_ProgressChanged; WorkerArgument workerArgument = new WorkerArgument { PresentationControl = presData.PresentationControl, PresentationName = presData.PresentationName, PresentationFullPath = presData.PresentationFullPath, //PresentationTitle = string.Empty, SelectedItem = presData.Category, //UrlNews = UrlNews.Text, Login = presData.Login }; presData.PresentationControl.PresentationGrid.Opacity = 0.2; presData.PresentationControl.PresentationGrid.IsEnabled = false; worker.RunWorkerAsync(workerArgument); }
private void _worker_DoWork(object sender, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; ICollection <string> words = new WordGenerator().GenerateWords(arg.Size, arg.Choices); string[] wordsArray = new string[words.Count]; words.CopyTo(wordsArray, 0); e.Result = wordsArray; }
private bool NewMethod(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; bool success = true; try { string sheetName = this.pathTextBox.Text; { clsAllnew BUINESS = new clsAllnew(); List <clsDATAinfo> dt = BUINESS.Read_Excel(sheetName); int rowCount = dt.Count; arg.OrderCount = rowCount; int i = 0; int progress = 0; { foreach (clsDATAinfo item in dt) { i += 1; progress = Convert.ToInt16(((i) * 1.0 / rowCount) * 100); arg.CurrentIndex = i; item.xinzeng = "true"; string conditions = ""; conditions = BUINESS.sql_yuju(e, item, conditions); int isrun = BUINESS.update_Server(conditions, item); item.xinzeng = "false"; backgroundWorker1.ReportProgress(progress, arg); } } backgroundWorker1.ReportProgress(100, arg); e.Result = string.Format("{0} 条正常导入成功", dt.Count); } } catch (Exception exception) { if (!e.Cancel) { //arg.HasError = true; //arg.ErrorMessage = exception.Message; e.Result = exception.Message + "或所导入信息超出要求长度"; } success = false; } return(success); }
private void backgroundWorker2_ProgressChanged(object sender, ProgressChangedEventArgs e) { WorkerArgument arg = e.UserState as WorkerArgument; if (!arg.HasError) { this.toolStripLabel1.Text = String.Format("{0}/{1}", arg.CurrentIndex, arg.OrderCount); this.ProgressValue = e.ProgressPercentage; } else { this.toolStripLabel1.Text = arg.ErrorMessage; } }
public MainViewModel() { RestartCommand = new UtilityWpf.RelayCommand(() => _itemsCount.OnNext(5)); var dis = Application.Current.Dispatcher; var x = new System.Reactive.Concurrency.DispatcherScheduler(dis); GetNewItems(_itemsCount).Switch().ObserveOn(x).Subscribe(_ => { Application.Current.Dispatcher.Invoke(() => { NewItem = _; OnPropertyChanged(nameof(NewItem)); }); }); RestartCommand.Execute(5); }
private bool dailysaveList(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; clsAllnew BusinessHelp = new clsAllnew(); bool success = true; try { int rowCount = changeindex.Count; arg.OrderCount = rowCount; int j = 1; int progress = 0; #region MyRegion for (int ik = 0; ik < changeindex.Count; ik++) { j = ik; arg.CurrentIndex = j + 1; progress = Convert.ToInt16(((j + 1) * 1.0 / rowCount) * 100); int i = changeindex[ik]; var row = dataGridView1.Rows[i]; var model = row.DataBoundItem as cls_kehucishufashengshijian_info; cls_kehucishufashengshijian_info item = new cls_kehucishufashengshijian_info(); item.kehuxingming = Convert.ToString(dataGridView1.Rows[i].Cells["kehuxingming"].EditedFormattedValue.ToString()); item.shangcichugongshijian = Convert.ToString(dataGridView1.Rows[i].Cells["shangcichugongshijian"].EditedFormattedValue.ToString()); item.shangcichugongbaojie = Convert.ToString(dataGridView1.Rows[i].Cells["shangcichugongbaojie"].EditedFormattedValue.ToString()); item.kehupingjia = Convert.ToString(dataGridView1.Rows[i].Cells["kehupingjia"].EditedFormattedValue.ToString()); item.beizhu = Convert.ToString(dataGridView1.Rows[i].Cells["beizhu"].EditedFormattedValue.ToString()); item.xinzeng = Convert.ToString(dataGridView1.Rows[i].Cells["xinzeng"].EditedFormattedValue.ToString()); item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.status_id = model.status_id; #endregion #region MyRegion #region 构造查询条件 string conditions = ""; conditions = sql_yuju(e, item, conditions); #endregion #endregion int isrun = BusinessHelp.updatecustomer_Server(conditions); if (item.xinzeng == "true" && isrun == 1) { item.xinzeng = ""; } if (arg.CurrentIndex % 5 == 0) { backgroundWorker2.ReportProgress(progress, arg); } } backgroundWorker2.ReportProgress(100, arg); e.Result = string.Format("{0} 已保存 !", changeindex.Count); } catch (Exception ex) { if (!e.Cancel) { e.Result = ex.Message + ""; } success = false; } return(success); }
private void ParsePresentation(PresentationData presData) { BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += worker_DoWork; worker.RunWorkerCompleted += worker_RunWorkerCompleted; worker.WorkerReportsProgress = true; worker.ProgressChanged += worker_ProgressChanged; WorkerArgument workerArgument = new WorkerArgument { PresentationControl = presData.PresentationControl, PresentationName = presData.PresentationName, PresentationFullPath = presData.PresentationFullPath, //PresentationTitle = string.Empty, SelectedItem = presData.Category, //UrlNews = UrlNews.Text, Login = presData.Login }; presData.PresentationControl.PresentationGrid.Opacity = 0.2; presData.PresentationControl.PresentationGrid.IsEnabled = false; worker.RunWorkerAsync(workerArgument); }
private void worker_DoWork(object sender, DoWorkEventArgs e) { WorkerArgument argument = (WorkerArgument)e.Argument; var progressStatus = new ParseProgressStatus { PresentationControl = argument.PresentationControl }; MySQLPresentationTable abstractpresTable = null; PresentationInfo presInfo = null; try { #region Парсинг презентации ((BackgroundWorker)sender).ReportProgress(0, new ParseProgressStatus { PresentationControl = argument.PresentationControl, Message = "Начало парсинга презентации", IsOnlyMessage = true }); using (PPTFiles pptFiles = new PPTFiles()) { #region Получаюданные настройки соединения с БД string dbRemoteHost = null, dbName = null, dbUser = null, dbPassword = null; try { XDocument xmlDBDoc = XDocument.Load("Lib\\FCashProfile.tss"); var XdbRemoteHost = xmlDBDoc.Root.Element(XName.Get("ExportDBInfo")).Element(XName.Get("DBRemoteHost")); dbRemoteHost = XdbRemoteHost.Value; var XdbName = xmlDBDoc.Root.Element(XName.Get("ExportDBInfo")).Element(XName.Get("DBName")); dbName = XdbName.Value; var XdbUser = xmlDBDoc.Root.Element(XName.Get("ExportDBInfo")).Element(XName.Get("DBUser")); dbUser = XdbUser.Value; var XdbPassword = xmlDBDoc.Root.Element(XName.Get("ExportDBInfo")).Element(XName.Get("DBPassword")); dbPassword = XdbPassword.Value; } catch (Exception ex) { throw new Exception( String.Format("Не получилось получить конфигурационные данные из файла конфигурации: {0}", ex.Message)); } //if (!String.IsNullOrEmpty(argument.UrlNews)) // presInfo.UrlNews = argument.UrlNews; if (String.IsNullOrEmpty(dbRemoteHost) || String.IsNullOrEmpty(dbName) || String.IsNullOrEmpty(dbUser)) { throw new Exception( "У вас не заполнена конфигурация соединения с базой данных для экспорта\nПожалуйста заполните ее через настройки"); } MySQLPresentationTable presTable = new MySQLPresentationTable(dbRemoteHost, dbName, dbUser, dbPassword); abstractpresTable = presTable; #endregion pptFiles.ParseSlideCompleteCallback += (object pptFile, SlideCompleteParsingInfo slideParsingInfo) => { ((BackgroundWorker)sender).ReportProgress( (int)((decimal)slideParsingInfo.SlideCurrentNumber / (decimal)slideParsingInfo.SlideTotalNumber * 100), new ParseProgressStatus { PresentationControl = argument.PresentationControl, Message = "Обработка слайдов" }); }; presTable.CreateTable(); presInfo = pptFiles.ExtractInfo(argument.PresentationFullPath, presTable); presInfo.Name = argument.PresentationName; presInfo.Title = argument.PresentationTitle; presInfo.Login = argument.Login; presInfo.Categorie = ((KeyValuePair <string, string>)argument.SelectedItem); } #endregion #region Заливка информации по презентации в БД { ((BackgroundWorker)sender).ReportProgress(0, new ParseProgressStatus { PresentationControl = argument.PresentationControl, Message = "Обновление данных на сервере", IsOnlyMessage = true }); abstractpresTable.PutDataOnServer(presInfo); } #endregion #region Отправка на FTP try { ((BackgroundWorker)sender).ReportProgress(0, new ParseProgressStatus { PresentationControl = argument.PresentationControl, Message = "Подготовка к отправке файлов на FTP", IsOnlyMessage = true }); XDocument xmlFtpDoc = XDocument.Load("Lib\\FCashProfile.tss"); var ftpHost = xmlFtpDoc.Root.Element(XName.Get("ExportFtpInfo")).Element(XName.Get("Host")); var ftpUserName = xmlFtpDoc.Root.Element(XName.Get("ExportFtpInfo")).Element(XName.Get("UserName")); var ftpUserPassword = xmlFtpDoc.Root.Element(XName.Get("ExportFtpInfo")).Element(XName.Get("UserPassword")); var ftpImagesDir = xmlFtpDoc.Root.Element(XName.Get("ExportFtpInfo")).Element(XName.Get("ImagesDir")); FTP ftp = new FTP(ftpHost.Value, ftpUserName.Value, ftpUserPassword.Value, ftpImagesDir.Value); ftp.UploadImageCompleteCallback += (object ftpSender, UploadImageCompliteInfo completeInfo) => { ((BackgroundWorker)sender).ReportProgress( (int)((decimal)completeInfo.CurrentImageNumber / (decimal)completeInfo.TotalImagesCount * 100), new ParseProgressStatus { PresentationControl = argument.PresentationControl, Message = "Загрузка изображений на FTP" }); }; ftp.OnUploadPresentationBlockCallbak += (object ftpSender, UploadPresentationBlockInfo blockInfo) => { ((BackgroundWorker)sender).ReportProgress(blockInfo.PercentProgress, new ParseProgressStatus { PresentationControl = argument.PresentationControl, Message = "Загрузка презентации" }); }; List <string> imageNames = new List <string>(); foreach (var slideInfo in presInfo.SlidersInfo) { if (!String.IsNullOrEmpty(slideInfo.ImageNameClientSmall)) { imageNames.Add(slideInfo.ImageNameClientSmall); } if (!String.IsNullOrEmpty(slideInfo.ImageNameClientAverage)) { imageNames.Add(slideInfo.ImageNameClientAverage); } if (!String.IsNullOrEmpty(slideInfo.ImageNameClientBig)) { imageNames.Add(slideInfo.ImageNameClientBig); } } ftp.UploadImages(presInfo); } catch (Exception ex) { throw new Exception(String.Format("Во время отправки изображений на FTP возникла ошибка: {0}", ex.Message)); } #endregion } catch (Exception ex) { lock (_exceptionLoger) { _exceptionLoger.WriteLog(string.Format(Environment.NewLine + Environment.NewLine + "[{0}] Во время обработки презентации [{1}] произошла ошибка.\r\n Ошибка: {2} \r\nСтек вызова: {3}", DateTime.Now, argument.PresentationName, ex.Message, ex.StackTrace)); } // Удаляю пустую подготовленную строчку для презентации из таблицы if (presInfo != null) { try { abstractpresTable.DeleteFromMainTable((ulong)presInfo.DbId); } catch (Exception ex2) { lock (_exceptionLoger) { _exceptionLoger.WriteLog(string.Format(Environment.NewLine + Environment.NewLine + "[{0}] Во время обработки презентации [{1}] произошла ошибка.\r\n Ошибка: {2} \r\nСтек вызова: {3}", DateTime.Now, argument.PresentationName, ex2.Message, ex2.StackTrace)); } } } progressStatus.IsError = true; } finally { e.Result = progressStatus; } }
private bool dailysaveList(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; clsAllnew BusinessHelp = new clsAllnew(); bool success = true; try { int rowCount = changeindex.Count; arg.OrderCount = rowCount; int j = 1; int progress = 0; #region MyRegion for (int ik = 0; ik < changeindex.Count; ik++) { j = ik; arg.CurrentIndex = j + 1; progress = Convert.ToInt16(((j + 1) * 1.0 / rowCount) * 100); int i = changeindex[ik]; var row = dataGridView1.Rows[i]; var model = row.DataBoundItem as clscustomerinfo; clscustomerinfo item = new clscustomerinfo(); item.customer_name = Convert.ToString(dataGridView1.Rows[i].Cells["customer_name"].EditedFormattedValue.ToString()); item.customer_adress = Convert.ToString(dataGridView1.Rows[i].Cells["customer_adress"].EditedFormattedValue.ToString()); item.customer_shuihao = Convert.ToString(dataGridView1.Rows[i].Cells["customer_shuihao"].EditedFormattedValue.ToString()); item.customer_bank = Convert.ToString(dataGridView1.Rows[i].Cells["customer_bank"].EditedFormattedValue.ToString()); item.customer_account = Convert.ToString(dataGridView1.Rows[i].Cells["customer_account"].EditedFormattedValue.ToString()); item.customer_phone = Convert.ToString(dataGridView1.Rows[i].Cells["customer_phone"].EditedFormattedValue.ToString()); item.customer_contact = Convert.ToString(dataGridView1.Rows[i].Cells["customer_contact"].EditedFormattedValue.ToString()); item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.customer_id = model.customer_id; #endregion #region MyRegion var startAt = this.stockOutDateTimePicker.Value.AddDays(0).Date; string conditions = ""; #region 构造查询条件 if (item.customer_name != null) { conditions += " customer_name ='" + item.customer_name + "'"; } if (item.customer_adress != null) { conditions += " ,customer_adress ='" + item.customer_adress + "'"; } if (item.customer_shuihao != null) { conditions += " ,customer_shuihao ='" + item.customer_shuihao + "'"; } if (item.customer_bank != null) { conditions += " ,customer_bank ='" + item.customer_bank + "'"; } if (item.customer_account != null) { conditions += " ,customer_account ='" + item.customer_account + "'"; } if (item.customer_phone != null) { conditions += " ,customer_phone ='" + item.customer_phone + "'"; } if (item.customer_contact != null) { conditions += " ,customer_contact ='" + item.customer_contact + "'"; } if (item.Input_Date != null) { conditions += " ,Input_Date ='" + item.Input_Date.ToString("yyyy/MM/dd") + "'"; } conditions = "update JNOrder_customer set " + conditions + " where customer_id = " + item.customer_id + " "; // conditions += " order by Id desc"; #endregion #endregion int isrun = BusinessHelp.updatecustomer_Server(conditions); if (arg.CurrentIndex % 5 == 0) { backgroundWorker2.ReportProgress(progress, arg); } } backgroundWorker2.ReportProgress(100, arg); e.Result = string.Format("{0} 已保存 !", changeindex.Count); } catch (Exception ex) { if (!e.Cancel) { e.Result = ex.Message + ""; } success = false; } return(success); }
private bool dailysaveList(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; clsAllnew BusinessHelp = new clsAllnew(); bool success = true; try { int rowCount = changeindex.Count; arg.OrderCount = rowCount; int j = 1; int progress = 0; #region MyRegion for (int ik = 0; ik < changeindex.Count; ik++) { j = ik; arg.CurrentIndex = j + 1; progress = Convert.ToInt16(((j + 1) * 1.0 / rowCount) * 100); int i = changeindex[ik]; var row = dataGridView1.Rows[i]; var model = row.DataBoundItem as clsDATAinfo; clsDATAinfo item = new clsDATAinfo(); item.zhenghao = Convert.ToString(dataGridView1.Rows[i].Cells["zhenghao"].EditedFormattedValue.ToString()); item.xingming = Convert.ToString(dataGridView1.Rows[i].Cells["xingming"].EditedFormattedValue.ToString()); item.xingbie = Convert.ToString(dataGridView1.Rows[i].Cells["xingbie"].EditedFormattedValue.ToString()); item.zuoyeleibie = Convert.ToString(dataGridView1.Rows[i].Cells["zuoyeleibie"].EditedFormattedValue.ToString()); item.zhuncaoxiangmu = Convert.ToString(dataGridView1.Rows[i].Cells["zhuncaoxiangmu"].EditedFormattedValue.ToString()); item.chulingriqi = Convert.ToString(dataGridView1.Rows[i].Cells["chulingriqi"].EditedFormattedValue.ToString()); item.youxiangqixian = Convert.ToString(dataGridView1.Rows[i].Cells["youxiangqixian"].EditedFormattedValue.ToString()); item.fushenriqi = Convert.ToString(dataGridView1.Rows[i].Cells["fushenriqi"].EditedFormattedValue.ToString()); item.xinzeng = Convert.ToString(dataGridView1.Rows[i].Cells["xinzeng"].EditedFormattedValue.ToString()); item.Message = Convert.ToString(dataGridView1.Rows[i].Cells["Message"].EditedFormattedValue.ToString());//印章类型 item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.Item_ID = model.Item_ID; #endregion #region MyRegion var startAt = this.stockOutDateTimePicker.Value.AddDays(0).Date; #region 构造查询条件 string conditions = ""; conditions = BusinessHelp.sql_yuju(e, item, conditions); #endregion #endregion int isrun = BusinessHelp.update_Server(conditions, item); if (item.xinzeng == "true" && isrun == 1) { item.xinzeng = ""; } if (arg.CurrentIndex % 5 == 0) { backgroundWorker2.ReportProgress(progress, arg); } } backgroundWorker2.ReportProgress(100, arg); e.Result = string.Format("{0} 已保存 !", changeindex.Count); } catch (Exception ex) { if (!e.Cancel) { e.Result = ex.Message + ""; } success = false; } return(success); }
private bool dailysaveList(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; clsAllnew BusinessHelp = new clsAllnew(); bool success = true; try { int rowCount = changeindex.Count; arg.OrderCount = rowCount; int j = 1; int progress = 0; #region MyRegion for (int ik = 0; ik < changeindex.Count; ik++) { j = ik; arg.CurrentIndex = j + 1; progress = Convert.ToInt16(((j + 1) * 1.0 / rowCount) * 100); int i = changeindex[ik]; var row = dataGridView1.Rows[i]; var model = row.DataBoundItem as clsOrderinfo; clsOrderinfo item = new clsOrderinfo(); item.hetongbianhao = Convert.ToString(dataGridView1.Rows[i].Cells["hetongbianhao"].EditedFormattedValue.ToString()); item.kehuxingming = Convert.ToString(dataGridView1.Rows[i].Cells["kehuxingming"].EditedFormattedValue.ToString()); item.kehudizhi = Convert.ToString(dataGridView1.Rows[i].Cells["kehudizhi"].EditedFormattedValue.ToString()); item.lianxidianhua = Convert.ToString(dataGridView1.Rows[i].Cells["lianxidianhua"].EditedFormattedValue.ToString()); item.hetongdaoqishijian = Convert.ToString(dataGridView1.Rows[i].Cells["hetongdaoqishijian"].EditedFormattedValue.ToString()); item.hetongshichang = Convert.ToString(dataGridView1.Rows[i].Cells["hetongshichang"].EditedFormattedValue.ToString()); item.shishou = Convert.ToString(dataGridView1.Rows[i].Cells["shishou"].EditedFormattedValue.ToString()); item.yuejia = Convert.ToString(dataGridView1.Rows[i].Cells["yuejia"].EditedFormattedValue.ToString()); item.mianji = Convert.ToString(dataGridView1.Rows[i].Cells["mianji"].EditedFormattedValue.ToString()); item.tixingshoufeishijian = Convert.ToString(dataGridView1.Rows[i].Cells["tixingshoufeishijian"].EditedFormattedValue.ToString()); item.meiyuanci = Convert.ToString(dataGridView1.Rows[i].Cells["meiyuanci"].EditedFormattedValue.ToString()); item.zongcishu = Convert.ToString(dataGridView1.Rows[i].Cells["zongcishu"].EditedFormattedValue.ToString()); item.shengyushu = Convert.ToString(dataGridView1.Rows[i].Cells["shengyushu"].EditedFormattedValue.ToString()); item.chaboli = Convert.ToString(dataGridView1.Rows[i].Cells["chaboli"].EditedFormattedValue.ToString()); item.kehuyaoqiu = Convert.ToString(dataGridView1.Rows[i].Cells["kehuyaoqiu"].EditedFormattedValue.ToString()); item.beizhu = Convert.ToString(dataGridView1.Rows[i].Cells["beizhu"].EditedFormattedValue.ToString()); item.xinzeng = Convert.ToString(dataGridView1.Rows[i].Cells["xinzeng"].EditedFormattedValue.ToString()); item.Message = Convert.ToString(dataGridView1.Rows[i].Cells["Message"].EditedFormattedValue.ToString()); item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.order_id = model.order_id; #endregion #region MyRegion var startAt = this.stockOutDateTimePicker.Value.AddDays(0).Date; #region 构造查询条件 string conditions = ""; conditions = sql_yuju(e, item, conditions); // conditions += " order by Id desc"; #endregion #endregion int isrun = BusinessHelp.updatecustomer_Server(conditions); if (item.xinzeng == "true" && isrun == 1) { item.xinzeng = ""; } if (arg.CurrentIndex % 5 == 0) { backgroundWorker2.ReportProgress(progress, arg); } } backgroundWorker2.ReportProgress(100, arg); e.Result = string.Format("{0} 已保存 !", changeindex.Count); } catch (Exception ex) { if (!e.Cancel) { e.Result = ex.Message + ""; } success = false; } return(success); }
private bool dailysaveList(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; clsAllnew BusinessHelp = new clsAllnew(); bool success = true; try { int rowCount = changeindex.Count; arg.OrderCount = rowCount; int j = 1; int progress = 0; #region MyRegion for (int ik = 0; ik < changeindex.Count; ik++) { j = ik; arg.CurrentIndex = j + 1; progress = Convert.ToInt16(((j + 1) * 1.0 / rowCount) * 100); int i = changeindex[ik]; var row = dataGridView1.Rows[i]; var model = row.DataBoundItem as clsLog_info; clsLog_info item = new clsLog_info(); item.product_no = Convert.ToString(dataGridView1.Rows[i].Cells["product_no"].EditedFormattedValue.ToString()); item.indent = Convert.ToString(dataGridView1.Rows[i].Cells["indent"].EditedFormattedValue.ToString()); item.indent_date = Convert.ToString(dataGridView1.Rows[i].Cells["indent_date"].EditedFormattedValue.ToString()); item.end_user = Convert.ToString(dataGridView1.Rows[i].Cells["end_user"].EditedFormattedValue.ToString()); item.vendor = Convert.ToString(dataGridView1.Rows[i].Cells["vendor"].EditedFormattedValue.ToString()); item.daohuoshijian = Convert.ToString(dataGridView1.Rows[i].Cells["daohuoshijian"].EditedFormattedValue.ToString()); item.xinzeng = Convert.ToString(dataGridView1.Rows[i].Cells["xinzeng"].EditedFormattedValue.ToString()); item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.Log_id = model.Log_id; #endregion #region MyRegion var startAt = this.stockOutDateTimePicker.Value.AddDays(0).Date; string conditions = ""; #region 构造查询条件 if (item.product_no != null) { conditions += " product_no ='" + item.product_no + "'"; } if (item.indent != null) { conditions += " ,indent ='" + item.indent + "'"; } if (item.indent_date != null) { conditions += " ,indent_date ='" + item.indent_date + "'"; } if (item.end_user != null) { conditions += " ,end_user ='******'"; } if (item.vendor != null) { conditions += " ,vendor ='" + item.vendor + "'"; } if (item.daohuoshijian != null) { conditions += " ,daohuoshijian ='" + item.daohuoshijian + "'"; } if (item.Input_Date != null) { conditions += " ,Input_Date ='" + item.Input_Date.ToString("yyyy/MM/dd") + "'"; } if (item.xinzeng == "true") { conditions = "insert into JNOrder_log(product_no,indent,indent_date,end_user,vendor,Input_Date) values ('" + item.product_no + "','" + item.indent + "','" + item.indent_date + "','" + item.end_user + "','" + item.vendor + "','" + item.Input_Date.ToString("yyyy/MM/dd") + "')"; } else { conditions = "update JNOrder_log set " + conditions + " where Log_id = " + item.Log_id + " "; } #endregion #endregion int isrun = BusinessHelp.updateLog_Server(conditions); if (item.xinzeng == "true" && isrun == 1) { item.xinzeng = ""; } if (arg.CurrentIndex % 5 == 0) { backgroundWorker2.ReportProgress(progress, arg); } } backgroundWorker2.ReportProgress(100, arg); e.Result = string.Format("{0} 已保存 !", changeindex.Count); } catch (Exception ex) { if (!e.Cancel) { e.Result = ex.Message + ""; } success = false; } return(success); }
private bool dailysaveList(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; clsAllnew BusinessHelp = new clsAllnew(); bool success = true; try { int rowCount = changeindex.Count; arg.OrderCount = rowCount; int j = 1; int progress = 0; #region MyRegion for (int ik = 0; ik < changeindex.Count; ik++) { j = ik; arg.CurrentIndex = j + 1; progress = Convert.ToInt16(((j + 1) * 1.0 / rowCount) * 100); int i = changeindex[ik]; var row = dataGridView1.Rows[i]; var model = row.DataBoundItem as clsOrderinfo; clsOrderinfo item = new clsOrderinfo(); item.customer_name = Convert.ToString(dataGridView1.Rows[i].Cells["customer_name"].EditedFormattedValue.ToString()); if (dataGridView1.Rows[i].Cells["dinghuoshijian"].EditedFormattedValue.ToString() != "") item.dinghuoshijian = Convert.ToDateTime(dataGridView1.Rows[i].Cells["dinghuoshijian"].EditedFormattedValue.ToString()); item.order_no = Convert.ToString(dataGridView1.Rows[i].Cells["order_no"].EditedFormattedValue.ToString()); item.Product_no = Convert.ToString(dataGridView1.Rows[i].Cells["Product_no"].EditedFormattedValue.ToString()); item.Product_name = Convert.ToString(dataGridView1.Rows[i].Cells["Product_name"].EditedFormattedValue.ToString()); item.shuliang = Convert.ToString(dataGridView1.Rows[i].Cells["shuliang"].EditedFormattedValue.ToString()); item.Product_salse = Convert.ToString(dataGridView1.Rows[i].Cells["Product_salse"].EditedFormattedValue.ToString()); item.jine = Convert.ToString(dataGridView1.Rows[i].Cells["jine"].EditedFormattedValue.ToString()); if (dataGridView1.Rows[i].Cells["yujijiaohuoshijian"].EditedFormattedValue.ToString() != null && dataGridView1.Rows[i].Cells["yujijiaohuoshijian"].EditedFormattedValue.ToString() != "") item.yujijiaohuoshijian = Convert.ToDateTime(dataGridView1.Rows[i].Cells["yujijiaohuoshijian"].EditedFormattedValue.ToString()); if (dataGridView1.Rows[i].Cells["jianhuoshijian2"].EditedFormattedValue.ToString() != null && dataGridView1.Rows[i].Cells["jianhuoshijian2"].EditedFormattedValue.ToString() != "") item.jianhuoshijian2 = Convert.ToDateTime(dataGridView1.Rows[i].Cells["jianhuoshijian2"].EditedFormattedValue.ToString()); item.dingdanguanliyuan = Convert.ToString(dataGridView1.Rows[i].Cells["dingdanguanliyuan"].EditedFormattedValue.ToString()); item.kaipiao = Convert.ToString(dataGridView1.Rows[i].Cells["kaipiao"].EditedFormattedValue.ToString()); item.shifoujiaohuo = Convert.ToString(dataGridView1.Rows[i].Cells["shifoujiaohuo"].EditedFormattedValue.ToString()); if (dataGridView1.Rows[i].Cells["fukuanriqi"].EditedFormattedValue.ToString() != null && dataGridView1.Rows[i].Cells["fukuanriqi"].EditedFormattedValue.ToString() != "") item.fukuanriqi = Convert.ToDateTime(dataGridView1.Rows[i].Cells["fukuanriqi"].EditedFormattedValue.ToString()); item.beizhu = Convert.ToString(dataGridView1.Rows[i].Cells["beizhu"].EditedFormattedValue.ToString()); item.xinzeng = Convert.ToString(dataGridView1.Rows[i].Cells["xinzeng"].EditedFormattedValue.ToString()); item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.order_id = model.order_id; #endregion #region MyRegion var startAt = this.stockOutDateTimePicker.Value.AddDays(0).Date; string conditions = ""; #region 构造查询条件 if (item.customer_name != null) { conditions += " customer_name ='" + item.customer_name + "'"; } if (item.dinghuoshijian != null) { conditions += " ,dinghuoshijian ='" + item.dinghuoshijian.ToString("yyyy/MM/dd") + "'"; } if (item.order_no != null) { conditions += " ,order_no ='" + item.order_no + "'"; } if (item.Product_no != null) { conditions += " ,Product_no ='" + item.Product_no + "'"; } if (item.Product_name != null) { conditions += " ,Product_name ='" + item.Product_name + "'"; } if (item.shuliang != null) { conditions += " ,shuliang ='" + item.shuliang + "'"; } if (item.Product_salse != null) { conditions += " ,Product_salse ='" + item.Product_salse + "'"; } if (item.jine != null) { conditions += " ,jine ='" + item.jine + "'"; } if (item.yujijiaohuoshijian != null && item.yujijiaohuoshijian != Convert.ToDateTime("01/01/0001 00:00:00")) { conditions += " ,yujijiaohuoshijian ='" + item.yujijiaohuoshijian.ToString("yyyy/MM/dd") + "'"; } if (item.jianhuoshijian2 != null && item.jianhuoshijian2 != Convert.ToDateTime("01/01/0001 00:00:00")) { conditions += " ,jianhuoshijian2 ='" + item.jianhuoshijian2.ToString("yyyy/MM/dd") + "'"; } if (item.dingdanguanliyuan != null) { conditions += " ,dingdanguanliyuan ='" + item.dingdanguanliyuan + "'"; } if (item.kaipiao != null) { conditions += " ,kaipiao ='" + item.kaipiao + "'"; } if (item.shifoujiaohuo != null) { conditions += " ,shifoujiaohuo ='" + item.shifoujiaohuo + "'"; } if (item.fukuanriqi != null && item.fukuanriqi != Convert.ToDateTime("01/01/0001 00:00:00")) { conditions += " ,fukuanriqi ='" + item.fukuanriqi.ToString("yyyy/MM/dd") + "'"; } if (item.beizhu != null) { conditions += " ,beizhu ='" + item.beizhu + "'"; } if (item.Input_Date != null) { conditions += " ,Input_Date ='" + item.Input_Date.ToString("yyyy/MM/dd") + "'"; } if (item.xinzeng == "true") conditions = "insert into JNOrder_order(customer_name,dinghuoshijian,order_no,Product_no,Product_name,shuliang,Product_salse,jine,yujijiaohuoshijian,jianhuoshijian2,dingdanguanliyuan,kaipiao,shifoujiaohuo,fukuanriqi,beizhu,Input_Date) values ('" + item.customer_name + "','" + item.dinghuoshijian.ToString("yyyy/MM/dd") + "','" + item.order_no + "','" + item.Product_no + "','" + item.Product_name + "','" + item.shuliang + "','" + item.Product_salse + "','" + item.jine + "','" + item.yujijiaohuoshijian.ToString("yyyy/MM/dd") + "','" + item.jianhuoshijian2.ToString("yyyy/MM/dd") + "','" + item.dingdanguanliyuan + "','" + item.kaipiao + "','" + item.shifoujiaohuo + "','" + item.fukuanriqi.ToString("yyyy/MM/dd") + "','" + item.beizhu + "','" + item.Input_Date.ToString("yyyy/MM/dd") + "')"; else conditions = "update JNOrder_order set " + conditions + " where order_id = " + item.order_id + " "; // conditions += " order by Id desc"; #endregion #endregion int isrun = BusinessHelp.updateProduct_Server(conditions); if (item.xinzeng == "true" && isrun == 1) item.xinzeng = ""; if (arg.CurrentIndex % 5 == 0) { backgroundWorker2.ReportProgress(progress, arg); } } backgroundWorker2.ReportProgress(100, arg); e.Result = string.Format("{0} 已保存 !", changeindex.Count); } catch (Exception ex) { if (!e.Cancel) { e.Result = ex.Message + ""; } success = false; } return success; }
private void FormChanging_Shown(object sender, EventArgs e) { WorkerArgument args = new WorkerArgument(listview, labelCurrentFile); backgroundWorkerRename.RunWorkerAsync(args); }