protected void C1WebReport1_StartSection(object sender, C1.C1Report.ReportEventArgs e)
{
if (e.Section == C1.C1Report.SectionTypeEnum.Header)
{
// get picture field
C1.C1Report.Field f = this.C1WebReport1.Report.Fields["PictureField"];
// calculate image size in pixels (convert from twips)
System.Drawing.Size size = new System.Drawing.Size(
(int)(f.Width * 96f / 1440f),
(int)(f.Height * 96f / 1440f));
// get image from webchart and assign it to field
f.Picture = this.C1WebChart1.GetImage(System.Drawing.Imaging.ImageFormat.Png, size);
}
}
/// <summary>
/// Thachnn: 28/10/2005
/// Preview the report for this form
/// Using the "InventoryStatusSummaryByMasterLocationReport.xml" layout
/// </summary>
/// <history>Thachnn: 29/12/2005: Add parameter display to the report. Change USECASE.</history>
/// <param name="sender"></param>
/// <param name="e"></param>
public DataTable ExecuteReport(string pstrCCNID, string pstrMasterLocationID, string pstrCategoryID, string pstrParameterModel)
{
#region Constants
string mstrReportDefFolder = mstrReportDefinitionFolder;
const string REPORT_LAYOUT_FILE = "InventoryStatusSummaryByMasterLocationReport.xml";
const string TABLE_NAME = "InventoryStatusSummaryByMasterLocationReport";
const string REPORT_NAME = "Inventory Status Summary By Master Location";
const string PAGE = "Page";
const string HEADER = "Header";
const string REPORTFLD_TITLE = "fldTitle";
const string REPORTFLD_COMPANY = "fldCompany";
const string REPORTFLD_ADDRESS = "fldAddress";
const string REPORTFLD_TEL = "fldTel";
const string REPORTFLD_FAX = "fldFax";
const string REPORTFLD_DAY = "fldDay";
const string REPORTFLD_MONTH = "fldMonth";
const string REPORTFLD_YEAR = "fldYear";
const string REPORTFLD_CATEGORY = "fldCategory";
const string REPORTFLD_PARTNUMBER = "fldPartNumber";
const string REPORTFLD_PARTNAME = "fldPartName";
const string REPORTFLD_MODEL = "fldModel";
const string REPORTFLD_STOCKUM = "fldStockUM";
const string REPORTFLD_LOCATION = "fldLocation";
const string REPORTFLD_OHQTY = "fldOHQty";
const string REPORTFLD_COMMITQTY = "fldCommitQty";
const string REPORTFLD_AVAILABLEQTY = "fldAvailableQty";
const string REPORTFLD_TYPE = "fldType";
const string REPORTFLD_SOURCE = "fldSource";
const string REPORTFLD_SAFETYSTOCK = "fldSafetyStock";
const string REPORTFLD_LOT = "fldLot";
const string REPORTFLD_WARNING = "fldWarning";
#region QUERY COLUMMS
const string CATEGORY_COL = "[Category]";
const string PARTNUMBER_COL = "[Part No.]";
const string PARTNAME_COL = "[Part Name]";
const string MODEL_COL = "[Model]";
const string STOCKUM_COL = "[Stock UM]";
const string LOCATION_COL = "[Location]";
const string OHQTY_COL = "[OH Qty]";
const string COMMITQTY_COL = "[Commit Qty]";
const string AVAILABLEQTY_COL = "[Available Qty]";
const string TYPE_COL = "[Type]";
const string SOURCE_COL = "[Source]";
const string SAFETYSTOCK_COL = "[Safety Stock]";
const string LOT_COL = "[Lot]";
const string WARNING_COL = "[Warning]";
#endregion
#endregion
#region GETTING THE PARAMETER
PCSComUtils.Common.BO.UtilsBO boUtil = new PCSComUtils.Common.BO.UtilsBO();
PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO objBO = new PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO();
string strCCN = boUtil.GetCCNCodeFromID(int.Parse(pstrCCNID));
string strMasterLocation = objBO.GetMasterLocationCodeFromID(int.Parse(pstrMasterLocationID)) + ": " + objBO.GetMasterLocationNameFromID(int.Parse(pstrMasterLocationID));
string strCategory = string.Empty;
try
{
strCategory = objBO.GetCategoryCodeFromID(pstrCategoryID);
}
catch {}
#endregion
float fActualPageSize = 9000f;
#region Build dtbResult DataTable
DataTable dtbResult;
try
{
dtbResult = GetInventoryStatusData(pstrCCNID, pstrMasterLocationID, pstrCategoryID, pstrParameterModel);
}
catch
{
dtbResult = new DataTable();
}
#endregion
ReportBuilder objRB;
objRB = new ReportBuilder();
objRB.ReportName = REPORT_NAME;
objRB.SourceDataTable = dtbResult;
#region INIT REPORT BUIDER OBJECT
try
{
objRB.ReportDefinitionFolder = mstrReportDefinitionFolder;
objRB.ReportLayoutFile = REPORT_LAYOUT_FILE;
if (objRB.AnalyseLayoutFile() == false)
{
// PCSMessageBox.Show(ErrorCode.MESSAGE_REPORT_TEMPLATE_FILE_NOT_FOUND, MessageBoxIcon.Error);
return(new DataTable());
}
//objRB.UseLayoutFile = objRB.AnalyseLayoutFile(); // use layout file if any , auto drawing if not found layout file
objRB.UseLayoutFile = true; // always use layout file
}
catch
{
objRB.UseLayoutFile = false;
// PCSMessageBox.Show(ErrorCode.MESSAGE_REPORT_TEMPLATE_FILE_NOT_FOUND,MessageBoxIcon.Error);
}
C1.C1Report.Layout objLayout = objRB.Report.Layout;
fActualPageSize = objLayout.PageSize.Width - (float)objLayout.MarginLeft - (float)objLayout.MarginRight;
#endregion
objRB.MakeDataTableForRender();
//grid.DataSource = objRB.RenderDataTable;
#region RENDER TO PRINT PREVIEW
// and show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
printPreview.FormTitle = REPORT_NAME;
objRB.ReportViewer = printPreview.ReportViewer;
objRB.RenderReport();
#region COMPANY INFO header information get from system params
// try
// {
// objRB.DrawPredefinedField(REPORTFLD_COMPANY,SystemProperty.SytemParams.Get(SystemParam.COMPANY_NAME));
// }
// catch{}
// try
// {
// objRB.DrawPredefinedField(REPORTFLD_ADDRESS,SystemProperty.SytemParams.Get(SystemParam.ADDRESS));
// }
// catch{}
// try
// {
// objRB.DrawPredefinedField(REPORTFLD_TEL,SystemProperty.SytemParams.Get(SystemParam.TEL));
// }
// catch{}
// try
// {
// objRB.DrawPredefinedField(REPORTFLD_FAX,SystemProperty.SytemParams.Get(SystemParam.FAX));
// }
// catch{}
#endregion
#region DRAW Parameters
const string CCN = "CCN";
const string MASTER_LOCATION = "Master Location";
const string LOCATION = "Location";
const string CATEGORY = "Category";
const string MODEL = "Model";
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
arrParamAndValue.Add(CCN, strCCN);
arrParamAndValue.Add(MASTER_LOCATION, strMasterLocation);
if (pstrCategoryID.Trim() != string.Empty)
{
arrParamAndValue.Add(CATEGORY, strCategory);
}
if (pstrParameterModel.Trim() != string.Empty)
{
arrParamAndValue.Add(MODEL, pstrParameterModel);
}
/// anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = objRB.GetFieldByName(REPORTFLD_TITLE);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
objRB.GetSectionByName(PAGE + HEADER).CanGrow = true;
objRB.DrawParameters(objRB.GetSectionByName(PAGE + HEADER), dblStartX, dblStartY, arrParamAndValue, objRB.Report.Font.Size);
#endregion
/// there are some hardcode numbers here
/// but these numbers are use ONLY ONE and ONLY USED HERE, so we don't need to define constant for it.
objRB.DrawBoxGroup_Madeby_Checkedby_Approvedby(objRB.GetSectionByName(PAGE + HEADER), 16005 - 1400 - 1400 - 1400, 600, 1400, 1300, 200);
#region DAY--MONTH--YEAR INFO
DateTime dtm;
try
{
dtm = objUtilBO.GetDBDate();
}
catch
{
dtm = DateTime.Now;
}
try
{
objRB.DrawPredefinedField(REPORTFLD_DAY, dtm.Day.ToString("00"));
}
catch {}
try
{
objRB.DrawPredefinedField(REPORTFLD_MONTH, dtm.Month.ToString("00"));
}
catch {}
try
{
objRB.DrawPredefinedField(REPORTFLD_YEAR, dtm.Year.ToString("0000"));
}
catch {}
#endregion
try // mapping report field with table column
{
objRB.DrawPredefinedField(REPORTFLD_CATEGORY, CATEGORY_COL);
objRB.DrawPredefinedField(REPORTFLD_PARTNUMBER, PARTNUMBER_COL);
objRB.DrawPredefinedField(REPORTFLD_PARTNAME, PARTNAME_COL);
objRB.DrawPredefinedField(REPORTFLD_MODEL, MODEL_COL);
objRB.DrawPredefinedField(REPORTFLD_STOCKUM, STOCKUM_COL);
objRB.DrawPredefinedField(REPORTFLD_LOCATION, LOCATION_COL);
objRB.DrawPredefinedField(REPORTFLD_OHQTY, OHQTY_COL);
objRB.DrawPredefinedField(REPORTFLD_COMMITQTY, COMMITQTY_COL);
objRB.DrawPredefinedField(REPORTFLD_AVAILABLEQTY, AVAILABLEQTY_COL);
objRB.DrawPredefinedField(REPORTFLD_TYPE, TYPE_COL);
objRB.DrawPredefinedField(REPORTFLD_SOURCE, SOURCE_COL);
objRB.DrawPredefinedField(REPORTFLD_SAFETYSTOCK, SAFETYSTOCK_COL);
objRB.DrawPredefinedField(REPORTFLD_LOT, LOT_COL);
objRB.DrawPredefinedField(REPORTFLD_WARNING, WARNING_COL);
}
catch {}
objRB.RefreshReport();
printPreview.Show();
#endregion
UseReportViewerRenderEngine = false;
mResult = dtbResult;
return(dtbResult);
}
public DataTable ExecuteReport(string pstrCCNID, string pstrMasLocID, string pstrPartyIDList, string pstrSaleOrderIDList, string pstrProductIDList)
{
try
{
const string DATE_FORMAT = "dd-MM-yyyy HH:mm";
const string REPORT_NAME = "SaleOrderManagementReport";
const string REPORT_LAYOUT = "SaleOrderManagementReport.xml";
const string RPT_PAGE_HEADER = "PageHeader";
//Report field names
const string RPT_TITLE_FIELD = "fldTitle";
const string RPT_CCN = "CCN";
const string RPT_SO_NO = "SO No.";
const string RPT_CUSTOMER = "Customer";
const string RPT_PART_NUMBER = "Part Number";
const string RPT_MASTER_LOCATION = "Master Location";
DataTable dtbTranHis = GetSaleOrderManagementData(pstrCCNID, pstrMasLocID, pstrPartyIDList, pstrSaleOrderIDList, pstrProductIDList);
//Create builder object
ReportBuilder reportBuilder = new ReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbTranHis;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
reportBuilder.ReportLayoutFile = REPORT_LAYOUT;
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// And show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
string strCode = GetCCNInfoByID(pstrCCNID);
arrParamAndValue.Add(RPT_CCN, strCode);
//Master Location
strCode = GetMasterLocationInfoByID(pstrMasLocID);
arrParamAndValue.Add(RPT_MASTER_LOCATION, strCode);
//Party Information
if (pstrPartyIDList != null && pstrPartyIDList != string.Empty)
{
arrParamAndValue.Add(RPT_CUSTOMER, GetPartyInfo(pstrPartyIDList));
}
//Sale Order Information
if (pstrSaleOrderIDList != null && pstrSaleOrderIDList != string.Empty)
{
arrParamAndValue.Add(RPT_SO_NO, GetSaleOrderInfo(pstrSaleOrderIDList));
}
//Product Information
if (pstrProductIDList != null && pstrProductIDList != string.Empty)
{
arrParamAndValue.Add(RPT_PART_NUMBER, GetProductInfo(pstrProductIDList));
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text;
}
catch {}
reportBuilder.RefreshReport();
printPreview.Show();
return(dtbTranHis);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable ExecuteReport(string pstrCCNID, string pstrMasLocID, string pstrFromDate, string pstrToDate,
string pstrProductIDList, string pstrCustomerIDList, string pstrCurrencyIDList
)
{
try
{
const string DATE_FORMAT = "dd-MM-yyyy HH:mm";
const string REPORT_NAME = "SaleTransactionHistoryReport";
const string REPORT_LAYOUT = "SaleTransactionHistoryReport.xml";
const int FOOTER_HEIGHT = 10;
const string RPT_PAGE_HEADER = "PageHeader";
const string RPT_CONFIRM_SHIP_NO_FOOTER = "ConfirmShipNoFooter";
//Report field names
const string RPT_FIELD_PREFIX = "fld";
const string RPT_TITLE_FIELD = "fldTitle";
const string RPT_CCN = "CCN";
const string RPT_FROM_DATE = "From Date";
const string RPT_TO_DATE = "To Date";
const string RPT_PART_NUMBER = "Part Number";
const string RPT_MASTER_LOCATION = "Master Location";
const string RPT_CURRENCY = "Currency";
const string RPT_CUSTOMER = "Customer";
DataTable dtbTranHis = GetSaleTransactionHistoryData(pstrCCNID, pstrMasLocID, pstrFromDate, pstrToDate, pstrProductIDList, pstrCustomerIDList, pstrCurrencyIDList);
//Create builder object
ReportBuilder reportBuilder = new ReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbTranHis;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
reportBuilder.ReportLayoutFile = REPORT_LAYOUT;
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// And show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
string strCode = GetCCNInfoByID(pstrCCNID);
arrParamAndValue.Add(RPT_CCN, strCode);
//Master Location
strCode = GetMasterLocationInfoByID(pstrMasLocID);
arrParamAndValue.Add(RPT_MASTER_LOCATION, strCode);
//From Date
if (pstrFromDate != null && pstrFromDate != string.Empty)
{
arrParamAndValue.Add(RPT_FROM_DATE, DateTime.Parse(pstrFromDate).ToString(DATE_FORMAT));
}
//To Date
if (pstrToDate != null && pstrToDate != string.Empty)
{
arrParamAndValue.Add(RPT_TO_DATE, DateTime.Parse(pstrToDate).ToString(DATE_FORMAT));
}
//Product Information
if (pstrProductIDList != null && pstrProductIDList != string.Empty)
{
arrParamAndValue.Add(RPT_PART_NUMBER, GetProductInfo(pstrProductIDList));
}
//Customer Information
if (pstrCustomerIDList != null && pstrCustomerIDList != string.Empty)
{
arrParamAndValue.Add(RPT_CUSTOMER, GetCustomerInfoByID(pstrCustomerIDList));
}
//Currency Information
if (pstrCurrencyIDList != null && pstrCurrencyIDList != string.Empty)
{
arrParamAndValue.Add(RPT_CURRENCY, GetCurrencyInfoByID(pstrCurrencyIDList));
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text;
}
catch {}
//Hide footer if items were selected
if (pstrProductIDList != null && pstrProductIDList != string.Empty)
{
C1.C1Report.Section confirmFooter = reportBuilder.GetSectionByName(RPT_CONFIRM_SHIP_NO_FOOTER);
if (confirmFooter != null)
{
foreach (C1.C1Report.Field field in confirmFooter.Fields)
{
field.Top = 0;
field.Visible = !(field.Name.StartsWith(RPT_FIELD_PREFIX));
}
confirmFooter.Height = FOOTER_HEIGHT;
}
}
reportBuilder.RefreshReport();
printPreview.Show();
return(dtbTranHis);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Build and show Detai lItem Price By PO Receipt
/// </summary>
/// <author> Tuan TQ, 11 Apr, 2006</author>
public DataTable ExecuteReport(string pstrCCNID,
string pstrStockTakingPeriodID,
string pstrDepartmentIDs,
string pstrProductionLineIDs,
string pstrLocationIDs,
string pstrBinIDs
)
{
// try
// {
string strPOTypeID = Convert.ToString((int)PCSComUtils.Common.POReceiptTypeEnum.ByInvoice);
const string DATE_HOUR_FORMAT = "dd-MM-yyyy HH:mm";
const string REPORT_TEMPLATE = "StockTakingReport.xml";
const string RPT_PAGE_HEADER = "PageHeader";
const string REPORT_NAME = "StockTakingReport";
const string RPT_TITLE_FLD = "fldTitle";
const string RPT_COMPANY_FLD = "fldCompany";
const string RPT_CCN_FLD = "CCN";
const string RPT_MASTER_LOCATION_FLD = "Master Location";
const string RPT_LOCATION_FLD = "Master Location";
const string RPT_FROM_DATE_FLD = "From Date";
const string RPT_TO_DATE_FLD = "To Date";
const string RPT_PART_NO_FLD = "Part No.";
const string RPT_TRANSACTION_TYPE_FLD = "Trans. Type";
DataTable dtbDataSource = null;
dtbDataSource = GetStockTakingData(pstrCCNID,
pstrStockTakingPeriodID,
pstrDepartmentIDs,
pstrProductionLineIDs,
pstrLocationIDs,
pstrBinIDs);
//Create builder object
ReportBuilder reportBuilder = new ReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbDataSource;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
reportBuilder.ReportLayoutFile = REPORT_TEMPLATE;
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// and show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
reportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, GetCompanyFullName());
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
arrParamAndValue.Add(RPT_CCN_FLD, GetCCNInfoByID(pstrCCNID));
arrParamAndValue.Add("StockTakingPeriod ", GetFieldInfoFromTable("IV_StockTakingPeriod", "Description", "StockTakingPeriodID", pstrStockTakingPeriodID));
//
if (pstrDepartmentIDs != null && pstrDepartmentIDs != string.Empty)
{
arrParamAndValue.Add("Department ", GetFieldInfoFromTable(MST_DepartmentTable.TABLE_NAME, "Code", MST_DepartmentTable.DEPARTMENTID_FLD, pstrDepartmentIDs));
}
//
if (pstrProductionLineIDs != null && pstrProductionLineIDs != string.Empty)
{
arrParamAndValue.Add("Production Line ", GetFieldInfoFromTable(PRO_ProductionLineTable.TABLE_NAME, "Code", PRO_ProductionLineTable.PRODUCTIONLINEID_FLD, pstrProductionLineIDs));
}
//Location list
if (pstrLocationIDs != null && pstrLocationIDs != string.Empty)
{
arrParamAndValue.Add("Location ", GetLocationInfo(pstrLocationIDs));
}
//Part no list
if (pstrBinIDs != null && pstrBinIDs != string.Empty)
{
arrParamAndValue.Add("Bin ", GetFieldInfoFromTable(MST_BINTable.TABLE_NAME, "Code", MST_BINTable.BINID_FLD, pstrBinIDs));
}
//
// //Trans. type list
// if(pstrTransTypeIDList != null && pstrTransTypeIDList != string.Empty)
// {
// arrParamAndValue.Add(RPT_TRANSACTION_TYPE_FLD, GetTransTypeInfo(pstrTransTypeIDList));
// }
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD).Text;
}
catch
{}
reportBuilder.RefreshReport();
printPreview.Show();
//return table
return(dtbDataSource);
// }
// catch (Exception ex)
// {
// throw ex;
// }
}
public DataTable ExecuteReport(string pstrCCNID, string pstrFromDate, string pstrToDate,
string pstrTransTypeID, string pstrGreaterThan0, string pstrMasLocID, string pstrLocationID, string pstrProductID)
{
try
{
const string DATE_FORMAT = "dd-MM-yyyy HH:mm";
const string REPORT_NAME = "TransactionHistoryReport";
const string REPORT_LAYOUT = "TransactionHistoryReport.xml";
const string RPT_PAGE_HEADER = "PageHeader";
//Report field names
const string RPT_TITLE_FIELD = "fldTitle";
const string RPT_CCN = "CCN";
const string RPT_FROM_DATE = "From Date";
const string RPT_TO_DATE = "To Date";
const string RPT_LOCATION = "Location";
const string RPT_TRAN_TYPE = "Transation Type";
const string RPT_PART_NUMBER = "Part Number";
const string RPT_MODEL = "Model";
const string RPT_PART_NAME = "Part Name";
const string RPT_MASTER_LOCATION = "Master Location";
DataTable dtbTranHis = GetTransactionHistoryData(pstrCCNID, pstrFromDate, pstrToDate, pstrTransTypeID, pstrGreaterThan0, pstrMasLocID, pstrLocationID, pstrProductID);
//Create builder object
ReportBuilder reportBuilder = new ReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbTranHis;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
reportBuilder.ReportLayoutFile = REPORT_LAYOUT;
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// And show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
string strCode = GetCCNInfoByID(pstrCCNID);
arrParamAndValue.Add(RPT_CCN, strCode);
arrParamAndValue.Add(RPT_FROM_DATE, DateTime.Parse(pstrFromDate).ToString(DATE_FORMAT));
arrParamAndValue.Add(RPT_TO_DATE, DateTime.Parse(pstrToDate).ToString(DATE_FORMAT));
//Master Location
if (pstrMasLocID != null && pstrMasLocID != string.Empty)
{
strCode = GetMasterLocationInfoByID(pstrMasLocID);
arrParamAndValue.Add(RPT_MASTER_LOCATION, strCode);
}
//Location
if (pstrLocationID != null && pstrLocationID != string.Empty)
{
strCode = GetLocationInfoByID(pstrLocationID);
arrParamAndValue.Add(RPT_LOCATION, strCode);
}
//Transaction Type
if (pstrTransTypeID != null && pstrTransTypeID != string.Empty)
{
strCode = GetTranTypeName(pstrTransTypeID);
arrParamAndValue.Add(RPT_TRAN_TYPE, strCode);
}
//Product Information
if (pstrProductID != null && pstrProductID != string.Empty)
{
Hashtable htbProductInfo = GetProductInfoByID(pstrProductID);
arrParamAndValue.Add(RPT_PART_NUMBER, htbProductInfo[PRODUCT_CODE].ToString());
arrParamAndValue.Add(RPT_PART_NAME, htbProductInfo[PRODUCT_NAME].ToString());
arrParamAndValue.Add(RPT_MODEL, htbProductInfo[PRODUCT_MODEL].ToString());
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text;
}
catch {}
reportBuilder.RefreshReport();
printPreview.Show();
return(dtbTranHis);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Build and show Detai lItem Price By PO Receipt
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <author> Tuan TQ, 11 Apr, 2006</author>
public DataTable ExecuteReport(string pstrCCNID,
string pstrMasLocID,
string pstrFromDate,
string pstrToDate,
string pstrCurrencyID,
string pstrExchangeRate,
string pstrProductIDList,
string pstrVendorType,
string pstrVendorIDList
)
{
string strPOTypeID = Convert.ToString((int)PCSComUtils.Common.POReceiptTypeEnum.ByInvoice);
const string DATE_HOUR_FORMAT = "dd-MM-yyyy HH:mm";
const string NUMERIC_FORMAT = "#,##0.00";
const string REPORT_TEMPLATE_LOCAL = "ReceivingMaterialReport_Local.xml";
const string REPORT_TEMPLATE = "ReceivingMaterialReport.xml";
const string RPT_PAGE_HEADER = "PageHeader";
const string REPORT_NAME = "ReceivingMaterialReport";
const string RPT_TITLE_FLD = "fldTitle";
const string RPT_COMPANY_FLD = "fldCompany";
const string RPT_CCN_FLD = "CCN";
const string RPT_MASTER_LOCATION_FLD = "Master Location";
const string RPT_FROM_DATE_FLD = "From Date";
const string RPT_TO_DATE_FLD = "To Date";
const string RPT_PART_NUMBER_FLD = "Part Number";
const string RPT_CURRENCY_FLD = "Currency";
const string RPT_EXCHANGE_RATE_FLD = "Exchange Rate";
const string RPT_VENDOR_FLD = "Vendor";
const string RPT_VENDOR_TYPE_FLD = "Vendor Type";
DataTable dtbDataSource = null;
string strHomeCurrency = GetHomeCurrency(pstrCCNID);
dtbDataSource = GetReceivingMaterialReportData(pstrCCNID,
pstrMasLocID,
pstrFromDate,
pstrToDate,
pstrProductIDList,
pstrCurrencyID,
pstrExchangeRate,
strHomeCurrency,
pstrVendorType,
pstrVendorIDList);
//Create builder object
ReportWithSubReportBuilder reportBuilder = new ReportWithSubReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbDataSource;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
if (pstrVendorType != null && pstrVendorType != string.Empty)
{
if (pstrVendorType.ToUpper() == LOCAL_STRING.ToUpper())
{
reportBuilder.ReportLayoutFile = REPORT_TEMPLATE_LOCAL;
}
else
{
reportBuilder.ReportLayoutFile = REPORT_TEMPLATE;
}
}
else
{
reportBuilder.ReportLayoutFile = REPORT_TEMPLATE;
}
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// and show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
reportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, GetCompanyFullName());
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
arrParamAndValue.Add(RPT_CCN_FLD, GetCCNInfoByID(pstrCCNID));
arrParamAndValue.Add(RPT_MASTER_LOCATION_FLD, GetMasterLocationInfoByID(pstrMasLocID));
Hashtable htbCurrency = GetCurrencyInfo(pstrCurrencyID);
if (htbCurrency != null)
{
arrParamAndValue.Add(RPT_CURRENCY_FLD, htbCurrency[PRODUCT_CODE_FLD].ToString());
if (strHomeCurrency == pstrCurrencyID)
{
arrParamAndValue.Add(RPT_EXCHANGE_RATE_FLD, decimal.One.ToString(NUMERIC_FORMAT));
}
else
{
if (pstrExchangeRate != string.Empty && pstrExchangeRate != null)
{
arrParamAndValue.Add(RPT_EXCHANGE_RATE_FLD, decimal.Parse(pstrExchangeRate).ToString(NUMERIC_FORMAT));
}
else
{
arrParamAndValue.Add(RPT_EXCHANGE_RATE_FLD, decimal.Parse(htbCurrency[EXCHANGE_RATE_FLD].ToString()).ToString(NUMERIC_FORMAT));
}
}
}
if (pstrFromDate != null && pstrFromDate != string.Empty)
{
arrParamAndValue.Add(RPT_FROM_DATE_FLD, DateTime.Parse(pstrFromDate).ToString(DATE_HOUR_FORMAT));
}
if (pstrToDate != null && pstrToDate != string.Empty)
{
arrParamAndValue.Add(RPT_TO_DATE_FLD, DateTime.Parse(pstrToDate).ToString(DATE_HOUR_FORMAT));
}
if (pstrProductIDList != null && pstrProductIDList != string.Empty)
{
arrParamAndValue.Add(RPT_PART_NUMBER_FLD, GetProductInfo(pstrProductIDList));
}
if (pstrVendorType != null && pstrVendorType != string.Empty)
{
arrParamAndValue.Add(RPT_VENDOR_TYPE_FLD, pstrVendorType);
}
if (pstrVendorIDList != null && pstrVendorIDList != string.Empty)
{
arrParamAndValue.Add(RPT_VENDOR_FLD, GetPartyInfo(pstrVendorIDList));
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD).Text;
}
catch
{}
reportBuilder.RefreshReport();
printPreview.Show();
//return table
return(dtbDataSource);
}
/// <summary>
/// Thachnn: 28/10/2005
/// Preview the report for this form
/// Using the "InventoryDetailReport.xml" layout
/// </summary>
/// <history>Thachnn: 29/12/2005: Add parameter display to the report. Change USECASE.</history>
/// <param name="sender"></param>
/// <param name="e"></param>
public DataTable ExecuteReport(string pstrCCNID, string pstrMasterLocationID, string pstrLocationID, string pstrBinID, string pstrCategoryID, string pstrParameterModel)
{
#region Constants
string mstrReportDefFolder = mstrReportDefinitionFolder;
const string REPORT_LAYOUT_FILE = "InventoryDetailReport.xml";
const string TABLE_NAME = "InventoryDetailReport";
const string REPORT_NAME = "Inventory Detail";
const string PAGE = "Page";
const string HEADER = "Header";
const string REPORTFLD_TITLE = "fldTitle";
const string REPORTFLD_COMPANY = "fldCompany";
const string REPORTFLD_ADDRESS = "fldAddress";
const string REPORTFLD_TEL = "fldTel";
const string REPORTFLD_FAX = "fldFax";
const string REPORTFLD_DATETIME = "fldDateTime";
#endregion
#region GETTING THE PARAMETER
PCSComUtils.Common.BO.UtilsBO boUtil = new PCSComUtils.Common.BO.UtilsBO();
PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO objBO = new PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO();
string strCCN = boUtil.GetCCNCodeFromID(int.Parse(pstrCCNID));
string strMasterLocation = objBO.GetMasterLocationCodeFromID(int.Parse(pstrMasterLocationID)) + ": " + objBO.GetMasterLocationNameFromID(int.Parse(pstrMasterLocationID));
string strLocation = string.Empty;
try
{
strLocation = objBO.GetLocationCodeFromID(int.Parse(pstrLocationID));
}
catch {}
string strBin = string.Empty;
try
{
strBin = objBO.GetBinCodeFromID(int.Parse(pstrBinID));
}
catch {}
string strCategory = string.Empty;
try
{
strCategory = objBO.GetCategoryCodeFromID(int.Parse(pstrCategoryID));
}
catch {}
#endregion
float fActualPageSize = 9000f;
#region Build dtbResult DataTable
DataTable dtbResult;
try
{
dtbResult = GetInventoryDetailData(pstrCCNID, pstrMasterLocationID, pstrLocationID, pstrBinID, pstrCategoryID, pstrParameterModel);
}
catch
{
dtbResult = new DataTable();
}
#endregion
ReportBuilder objRB;
objRB = new ReportBuilder();
objRB.ReportName = REPORT_NAME;
objRB.SourceDataTable = dtbResult;
#region INIT REPORT BUIDER OBJECT
try
{
objRB.ReportDefinitionFolder = mstrReportDefinitionFolder;
objRB.ReportLayoutFile = REPORT_LAYOUT_FILE;
if (objRB.AnalyseLayoutFile() == false)
{
// PCSMessageBox.Show(ErrorCode.MESSAGE_REPORT_TEMPLATE_FILE_NOT_FOUND, MessageBoxIcon.Error);
return(new DataTable());
}
//objRB.UseLayoutFile = objRB.AnalyseLayoutFile(); // use layout file if any , auto drawing if not found layout file
objRB.UseLayoutFile = true; // always use layout file
}
catch
{
objRB.UseLayoutFile = false;
// PCSMessageBox.Show(ErrorCode.MESSAGE_REPORT_TEMPLATE_FILE_NOT_FOUND,MessageBoxIcon.Error);
}
C1.C1Report.Layout objLayout = objRB.Report.Layout;
fActualPageSize = objLayout.PageSize.Width - (float)objLayout.MarginLeft - (float)objLayout.MarginRight;
#endregion
objRB.MakeDataTableForRender();
//grid.DataSource = objRB.RenderDataTable;
#region RENDER TO PRINT PREVIEW
// and show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
printPreview.FormTitle = REPORT_NAME;
objRB.ReportViewer = printPreview.ReportViewer;
objRB.RenderReport();
#region COMPANY INFO header information get from system params
// try
// {
// objRB.DrawPredefinedField(REPORTFLD_COMPANY,SystemProperty.SytemParams.Get(SystemParam.COMPANY_NAME));
// }
// catch{}
// try
// {
// objRB.DrawPredefinedField(REPORTFLD_ADDRESS,SystemProperty.SytemParams.Get(SystemParam.ADDRESS));
// }
// catch{}
// try
// {
// objRB.DrawPredefinedField(REPORTFLD_TEL,SystemProperty.SytemParams.Get(SystemParam.TEL));
// }
// catch{}
// try
// {
// objRB.DrawPredefinedField(REPORTFLD_FAX,SystemProperty.SytemParams.Get(SystemParam.FAX));
// }
// catch{}
#endregion
#region DRAW Parameters
const string CCN = "CCN";
const string MASTER_LOCATION = "Master Location";
const string LOCATION = "Location";
const string BIN = "Bin";
const string CATEGORY = "Category";
const string MODEL = "Model";
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
arrParamAndValue.Add(CCN, strCCN);
arrParamAndValue.Add(MASTER_LOCATION, strMasterLocation);
if (pstrLocationID.Trim() != string.Empty)
{
arrParamAndValue.Add(LOCATION, strLocation);
}
if (pstrBinID.Trim() != string.Empty)
{
arrParamAndValue.Add(BIN, strBin);
}
if (pstrCategoryID.Trim() != string.Empty)
{
arrParamAndValue.Add(CATEGORY, strCategory);
}
if (pstrParameterModel.Trim() != string.Empty)
{
arrParamAndValue.Add(MODEL, pstrParameterModel);
}
/// anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = objRB.GetFieldByName(REPORTFLD_TITLE);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
objRB.GetSectionByName(PAGE + HEADER).CanGrow = true;
objRB.DrawParameters(objRB.GetSectionByName(PAGE + HEADER), dblStartX, dblStartY, arrParamAndValue, objRB.Report.Font.Size);
#endregion
/// there are some hardcode numbers here
/// but these numbers are use ONLY ONE and ONLY USED HERE, so we don't need to define constant for it.
objRB.DrawBoxGroup_Madeby_Checkedby_Approvedby(objRB.GetSectionByName(PAGE + HEADER), 15945 - 1400 - 1400 - 1400, 600, 1400, 1300, 200);
#region DAY--MONTH--YEAR INFO
DateTime dtm;
try
{
dtm = objUtilBO.GetDBDate();
}
catch
{
dtm = DateTime.Now;
}
try
{
objRB.DrawPredefinedField(REPORTFLD_DATETIME, dtm.ToString("dd-MM-yyyy hh:mm"));
}
catch {}
#endregion
objRB.RefreshReport();
printPreview.Show();
#endregion
UseReportViewerRenderEngine = false;
mResult = dtbResult;
return(dtbResult);
}
public DataTable ExecuteReport(string pstrCCN, string pstrCategory, string pstrModel, string pstrSource, string pstrType, string pstrMakeItem)
{
try
{
//const char UNCHECK_SQUARE_CHAR = (char)111;
//const char CHECK_SQUARE_CHAR = (char)120;
//const char SPACE_CHAR = (char)32;
//Report name
const string REPORT_NAME = "ItemListReport";
const string REPORT_LAYOUT = "ItemListReport.xml";
const string RPT_HEADER = "Header";
//Report field names
const string RPT_TITLE_FIELD = "fldTitle";
//Report field names
const string RPT_CCN = "CCN";
const string RPT_CATEGORY = "Category";
const string RPT_MODEL = "Model";
const string RPT_SOURCE = "Source";
const string RPT_TYPE = "Type";
const string RPT_MAKE_ITEM = "Make";
DataTable dtbItemList = GetItemListData(pstrCCN, pstrCategory, pstrModel, pstrSource, pstrType, pstrMakeItem);
//Create builder object
ReportWithSubReportBuilder reportBuilder = new ReportWithSubReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbItemList;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
reportBuilder.ReportLayoutFile = REPORT_LAYOUT;
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// and show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
arrParamAndValue.Add(RPT_CCN, pstrCCN);
if (pstrCategory != string.Empty)
{
arrParamAndValue.Add(RPT_CATEGORY, pstrCategory);
}
if (pstrModel != string.Empty)
{
arrParamAndValue.Add(RPT_MODEL, pstrModel);
}
if (pstrSource != string.Empty)
{
arrParamAndValue.Add(RPT_SOURCE, pstrSource);
}
if (pstrType != string.Empty)
{
arrParamAndValue.Add(RPT_TYPE, pstrType);
}
if (pstrMakeItem.ToUpper().Equals("TRUE") || pstrMakeItem.Equals("1"))
{
arrParamAndValue.Add(RPT_MAKE_ITEM, "x");
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text;
}
catch {}
//Show report
reportBuilder.RefreshReport();
printPreview.Show();
return(dtbItemList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Change header & column header of report
/// </summary>
/// <param name="pobjReportBuilder"></param>
/// <param name="pintReportYear.ToString()"></param>
/// <author> Tuan TQ, 07 Dec, 2005</author>
private void ChangeReportDisplayInfo(ReportBuilder pobjReportBuilder, string pstrCCN, string pstrReportYear, string pstrReportMonth, string pstrPartyID, string pstrCategoryID, string pstrProductID)
{
try
{
#region Constants
const string SHORT_DATE_FORMAT = "d-MMM";
//Report Field's Name
const string RPT_COMPANY_FLD = "fldCompany";
const string RPT_PAGE_HEADER = "PageHeader";
//Report field names
const string RPT_TITLE_FIELD = "fldTitle";
const string RPT_CCN_FLD = "CCN";
const string RPT_MONTH_FLD = "Month";
const string RPT_YEAR_FLD = "Year";
const string RPT_PARTY_CODE_NAME_FLD = "Customer";
const string RPT_CATEGORY_FLD = "Category";
const string RPT_ITEM_INFO_FLD = "Item(Part No., Part Name, Model)";
const string RPT_DAY_PREFIX = "fldDay_";
const string RPT_DAY_OF_WEEK_PREFIX = "fldDayOfWeek_";
const string RPT_QUANTITY_PREFIX = "fldQuantity_";
#endregion Constants
//set start day in month
int iReportYear = int.Parse(pstrReportYear);
int iReportMonth = int.Parse(pstrReportMonth);
DateTime dtmReportDay = new DateTime(iReportYear, iReportMonth, 1);
int iDaysInMonth = DateTime.DaysInMonth(iReportYear, iReportMonth);
//Change report header's value
pobjReportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, GetCompanyFullName());
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
arrParamAndValue.Add(RPT_CCN_FLD, GetCCNInfoByID(pstrCCN));
arrParamAndValue.Add(RPT_MONTH_FLD, pstrReportMonth);
arrParamAndValue.Add(RPT_YEAR_FLD, pstrReportYear);
if (pstrPartyID != null && pstrPartyID != string.Empty)
{
arrParamAndValue.Add(RPT_PARTY_CODE_NAME_FLD, GetCustomerInfoByID(pstrPartyID));
}
if (pstrCategoryID != null && pstrCategoryID != string.Empty)
{
arrParamAndValue.Add(RPT_CATEGORY_FLD, GetCategoryInfoByID(pstrCategoryID));
}
if (pstrProductID != null && pstrProductID != string.Empty)
{
string strItemInfo = string.Empty;
Hashtable htbItem = GetProductInfoByID(pstrProductID);
if (htbItem != null)
{
strItemInfo = htbItem[PRODUCT_CODE].ToString();
strItemInfo += ", " + htbItem[PRODUCT_NAME].ToString();
strItemInfo += ", " + htbItem[PRODUCT_MODEL].ToString();
}
arrParamAndValue.Add(RPT_ITEM_INFO_FLD, strItemInfo);
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = pobjReportBuilder.GetFieldByName(RPT_TITLE_FIELD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
pobjReportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
pobjReportBuilder.DrawParameters(pobjReportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, pobjReportBuilder.Report.Font.Size);
//loop and change caption
for (int i = 1; i <= iDaysInMonth; i++)
{
pobjReportBuilder.DrawPredefinedField(RPT_DAY_PREFIX + i, dtmReportDay.ToString(SHORT_DATE_FORMAT));
pobjReportBuilder.DrawPredefinedField(RPT_DAY_OF_WEEK_PREFIX + i, dtmReportDay.DayOfWeek.ToString().Substring(0, 3));
if (dtmReportDay.DayOfWeek == DayOfWeek.Sunday)
{
pobjReportBuilder.Report.Fields[RPT_DAY_PREFIX + i.ToString()].BackColor = Color.Yellow;
pobjReportBuilder.Report.Fields[RPT_DAY_PREFIX + i.ToString()].ForeColor = Color.Red;
pobjReportBuilder.Report.Fields[RPT_DAY_OF_WEEK_PREFIX + i.ToString()].BackColor = Color.Yellow;
pobjReportBuilder.Report.Fields[RPT_DAY_OF_WEEK_PREFIX + i.ToString()].ForeColor = Color.Red;
//pobjReportBuilder.Report.Fields[RPT_QUANTITY_PREFIX + i.ToString()].Visible = false;
}
dtmReportDay = dtmReportDay.AddDays(1);
}
//Company Info
//pobjReportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, SystemProperty.SytemParams.Get(SystemParam.COMPANY_FULL_NAME));
//Hide fields those are not displayed
for (int i = iDaysInMonth + 1; i <= MAX_DAYS_IN_MONTH; i++)
{
pobjReportBuilder.Report.Fields[RPT_DAY_PREFIX + i.ToString()].Visible = false;
pobjReportBuilder.Report.Fields[RPT_DAY_OF_WEEK_PREFIX + i.ToString()].Visible = false;
pobjReportBuilder.Report.Fields[RPT_QUANTITY_PREFIX + i.ToString()].Visible = false;
}
AdjustWidthAndLocation(pobjReportBuilder, iDaysInMonth);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable ExecuteReport(string pstrCCNID, string pstrCategoryID, string pstrModel, string pstrProductID)
{
try
{
const string REPORT_NAME = "ItemStandardCostReport";
const string REPORT_LAYOUT = "ItemStandardCostReport.xml";
const string RPT_PAGE_HEADER = "PageHeader";
const string RPT_TITLE_FLD = "fldTitle";
const string RPT_CURRENCY_FLD = "fldCurrency";
const string RPT_CCN_FLD = "CCN";
const string RPT_CATEGORY_FLD = "Category";
const string RPT_MODEL_FLD = "Model";
const string RPT_PART_NO_FLD = "Part No.";
const string RPT_PART_NAME_FLD = "Part Name";
DataTable dtbData = BuildItemStandardCostData(pstrCCNID, pstrCategoryID, pstrModel, pstrProductID);
//Create builder object
ReportBuilder reportBuilder = new ReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbData;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
reportBuilder.ReportLayoutFile = REPORT_LAYOUT;
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// and show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO objBO = new PCSComUtils.Framework.ReportFrame.BO.C1PrintPreviewDialogBO();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
reportBuilder.DrawPredefinedField(RPT_CURRENCY_FLD, GetHomeCurrency(pstrCCNID));
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
string strCode = GetCCNInfoByID(pstrCCNID);
arrParamAndValue.Add(RPT_CCN_FLD, strCode);
//Category
if (pstrCategoryID != null && pstrCategoryID != string.Empty)
{
strCode = objBO.GetCategoryCodeFromID(pstrCategoryID);
arrParamAndValue.Add(RPT_CATEGORY_FLD, strCode);
}
//Model
if (pstrModel != null && pstrModel != string.Empty)
{
arrParamAndValue.Add(RPT_MODEL_FLD, pstrModel);
}
//Product Information
if (pstrProductID != null && pstrProductID != string.Empty)
{
Hashtable htbProductInfo = GetProductInfoByID(pstrProductID);
arrParamAndValue.Add(RPT_PART_NO_FLD, htbProductInfo[CODE_FLD].ToString());
arrParamAndValue.Add(RPT_PART_NAME_FLD, htbProductInfo[DESCRIPTION_FLD].ToString());
if (pstrModel == string.Empty || pstrModel == null)
{
arrParamAndValue.Add(RPT_MODEL_FLD, htbProductInfo[REVISION_FLD].ToString());
}
else
{
arrParamAndValue[RPT_MODEL_FLD] = htbProductInfo[REVISION_FLD].ToString();
}
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD).Text;
}
catch
{
}
reportBuilder.RefreshReport();
printPreview.Show();
return(dtbData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable ExecuteReport(string pstrMonth, string pstrYear, string pstrCustomerIDList)
{
try
{
const string DATE_FORMAT = "MMM-yyyy";
const string REPORT_NAME = "MonthlyReturnGoodsReceipt";
const string REPORT_LAYOUT = "MonthlyReturnGoodsReceipt.xml";
const string RPT_PAGE_HEADER = "PageHeader";
//Report field names
const string RPT_TITLE_FIELD = "fldTitle";
const string RPT_REPORT_MONTH = "Month";
const string RPT_CUSTOMER = "Customer";
DataTable dtbTranHis = GetMonthlyReturnGoodsReceiptData(pstrMonth, pstrYear, pstrCustomerIDList);
//Create builder object
ReportBuilder reportBuilder = new ReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbTranHis;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
reportBuilder.ReportLayoutFile = REPORT_LAYOUT;
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// And show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
//From Date
if (pstrMonth != null && pstrMonth != string.Empty &&
pstrYear != null && pstrYear != string.Empty)
{
DateTime dtmTemp = new DateTime(int.Parse(pstrYear), int.Parse(pstrMonth), 1);
arrParamAndValue.Add(RPT_REPORT_MONTH, dtmTemp.ToString(DATE_FORMAT));
}
//Customer Information
if (pstrCustomerIDList != null && pstrCustomerIDList != string.Empty)
{
arrParamAndValue.Add(RPT_CUSTOMER, GetCustomerInfoByID(pstrCustomerIDList));
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FIELD).Text;
}
catch {}
reportBuilder.RefreshReport();
printPreview.Show();
return(dtbTranHis);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Build and show Detai lItem Price By PO Receipt
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <author> Tuan TQ, 11 Apr, 2006</author>
public DataTable ExecuteReport(string pstrCCNID,
string pstrFromDate,
string pstrToDate,
string pstrCurrencyIDList
)
{
try
{
string strPOTypeID = Convert.ToString((int)PCSComUtils.Common.POReceiptTypeEnum.ByInvoice);
const string DATE_HOUR_FORMAT = "dd-MM-yyyy HH:mm";
const string NUMERIC_FORMAT = "#,##0.00";
const string REPORT_TEMPLATE = "ImportMaterialReport.xml";
const string RPT_PAGE_HEADER = "PageHeader";
const string REPORT_NAME = "ImportMaterialReport";
const string RPT_TITLE_FLD = "fldTitle";
const string RPT_COMPANY_FLD = "fldCompany";
const string RPT_CCN_FLD = "CCN";
const string RPT_FROM_DATE_FLD = "From Date";
const string RPT_TO_DATE_FLD = "To Date";
const string RPT_CURRENCY_FLD = "Currency";
DataTable dtbDataSource = null;
dtbDataSource = GetImportMaterialReport(pstrCCNID, pstrFromDate, pstrToDate, pstrCurrencyIDList);
//Create builder object
ReportWithSubReportBuilder reportBuilder = new ReportWithSubReportBuilder();
//Set report name
reportBuilder.ReportName = REPORT_NAME;
//Set Datasource
reportBuilder.SourceDataTable = dtbDataSource;
//Set report layout location
reportBuilder.ReportDefinitionFolder = mstrReportDefinitionFolder;
reportBuilder.ReportLayoutFile = REPORT_TEMPLATE;
reportBuilder.UseLayoutFile = true;
reportBuilder.MakeDataTableForRender();
// and show it in preview dialog
PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog printPreview = new PCSUtils.Framework.ReportFrame.C1PrintPreviewDialog();
//Attach report viewer
reportBuilder.ReportViewer = printPreview.ReportViewer;
reportBuilder.RenderReport();
reportBuilder.DrawPredefinedField(RPT_COMPANY_FLD, GetCompanyFullName());
//Draw parameters
System.Collections.Specialized.NameValueCollection arrParamAndValue = new System.Collections.Specialized.NameValueCollection();
arrParamAndValue.Add(RPT_CCN_FLD, GetCCNInfoByID(pstrCCNID));
if (pstrFromDate != null && pstrFromDate != string.Empty)
{
arrParamAndValue.Add(RPT_FROM_DATE_FLD, DateTime.Parse(pstrFromDate).ToString(DATE_HOUR_FORMAT));
}
if (pstrToDate != null && pstrToDate != string.Empty)
{
arrParamAndValue.Add(RPT_TO_DATE_FLD, DateTime.Parse(pstrToDate).ToString(DATE_HOUR_FORMAT));
}
if (pstrCurrencyIDList != null && pstrCurrencyIDList != string.Empty)
{
arrParamAndValue.Add(RPT_CURRENCY_FLD, GetCurrencyInfo(pstrCurrencyIDList));
}
//Anchor the Parameter drawing canvas cordinate to the fldTitle
C1.C1Report.Field fldTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD);
double dblStartX = fldTitle.Left;
double dblStartY = fldTitle.Top + 1.3 * fldTitle.RenderHeight;
reportBuilder.GetSectionByName(RPT_PAGE_HEADER).CanGrow = true;
reportBuilder.DrawParameters(reportBuilder.GetSectionByName(RPT_PAGE_HEADER), dblStartX, dblStartY, arrParamAndValue, reportBuilder.Report.Font.Size);
try
{
printPreview.FormTitle = reportBuilder.GetFieldByName(RPT_TITLE_FLD).Text;
}
catch
{}
reportBuilder.RefreshReport();
printPreview.Show();
//return table
return(dtbDataSource);
}
catch (Exception ex)
{
throw ex;
}
}
