public override void SetAsservOffset(Position newPosition)
{
Position = new Position(newPosition.Angle, newPosition.Coordinates);
PositionTarget?.Set(Position.Coordinates);
OnPositionChanged(Position);
}
protected override void OnProcessOutputSchema(MutableObject newSchema)
{
PayloadData = newSchema;
PositionTarget.SetValue(Vector3.zero, newSchema);
Router.TransmitAllSchema(newSchema);
}
/// <summary>
/// 根据姓名，获取岗位目标责任书
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static PositionTarget GetTargetByName(string staffName)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("SELECT * FROM [PositionTarget] WHERE [StaffName] = @StaffName", conn);
cmd.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = staffName;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
PositionTarget pi = null;
if (sdr.Read())
{
pi = new PositionTarget();
pi.staffName = (string)sdr["StaffName"];
pi.department = (string)sdr["Department"];
pi.position = (string)sdr["Position"];
pi.formerPosition = (string)sdr["FormerPosition"];
pi.leader = (string)sdr["Leader"];
pi.year = Convert.ToInt16(sdr["Year"]);
pi.newPosition = (string)sdr["NewPosition"];
pi.duty = (string)sdr["Duty"];
pi.target = (string)sdr["Target"];
pi.monthlyIncome = (string)sdr["MonthlyIncome"];
pi.salaryLevel = (string)sdr["SalaryLevel"];
pi.ApproveProcess = sdr["ApproveProcess"] == DBNull.Value ? "" : (string)sdr["ApproveProcess"];
}
sdr.Close();
conn.Close();
return(pi);
}
protected void Page_Load(object sender, EventArgs e)
{
int recordID = Convert.ToInt32(Request["RecordID"]);
int applyID = Convert.ToInt32(Request["ApplyID"]);
bool rejected = Convert.ToBoolean(Request["rejected"]);
Apply ap = Apply.GetApplyByID(applyID);
PositionTarget pi = PositionTarget.GetTargetByID(recordID);
staffName.Text = pi.StaffName;
position.Text = pi.Position;
department.Text = pi.Department;
formerPosition.Text = pi.FormerPosition;
leader.Text = pi.Leader;
year.Text = string.Format("{0}.1.1~{1}.12.31", pi.Year, pi.Year);
newPosition.Text = pi.NewPosition;
duty.Text = pi.Duty.Replace("\n", "<br>").Replace(" ", "& nbsp;");
target.Text = pi.Target.Replace("\n", "<br>").Replace(" ", "& nbsp;");;
salaryLevel.Text = pi.SalaryLevel;
processShow.Text = pi.ApproveProcess;
string[] words = pi.MonthlyIncome.Split(',');
january.Text = words[0];
february.Text = words[1];
march.Text = words[2];
april.Text = words[3];
may.Text = words[4];
june.Text = words[5];
july.Text = words[6];
august.Text = words[7];
september.Text = words[8];
october.Text = words[9];
november.Text = words[10];
december.Text = words[11];
//用户权限相关显示功能
Users usr = (Users)Session["Identify"];
BasicInfo info = BasicInfo.GetBasicInfoByID(usr.UserID);
if (!rejected && ap.NextApprover == pi.StaffName)
{
agreeButton.Visible = false;
disagreeButton.Visible = false;
whyDisagree.Visible = false;
//可打印状态
}
else if (info.StaffName.Trim() == pi.StaffName.Trim())
{
agreeButton.Visible = false;
disagreeButton.Visible = false;
whyDisagree.Visible = false;
}
//测试阶段保持处理流程可见，运行阶段记得去掉
processShow.Visible = true;
}
private void updateApprove(string if_agree, string next, BasicInfo info, bool if_back)
{
Users usr = (Users)Session["Identify"];
int recordID = Convert.ToInt32(Request["RecordID"]);
PositionTarget pi = PositionTarget.GetTargetByID(recordID);
pi.ApproveProcess += info.StaffName.Trim() + "-" + if_agree + ",";
PositionTarget.SetPositionTargetByID(recordID, pi);
string nextApprover = next;
int applyID = Convert.ToInt32(Request["ApplyID"]);
Apply.UpdateNextApprover(applyID, nextApprover, if_back);
}
/// <summary>
/// 新增或更新岗位目标责任书
/// </summary>
/// <param name="id"></param>
/// <param name="ri"></param>
public static void SetPositionTargetByID(int id, PositionTarget pi)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd;
bool isExist = HasPositionTarget(id);
if (!isExist)
{
cmd = new SqlCommand("INSERT INTO [PositionTarget] ([StaffName], [Position], [Department], [FormerPosition], [Leader], [Year], [NewPosition], [Duty], [Target], [MonthlyIncome], [SalaryLevel], [ApproveProcess]) VALUES (@StaffName, @Position, @Department, @FormerPosition, @Leader, @Year, @NewPosition, @Duty, @Target, @MonthlyIncome, @SalaryLevel, @ApproveProcess) Select @@Identity as 'Identity'", conn);
}
else
{
cmd = new SqlCommand("UPDATE [PositionTarget] SET [StaffName]=@StaffName, [Position]=@Position, [Department]=@Department, [FormerPosition]=@FormerPosition, [Leader]=@Leader, [Year]=@Year, [NewPosition]=@NewPosition, [Duty]=@Duty, [Target]=@Target, [MonthlyIncome]=@MonthlyIncome, [SalaryLevel]=@SalaryLevel, [ApproveProcess]=@ApproveProcess WHERE [RecordID] = @RecordID", conn);
}
cmd.Parameters.Add("@RecordID", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = pi.staffName;
cmd.Parameters.Add("@Position", SqlDbType.VarChar).Value = pi.position;
cmd.Parameters.Add("@Department", SqlDbType.VarChar).Value = pi.department;
cmd.Parameters.Add("@FormerPosition", SqlDbType.VarChar).Value = pi.formerPosition;
cmd.Parameters.Add("@Leader", SqlDbType.VarChar).Value = pi.leader;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = pi.year;
cmd.Parameters.Add("@NewPosition", SqlDbType.VarChar).Value = pi.newPosition;
cmd.Parameters.Add("@Duty", SqlDbType.VarChar).Value = pi.duty;
cmd.Parameters.Add("@Target", SqlDbType.VarChar).Value = pi.target;
cmd.Parameters.Add("@MonthlyIncome", SqlDbType.VarChar).Value = pi.monthlyIncome;
cmd.Parameters.Add("@SalaryLevel", SqlDbType.VarChar).Value = pi.salaryLevel;
cmd.Parameters.Add("@ApproveProcess", SqlDbType.VarChar).Value = pi.approveProcess;
conn.Open();
//cmd.ExecuteNonQuery();
//同时在标准化申请表中插入一条记录
int recordId = Convert.ToInt32(cmd.ExecuteScalar());
if (!isExist)
{
SqlCommand cmd2 = new SqlCommand("INSERT INTO [AllApplies] ( [ApplyStaff], [ApplyDate], [ApplyType], [NextApprover], [RecordID], [Result]) VALUES (@ApplyStaff, @ApplyDate, @ApplyType, @NextApprover, @RecordID, @Result)", conn);
cmd2.Parameters.Add("@ApplyStaff", SqlDbType.VarChar).Value = pi.staffName;
cmd2.Parameters.Add("@ApplyDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd2.Parameters.Add("@ApplyType", SqlDbType.VarChar).Value = "岗位责任书";
cmd2.Parameters.Add("@RecordID", SqlDbType.Int).Value = recordId;
cmd2.Parameters.Add("@NextApprover", SqlDbType.VarChar).Value = pi.leader;
cmd2.Parameters.Add("@Result", SqlDbType.Bit).Value = false;
cmd2.ExecuteNonQuery();
}
conn.Close();
}
void Update()
{
if (_controllable != null)
{
_controllable.Accelerate(Input.GetAxis("Vertical"));
_controllable.Turn(Input.GetAxis("Horizontal"));
}
Ray ray = Camera.main.ScreenPointToRay(Input.mousePosition);
ITarget target = new PositionTarget(ray.GetPoint(1000));
if (Physics.Raycast(ray, out RaycastHit hit, Mathf.Infinity))
{
Turrets.ForEach(x => x.AimTowards(hit.point));
target = hit.collider.gameObject.CompareTag("Terrain") ? target : new ColliderTarget(hit.collider);
}
public override IEnumerator ReceivePayload(VisualPayload payload)
{
PayloadData = payload.Data;
CacheSchema();
var boundsList = Expression.ResolveExpression(ChainView.Instance.Chain.RootBoundingBoxes);
PositionTarget.SetValue(
!boundsList.Any()
? DefaultPosition.GetFirstValue(payload.Data)
: boundsList.First().transform.position, payload.Data);
UnCacheSchema();
var iterator = Router.TransmitAll(payload);
while (iterator.MoveNext())
{
yield return(null);
}
}
protected void confirm_Click(object sender, EventArgs e)
{
PositionTarget pi = new PositionTarget();
pi.StaffName = staffName.Text;
pi.Position = position.Text;
pi.Department = department.Text;
pi.FormerPosition = formerPosition.Value;
pi.Leader = leader.Value;
DateTime dt = Convert.ToDateTime(happenDate.Value);
pi.Year = dt.Year;
pi.NewPosition = newPosition.Value;
pi.Duty = duty.Text;
pi.Target = target.Text;
pi.SalaryLevel = salaryLevel.Value;
pi.ApproveProcess = "";
StringBuilder temp = new StringBuilder();
temp.Append(Request["january"] + ",");
temp.Append(Request["february"] + ",");
temp.Append(Request["march"] + ",");
temp.Append(Request["april"] + ",");
temp.Append(Request["may"] + ",");
temp.Append(Request["june"] + ",");
temp.Append(Request["july"] + ",");
temp.Append(Request["august"] + ",");
temp.Append(Request["september"] + ",");
temp.Append(Request["october"] + ",");
temp.Append(Request["november"] + ",");
temp.Append(Request["december"]);
pi.MonthlyIncome = temp.ToString();
PositionTarget.SetPositionTargetByID(-1, pi);
Response.Redirect("~/Account/ApplyListPage.aspx");
}
