public async Task SaveItemTaskAsync(ItemTask item, bool isNewItem = false) { RestUrl = "http://10.10.3.183:50176/api/task/"; var uri = new Uri(string.Format(RestUrl, string.Empty)); var json = JsonConvert.SerializeObject(item); var content = new StringContent(json, Encoding.UTF8, "application/json"); HttpResponseMessage response = null; if (isNewItem) { response = await client.PostAsync(uri, content); } else { RestUrl = "http://10.10.3.183:50176/api/task/?id=" + item.Id; uri = new Uri(string.Format(RestUrl, string.Empty)); response = await client.PutAsync(uri, content); } if (response.IsSuccessStatusCode) { Debug.WriteLine(@" Task successfully saved."); } }
public void DeleteTaskFromTable(ItemTask _task) { if (_task.Id != 0) { _con.Table <ItemTask>().Where(x => x.Id == _task.Id).Delete(); } }
public async Task <IActionResult> Edit(int id, [Bind("Id,UserTaskId,Name")] ItemTask itemTask) { if (id != itemTask.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(itemTask); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ItemTaskExists(itemTask.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["UserTaskId"] = new SelectList(_context.UserTask, "Id", "Desc", itemTask.UserTaskId); return(View(itemTask)); }
public override void Execute() { IContentView activeView = (IContentView)MainFormManager.MainForm.ActiveView; var content = (IItem)activeView.Content; var clonedConent = (IItem)content.Clone(); //IOptimizer and IExecutables need some special care if (clonedConent is IOptimizer) { ((IOptimizer)clonedConent).Runs.Clear(); } if (clonedConent is IExecutable) { IExecutable exec = clonedConent as IExecutable; if (exec.ExecutionState != ExecutionState.Prepared) { exec.Prepare(); } } HiveClient.Instance.Refresh(); ItemTask hiveTask = ItemTask.GetItemTaskForItem(clonedConent); HiveTask task = hiveTask.CreateHiveTask(); RefreshableJob rJob = new RefreshableJob(); rJob.Job.Name = clonedConent.ToString(); rJob.HiveTasks.Add(task); task.ItemTask.ComputeInParallel = clonedConent is Experiment || clonedConent is BatchRun; MainFormManager.MainForm.ShowContent(rJob); }
private void btnRetry_Click(object sender, EventArgs e) { this.btnRetry.Enabled = false; threadnum--; //线程数必须减1 itemCompleteNum = 0; //完成数置0 string inforMsg = string.Format("{0} {1}", DateTime.Now.ToString("HH:mm:ss"), "重新下载失败的宝贝!"); listBoxDetail.Items.Insert(0, inforMsg); /*再开线程处理*/ BackgroundWorker workerExtent = new BackgroundWorker(); workerExtent.WorkerReportsProgress = true; workerExtent.WorkerSupportsCancellation = true; workerExtent.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted); workerExtent.ProgressChanged += new ProgressChangedEventHandler(worker_ProgressChanged); workerExtent.DoWork += new DoWorkEventHandler(worker_DoWork); /*参数传递*/ ItemTask tradeTask = new ItemTask(); tradeTask.shopNic = failedDownload.shopNick; tradeTask.iidList = failedDownload.iidList; tradeTask.sessionKey = failedDownload.sessionKey; tradeTask.totalNum = failedDownload.iidList.Count; tradeTask.threadIndex = 1; //重新设定进度条最大值 this.progressBarTotal.Properties.Maximum = tradeTask.totalNum; //重新实例化 failedDownload = new FailDownloadeItem(); //线程开启 workerExtent.RunWorkerAsync(tradeTask); }
public bool Cancelar(long id) { ItemTask task = _itemTaskRepositorio.Obter(id); task.Status = StatusTask.Cancelado; return(_itemTaskRepositorio.Salvar(task)); }
private void jobsTreeView_DragDrop(object sender, DragEventArgs e) { if (e.Effect != DragDropEffects.None) { var obj = (IItem)e.Data.GetData(Constants.DragDropDataFormat); IItem newObj = null; if (e.Effect.HasFlag(DragDropEffects.Copy)) { newObj = (IItem)obj.Clone(); } else { newObj = obj; } //IOptimizer and IExecutables need some special care if (newObj is IOptimizer) { ((IOptimizer)newObj).Runs.Clear(); } if (newObj is IExecutable) { IExecutable exec = (IExecutable)newObj; if (exec.ExecutionState != ExecutionState.Prepared) { exec.Prepare(); } } ItemTask hiveTask = ItemTask.GetItemTaskForItem(newObj); Content.HiveTasks.Add(hiveTask.CreateHiveTask()); } }
public override void Execute() { IContentView activeView = MainFormManager.MainForm.ActiveView as IContentView; content = activeView.Content as IItem; //IOptimizer and IExecutables need some special care if (content is IOptimizer) { ((IOptimizer)content).Runs.Clear(); } if (content is IExecutable) { IExecutable exec = content as IExecutable; if (exec.ExecutionState != ExecutionState.Prepared) { exec.Prepare(); } } HiveClient.Instance.Refresh(); ItemTask hiveTask = ItemTask.GetItemTaskForItem(content); HiveTask task = hiveTask.CreateHiveTask(); RefreshableJob rJob = new RefreshableJob(); rJob.Job.Name = content.ToString(); rJob.HiveTasks.Add(task); task.ItemTask.ComputeInParallel = content is Experiment || content is BatchRun; var hiveResourceSelectorDialog = new HiveResourceSelectorDialog(rJob.Job.Id, rJob.Job.ProjectId); if (HiveClient.Instance.Projects.Count == 1) { var project = HiveClient.Instance.Projects.FirstOrDefault(); if (project != null && project.Id != Guid.Empty) { hiveResourceSelectorDialog.SelectedProjectId = project.Id; } } if (hiveResourceSelectorDialog.ShowDialog((UserControl)activeView) == DialogResult.OK) { var selectedProject = hiveResourceSelectorDialog.SelectedProject; if (selectedProject != null) { rJob.Job.ProjectId = selectedProject.Id; rJob.Job.ResourceIds = hiveResourceSelectorDialog.SelectedResources.Select(x => x.Id).ToList(); progress = Progress.Show(this.content, "Uploading to Hive...", ProgressMode.Indeterminate); rJob.Progress = progress; progress.ProgressStateChanged += progress_ProgressStateChanged; HiveClient.StartJob(new Action <Exception>(HandleEx), rJob, new CancellationToken()); } } }
//Work with ItemTask public void AddTaskToTable(ItemTask task1) { if (task1.Id == 0) { _con.Insert(task1); } else { _con.Update(task1); } }
public static DBItemTask ToEntity(this ItemTask task) { return(new DBItemTask { Id = task.Id, User = task.User.ToEntity(), Created = task.Created, Description = task.Description, Title = task.Title }); }
public void Salvar() { ItemTask task = _itemTaskServico.Obter().SingleOrDefault(t => t.Titulo.Equals("Teste task 001")) ?? new ItemTask { Titulo = "Teste task 001" }; _itemTaskServico.Salvar(task); Assert.IsTrue(task.Id > 0); Assert.AreEqual(task.Status, StatusTask.Normal); Assert.AreEqual(task.Titulo, "Teste task 001"); }
public void Cancelar() { ItemTask task = _itemTaskServico.Obter().SingleOrDefault(t => t.Titulo.Equals("Teste task 003")) ?? new ItemTask { Titulo = "Teste task 003" }; _itemTaskServico.Salvar(task); _itemTaskServico.Cancelar(task.Id); Assert.AreEqual(task.Status, StatusTask.Cancelado); Assert.AreEqual(task.Titulo, "Teste task 003"); }
internal void UpdateCell(ItemTask task) { titleLabel.Text = task.Title; if (task.Status == true) { ChecboxImage.Image = UIImage.FromBundle("Checked"); } else { ChecboxImage.Image = UIImage.FromBundle("Unchecked"); } }
public async Task <IActionResult> Create([Bind("Id,UserTaskId,Name")] ItemTask itemTask) { if (ModelState.IsValid) { _context.Add(itemTask); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["UserTaskId"] = new SelectList(_context.UserTask, "Id", "Desc", itemTask.UserTaskId); return(View(itemTask)); }
public override TEntity Create(TEntity item) { GetCache().Add(item); var task = new ItemTask((i) => { var result = base.Create(i as TEntity); Context.SaveChanges(); return(result); }, item); GetTaskQueue().Enqueue(task); return(item); }
public async Task AddTask(ItemTask task, int backlogItemId) { var backlogItem = await _context.BacklogItems.Include(b => b.Tasks).FirstOrDefaultAsync(b => b.Id == backlogItemId); if (backlogItem == default) { throw new Exception("Provided backlogItem id is invalid"); } backlogItem.Tasks.ToList().Add(task.ToEntity()); await _context.SaveChangesAsync(); }
private ItemTask CreateItemTask(UIGrid grid, int taskID) { ItemTask tab = new ItemTask(); GameObject item = NGUITools.AddChild(grid.gameObject, mTemp); item.SetActive(true); grid.AddChild(item.transform); tab.go = item; tab.taskID = taskID; tab.taskName = item.transform.Find("Name").GetComponent <UILabel>(); tab.taskIcon = item.transform.Find("Icon").GetComponent <UISprite>(); return(tab); }
protected override void OnActiveViewChanged(object sender, EventArgs e) { IContentView activeView = MainFormManager.MainForm.ActiveView as IContentView; if (activeView != null && activeView.Content != null && !activeView.Locked) { var content = activeView.Content as IItem; if (content != null) { Type contentType = content.GetType(); ToolStripItem.Enabled = ItemTask.IsTypeSupported(contentType); return; } } ToolStripItem.Enabled = false; }
public async Task Update(ItemTask task) { var taskToUpdate = await _context.Tasks.FirstOrDefaultAsync(t => t.Id == task.Id); if (taskToUpdate == default) { throw new Exception("Provided task id is invalid"); } taskToUpdate.Created = task.Created; taskToUpdate.Title = task.Title; taskToUpdate.Description = task.Description; await _context.SaveChangesAsync(); }
private void OnRecvSubmitTask(int pTaskID) { DTask db = ReadCfgTask.GetDataById(pTaskID); List <ItemTask> pList = mTasks[db.Type]; UIGrid grid = mGrids[db.Type]; for (int i = 0; i < pList.Count; i++) { ItemTask tab = pList[i]; if (tab.taskID == pTaskID) { grid.RemoveChild(tab.go.transform); pList.Remove(tab); GameObject.Destroy(tab.go); break; } } ResetView(); }
public bool Salvar(ItemTask entidade) { if (entidade.Id > 0) { ItemTask task = _contexto.Tasks.Find(entidade.Id); if (task == null) { return(false); } _contexto.Entry(task).CurrentValues.SetValues(entidade); } else { _contexto.Tasks.Add(entidade); } return(_contexto.SaveChanges() > 0); }
public override void Update(TEntity item) { var cachedItem = GetCache().OfType <TEntity>().FirstOrDefault(i => i.Id.Equals(item.Id)); if (cachedItem == null) { GetCache().Add(item); } else { cachedItem = item; } var task = new ItemTask((i) => { base.Update(i as TEntity); Context.SaveChanges(); return(null); }, item); GetTaskQueue().Enqueue(task); }
private void jobsTreeView_DragEnter(object sender, DragEventArgs e) { e.Effect = DragDropEffects.None; var obj = (IDeepCloneable)e.Data.GetData(Constants.DragDropDataFormat); Type objType = obj.GetType(); if (ItemTask.IsTypeSupported(objType)) { if (Content.Id != Guid.Empty) { e.Effect = DragDropEffects.None; } else if ((e.KeyState & 32) == 32) { e.Effect = DragDropEffects.Link; // ALT key } else if (e.AllowedEffect.HasFlag(DragDropEffects.Copy)) { e.Effect = DragDropEffects.Copy; } } }
public override void Execute() { IContentView activeView = MainFormManager.MainForm.ActiveView as IContentView; content = activeView.Content as IItem; //IOptimizer and IExecutables need some special care if (content is IOptimizer) { ((IOptimizer)content).Runs.Clear(); } if (content is IExecutable) { IExecutable exec = content as IExecutable; if (exec.ExecutionState != ExecutionState.Prepared) { exec.Prepare(); } } HiveClient.Instance.Refresh(); ItemTask hiveTask = ItemTask.GetItemTaskForItem(content); HiveTask task = hiveTask.CreateHiveTask(); RefreshableJob rJob = new RefreshableJob(); rJob.Job.Name = content.ToString(); rJob.HiveTasks.Add(task); task.ItemTask.ComputeInParallel = content is Experiment || content is BatchRun; progress = MainFormManager.GetMainForm <MainForm.WindowsForms.MainForm>().AddOperationProgressToContent(this.content, "Uploading to Hive..."); rJob.Progress = progress; progress.ProgressStateChanged += progress_ProgressStateChanged; HiveClient.StartJob(new Action <Exception>(HandleEx), rJob, new CancellationToken()); }
private async Task ShowTaskChanged(ItemTask _taskCreate) { var result = await _navigationService.Navigate <TaskChangedViewModel, ItemTask>(_taskCreate); }
public void SaveItem(ItemTask item) => ItemDataBase.Insert(item);
// Start is called before the first frame update public virtual void Start() { gameTask = Utility.GetGameTask(); itemTask = Utility.GetTaskObject().GetComponent <ItemTask>(); UseSet(); }
private static void GenerateRunningTask(string Subsidary) { int TaskRunType = Utility.ConvertToInt(ConfigurationManager.AppSettings["TaskRunType"]); if (TaskRunType == 1 || TaskRunType == 3) { #region Setting //NetSuiteBaseIntegration[] NetSuitetaskBase = new NetSuiteBaseIntegration[1]; //NetSuitetaskBase[0] = new SettingTask(); //foreach (NetSuiteBaseIntegration ts in NetSuitetaskBase) //{ // try // { // ts.Set(""); // ts.Get(); // } // catch (Exception ex) // { // LogDAO.Integration_Exception(LogIntegrationType.Error, "NetSuitetaskBase Main Program Error", "Error " + ex.Message); // } //} #endregion //foodics integeration Foodics_BaseIntegration[] FoodicstaskInital = new Foodics_BaseIntegration[8]; FoodicstaskInital[0] = new FoodicsBranche_Task(); FoodicstaskInital[1] = new FoodicsPaymentMethod_Task(); FoodicstaskInital[2] = new FoodicsProductCategories_task(); FoodicstaskInital[3] = new FoodicsInventoryCategories_task(); FoodicstaskInital[4] = new FoodicsModifiers_task(); FoodicstaskInital[5] = new FoodicsInventoryItem_Task(); FoodicstaskInital[6] = new FoodicsdDiscounts_Task(); FoodicstaskInital[7] = new FoodicsOtherChargetem_Task(); foreach (Foodics_BaseIntegration ts in FoodicstaskInital) { try { LogDAO.Integration_Exception(LogIntegrationType.Error, "FoodicstaskInital Main Program Task", ts.GetType().Name); ts.Get(Subsidary); } catch (Exception ex) { LogDAO.Integration_Exception(LogIntegrationType.Error, "FoodicstaskInital Main Program Error", "Error " + ex.Message); } } NetSuiteBaseIntegration[] NetSuitetaskInitial = new NetSuiteBaseIntegration[6]; NetSuitetaskInitial[0] = new ProductClassTask(); NetSuitetaskInitial[1] = new LocationTask(); NetSuitetaskInitial[2] = new UnitsTypeTask(); NetSuitetaskInitial[3] = new ItemTask(); NetSuitetaskInitial[4] = new DiscountTask(); NetSuitetaskInitial[5] = new ChargeItemTask(); foreach (NetSuiteBaseIntegration ts in NetSuitetaskInitial) { try { LogDAO.Integration_Exception(LogIntegrationType.Error, "NetSuitetaskInitial Main Program Task", ts.GetType().Name); ts.Set(""); ts.Get(); } catch (Exception ex) { LogDAO.Integration_Exception(LogIntegrationType.Error, "NetSuitetaskInitial Main Program Error", "Error " + ex.Message); } } Foodics_BaseIntegration[] Foodicstask2 = new Foodics_BaseIntegration[3]; Foodicstask2[0] = new Foodicsproducts_Task(); if (Utility.ConvertToInt(ConfigurationManager.AppSettings["ModifierOptionProduct"]) == 1) { Foodicstask2[1] = new FoodicsModifierOptionProduct_Task(); //for Delicious } else { Foodicstask2[1] = new FoodicsModifierOptionsService_Task();//for Overdooose } Foodicstask2[2] = new FoodicsPaymentMethod_Task(); foreach (Foodics_BaseIntegration ts in Foodicstask2) { try { LogDAO.Integration_Exception(LogIntegrationType.Error, "Foodicstask2 Main Program Task", ts.GetType().Name); ts.Get(Subsidary); } catch (Exception ex) { LogDAO.Integration_Exception(LogIntegrationType.Error, "Foodicstask2 Main Program Error", "Error " + ex.Message); } } NetSuiteBaseIntegration[] NetSuitetask02 = new NetSuiteBaseIntegration[3]; NetSuitetask02[0] = new PaymentMethodTask(); NetSuitetask02[1] = new ProductTask(); NetSuitetask02[2] = new ServiceItemTask(); foreach (NetSuiteBaseIntegration ts in NetSuitetask02) { try { LogDAO.Integration_Exception(LogIntegrationType.Error, "NetSuitetask02 Main Program Task", ts.GetType().Name); ts.Set(""); ts.Get(); } catch (Exception ex) { LogDAO.Integration_Exception(LogIntegrationType.Error, "NetSuitetask02 Main Program Error", "Error " + ex.Message); } } } if (TaskRunType == 2 || TaskRunType == 3) { Foodics_BaseIntegration[] FoodicstaskFinal = new Foodics_BaseIntegration[2]; FoodicstaskFinal[0] = new FoodicsCustomer_Task(); FoodicstaskFinal[1] = new FoodicsOrder_Task(); foreach (Foodics_BaseIntegration ts in FoodicstaskFinal) { try { ts.Get(Subsidary); } catch (Exception ex) { LogDAO.Integration_Exception(LogIntegrationType.Error, "NetSuitetaskInitial Main Program Error", "Error " + ex.Message); } } NetSuiteBaseIntegration[] NetSuitetaskFinal = new NetSuiteBaseIntegration[7]; NetSuitetaskFinal[0] = new CustomerTask(); NetSuitetaskFinal[1] = new AssemblyBuildTask(); NetSuitetaskFinal[2] = new InvoiceTask(); NetSuitetaskFinal[3] = new CustomerPaymentTask(); NetSuitetaskFinal[4] = new CreditMemoTask(); NetSuitetaskFinal[5] = new CustomerRefundTask(); NetSuitetaskFinal[6] = new AdjustmentBuildTask(); foreach (NetSuiteBaseIntegration ts in NetSuitetaskFinal) { try { ts.Set(""); ts.Get(); } catch (Exception ex) { LogDAO.Integration_Exception(LogIntegrationType.Error, "NetSuitetaskFinal Main Program Error", "Error " + ex.Message); } } } }
public static void GetItemsInfo() { sLogger.Info("Loading items informations..."); using (var connection = sDefaultPool.GetConnection()) { using (var command = connection.CreateCommand()) { command.CommandText = ( "SELECT `id`, `name`, `req_profession`, `req_weaponskill`, `req_level`, `req_sex`, " + "`req_force`, `req_speed`, `req_health`, `req_soul`, `monopoly`, `weight`, `price`, `task`, " + "`attack_max`, `attack_min`, `defense`, `dexterity`, `dodge`, `life`, `mana`, " + "`amount`, `amount_limit`, `status`, `gem1`, `gem2`, `magic1`, `magic2`, `magic3`, " + "`magic_atk`, `magic_def`, `atk_range`, `atk_speed` FROM `itemtype`"); command.Prepare(); sLogger.Debug("Executing SQL: {0}", GetSqlCommand(command)); using (var reader = command.ExecuteReader()) { while (reader.Read()) { Item.Info entry = new Item.Info(); entry.ID = reader.GetInt32("id"); entry.Name = reader.GetString("name"); entry.RequiredProfession = reader.GetByte("req_profession"); entry.RequiredWeaponSkill = reader.GetByte("req_weaponskill"); entry.RequiredLevel = reader.GetByte("req_level"); entry.RequiredSex = reader.GetByte("req_sex"); entry.RequiredForce = reader.GetUInt16("req_force"); entry.RequiredSpeed = reader.GetUInt16("req_speed"); entry.RequiredHealth = reader.GetUInt16("req_health"); entry.RequiredSoul = reader.GetUInt16("req_soul"); entry.Monopoly = reader.GetByte("monopoly"); entry.Weight = reader.GetUInt16("weight"); entry.Price = reader.GetUInt32("price"); entry.Task = null; entry.MaxAttack = reader.GetUInt16("attack_max"); entry.MinAttack = reader.GetUInt16("attack_min"); entry.Defense = reader.GetInt16("defense"); entry.Dexterity = reader.GetInt16("dexterity"); entry.Dodge = reader.GetInt16("dodge"); entry.Life = reader.GetInt16("life"); entry.Mana = reader.GetInt16("mana"); entry.Amount = reader.GetUInt16("amount"); entry.AmountLimit = reader.GetUInt16("amount_limit"); entry.Status = reader.GetByte("status"); entry.Gem1 = reader.GetByte("gem1"); entry.Gem2 = reader.GetByte("gem2"); entry.Magic1 = reader.GetByte("magic1"); entry.Magic2 = reader.GetByte("magic2"); entry.Magic3 = reader.GetByte("magic3"); entry.MagicAttack = reader.GetUInt16("magic_atk"); entry.MagicDefence = reader.GetUInt16("magic_def"); entry.Range = reader.GetUInt16("atk_range"); entry.AttackSpeed = reader.GetUInt16("atk_speed"); if (!AllItems.ContainsKey(entry.ID)) { AllItems.Add(entry.ID, entry); } } } } } String[] scripts = Directory.GetFiles(Program.RootPath + "/Items", "*.lua"); for (Int32 i = 0; i < scripts.Length; i++) { FileInfo file = new FileInfo(scripts[i]); Int32 uid = Int32.Parse(file.Name.Replace(".lua", "")); try { ItemTask task = new ItemTask(uid, file.FullName); Item.Info info; if (AllItems.TryGetValue(uid, out info)) { info.Task = task; AllItems[uid] = info; } } catch (SyntaxErrorException exc) { sLogger.Error("Failed to load the task {0}. Error: {1}", uid, exc.Message); } } }
public void Load_table() { Dictionary <string, MyColumn> MyColumns = new Dictionary <string, MyColumn>(); System.Data.DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_task_details({0})", (System.Windows.Application.Current.Resources["User"] as UserInfo).ID)).Tables[0]; currenttable = table; list.Clear(); for (int i = 0; i < table.Rows.Count; i++) { DeptItem info = new DeptItem(); info.DeptId = table.Rows[i][0].ToString(); info.DeptName = table.Rows[i][1].ToString(); info.ItemId = table.Rows[i][2].ToString(); info.ItemName = table.Rows[i][3].ToString(); info.Task = table.Rows[i][4].ToString(); list.Add(info); } //得到行和列标题 及数量 string[] DeptNames = list.Select(t => t.DeptName).Distinct().ToArray(); string[] ItemNames = list.Select(t => t.ItemName).Distinct().ToArray(); //创建DataTable System.Data.DataTable tabledisplay = new System.Data.DataTable(); //表中第一行第一列交叉处一般显示为第1列标题 //tabledisplay.Columns.Add(new DataColumn("序号")); //MyColumns.Add("序号", new MyColumn("序号", "序号") { BShow = true, Width = 10 }); switch (user_flag_tier) { case "0": tabledisplay.Columns.Add(new DataColumn("省名称")); MyColumns.Add("省名称", new MyColumn("省名称", "省名称") { BShow = true, Width = 20 }); break; case "1": tabledisplay.Columns.Add(new DataColumn("市(州)单位名称")); MyColumns.Add("市(州)单位名称", new MyColumn("市(州)单位名称", "市(州)单位名称") { BShow = true, Width = 20 }); break; case "2": tabledisplay.Columns.Add(new DataColumn("区县名称")); MyColumns.Add("区县名称", new MyColumn("区县名称", "区县名称") { BShow = true, Width = 20 }); break; case "3": tabledisplay.Columns.Add(new DataColumn("检测单位名称")); MyColumns.Add("检测单位名称", new MyColumn("检测单位名称", "检测单位名称") { BShow = true, Width = 20 }); break; case "4": tabledisplay.Columns.Add(new DataColumn("检测单位名称")); MyColumns.Add("检测单位名称", new MyColumn("检测单位名称", "检测单位名称") { BShow = true, Width = 20 }); break; default: break; } //表中后面每列的标题其实是列分组的关键字 for (int i = 0; i < ItemNames.Length; i++) { DataColumn column = new DataColumn(ItemNames[i]); tabledisplay.Columns.Add(column); MyColumns.Add(ItemNames[i].ToLower(), new MyColumn(ItemNames[i].ToLower(), ItemNames[i]) { BShow = true, Width = 15 }); } //为表中各行生成数据 for (int i = 0; i < DeptNames.Length; i++) { var row = tabledisplay.NewRow(); //每行第0列为行分组关键字 //row[0] = i + 1; row[0] = DeptNames[i]; //每行的其余列为行列交叉对应的汇总数据 for (int j = 0; j < ItemNames.Length; j++) { string num = list.Where(t => t.DeptName == DeptNames[i] && t.ItemName == ItemNames[j]).Select(t => t.Task).FirstOrDefault(); if (num == null || num == "") { num = '0'.ToString(); } row[ItemNames[j]] = num; } tabledisplay.Rows.Add(row); } if (table.Rows.Count != 0) { //表格最后添加合计行 tabledisplay.Rows.Add(tabledisplay.NewRow()[1] = "合计"); for (int j = 1; j < tabledisplay.Columns.Count; j++) { int sum = 0; for (int i = 0; i < tabledisplay.Rows.Count - 1; i++) { sum += Convert.ToInt32(tabledisplay.Rows[i][j].ToString()); } //sum_column += sum; tabledisplay.Rows[tabledisplay.Rows.Count - 1][j] = sum; } System.Data.DataTable tasktable = dbOperation.GetDbHelper().GetDataSet("select t_det_item.ItemNAME,task " + "from t_task_assign_new left JOIN t_det_item ON t_task_assign_new.iid = t_det_item.ItemID " + "where t_task_assign_new.did = " + deptid).Tables[0]; List <ItemTask> listtask = new List <ItemTask>(); listtask.Clear(); for (int i = 0; i < tasktable.Rows.Count; i++) { ItemTask task = new ItemTask(); task.ItemName = tasktable.Rows[i][0].ToString(); task.Task = tasktable.Rows[i][1].ToString(); listtask.Add(task); } if (user_flag_tier != "1") { //表格最后添加上级分配任务量 tabledisplay.Rows.Add(tabledisplay.NewRow()[1] = "上级下达任务量"); for (int j = 1; j < tabledisplay.Columns.Count; j++) { string task = listtask.Where(s => s.ItemName == tabledisplay.Columns[j].ColumnName.ToString()).Select(s => s.Task).FirstOrDefault(); if (task == null || task == "") { task = '0'.ToString(); } tabledisplay.Rows[tabledisplay.Rows.Count - 1][j] = task; } //表格最后添加未分配量 tabledisplay.Rows.Add(tabledisplay.NewRow()[1] = "未分配量"); for (int j = 1; j < tabledisplay.Columns.Count; j++) { int rwl = Convert.ToInt32(tabledisplay.Rows[tabledisplay.Rows.Count - 2][j].ToString()); int yfp = Convert.ToInt32(tabledisplay.Rows[tabledisplay.Rows.Count - 3][j].ToString()); int wfp = rwl - yfp; tabledisplay.Rows[tabledisplay.Rows.Count - 1][j] = wfp; } } } exporttable = tabledisplay; _tableview.BShowModify = true; _tableview.MyColumns = MyColumns; _tableview.Table = tabledisplay; }
public void AddItem(ItemTask item) { dispatcher.AddTask (item); }
public void Load_table() { Dictionary<string, MyColumn> MyColumns = new Dictionary<string, MyColumn>(); System.Data.DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_task_details('{0}','{1}')", (System.Windows.Application.Current.Resources["User"] as UserInfo).ID, dept_type)).Tables[0]; currenttable = table; list.Clear(); for (int i = 0; i < table.Rows.Count; i++) { DeptItem info = new DeptItem(); info.DeptId = table.Rows[i][0].ToString(); info.DeptName = table.Rows[i][1].ToString(); info.ItemId = table.Rows[i][2].ToString(); info.ItemName = table.Rows[i][3].ToString(); info.Task = table.Rows[i][4].ToString(); list.Add(info); } //得到行和列标题 及数量 string[] DeptNames = list.Select(t => t.DeptName).Distinct().ToArray(); string[] ItemNames = list.Select(t => t.ItemName).Distinct().ToArray(); //创建DataTable System.Data.DataTable tabledisplay = new System.Data.DataTable(); //表中第一行第一列交叉处一般显示为第1列标题 //tabledisplay.Columns.Add(new DataColumn("序号")); //MyColumns.Add("序号", new MyColumn("序号", "序号") { BShow = true, Width = 10 }); //switch (user_flag_tier) //{ // case "0": tabledisplay.Columns.Add(new DataColumn("省名称")); // MyColumns.Add("省名称", new MyColumn("省名称", "省名称") { BShow = true, Width = 20 }); // break; // case "1": tabledisplay.Columns.Add(new DataColumn("市(州)单位名称")); // MyColumns.Add("市(州)单位名称", new MyColumn("市(州)单位名称", "市(州)单位名称") { BShow = true, Width = 20 }); // break; // case "2": tabledisplay.Columns.Add(new DataColumn("区县名称")); // MyColumns.Add("区县名称", new MyColumn("区县名称", "区县名称") { BShow = true, Width = 20 }); // break; // case "3": tabledisplay.Columns.Add(new DataColumn("检测单位名称")); // MyColumns.Add("检测单位名称", new MyColumn("检测单位名称", "检测单位名称") { BShow = true, Width = 20 }); // break; // case "4": tabledisplay.Columns.Add(new DataColumn("检测单位名称")); // MyColumns.Add("检测单位名称", new MyColumn("检测单位名称", "检测单位名称") { BShow = true, Width = 20 }); // break; // default: break; //} tabledisplay.Columns.Add(new DataColumn("部门名称")); MyColumns.Add("部门名称", new MyColumn("部门名称", "部门名称") { BShow = true, Width = 20 }); //表中后面每列的标题其实是列分组的关键字 for (int i = 0; i < ItemNames.Length; i++) { DataColumn column = new DataColumn(ItemNames[i]); tabledisplay.Columns.Add(column); MyColumns.Add(ItemNames[i], new MyColumn(ItemNames[i], ItemNames[i]) { BShow = true, Width = 15 }); } //为表中各行生成数据 for (int i = 0; i < DeptNames.Length; i++) { var row = tabledisplay.NewRow(); //每行第0列为行分组关键字 //row[0] = i + 1; row[0] = DeptNames[i]; //每行的其余列为行列交叉对应的汇总数据 for (int j = 0; j < ItemNames.Length; j++) { string num = list.Where(t => t.DeptName == DeptNames[i] && t.ItemName == ItemNames[j]).Select(t => t.Task).FirstOrDefault(); if (num == null || num == "") { num = '0'.ToString(); } row[ItemNames[j]] = num; } tabledisplay.Rows.Add(row); } if (table.Rows.Count != 0) { //表格最后添加合计行 tabledisplay.Rows.Add(tabledisplay.NewRow()[1] = "合计"); for (int j = 1; j < tabledisplay.Columns.Count; j++) { int sum = 0; for (int i = 0; i < tabledisplay.Rows.Count - 1; i++) { sum += Convert.ToInt32(tabledisplay.Rows[i][j].ToString()); } //sum_column += sum; tabledisplay.Rows[tabledisplay.Rows.Count - 1][j] = sum; } System.Data.DataTable tasktable = dbOperation.GetDbHelper().GetDataSet("select t_det_item.ItemNAME,task " + "from t_task_assign_new left JOIN t_det_item ON t_task_assign_new.iid = t_det_item.ItemID " + "where t_task_assign_new.did = " + deptid).Tables[0]; List<ItemTask> listtask = new List<ItemTask>(); listtask.Clear(); for (int i = 0; i < tasktable.Rows.Count; i++) { ItemTask task = new ItemTask(); task.ItemName = tasktable.Rows[i][0].ToString(); task.Task = tasktable.Rows[i][1].ToString(); listtask.Add(task); } if (user_flag_tier != "1") { //表格最后添加上级分配任务量 tabledisplay.Rows.Add(tabledisplay.NewRow()[1] = "上级下达任务量"); for (int j = 1; j < tabledisplay.Columns.Count; j++) { string task = listtask.Where(s => s.ItemName == tabledisplay.Columns[j].ColumnName.ToString()).Select(s => s.Task).FirstOrDefault(); if (task == null || task == "") { task = '0'.ToString(); } tabledisplay.Rows[tabledisplay.Rows.Count - 1][j] = task; } //表格最后添加未分配量 tabledisplay.Rows.Add(tabledisplay.NewRow()[1] = "未分配量"); for (int j = 1; j < tabledisplay.Columns.Count; j++) { int rwl = Convert.ToInt32(tabledisplay.Rows[tabledisplay.Rows.Count - 2][j].ToString()); int yfp = Convert.ToInt32(tabledisplay.Rows[tabledisplay.Rows.Count - 3][j].ToString()); int wfp = rwl - yfp; tabledisplay.Rows[tabledisplay.Rows.Count - 1][j] = wfp; } } } exporttable = tabledisplay; _tableview.BShowModify = true; _tableview.MyColumns = MyColumns; _tableview.Table = tabledisplay; }