public DataTable D_Exclusive_Lock_Check(StaffEntity se)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@DataKBN", SqlDbType.Int)
{
Value = "1"
};
parameters[1] = new SqlParameter("@Number", SqlDbType.VarChar)
{
Value = se.StaffName
};
parameters[2] = new SqlParameter("@OperatorCD", SqlDbType.VarChar)
{
Value = se.OperatorCD
};
parameters[3] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = se.ProgramID
};
parameters[4] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = se.PC
};
DataTable dt = ckmdl.SelectDatatable("D_Exclusive_Lock_Check", GetConnectionString(), parameters);
return(dt);
}
public string IdouNyuuryoku_Exclusive_Insert(StaffEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@DataKBN", SqlDbType.VarChar)
{
Value = "15"
};
parameters[1] = new SqlParameter("@Number", SqlDbType.VarChar)
{
Value = obj.StaffName
};
parameters[2] = new SqlParameter("@Operator", SqlDbType.VarChar)
{
Value = obj.OperatorCD
};
parameters[3] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = "IdouNyuuryoku"
};
parameters[4] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = obj.PC
};
return(ckmdl.InsertUpdateDeleteData("D_Exclusive_Insert", GetConnectionString(), parameters));
}
public virtual ActionResult Unbind(StaffModel model)
{
var result = new Dictionary <string, object>();
var entity = new StaffEntity
{
Id = model.Id.Convert <long>(),
Account = new AccountEntity {
Id = 0
},
SaveType = SaveType.Modify
};
entity.SetProperty(it => it.Account.Id);
var rev = this.SaveEntity(entity);
if (rev)
{
result.Add("Id", entity.Id.ToString());
}
else
{
result.Add("Message", entity.Errors?.FirstOrDefault()?.Message);
}
result.Add("Status", rev);
return(this.Jsonp(result));
}
public bool IndertStaff(StaffEntity request)
{
using (var Db = GetDbConnection())
{
var sql = @"INSERT INTO dbo.sys_Staff
(StaffName
,Gender
,Role
,Mobile
,Email
,PassWord
,CreateTime
,ModifyTime)
VALUES
(@StaffName
,@Gender
,@Role
,@Mobile
,@Email
,@PassWord
,@CreateTime
,@ModifyTime)";
return(Db.Execute(sql, request) > 0);
}
}
public ResponseContext <bool> AddOrUpdateStaff(StaffEntity request)
{
bool success = true;
if (request.StaffId <= 0)
{
request.PassWord = Md5Helper.GetMd5Str32(JsonSettingHelper.AppSettings["DefaultPassWord"]);
request.CreateTime = DateTime.Now;
request.ModifyTime = DateTime.Now;
success = sysDal.IndertStaff(request);
}
else
{
request.ModifyTime = DateTime.Now;
success = sysDal.UpdateStaff(request);
}
if (success)
{
return(new ResponseContext <bool>(success));
}
else
{
return(new ResponseContext <bool>(false, ErrCodeEnum.InnerError, success));
}
}
public static void Initialize(StaffAppContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.StaffEntities.Any())
{
return; // DB has been seeded
}
var staff = new StaffEntity[]
{
new StaffEntity {
Firstname = "Carson", Lastname = "Alexander", Email = "*****@*****.**"
},
new StaffEntity {
Firstname = "Per", Lastname = "Jensen", Email = "*****@*****.**"
},
new StaffEntity {
Firstname = "Hans", Lastname = "Hansen", Email = "*****@*****.**"
},
};
foreach (StaffEntity s in staff)
{
context.StaffEntities.Add(s);
}
context.SaveChanges();
}
public async Task <IActionResult> Edit(int id, [Bind("StaffEntityId,Firstname,Lastname,Email")] StaffEntity staffEntity)
{
if (id != staffEntity.StaffEntityId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(staffEntity);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StaffEntityExists(staffEntity.StaffEntityId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(staffEntity));
}
//取消报障单
public void CancelOrder(Guid orderID)
{
// TODO 增加判断，只能取消未处理完的工单
PermissionService permissionService = new PermissionService();
EntityManager <OrderEntity> orderManager = new EntityManager <OrderEntity>();
EntityManager <OrderFlowEntity> orderflowManager = new EntityManager <OrderFlowEntity>();
//1.0 获取当前员工数据
StaffEntity staff = permissionService.GetCurrentStaff();
//2.0 修改工单实体
List <KeyValuePair <string, object> > kvps = new List <KeyValuePair <string, object> >();
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldStatus, (int)OrderStatus.Canceled));
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldOperateTime, DateTime.Now));
int rows = orderManager.Update(kvps, orderID);
if (rows == 0)
{
throw new JSException(JSErrMsg.ERR_CODE_DATA_MISSING, string.Format(JSErrMsg.ERR_MSG_DATA_MISSING, "工单实体"));
}
//3.0 添加工作流实体
OrderFlowEntity orderflow = new OrderFlowEntity();
orderflow.OrderID = orderID;
orderflow.OperatorID = staff.ID;
orderflow.NextOperatorID = 0;
orderflow.Operation = (int)OperationEnum.Cancel;
orderflow.OperateTime = DateTime.Now;
orderflow.Remark = "";
orderflowManager.Insert(orderflow);
}
private void txtIdouNO_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (!txtIdouNO.IsErrorOccurs)
{
StaffEntity obj_staff = new StaffEntity();
obj_staff.OperatorCD = OperatorCD;
obj_staff.PC = PCID;
obj_staff.StaffName = txtIdouNO.Text;
if (cboMode.SelectedValue.ToString() == "2")//update
{
Idou_BL.IdouNyuuryoku_Exclusive_Insert(obj_staff);
EnablePanel();
}
else if (cboMode.SelectedValue.ToString() == "3" || cboMode.SelectedValue.ToString() == "4")
{
if (cboMode.SelectedValue.ToString() == "3")
{
Idou_BL.IdouNyuuryoku_Exclusive_Insert(obj_staff);
}
cf.DisablePanel(PanelTitle);
}
}
DataTable dt = txtIdouNO.IsDatatableOccurs;
if (dt.Rows.Count > 0 && cboMode.SelectedValue.ToString() != "1")
{
From_DB_To_Form(dt);
}
}
}
public StaffEntity Login(string userName, string pwd, string ip)
{
//判断当前session存不存在此用户
StaffEntity staff = WebHelper.GetSessionObj(WebHelper.USER_LOGIN_SESSION) as StaffEntity;
if (staff != null)
{
WebHelper.RemoveSession(WebHelper.USER_LOGIN_SESSION);
}
string encryptionPwd = EncryptionHelper.GetMd5HashStr(pwd);
staff = Repository.QueryFirst <StaffEntity>(x => (x.Name == userName || x.Code == userName) && x.Pwd == encryptionPwd);
if (staff == null)
{
throw new Exception(string.Format("用户[{0}]登录失败,请检查用户名和密码。", userName));
}
else
{
staff.LastLoginIp = ip;
Repository.Update <StaffEntity>(staff, x => x.LastLoginIp);
WebHelper.WriteSession <StaffEntity>(WebHelper.USER_LOGIN_SESSION, staff);
}
return(staff);
// StaffEntity
}
/// <summary>
/// 获取我的已发起工单
/// </summary>
/// <returns></returns>
public DataTable GetMyStartedOrders(int pageIndex, int pageSize, out int count)
{
WhereStatement where = new WhereStatement();
//string sStatus = JSRequest.GetRequestUrlParm(OrderEntity.FieldStatus, false);
//int? status = JSValidator.ValidateInt(OrderEntity.FieldStatus, sStatus, false);
//if (status != null) { where.Add(OrderEntity.FieldStatus, Comparison.Equals, status); }
PermissionService permissionService = new PermissionService();
ViewManager manager = new ViewManager("VO_Order");
//1.0 获取当前员工数据
StaffEntity staff = permissionService.GetCurrentStaff();
//2.0 构建where从句
where.Add(OrderEntity.FieldStarterID, Comparison.Equals, staff.ID);
where.Add(OrderEntity.FieldStatus, Comparison.NotEquals, (int)OrderStatus.Canceled);
OrderByStatement orderby = new OrderByStatement();
orderby.Add(OrderEntity.FieldPriority, Sorting.Descending);
orderby.Add(OrderEntity.FieldBookingTime, Sorting.Ascending);
//3.0 获取已发起的数据
DataTable dt = manager.GetDataTableByPage(where, out count, pageIndex, pageSize, orderby);
return(dt);
}
//发起报障单
public void StartOrder(OrderEntity order)
{
PermissionService permissionService = new PermissionService();
EntityManager <OrderEntity> orderManager = new EntityManager <OrderEntity>();
EntityManager <OrderFlowEntity> orderflowManager = new EntityManager <OrderFlowEntity>();
//1.0 获取当前员工数据
StaffEntity staff = permissionService.GetCurrentStaff();
//2.0 添加工单实体
order.ID = Guid.NewGuid();
order.Status = (int)OrderStatus.Appointing;
order.StarterID = staff.ID;
order.OperatorID = staff.ID;
order.Status = (int)OrderStatus.Appointing;
order.StartTime = DateTime.Now;
order.OperateTime = DateTime.Now;
if (string.IsNullOrEmpty(order.Attn) || string.IsNullOrEmpty(order.AttnTel))
{
order.Attn = staff.Name;
order.AttnTel = staff.Tel;
}
string s = orderManager.Insert(order);
//3.0 添加工作流实体
OrderFlowEntity orderFlow = new OrderFlowEntity();
orderFlow.OrderID = order.ID;
orderFlow.OperatorID = staff.ID;
orderFlow.NextOperatorID = 0;
orderFlow.Operation = (int)OperationEnum.Start;
orderFlow.OperateTime = DateTime.Now;
orderFlow.Remark = "";
orderflowManager.Insert(orderFlow);
}
/// <summary>
/// 获取我处理中的工单
/// </summary>
/// <returns></returns>
public DataTable GetMyHandlingOrders(int pageIndex, int pageSize, out int count)
{
PermissionService permissionService = new PermissionService();
ViewManager manager = new ViewManager("VO_Order");
//1.0 获取当前员工数据
StaffEntity staff = permissionService.GetCurrentStaff();
//2.0 构建where从句
WhereStatement where = new WhereStatement();
WhereClause clause = new WhereClause(OrderEntity.FieldStatus, Comparison.Equals, (int)OrderStatus.Handling);
clause.AddClause(LogicOperator.Or, Comparison.Equals, (int)OrderStatus.Rejected);
where.Add(clause);
where.Add(OrderEntity.FieldHandlerID, Comparison.Equals, staff.ID);
//2.1 构建orderby 从句
OrderByStatement orderby = new OrderByStatement();
orderby.Add(OrderEntity.FieldPriority, Sorting.Descending);
orderby.Add(OrderEntity.FieldBookingTime, Sorting.Ascending);
//3.0 获取已发起的数据
DataTable dt = manager.GetDataTableByPage(where, out count, pageIndex, pageSize, orderby);
return(dt);
}
public ProgramEntity Staff_AccessCheck(StaffEntity staffEntity)
{
staffEntity.Sqlprms = new SqlParameter[3];
staffEntity.Sqlprms[0] = new SqlParameter("@StaffCD", staffEntity.StaffCD);
staffEntity.Sqlprms[1] = new SqlParameter("@ProgramID", staffEntity.ProgramID);
staffEntity.Sqlprms[2] = new SqlParameter("@PC", staffEntity.PC);
DataTable dtProgram = ckmdl.SelectDatatable("Staff_AccessCheck", GetConnectionString(), staffEntity.Sqlprms);
ProgramEntity programEntity;
string messageID = dtProgram.Rows[0]["MessageID"].ToString();
if (messageID.Equals("allow"))
{
programEntity = new ProgramEntity
{
Insertable = dtProgram.Rows[0]["Insertable"].ToString(),
Updatable = dtProgram.Rows[0]["Updatable"].ToString(),
Deletable = dtProgram.Rows[0]["Deletable"].ToString(),
Inquirable = dtProgram.Rows[0]["Inquirable"].ToString(),
Printable = dtProgram.Rows[0]["Printable"].ToString(),
Outputable = dtProgram.Rows[0]["Outputable"].ToString(),
Runable = dtProgram.Rows[0]["Runable"].ToString(),
ProgramID = dtProgram.Rows[0]["ProgramID"].ToString(),
ProgramName = dtProgram.Rows[0]["ProgramName"].ToString(),
Type = dtProgram.Rows[0]["Type"].ToString()
};
return(programEntity);
}
else
{
ShowMessage(messageID);
return(null);
}
}
public DataTable GetStaff(StaffEntity staffEntity)
{
staffEntity.Sqlprms = new SqlParameter[1];
staffEntity.Sqlprms[0] = new SqlParameter("@MessageID", staffEntity.StaffCD);
DataTable dtStaff = ckmdl.SelectDatatable("M_Staff_Select", GetConnectionString(), staffEntity.Sqlprms);
return(dtStaff);
}
public static async Task<HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)]HttpRequestMessage req, TraceWriter log)
{
log.Info("C# HTTP trigger function processed a request.");
// parse query parameter
string name = req.GetQueryNameValuePairs()
.FirstOrDefault(q => string.Compare(q.Key, "name", true) == 0)
.Value;
string designation = req.GetQueryNameValuePairs()
.FirstOrDefault(q => string.Compare(q.Key, "designation", true) == 0)
.Value;
if (name == null)
{
// Get request body
dynamic data = await req.Content.ReadAsAsync<object>();
name = data?.name;
}
if (designation == null)
{
// Get request body
dynamic data = await req.Content.ReadAsAsync<object>();
designation = data?.designation;
}
string storageAccountSetting = @"DefaultEndpointsProtocol=https;AccountName=mmebstorage;AccountKey=OVUxaTWk9L0gW2/7fjhX6gJZOAjH2me9zn6g1oQKxxQVU8TOadUaNp6JLMhGJdSi3E1MMk9ezQeo9SxXQOyzYA==;EndpointSuffix=core.windows.net";
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(storageAccountSetting);
// Create the table client.
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
// Retrieve a reference to the table.
CloudTable table = tableClient.GetTableReference("Staffs");
// Create the table if it doesn't exist.
table.CreateIfNotExists();
// Create a new customer entity.
StaffEntity Staff = new StaffEntity(name, "Active");
Staff.StartDate = DateTime.Now.ToShortDateString();
Staff.Designation = designation;
Staff.ImageURL = "http://lorempixel.com/100/100/people/1";
// Create the TableOperation object that inserts the customer entity.
TableOperation insertOperation = TableOperation.Insert(Staff);
// Execute the insert operation.
table.Execute(insertOperation);
return name == null
? req.CreateResponse(HttpStatusCode.BadRequest, "Please pass a name on the query string or in the request body")
: req.CreateResponse(HttpStatusCode.OK, "Hello " + name);
}
private static void FillStaffEntityObject(StaffEntity Fields, DataRow row)
{
//Base
Fields.ID = (row["ID"] != DBNull.Value) ? (Guid?)row["ID"] : null;
//StaffEntity
Fields.UserID = (Guid)row["UserId"];
Fields.Tier = (int)row["Tier"];
}
public Staff(StaffEntity ObjEntity)
{
Init();
Fields = ObjEntity;
if (Fields.ID != null && Fields.ID != default(Guid))
{
IsNew = false;
}
InitBaseFields();
}
private void InitBaseFields()
{
if (Fields == null)
{
Fields = new StaffEntity();
}
if (Fields.ID == null)
{
Fields.ID = Guid.NewGuid();
}
}
public void AddStaff(StaffEntity entity)
{
EntityManager <StaffEntity> manager = new EntityManager <StaffEntity>();
UserEntity user = GetCurrentUser();
entity.DeletionStateCode = (int)TrueFalse.True;
entity.CreateUserId = user.ID.ToString();
entity.CreateBy = user.UserName;
entity.CreateOn = DateTime.Now;
manager.Insert(entity);
}
public virtual void AssignFrom(StaffEntity source)
{
if (source == null) throw new ArgumentNullException(nameof(source));
this.Id = source.Id;
this.IsEnabled = source.IsEnabled;
this.Name = source.Name;
this.AccountId = source.Account.Id;
this.OrgId = source.Org.Id;
this.Department = source.Department;
}
public Invoker QueryForSingleStaff(){
var staffExample = new StaffEntity{NickName = "Kris"};
var container = Operations._();
var staffResult = (StaffEntity)container.QueryBySingleExample( staffExample );
Console.WriteLine( staffResult.Email );
return this;
}
public async Task <IActionResult> Create([Bind("StaffEntityId,Firstname,Lastname,Email")] StaffEntity staffEntity)
{
if (ModelState.IsValid)
{
_context.Add(staffEntity);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(staffEntity));
}
public static async Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequestMessage req, TraceWriter log)
{
log.Info("C# HTTP trigger function processed a request.");
// parse query parameter
string name = req.GetQueryNameValuePairs()
.FirstOrDefault(q => string.Compare(q.Key, "name", true) == 0)
.Value;
if (name == null)
{
// Get request body
dynamic data = await req.Content.ReadAsAsync <object>();
name = data?.name;
}
string storageAccountSetting = @"DefaultEndpointsProtocol=https;AccountName=mmebstorage;AccountKey=OVUxaTWk9L0gW2/7fjhX6gJZOAjH2me9zn6g1oQKxxQVU8TOadUaNp6JLMhGJdSi3E1MMk9ezQeo9SxXQOyzYA==;EndpointSuffix=core.windows.net";
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(storageAccountSetting);
// Create the table client.
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
// Retrieve a reference to the table.
CloudTable table = tableClient.GetTableReference("Staffs");
// Create a new customer entity.
StaffEntity Staff = new StaffEntity();
// Construct the query operation for all customer entities where PartitionKey="Active".
TableQuery <StaffEntity> query = new TableQuery <StaffEntity>();
//List<string> Staffs = new List<string>();
List <StaffModel> Staffs = new List <StaffModel>();
// Print the fields for each Staff.
foreach (StaffEntity entity in table.ExecuteQuery(query))
{
if (!string.IsNullOrEmpty(entity.StaffName))
{
StaffModel StaffModel = new StaffModel();
StaffModel.StaffName = entity.StaffName ?? string.Empty;
StaffModel.StartDate = entity.StartDate ?? string.Empty;
StaffModel.ImageURL = entity.ImageURL ?? string.Empty;
StaffModel.Designation = entity.Designation ?? string.Empty;
Staffs.Add(StaffModel);
}
}
return(req.CreateResponse(HttpStatusCode.OK, Staffs));
}
public StaffEntity GetStaffEntity(StaffEntity staffEntity)
{
staffEntity.Sqlprms = new SqlParameter[1];
staffEntity.Sqlprms[0] = new SqlParameter("@StaffCD", staffEntity.StaffCD);
DataTable dtStaff = ckmdl.SelectDatatable("M_Staff_Select", GetConnectionString(), staffEntity.Sqlprms);
if (dtStaff.Rows.Count > 0)
{
staffEntity.StaffName = dtStaff.Rows[0]["StaffName"].ToString();
staffEntity.LoginDate = dtStaff.Rows[0]["LoginDate"].ToString();
}
return(staffEntity);
}
public List <StaffEntity> GetStaff(STAFF_TYPE sType)
{
List <StaffEntity> staff = new List <StaffEntity>();
SqlConnection conn = new SqlConnection(STAFF_DB_CONN_STRING);
SqlCommand command = new SqlCommand("GetActiveStaffByType", conn)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.Clear();
int typeCode = ConvertStaffTypeToInt(sType);
if (typeCode > 0)
{
command.Parameters.Add(new SqlParameter("@staffType", typeCode));
}
try
{
conn.Open();
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
StaffEntity member = new StaffEntity();
member.FirstName = reader.GetString(reader.GetOrdinal("FirstName"));
member.LastName = reader.GetString(reader.GetOrdinal("LastName"));
member.Role = reader.GetString(reader.GetOrdinal("Role"));
member.Bio = reader.GetString(reader.GetOrdinal("Bio"));
string mType = reader.GetString(reader.GetOrdinal("StaffType"));
member.Category = ConvertStringToStaffType(mType);
string imgFilename = reader.GetString(reader.GetOrdinal("ImgFileName"));
member.ImgUrl = IMG_URL_PREFIX + imgFilename;
staff.Add(member);
}
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(staff);
}
public override void OnActionExecuting(HttpActionContext actionContext)
{
var notChecks = actionContext.ActionDescriptor.GetCustomAttributes <NotCheckUserAttribute>();
if (notChecks == null || notChecks.Count <= 0)
{
StaffEntity staff = WebHelper.GetSessionObj(WebHelper.USER_LOGIN_SESSION) as StaffEntity;
if (staff == null)
{
actionContext.Response = new System.Net.Http.HttpResponseMessage(System.Net.HttpStatusCode.Forbidden);
}
}
base.OnActionExecuting(actionContext);
}
internal static List <StaffEntity> MapStaffAsListOfEntities(DataSet dsFields)
{
List <StaffEntity> lst = new List <StaffEntity>();
StaffEntity entityObject;
foreach (DataRow row in dsFields.Tables[0].Rows)
{
entityObject = new StaffEntity();
FillStaffEntityObject(entityObject, row);
lst.Add(entityObject);
}
return(lst);
}
//驳回报障，需继续处理
public void RejectOrder(Guid orderID, string remark)
{
PermissionService permissionService = new PermissionService();
EntityManager <OrderEntity> orderManager = new EntityManager <OrderEntity>();
EntityManager <OrderHandlerEntity> orderHandlerManager = new EntityManager <OrderHandlerEntity>();
EntityManager <OrderFlowEntity> orderflowManager = new EntityManager <OrderFlowEntity>();
//1.0 获取当前员工数据
StaffEntity staff = permissionService.GetCurrentStaff();
//1.1 获取工单处理者列表，必备获取领队人的信息
int count = 0;
WhereStatement where = new WhereStatement();
where.Add(OrderHandlerEntity.FieldOrderID, Comparison.Equals, orderID);
List <OrderHandlerEntity> orderHandlers = orderHandlerManager.GetList(where, out count);
//2.0 修改工单实体
List <KeyValuePair <string, object> > kvps = new List <KeyValuePair <string, object> >();
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldOperatorID, staff.ID));
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldNextOperatorID, GetLeaderHandlerID(orderHandlers)));
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldStatus, (int)OrderStatus.Rejected));
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldOperateTime, DateTime.Now));
int rows = orderManager.Update(kvps, orderID);
if (rows == 0)
{
throw new JSException(JSErrMsg.ERR_CODE_DATA_MISSING, string.Format(JSErrMsg.ERR_MSG_DATA_MISSING, "工单实体"));
}
//3.0 添加工作流实体
OrderFlowEntity orderflow = new OrderFlowEntity();
orderflow.OrderID = orderID;
orderflow.OperatorID = staff.ID;
orderflow.NextOperatorID = GetLeaderHandlerID(orderHandlers);
orderflow.Operation = (int)OperationEnum.reject;
orderflow.OperateTime = DateTime.Now;
orderflow.Remark = remark;
orderflowManager.Insert(orderflow);
OrderHandleDetailEntity orderHandleDetail = new OrderHandleDetailEntity();
orderHandleDetail.OrderID = orderID;
orderHandleDetail.HandleType = (int)OrderHandleType.Others;
orderHandleDetail.HandleDetail = "驳回";
orderHandleDetail.Remark = remark;
AddHandleDetail(orderHandleDetail);
}
//报障处理完毕
public void HandledOrder(Guid orderID)
{
PermissionService permissionService = new PermissionService();
EntityManager <OrderEntity> orderManager = new EntityManager <OrderEntity>();
EntityManager <OrderFlowEntity> orderflowManager = new EntityManager <OrderFlowEntity>();
//1.0 获取当前员工数据
StaffEntity staff = permissionService.GetCurrentStaff();
//1.1 获取工单实体，以备获取发起人信息
OrderEntity order = orderManager.GetSingle(orderID);
if (order == null)
{
throw new JSException(JSErrMsg.ERR_CODE_DATA_MISSING, string.Format(JSErrMsg.ERR_MSG_DATA_MISSING, "工单实体"));
}
//2.0 修改工单实体
List <KeyValuePair <string, object> > kvps = new List <KeyValuePair <string, object> >();
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldOperatorID, staff.ID));
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldNextOperatorID, order.StarterID));
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldStatus, (int)OrderStatus.Checking));
kvps.Add(new KeyValuePair <string, object>(OrderEntity.FieldOperateTime, DateTime.Now));
int rows = orderManager.Update(kvps, orderID);
if (rows == 0)
{
throw new JSException(JSErrMsg.ERR_CODE_DATA_MISSING, string.Format(JSErrMsg.ERR_MSG_DATA_MISSING, "工单实体"));
}
//3.0 添加工作流实体
OrderFlowEntity orderflow = new OrderFlowEntity();
orderflow.OrderID = orderID;
orderflow.OperatorID = staff.ID;
orderflow.NextOperatorID = order.StarterID;//传回发起人验收。
orderflow.Operation = (int)OperationEnum.Handle;
orderflow.OperateTime = DateTime.Now;
orderflow.Remark = "";
orderflowManager.Insert(orderflow);
//4.0 添加处理进度
OrderHandleDetailEntity orderHandleDetail = new OrderHandleDetailEntity();
orderHandleDetail.OrderID = orderID;
orderHandleDetail.HandleType = (int)OrderHandleType.WanCheng;
orderHandleDetail.Remark = "已完成，送检。";
AddHandleDetail(orderHandleDetail);
}
public bool UpdateStaff(StaffEntity request)
{
using (var Db = GetDbConnection())
{
var sql = @"UPDATE dbo.sys_Staff
SET StaffName = @StaffName
, Gender = @Gender
, Role = @Role
, Mobile = @Mobile
, Email = @Email
, ModifyTime = @ModifyTime
WHERE StaffId = @StaffId";
return(Db.Execute(sql, request) > 0);
}
}
public StaffEntity GetCurrentStaff()
{
EntityManager <StaffEntity> manager = new EntityManager <StaffEntity>();
UserEntity user = GetCurrentUser();
StaffEntity staff = manager.GetSingle(user.ID, StaffEntity.FieldID);
if (staff == null)
{
throw new JSException(JSErrMsg.ERR_CODE_DATA_MISSING, string.Format(JSErrMsg.ERR_MSG_DATA_MISSING, "员工"));
}
return(staff);
}
public static PartakerInvExistsResult CheckPending(IPartakerInvManager partakerInvManager, TaskEntity task, StaffEntity staff)
{
if (partakerInvManager == null) throw new ArgumentNullException(nameof(partakerInvManager));
if (task == null) throw new ArgumentNullException(nameof(task));
if (staff == null) throw new ArgumentNullException(nameof(staff));
var pendingInvs = partakerInvManager.FetchPendingPartakerInvs(task.Id, staff.Id);
var existed = pendingInvs.FirstOrDefault();
if (existed == null)
{
return new PartakerInvExistsResult(false,"不存在对应的任务邀请.",null);
}
return new PartakerInvExistsResult(true, null, existed);
}
public static PartakerReqNotExistsResult Check(IPartakerReqManager partakerReqManager, TaskEntity task, StaffEntity staff)
{
if (partakerReqManager == null) throw new ArgumentNullException(nameof(partakerReqManager));
if (task == null) throw new ArgumentNullException(nameof(task));
if (staff == null) throw new ArgumentNullException(nameof(staff));
var pendingReqs = partakerReqManager.FetchPendingPartakerReqs(task.Id, staff.Id);
var existed = pendingReqs.SingleOrDefault();
if (existed != null)
{
return new PartakerReqNotExistsResult(false, "已经存在对应的申请信息.", null);
}
return new PartakerReqNotExistsResult(true, null, null);
}
public Invoker AddSingleStaff(){
var staff = new StaffEntity{
Id = Guid.NewGuid(),
IsOut = false,
NickName = "Kris",
Lastname = "Nile",
Firstname = "Kris",
HomeAddress = "West Jiangtou Rd.",
Email = "*****@*****.**",
Classification = StaffClassification.Officer,
Birthday = new DateTime( 1984, 8, 21 ),
Age = 27
};
Operations._().StoreSingeObject( staff );
return this;
}
private StaffEntity CreateNewStaff(int staffIndex, OrgEntity org, AccountEntity account)
{
StaffEntity staff = new StaffEntity();
staff.Id = Guid.NewGuid();
staff.Account = account;
staff.Org = org;
staff.Name = account.Name;
return staff;
}
private TaskEntity CreateNewTask(int taskIndex, StaffEntity staff)
{
TaskEntity task = new TaskEntity();
task.Id = Guid.NewGuid();
task.Name = "Task-" + taskIndex;
task.Creator = staff;
task.Level = 3;
task.Goal = task.Name;
return task;
}
/// <summary> 根据 <see cref="PartakerEntity.Task"/> 与 <see cref="PartakerEntity.Staff"/> 检查是否<b>不</b>存在相应的 <see cref="PartakerEntity"/>. </summary>
public static PartakerNotExistsResult CheckStaff(TaskEntity task, StaffEntity staff)
{
if (task == null) throw new ArgumentNullException(nameof(task));
if (staff == null) throw new ArgumentNullException(nameof(staff));
return CheckStaff(task, staff.Id);
}
