C# (CSharp) LeaveRepository.LeaveReport示例

示例#1

        public IHttpActionResult GetLeaveReport(JObject objData)
        {
            DataSet ds;

            if (!string.IsNullOrWhiteSpace(Convert.ToString(objData["employeeId"])))
            {
                ds = LeaveRepository.LeaveReport(Convert.ToString(objData["employeeStatus"]), Guid.Parse(Convert.ToString(objData["employeeId"])));
            }
            else
            {
                ds = LeaveRepository.LeaveReport(Convert.ToString(objData["employeeStatus"]));
            }
            ds.Tables[0].TableName = "LeaveReport";
            DataTable dt = new DataTable();

            dt.Clear();
            dt.Columns.Add("ReportHeaders");
            foreach (DataColumn col in ds.Tables[0].Columns)
            {
                DataRow newRow = dt.NewRow();
                newRow["ReportHeaders"] = col.ColumnName;
                dt.Rows.Add(newRow);
            }
            ds.Tables.Add(dt);
            ds.Tables[1].TableName = "ReportHeaders";
            return(Ok(ds));
        }