protected void Page_Load(object sender, EventArgs e)
{
string sqlcmd = Request["SqlCmd"];
List <Apply> allApplies = Apply.GetFilerResult(sqlcmd);
StringBuilder buff = new StringBuilder();
int counter = 1;
foreach (Apply ap in allApplies)
{
if (counter % 2 == 0)
{
buff.Append("<tr class=\"RowA\">");
}
else
{
buff.Append("<tr class=\"RowB\">");
}
switch (ap.ApplyType)
{
case "费用报销": buff.Append(string.Format("<td><a href=\"../Finance/ProjectReimbursementShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "到款分配-校内": buff.Append(string.Format("<td><a href=\"../Finance/PayAssignInSchoolShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "到款分配-校外": buff.Append(string.Format("<td><a href=\"../Finance/PayAssignShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "出差报销": buff.Append(string.Format("<td><a href=\"../Finance/BusinessTripReiShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "出差申请": buff.Append(string.Format("<td><a href=\"../Finance/BusinessTripApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "出差总结报告": buff.Append(string.Format("<td><a href=\"../Finance/BusinessTripApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "车辆使用登记": buff.Append(string.Format("<td><a href=\"../Account/CarUseShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "合同审批": buff.Append(string.Format("<td><a href=\"../Finance/ContractApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "员工转正申请": buff.Append(string.Format("<td><a href=\"../Finance/ConversionApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "离职申请": buff.Append(string.Format("<td><a href=\"../Finance/DismissApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "宴请申请": buff.Append(string.Format("<td><a href=\"../Finance/EntertainApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "资金使用审批": buff.Append(string.Format("<td><a href=\"../Finance/MoneyApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "办公用品申购": buff.Append(string.Format("<td><a href=\"../Finance/OfficeSupplyApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "加班申请": buff.Append(string.Format("<td><a href=\"../Finance/OverTimeShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "调休申请": buff.Append(string.Format("<td><a href=\"../Finance/ShiftLeaveShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "请假": buff.Append(string.Format("<td><a href=\"../Finance/LeaveApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "统一结算申请": buff.Append(string.Format("<td><a href=\"../Finance/SettleApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "固定资产保修申请": buff.Append(string.Format("<td><a href=\"../Finance/RepairApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "员工用餐申请": buff.Append(string.Format("<td><a href=\"../Finance/StaffMealApplyShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "工资表": buff.Append(string.Format("<td><a href=\"../Finance/SalaryShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "绩效表": buff.Append(string.Format("<td><a href=\"../Finance/SalaryShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "考勤表": buff.Append(string.Format("<td><a href=\"../Finance/SalaryShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
case "岗位责任书": buff.Append(string.Format("<td><a href=\"../Account/PositionTargetShow.aspx?RecordID={0}&&ApplyID={1}&&finished={2}\">{3}</a></td><td>{4}</td><td>{5}</td><td>{6}</td>", ap.RecordID, ap.ApplyID, true, counter, ap.ApplyType, ap.StaffName, ap.ApplyDate.ToShortDateString())); break;
default: break;
}
buff.Append("</tr>");
++counter;
}
string temp = buff.ToString();
UserRowsTemp.Text = buff.ToString();
}
