开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
TransferWorkItems.aspx.cs
资源名称：H3_OA.rar　[点击查看]
上传用户：li2971742
上传日期：2021-11-18
资源大小：39096k
文件大小：4k
源码类别：

OA系统

开发平台：

C#

TransferWorkItems.aspx.cs：源码内容
  1. using System;
  2. using System.Collections;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.HtmlControls;
  9. using System.Web.UI.WebControls;
  10. using System.Web.UI.WebControls.WebParts;
  12. namespace OThinker.H3.Portal
  13. {
  14.     public partial class TransferWorkItems : PortalPage
  15.     {
  16.         protected void Page_Load(object sender, EventArgs e)
  17.         {
  18.             if (!this.IsPostBack)
  19.             {
  20.                 // 验证是否具有管理员权限
  21.                 if (!this.UserValidator.ValidateAdministrator())
  22.                 {
  23.                     this.NotifyMessage(LackOfAuth);
  24.                 }
  25.             }
  26.         }
  28.         protected void lnkQuery_Click(object sender, EventArgs e)
  29.         {
  30.             if (this.txtSource.SelectedUser == null || this.txtSource.SelectedUser == "")
  31.             {
  32.                 this.NotifyMessage("没有选中转移谁的工作项");
  33.             }
  35.             // 查询可转移的工作项
  36.             OThinker.Data.Database.CommandFactory factory = new OThinker.Data.Database.CommandFactory(
  37.                 OThinker.H3.Configs.Config.Current.DataBase.DBType,
  38.                 OThinker.H3.Configs.Config.Current.DataBase.DBConnString);
  39.             OThinker.Data.Database.ICommand command = factory.CreateCommand();
  40.             System.Data.DataTable table = command.ExecuteDataTable(
  41.                 "SELECT * FROM " + OThinker.H3.WorkItem.WorkItem.TableName + " " +
  42.                 "WHERE " +
  43.                 OThinker.H3.WorkItem.WorkItem.PropertyName_Receiptor + "='" + this.txtSource.SelectedUser + "' OR " +
  44.                 "(" + OThinker.H3.WorkItem.WorkItem.PropertyName_Participant + "='" + this.txtSource.SelectedUser + "' AND " + WorkItem.WorkItem.PropertyName_Receiptor + " IS NULL)");
  45.             this.WorkItemGrid.BindDataGrid(table);
  46.         }
  48.         protected void lnkOk_Click(object sender, EventArgs e)
  49.         {
  50.             string source = this.txtSource.SelectedUser;
  51.             if (source == null || source == "")
  52.             {
  53.                 this.NotifyMessage("没有选中转移谁的工作项");
  54.             }
  56.             string receiptor = this.txtReceiptor.SelectedUser;
  57.             if (receiptor == null || receiptor == "")
  58.             {
  59.                 this.NotifyMessage("没有选中转移的接收人");
  60.             }
  62.             // 查询可转移的工作项
  63.             OThinker.Data.Database.CommandFactory factory = new OThinker.Data.Database.CommandFactory(
  64.                 OThinker.H3.Configs.Config.Current.DataBase.DBType,
  65.                 OThinker.H3.Configs.Config.Current.DataBase.DBConnString);
  66.             OThinker.Data.Database.ICommand command = factory.CreateCommand();
  67.             System.Data.DataTable table = command.ExecuteDataTable(
  68.                 "SELECT [" + WorkItem.WorkItem.PropertyName_ObjectID + "] FROM " + OThinker.H3.WorkItem.WorkItem.TableName + " " +
  69.                 "WHERE " +
  70.                 OThinker.H3.WorkItem.WorkItem.PropertyName_Receiptor + "='" + source + "' OR " +
  71.                 "(" + OThinker.H3.WorkItem.WorkItem.PropertyName_Participant + "='" + source + "' AND " + WorkItem.WorkItem.PropertyName_Receiptor + " IS NULL)");
  73.             // 转移工作项
  74.             int successCount = 0;
  75.             foreach (System.Data.DataRow row in table.Rows)
  76.             {
  77.                 string itemId = (string)row[0];
  78.                 long result = OThinker.H3.Server.Engine.WorkItemManager.Transfer(itemId, this.txtReceiptor.SelectedUser);
  79.                 if (result == ErrorCode.SUCCESS)
  80.                 {
  81.                     successCount++;
  82.                 }
  83.             }
  84.             this.NotifyMessage("成功转移" + successCount + "项工作项，总共需要转移" + table.Rows.Count + "项工作项。从用户" + OThinker.H3.Server.Engine.Organization.GetFullName(source) + "到用户" + OThinker.H3.Server.Engine.Organization.GetFullName(receiptor));
  85.         }
  86.     }
  87. }