void LoadData()
{
if (m_Report == null)
{
m_bIsNew = true;
m_Report = new CReport();
m_Report.Ctx = Program.Ctx;
m_Report.RPT_ReportCatalog_id = m_Catalog_id;
m_Report.B_Company_id = m_Company.Id;
}
txtName.Text = m_Report.Name;
dataGridStatItem.Rows.Clear();
foreach (CBaseObject obj in m_Report.StatItemMgr.GetList())
{
CStatItem StatItem = (CStatItem)obj;
if (StatItem.ItemType == CStatItem.enumItemType.Field)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(StatItem.FW_Table_id);
if (table == null)
{
continue;
}
CColumn column = (CColumn)table.ColumnMgr.Find(StatItem.FW_Column_id);
if (column == null)
{
continue;
}
dataGridStatItem.Rows.Add(1);
DataGridViewRow item = dataGridStatItem.Rows[dataGridStatItem.Rows.Count - 1];
item.Cells[0].Value = table.Name;
item.Cells[1].Value = column.Name;
//DataGridViewComboBoxCell cbCell = (DataGridViewComboBoxCell)item.Cells[2];
//if(cbCell!=null)
// cbCell.Value = "val";
item.Cells[2].Value = StatItem.GetStatTypeName();
item.Cells[3].Value = StatItem.GetOrderName();
item.Tag = StatItem;
}
else
{
dataGridStatItem.Rows.Add(1);
DataGridViewRow item = dataGridStatItem.Rows[dataGridStatItem.Rows.Count - 1];
item.Cells[0].Value = StatItem.Name;
item.Cells[1].Value = StatItem.Formula;
//DataGridViewComboBoxCell cbCell = (DataGridViewComboBoxCell)item.Cells[2];
//if(cbCell!=null)
// cbCell.Value = "val";
item.Cells[2].Value = StatItem.GetStatTypeName();
item.Cells[3].Value = StatItem.GetOrderName();
item.Tag = StatItem;
}
}
txtFilter.Text = m_Report.Filter;
}
/// <summary>
/// Metoda zwraca przygotowane dane wydruku dowodu przyjêcia prenumeraty
/// </summary>
/// <param name="Parameters"></param>
/// <returns></returns>
public CReport DajWydruk(RDruk220 par)
{
if (par.NumerDowodu == "")
{
CReport raport = new CReport();
foreach (int NumerKlienta in par.NumerKlienta)
{
DataSet ds = Port.ZamowieniaPrenumeraty.DajKolNumeryZamowienPrenumeratyKlienta(NumerKlienta, AktualnyKontekst.Kontekst.idUrzad, AktualnyKontekst.Kontekst.idDzienUrzedu, AktualnyKontekst.Kontekst.idUzytkownik, AktualnyKontekst.Kontekst.idLokalizacja);
System.Data.DataTable tb = ds.Tables[0];
foreach (DataRow Row in ds.Tables[0].Rows)
{
string NumerDowoduPrzyjecia = Row["NumerDowoduPrzyjecia"].ToString();
string NazwaPrenumeratora = Row["NazwaPrenumeratora"].ToString();
raport.AddRange(new ZDruk220Administracja(new Guid("00000000-0000-0000-0000-000000000227")).PrepareReport(AktualnyKontekst.Kontekst.idUrzad, NumerDowoduPrzyjecia, NazwaPrenumeratora).Pages);
raport.AddRange(new ZDruk220DowodAdministracja(new Guid("00000000-0000-0000-0000-000000000227")).PrepareReport(AktualnyKontekst.Kontekst.idUrzad, NumerDowoduPrzyjecia, NazwaPrenumeratora).Pages);
}
}
return(raport);
}
else
{
CReport raport = new CReport();
raport.AddRange(new ZDruk220Administracja(new Guid("00000000-0000-0000-0000-000000000227")).PrepareReport(AktualnyKontekst.Kontekst.idUrzad, par.NumerDowodu, par.NazwaPrenumeratora).Pages);
raport.AddRange(new ZDruk220DowodAdministracja(new Guid("00000000-0000-0000-0000-000000000227")).PrepareReport(AktualnyKontekst.Kontekst.idUrzad, par.NumerDowodu, par.NazwaPrenumeratora).Pages);
return(raport);
}
}
void GetData()
{
CUser user = (CUser)Session["User"];
CCompany Company = (CCompany)Global.GetCtx(Session["TopCompany"].ToString()).CompanyMgr.Find(user.B_Company_id);
int page = Convert.ToInt32(Request.Params["page"]);
int pageSize = Convert.ToInt32(Request.Params["pagesize"]);
string sData = "";
List <CBaseObject> lstObj = Company.ReportMgr.GetList();
int totalPage = lstObj.Count % pageSize == 0 ? lstObj.Count / pageSize : lstObj.Count / pageSize + 1; // 计算总页数
int index = (page - 1) * pageSize; // 开始记录数
for (int i = index; i < pageSize + index && i < lstObj.Count; i++)
{
CReport Report = (CReport)lstObj[i];
sData += string.Format("{{ \"id\": \"{0}\",\"Name\":\"{1}\"}},"
, Report.Id, Report.Name);
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
/// <summary>
/// Metoda zwraca przygotowane dane wydruku dowodu przyjêcia prenumeraty
/// </summary>
/// <param name="Parameters"></param>
/// <returns></returns>
public CReport DajWydruk(RDruk220 par)
{
if (par.NumerDowodu == "")
{
CReport raport = new CReport();
foreach (int NumerKlienta in par.NumerKlienta)
{
DataSet ds = Port.ZamowieniaPrenumeraty.DajKolNumeryZamowienPrenumeratyKlienta(NumerKlienta, AktualnyKontekst.Kontekst.idUrzad, AktualnyKontekst.Kontekst.idDzienUrzedu, AktualnyKontekst.Kontekst.idUzytkownik, AktualnyKontekst.Kontekst.idLokalizacja);
System.Data.DataTable tb = ds.Tables[0];
foreach (DataRow Row in ds.Tables[0].Rows)
{
string NumerDowoduPrzyjecia = Row["NumerDowoduPrzyjecia"].ToString();
string NazwaPrenumeratora = Row["NazwaPrenumeratora"].ToString();
raport.AddRange( new ZDruk220Administracja(new Guid("00000000-0000-0000-0000-000000000227")).PrepareReport( AktualnyKontekst.Kontekst.idUrzad, NumerDowoduPrzyjecia, NazwaPrenumeratora).Pages );
raport.AddRange( new ZDruk220DowodAdministracja(new Guid("00000000-0000-0000-0000-000000000227")).PrepareReport( AktualnyKontekst.Kontekst.idUrzad, NumerDowoduPrzyjecia, NazwaPrenumeratora).Pages );
}
}
return raport;
}
else
{
CReport raport = new CReport();
raport.AddRange( new ZDruk220Administracja(new Guid("00000000-0000-0000-0000-000000000227")).PrepareReport( AktualnyKontekst.Kontekst.idUrzad, par.NumerDowodu, par.NazwaPrenumeratora).Pages );
raport.AddRange( new ZDruk220DowodAdministracja(new Guid("00000000-0000-0000-0000-000000000227")).PrepareReport( AktualnyKontekst.Kontekst.idUrzad, par.NumerDowodu, par.NazwaPrenumeratora).Pages );
return raport;
}
}
protected void grdReports_RowCommand(object sender, GridViewCommandEventArgs e)
{
//String sError = "";
int iIndex;
//string hn;
string sReportFilename = "";
//if (pubHideNames == "")
//{
// pubHideNames = Session["HideNames"].ToString();
//}
if (e.CommandName == "Select")
{
iIndex = Convert.ToInt16(e.CommandArgument);
sReportFilename = grdReports.Rows[iIndex].Cells[2].Text;
if (sReportFilename == "")
{
DataSet ds = CReport.GetReportList();
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
sReportFilename = ds.Tables[0].Rows[iIndex]["ReportFileName"].ToString();
}
}
Response.Redirect(sReportFilename);
}
//else if (e.CommandName == "View")
//{
// iIndex = Convert.ToInt16(e.CommandArgument);
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.Redirect("../Login.aspx");
Response.End();
}
string B_Company_id = Request["B_Company_id"];
if (string.IsNullOrEmpty(B_Company_id))
{
m_Company = Global.GetCtx(Session["TopCompany"].ToString()).CompanyMgr.FindTopCompany();
}
else
{
m_Company = (CCompany)Global.GetCtx(Session["TopCompany"].ToString()).CompanyMgr.Find(new Guid(B_Company_id));
}
string id = Request["id"];
if (string.IsNullOrEmpty(id))
{
Response.End();
return;
}
m_BaseObject = (CReport)m_Company.ReportMgr.Find(new Guid(id));
if (m_BaseObject == null)
{
Response.End();
return;
}
//保存到编辑对象
EditObject.Add(Session.SessionID, m_BaseObject);
if (Request.Params["Action"] == "GetData")
{
GetData();
Response.End();
}
else if (Request.Params["Action"] == "Cancel")
{
Session["AddReport"] = null;
Response.End();
}
else if (Request.Params["Action"] == "PostData")
{
PostData();
//从编辑对象移除
EditObject.Remove(Session.SessionID, m_BaseObject);
Response.End();
}
else if (Request.Params["Action"] == "GetCondiction")
{
GetCondiction();
Response.End();
}
}
public static CReport GetReportFromWinService(CReportList rpl, string exportType)
{
CReport rpt = new CReport(rpl.Name, rpl.ReportHeaderTitle, rpl.ReportFileName, exportType);
try
{
//SINGLE_REPORT|UserID|Session|LanguageID|ExportType|ReportFileName
//string reportListBase64 = CBinaryUtils.BinaryToBase64(CBinaryUtils.SerializeObject(rpl));
string comand = string.Format("SINGLE_REPORT|{0}|{1}|{2}|{3}|{4}", rpl.UserID, rpl.Session.ToString(), rpl.LanguageID, exportType, rpl.ReportFileName);
string serverIP = CReportConfig.WinServiceServer.Split(':')[0];
int serverPort = 20000;
if (CReportConfig.WinServiceServer.Split(':').Length > 1)
{
int.TryParse(CReportConfig.WinServiceServer.Split(':')[1], out serverPort);
}
TcpClient client = new TcpClient(serverIP, serverPort);
Stream s = client.GetStream();
StreamWriter sw = new StreamWriter(s);
StreamReader sr = new StreamReader(s);
sw.AutoFlush = true;
sw.WriteLine(comand);
string result = sr.ReadLine(); //000-OK
Write("", rpl.Session.ToString(), rpl.UserID, "==STEP1==: Start Protocol :" + result + ",UserName:"******"");
result = sr.ReadLine(); //000-Begin Send
Write("", rpl.Session.ToString(), rpl.UserID, "==STEP2==: Begin Receive :" + result + ",UserName:"******"");
if (result.StartsWith("000-"))
{
result = sr.ReadLine();
Write("", rpl.Session.ToString(), rpl.UserID, "==STEP2==: Receive Content :" + result.Substring(0, 100) + ",UserName:"******"");
byte[] buffer = CBinaryUtils.Base64ToBinary(result);
rpt.Content = buffer;
rpt.Description = "Success";
}
else
{
result = sr.ReadLine();
rpt.Description = result;
}
s.Close();
rpt.ExportName = "application/pdf";
return(rpt);
}
catch (Exception ex)
{
rpt = new CReport()
{
Description = ex.Message
};
Write("", rpl.Session.ToString(), rpl.UserID, "==STEP2==: Error Receive :" + ex.Message + ",UserName:"******"");
}
return(rpt);
}
private void LoadIPReportData()
{
var ipReviewStartDate = Session["IPReviewStartDate"].ToString();
DataSet ds = CReport.GetIPReportData(ipReviewStartDate, 1);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
var dataRow = ds.Tables[0].Rows[0];
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row["QuestionType"].ToString().Equals("TextBox"))
{
(this.Master.FindControl("ContentPlaceHolder1").FindControl(row["QuestionAspID"].ToString()) as TextBox).Text = row["QuestionAns"].ToString();
}
if (row["QuestionType"].ToString().Equals("RadioButton"))
{
(this.Master.FindControl("ContentPlaceHolder1").FindControl(row["QuestionAspID"].ToString()) as RadioButtonList).SelectedValue = row["QuestionAns"].ToString();
}
if (row["QuestionType"].ToString().Equals("CheckBox"))
{
(this.Master.FindControl("ContentPlaceHolder1").FindControl(row["QuestionAspID"].ToString()) as CheckBox).Checked = row["QuestionAns"].ToString().Equals("Yes");
}
}
}
}
public ExcelResponse(CReport item)
{
this.Content = item.Content;
this.ExportName = item.ExportName;
this.ExportType = item.ExportType;
this.Name = item.Name;
this.Session = item.Session;
}
public Controller(CCurrencyPair currencyPair, String queryText, CountryInfo country)
{
_gates = new CDataBaseGates();
_dataInput = new QueryInfo();
_dataInput.CurrencyPair = currencyPair;
_dataInput.Country = country;
_dataInput.Tag = new CTag(queryText);
parsingExpressions = new RegularExpressions();
_queryInteractor = new CUserQueryInteractor(_gates, parsingExpressions);
_report = _queryInteractor.PutRequest(_dataInput);
}
public CReport GetReport(CReport report)
{
if (!File.Exists(report.ReportUrl))
{
report.Description = "Template not found.";
}
string htmlContent = File.ReadAllText(report.ReportUrl);
htmlContent = SetReportData(htmlContent, null);
return(report);
}
void LoadReport()
{
cbReport.Items.Clear();
CCompany Company = (CCompany)Program.Ctx.CompanyMgr.Find(Program.User.B_Company_id);
List <CBaseObject> lstObj = Company.ReportMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CReport Report = (CReport)obj;
DataItem item = new DataItem(Report.Name, Report);
cbReport.Items.Add(item);
}
}
private void tbtRun_Click(object sender, EventArgs e)
{
if (dataGridView.CurrentRow == null)
{
MessageBox.Show("请选择一项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
CReport obj = (CReport)dataGridView.CurrentRow.Tag;
RunReport frm = new RunReport();
frm.m_Report = obj;
frm.ShowDialog();
}
void GetData()
{
CReport Report = GetReport();
List <CBaseObject> lstObj = Report.StatItemMgr.GetList();
//按序号排序
List <CStatItem> sortObj = new List <CStatItem>();
foreach (CBaseObject obj in lstObj)
{
CStatItem StatItem = (CStatItem)obj;
sortObj.Add(StatItem);
}
sortObj.Sort();
string sData = "";
foreach (CStatItem StatItem in sortObj)
{
string sTableName = "", sColumnName = "";
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(StatItem.FW_Table_id);
if (table != null)
{
sTableName = table.Name;
CColumn column = (CColumn)table.ColumnMgr.Find(StatItem.FW_Column_id);
if (column != null)
{
sColumnName = column.Name;
}
}
sData += string.Format("{{ \"id\": \"{0}\",\"FW_Table_id\":\"{1}\",\"TableName\":\"{2}\",\"FW_Column_id\":\"{3}\", \"ColumnName\":\"{4}\", \"StatType\":\"{5}\", \"StatTypeName\":\"{6}\", \"Order\":\"{7}\", \"OrderName\":\"{8}\" }},"
, StatItem.Id
, StatItem.FW_Table_id
, sTableName
, StatItem.FW_Column_id
, sColumnName
, (int)StatItem.StatType
, StatItem.GetStatTypeName()
, (int)StatItem.Order
, StatItem.GetOrderName());
}
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string errorMsg = "";
int i = 0;
int j = 0;
try
{
//string errorMsg = "";
CReport.SaveErrorReportData(ref errorMsg,
System.Configuration.ConfigurationManager.AppSettings.Get("IPReviewStartDate"), //Session["IPReviewStartDate"].ToString(),
txtPercentCaseImproperPayment.Text,
txtSeniorOfficial.Text,
txtSeniorOfficialTitle.Text,
txtTimelineReducingErrorRate.Text,
txtTargetFutureImproperPayment.Text,
txtAction1.Text,
txtAction2.Text,
txtAction3.Text,
txtAction4.Text,
txtMilestone1.Text,
txtMilestone2.Text,
txtMilestone3.Text,
txtMilestone4.Text,
txtTimeline1.Text,
txtTimeline2.Text,
txtTimeline3.Text,
txtTimeline4.Text,
txtResponsible1.Text,
txtResponsible2.Text,
txtResponsible3.Text,
txtResponsible4.Text);
if (errorMsg == "")
{
lblErrMsg.Visible = false;
LoadErrorRateTable();
}
}
catch (Exception ex)
{
lblErrMsg.Text = "Error updating the Error Rate Table, " + ex.Message;
lblErrMsg.Visible = true;
return;
}
}
private void LoadErrorRateTable()
{
string sError = "";
string sReviewDate = System.Configuration.ConfigurationManager.AppSettings.Get("IPReviewStartDate"); //Session["IPReviewStartDate"].ToString();
DataSet dsErrorReportTable = CReport.GetErrorReportData(ref sError, sReviewDate);
if (sError == "")
{
DataRow dr = dsErrorReportTable.Tables[0].Rows[0];
if (dsErrorReportTable.Tables.Count > 0 && dsErrorReportTable.Tables[0].Rows.Count > 0)
{
txtPercentCaseImproperPayment.Text = dr["txtPercentCaseImproperPayment"].ToString() == "" ? "0.00" : dr["txtPercentCaseImproperPayment"].ToString();
//if (txtPercentCaseImproperPayment.Text == "")
// txtPercentCaseImproperPayment.Text = "0.00";
txtSeniorOfficial.Text = dr["txtSeniorOfficialName"].ToString();
txtSeniorOfficialTitle.Text = dr["txtSeniorOfficialJobTItle"].ToString();
txtTimelineReducingErrorRate.Text = dr["txtTimelineReducingErrorRate"].ToString();
txtTargetFutureImproperPayment.Text = dr["txtTargetFutureImproperPayment"].ToString();
txtAction1.Text = dr["txtAction1"].ToString();
txtAction2.Text = dr["txtAction2"].ToString();
txtAction3.Text = dr["txtAction3"].ToString();
txtAction4.Text = dr["txtAction4"].ToString();
txtMilestone1.Text = dr["txtMilestone1"].ToString();
txtMilestone2.Text = dr["txtMilestone2"].ToString();
txtMilestone3.Text = dr["txtMilestone3"].ToString();
txtMilestone4.Text = dr["txtMilestone4"].ToString();
txtTimeline1.Text = dr["txtTimeline1"].ToString();
txtTimeline2.Text = dr["txtTimeline2"].ToString();
txtTimeline3.Text = dr["txtTimeline3"].ToString();
txtTimeline4.Text = dr["txtTimeline4"].ToString();
txtResponsible1.Text = dr["txtResponsible1"].ToString();
txtResponsible2.Text = dr["txtResponsible2"].ToString();
txtResponsible3.Text = dr["txtResponsible3"].ToString();
txtResponsible4.Text = dr["txtResponsible4"].ToString();
}
else
{
InitializePage();
}
}
}
/// <summary>
/// Lay file Report de gui email
/// Dua theo RefType
/// 22: TBGT
/// 28: Phan hoi
/// </summary>
/// <param name="inputValue"></param>
/// <returns></returns>
private byte[] GetReportPdf(string inputValue)
{
string localInputValue = "<Root>" + inputValue + "</Root>";
int UserID = 0;
int.TryParse(CXML.GetXmlNodeValue(localInputValue, "Root/InputValue/@UserID"), out UserID);
string Session = CXML.GetXmlNodeValue(localInputValue, "Root/InputValue/Session");
CReport report = CServiceReference.ServiceReport.GetReport(UserID, Session, 0, inputValue, "PDF");
if (report.Content == null || report.Content.Length == 0)
{
throw new Exception("Lỗi xuất báo cáo: " + report.Description);
}
return(report.Content);
//return null;
}
public CReport PutRequest(QueryInfo dataInput)
{
CJob job = _gates.JobGateway.GetByQueryInfo(dataInput);
CReport report = new CReport();
if (job != null)
{
job.UpdateReports(); //it's happen to update db
return(job.Report);
}
else
{
CJob newJob = new CJob(dataInput, _parsingExpressions, _gates);
report = newJob.CreateReport(dataInput);
}
//check for job existance
//if job exists - > find get reports and update them
//if not exists -> create job and push it work
return(report);
}
public CReport GetReport()
{
if (Session["AddReport"] == null)
{
CReport Report = new CReport();
Report.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
Guid Catalog_id = Guid.Empty;
if (!string.IsNullOrEmpty(Request["catalog_id"]))
{
Catalog_id = new Guid(Request["catalog_id"]);
}
Report.RPT_ReportCatalog_id = Catalog_id;
CUser user = (CUser)Session["User"];
Report.Creator = user.Id;
Session["AddReport"] = Report;
}
return((CReport)Session["AddReport"]);
}
private void LoadReportData()
{
DataSet ds = CReport.GetReportData();
txtNumOfCaseRecord.Text = ds.Tables[0].Rows[0]["NumOfRecord"].ToString();
txtNumOfCaseComplete.Text = ds.Tables[0].Rows[0]["NumOfCompletedRecord"].ToString();
txtNumOfCaseRecordCompete.Text = txtNumOfCaseRecord.Text;
//txtAuthoAmount.Text = "$" + ds.Tables[0].Rows[0]["AuthoAmount"].ToString();
txtNumOfErrorCase.Text = ds.Tables[0].Rows[0]["NumOfErrorCase"].ToString();
txtNumCaseImproperPayment.Text = ds.Tables[0].Rows[0]["NumOfImproperPayment"].ToString();
//txtPercentImproperDoc.Text = ds.Tables[0].Rows[0]["PercentCaseImproperDoc"].ToString();
//txtTotalImproperDoc.Text = ds.Tables[0].Rows[0]["AmountImproperDoc"].ToString();
txtTotalGrossForReviewPeriod.Text = "$" + ((ds.Tables[0].Rows[0]["GrossImproperPayment"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["GrossImproperPayment"].ToString());
txtTotalAmtOfUnderPaymentsForReviewPeriod.Text = "$" + ((ds.Tables[0].Rows[0]["Underpayment"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["Underpayment"].ToString());
txtTotalAmtOfOverPaymentsForReviewPeriod.Text = "$" + ((ds.Tables[0].Rows[0]["Overpayment"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["Overpayment"].ToString());
txtNumOfIPMID.Text = ds.Tables[0].Rows[0]["NumOfImproperDoc"].ToString();
txtPercentCasesError.Text = ((ds.Tables[0].Rows[0]["PercentCasesError"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["PercentCasesError"].ToString()) + "%";
txtPercentCaseImproperPayment.Text = ((ds.Tables[0].Rows[0]["PercentCaseImproperPayment"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["PercentCaseImproperPayment"].ToString()) + "%";
txtPercentageTotalOfPayments.Text = ((ds.Tables[0].Rows[0]["PercentImproperPayment"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["PercentImproperPayment"].ToString()) + "%";
txtAvgAmtOfIP.Text = "$" + ((ds.Tables[0].Rows[0]["AverageImproperPayment"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["AverageImproperPayment"].ToString());
//7A is replaced
//txtTotalDollarIPMID.Text = "$" + ((ds.Tables[0].Rows[0]["AmountImproperDoc"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["AmountImproperDoc"].ToString());
txtNumOfMIDErrorsMitigatedAI.Text = ds.Tables[0].Rows[0]["NumOfMIDErrorsMitigatedUsingAI"].ToString();
txtTotalAmtMIDErrorsMitigatedAI.Text = "$" + ds.Tables[0].Rows[0]["AmountOfMIDErrorsMitigatedUsingAI"].ToString();
txtTotalMIDErrors.Text = ds.Tables[0].Rows[0]["NumOfMIDErrors"].ToString();
txtTotalDollarIPMID.Text = "$" + ds.Tables[0].Rows[0]["AmountOfMIDErrors"].ToString();
txtTotalAmtForSampledCases.Text = "$" + ds.Tables[0].Rows[0]["AuthoAmount"].ToString();
txtEstAnualAmtOfIP.Text = "$" + ds.Tables[0].Rows[0]["GrossImproperPayment"].ToString();
//9A
//Total number of MID errors that, after an AI was considered and possibly used, still resulted in an improper payment – Enter the difference between 7A and 8A
txtNumOfMIDErrorsAfterAI.Text = Math.Abs(Convert.ToInt32(ds.Tables[0].Rows[0]["NumOfMIDErrors"]) - Convert.ToInt32(ds.Tables[0].Rows[0]["NumOfMIDErrorsMitigatedUsingAI"])).ToString();
//9B. Total dollar amount of MID improper payments that resulted even after an AI was considered and possibly used – Enter the difference between 7B and 8B.
txtTotalAmtOfMIDAfterAI.Text = Math.Abs(Convert.ToDecimal(ds.Tables[0].Rows[0]["AmountOfMIDErrors"]) - Convert.ToDecimal(ds.Tables[0].Rows[0]["AmountOfMIDErrorsMitigatedUsingAI"])).ToString();
//14A
txtTotalAmtOfCCDFSubsidyPayment.Text = "$" + ds.Tables[0].Rows[0]["TotalAmountOfSubsidyPayment"].ToString();
//14B
txtEstAnualAmtOfIP.Text = "$" + ds.Tables[0].Rows[0]["AnualAmountOfIPSubsidy"].ToString();
}
private void LoadIPReportData()
{
var ipReviewStartDate = Session["IPReviewStartDate"].ToString();
DataSet ds = CReport.GetIPReportData(ipReviewStartDate, 1);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
var dataRow = ds.Tables[0].Rows[0];
foreach (DataRow row in ds.Tables[0].Rows)
{
if (!String.IsNullOrEmpty(row["QuestionAspID"].ToString()) && !row["QuestionType"].ToString().Equals("Table") && !row["QuestionType"].ToString().Equals("CheckBox"))
{
(this.Master.FindControl("ContentPlaceHolder1").FindControl(row["QuestionAspID"].ToString()) as Label).Text = row["QuestionAns"].ToString();
}
if (row["QuestionType"].ToString().Equals("CheckBox"))
{
(this.Master.FindControl("ContentPlaceHolder1").FindControl(row["QuestionAspID"].ToString()) as CheckBox).Checked = row["QuestionAns"].ToString().Equals("Yes");
}
}
}
}
public static CReport GetReport(int pUserID, string pSession, int pLanguageID, string xmlData, string pExportType)
{
CReport report = null;
try
{
CReportDao face = new CReportDao();
CReportList rpl = face.InitReport(xmlData);
if (!string.IsNullOrEmpty(rpl.OutputFormat))
{
pExportType = rpl.OutputFormat;
}
CLogManager.WritePL("GetReport", xmlData);
if (CReportConfig.UseWinservice == "1")
{
report = new CReport(rpl.Name, rpl.Description, rpl.ReportFileName);
//report = new CReport();
CReport itemTemp = GetReportFromWinService(rpl, pExportType);
report.Content = itemTemp.Content;
report.Description = itemTemp.Description;
report.ExportName = itemTemp.ExportName;
report.ExportType = itemTemp.ExportType;
return(report);
}
CReport _report = new CReport(rpl.Name, rpl.Description, rpl.ReportFileName, pExportType);
report = _report.GetReportContent(rpl.UserID, rpl.Session, pLanguageID, rpl.ID);
}
catch (Exception ex)
{
report = new CReport();
report.Description = "09 - Read file report error Or Report error. Please check report preview and conntact admin!" + ex.ToString();
CLogManager.WritePL("CReportUI Ex", "09 - Read file report error Or Report error. Please check report preview and conntact admin!");
}
return(report);
}
private void ControlsInitialize()
{
Master.ShowFooter = false;
Master.PageTitle = "Improper Payment (IP) Reports";
//UserMsg.Text = "";
//UserMsg.Visible = false;
Session["IPReviewStartDate"] = System.Configuration.ConfigurationManager.AppSettings.Get("IPReviewStartDate");
Session["IPReviewEndDate"] = System.Configuration.ConfigurationManager.AppSettings.Get("IPReviewEndDate");
//pubHideNames = GetParameter("hn");
//hidHideNames.Value = pubHideNames;
//if (hidHideNames.Value == "")
// hidHideNames.Value = Session["HideNames"].ToString();
DataSet ds = CReport.GetReportList();
if (ds.Tables[0].Rows.Count > 0)
{
grdReports.DataSource = ds;
grdReports.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.Redirect("../Login.aspx");
Response.End();
}
string RPT_Reprot_id = Request["id"];
if (string.IsNullOrEmpty(RPT_Reprot_id))
{
Response.End();
return;
}
string B_Company_id = Request["B_Company_id"];
if (string.IsNullOrEmpty(B_Company_id))
{
m_Company = Global.GetCtx(Session["TopCompany"].ToString()).CompanyMgr.FindTopCompany();
}
else
{
m_Company = (CCompany)Global.GetCtx(Session["TopCompany"].ToString()).CompanyMgr.Find(new Guid(B_Company_id));
}
m_Table = (CTable)m_Company.ReportMgr.Table;
m_Report = (CReport)m_Company.ReportMgr.Find(new Guid(RPT_Reprot_id));
if (Request.Params["Action"] == "GetData")
{
GetData();
Response.End();
}
}
public HttpResponseMessage GenerateReport(CReportParms iReportParms)
{
logger.Info("Entered GetReport()");
string returnString = "";
HttpResponseMessage returnResponse = new HttpResponseMessage();
try
{
CReport myReport = new CReport();
int retCode = myReport.GenerateReport(iReportParms);
if (retCode == -1)
{
throw new Exception(myReport.ErrorString);
}
else
{
returnString = GenerateReturnJSON(myReport.GetJSON(), 1);
}
}
catch (Exception ex)
{
returnString = GenerateReturnJSON("{\"Error\":\"Sorry, an error occured and we are unable to generate a report\"}", -1);
logger.Error("Error in GetReport() - " + ex.Message);
}
logger.Info("Leaving GetReport()");
JavaScriptSerializer ser = new JavaScriptSerializer();
string ret = ser.Serialize(returnString);
ret = ret.Replace(@"\", "");
ret = ret.Remove(0, 1);
ret = ret.TrimEnd('"');
return(new HttpResponseMessage()
{
Content = new StringContent(ret, System.Text.Encoding.UTF8, "application/json")
});
}
private void tbtDel_Click(object sender, EventArgs e)
{
if (dataGridView.CurrentRow == null)
{
MessageBox.Show("请选择一项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("是否确认删除？", "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
for (int i = dataGridView.SelectedRows.Count - 1; i >= 0; i--)
{
CReport obj = (CReport)dataGridView.SelectedRows[i].Tag;
obj.m_ObjectMgr.Delete(obj);
if (!obj.m_ObjectMgr.Save(true))
{
MessageBox.Show("删除失败！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
dataGridView.Rows.Remove(dataGridView.SelectedRows[i]);
}
}
public void ProcessRequest(HttpContext context)
{
HttpResponse response = context.Response;
HttpRequest request = context.Request;
try
{
string session = "", exportTo = "pdf", inputValue = "<InputValue ReportID=\"1\" UserID=\"1\"/>";
int userid = 1, languageid = 129;
string requestFrom = "0";
CSession ses = new CSession();
try
{
if (request.QueryString["ExportTo"] != null)
{
exportTo = request.QueryString["ExportTo"].ToString();
}
if (request.QueryString["InputValue"] != null)
{
inputValue = request.QueryString["InputValue"].ToString();
}
userid = ses.UserID;
session = ses.Session;
try
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(inputValue);
XmlAttribute xmlUser = doc.CreateAttribute("UserID");
xmlUser.Value = userid.ToString();
doc.DocumentElement.SetAttributeNode(xmlUser);
XmlAttribute xmlSession = doc.CreateAttribute("Session");
xmlSession.Value = session;
doc.DocumentElement.SetAttributeNode(xmlSession);
XmlElement node = (XmlElement)doc.SelectSingleNode("/InputValue");
languageid = int.Parse(node.Attributes["LanguageID"].Value);
requestFrom = node.Attributes["RequestFrom"].Value;
}
catch (Exception ex)
{
string s = ex.Message;
}
}
catch (Exception ex)
{
CLogManager.WritePL("CReportViewerUI.Request", ex.Message);
}
CReportService rfs = new CReportService();
CReport item = null;
byte[] jsBytes = null;
//Set time out call service
rfs.Timeout = 1000 * 60 * 15;
item = rfs.GetReport(userid, session, languageid, inputValue, exportTo);
if (item != null && item.Content != null && item.Content.Length > 0)
{
response.ClearHeaders();
response.ClearContent();
response.ContentType = item.ExportName;
response.Charset = "";
response.AddHeader("Content-Disposition", "inline Filename=" + item.Name.Replace(',', ' ') + session + "." + item.ExportType + ";"); //Parse out the file name in path here
int ContentLength = item.Content.Length;
//Add js to html: resize window, show image for browsers
if (exportTo.ToLower() == "html")
{
string js = CReportServiceUI.GetHtmlFunction(requestFrom);
jsBytes = new byte[js.Length];
System.Text.Encoding.ASCII.GetBytes(js.ToCharArray(), 0, js.Length, jsBytes, 0);
ContentLength += jsBytes.Length;
response.AddHeader("Content-Length", ContentLength.ToString());
//write js include header
response.OutputStream.Write(jsBytes, 0, jsBytes.Length);
response.Flush();
}
else
{
response.AddHeader("Content-Length", ContentLength.ToString());
}
//load data block 10MB
int count = 1024 * 1024 * 10;
if (ContentLength < count)
{
response.BinaryWrite(item.Content);
}
else
{
Stream s = new MemoryStream(item.Content);
byte[] buffer = new byte[count];
while (ContentLength > 0 && response.IsClientConnected)
{
int lengthRead = s.Read(buffer, 0, count);
response.OutputStream.Write(buffer, 0, lengthRead);
response.Flush();
ContentLength -= lengthRead;
}
}
//write image to web server
if (exportTo.ToLower() == "html" && item.ListReportImage.Length > 0)
{
for (int i = 0; i < item.ListReportImage.Length; i++)
{
CReportImage image = item.ListReportImage[i];
CReportServiceUI.SaveFile(image.Content, "", image.FileName);
}
}
}
else
{
response.ContentType = "text/plain";
response.Write(item.Description);
}
}
catch (Exception ex)
{
response.ClearHeaders();
response.ClearContent();
response.Charset = "";
response.ContentType = "text/plain";
response.Write("99. Report not found, please check again!!!");
CLogManager.WritePL("CReportViewerUI.GetReportDataById", ex.Message);
}
}
public void AddTestResult(CReport aReport, CTestResult aTestResult) => this.Add(aReport, aTestResult, "TestResult");
void GetData()
{
string UType = Request["UType"];
string Uid = Request["Uid"];
CUser user = null;
CRole role = null;
if (UType == "0") //用户
{
if (!string.IsNullOrEmpty(Uid))
{
user = (CUser)Global.GetCtx(Session["TopCompany"].ToString()).UserMgr.Find(new Guid(Uid));
}
}
else if (UType == "1") //角色
{
if (!string.IsNullOrEmpty(Uid))
{
role = (CRole)m_Company.RoleMgr.Find(new Guid(Uid));
}
}
string sData = "";
List <CBaseObject> lstObj = m_Company.ReportMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CReport report = (CReport)obj;
int iRead = 0;
int iWrite = 0;
if (UType == "0" && user != null) //用户
{
//管理员有所有权限
if (user.IsRole("管理员"))
{
iRead = 1;
iWrite = 1;
}
else
{
CReportAccessInUser raiu = user.ReportAccessInUserMgr.FindByReport(report.Id);
if (raiu != null)
{
if (raiu.Access == AccessType.read)
{
iRead = 1;
}
else if (raiu.Access == AccessType.write)
{
iRead = 1;
iWrite = 1;
}
}
}
}
else if (UType == "1" && role != null) //用户
{
//管理员有所有权限
if (role.Name == "管理员")
{
iRead = 1;
iWrite = 1;
}
else
{
CReportAccessInRole rair = role.ReportAccessInRoleMgr.FindByReport(report.Id);
if (rair != null)
{
if (rair.Access == AccessType.read)
{
iRead = 1;
}
else if (rair.Access == AccessType.write)
{
iRead = 1;
iWrite = 1;
}
}
}
}
string sRow = string.Format("\"id\":\"{0}\",\"Name\":\"{1}\",\"Read\":\"{2}\",\"Write\":\"{3}\",", report.Id, report.Name, iRead, iWrite);
sRow = "{" + sRow + "},";
sData += sRow;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
public virtual CReport PrepareReport(params object[] parameterValues)
{
return(PreparedReport = new CReport());
}
void GetData()
{
int page = Convert.ToInt32(Request.Params["page"]);
int pageSize = Convert.ToInt32(Request.Params["pagesize"]);
string catalog_id = Request["catalog_id"];
string sData = "";
List <CBaseObject> lstObj = new List <CBaseObject>();
CBaseObjectMgr BaseObjectMgr = m_Company.ReportMgr;
List <CBaseObject> lstRpt = BaseObjectMgr.GetList();
foreach (CBaseObject objRpt in lstRpt)
{
CReport Report = (CReport)objRpt;
if (!string.IsNullOrEmpty(catalog_id))
{
Guid guid = new Guid(catalog_id);
if (Report.RPT_ReportCatalog_id == guid)
{
lstObj.Add(Report);
}
}
else
{
//所有目录不存在的都放置根目录
CBaseObject objCatalog = m_Company.ReportCatalogMgr.Find(Report.RPT_ReportCatalog_id);
if (objCatalog == null)
{
lstObj.Add(Report);
}
}
}
int totalPage = lstObj.Count % pageSize == 0 ? lstObj.Count / pageSize : lstObj.Count / pageSize + 1; // 计算总页数
int index = (page - 1) * pageSize; // 开始记录数
for (int i = index; i < pageSize + index && i < lstObj.Count; i++)
{
CBaseObject obj = (CBaseObject)lstObj[i];
string sRow = "";
foreach (CBaseObject objC in m_Table.ColumnMgr.GetList())
{
CColumn col = (CColumn)objC;
if (col.ColType == ColumnType.object_type)
{
string sVal = "";
if (obj.GetColValue(col) != null)
{
sVal = "long byte";
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else if (col.ColType == ColumnType.ref_type)
{
CTable RefTable = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(col.RefTable);
if (RefTable == null)
{
continue;
}
CColumn RefCol = (CColumn)RefTable.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)RefTable.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
string sVal = "";
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
object objVal2 = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
else
{
CBaseObjectMgr objRefMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(RefTable.Code, guidParentId);
if (objRefMgr != null)
{
CBaseObject objCache = objRefMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
object objVal2 = objCache.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
}
else
{
objRefMgr = new CBaseObjectMgr();
objRefMgr.TbCode = RefTable.Code;
objRefMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objRefMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
object objVal2 = obj2.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
}
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else
{
string sVal = "";
object objVal = obj.GetColValue(col);
if (objVal != null)
{
sVal = objVal.ToString();
}
Util.ConvertJsonSymbol(ref sVal);
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
}
sRow = sRow.TrimEnd(",".ToCharArray());
sRow = "{" + sRow + "},";
sData += sRow;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
