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;
}
