/// <summary>
/// Download installation list data by CSV
/// </summary>
/// <param name="result"></param>
public void CMS180_DownloadAsCSV() //(List<CMS180_SearchResultGridData> result) //Modify by Jutarat A. on 25062013
{
ObjectResultData res = new ObjectResultData();
try
{
//Modify by Jutarat A. on 25062013
//IInstallationHandler handler = ServiceContainer.GetService<IInstallationHandler>() as IInstallationHandler;
//doSearchInstallationCondition cond = new doSearchInstallationCondition();
//cond.slipNoNullFlag = true;
//List<dtInstallation> lst = new List<dtInstallation>();
//lst = handler.GetInstallationDataListForCsvFile(cond);
//List<CMS180_SearchResultGridData> resultGridData = CommonUtil.ClonsObjectList<dtInstallation, CMS180_SearchResultGridData>(lst);
//if (resultGridData.Count > 0)
CMS180_ScreenParameter sParam = GetScreenObject <CMS180_ScreenParameter>();
if (sParam.doResultCSVData != null && sParam.doResultCSVData.Count > 0)
{
string strCSVResultData = CSVReportUtil.GenerateCSVData <CMS180_SearchResultGridData>(sParam.doResultCSVData, true); //resultGridData
this.DownloadCSVFile("InstallationBasic.csv", strCSVResultData);
}
//End Modify
}
catch (Exception ex)
{
res.AddErrorMessage(ex);
}
}
//public string GetMaintenanceCheckupList(List<Object[]> MACheckupKey)
/// <summary>
/// To get CTR120 – Maintenance check-up list
/// </summary>
/// <param name="MACheckupList"></param>
/// <returns></returns>
public string GetMaintenanceCheckupList(List <tbt_MaintenanceCheckup> MACheckupList)
{
//List<tbt_MaintenanceCheckup> listMaintenanceCheckup;
List <dtGetMaintenanceCheckupList> listDTGetMaintenanceCheckupList;
//tbt_MaintenanceCheckup tbtMaintenanceCheckup;
string csv = "";
CommonUtil comUtil = new CommonUtil();
List <dtMACheckupCSVData> dtMACheckupCSVDataList = new List <dtMACheckupCSVData>();
try
{
//listMaintenanceCheckup = new List<tbt_MaintenanceCheckup>();
//tbtMaintenanceCheckup = new tbt_MaintenanceCheckup();
//tbtMaintenanceCheckup.ContractCode = MACheckupKey[0][0].ToString();
//tbtMaintenanceCheckup.ProductCode = MACheckupKey[0][1].ToString();
//tbtMaintenanceCheckup.InstructionDate = Convert.ToDateTime(MACheckupKey[0][2]);
//listMaintenanceCheckup.Add(tbtMaintenanceCheckup);
//listDTGetMaintenanceCheckupList = this.GetMaintenanceCheckupList(CommonUtil.ConvertToXml_Store<tbt_MaintenanceCheckup>(listMaintenanceCheckup), MACheckupKey[0][1].ToString(), Convert.ToDateTime(MACheckupKey[0][2]), ContractStatus.C_CONTRACT_STATUS_AFTER_START);
listDTGetMaintenanceCheckupList = this.GetMaintenanceCheckupList(CommonUtil.ConvertToXml_Store <tbt_MaintenanceCheckup>(MACheckupList));
//var sb = new StringBuilder();
//sb.Append(string.Format("OperationOfficeCode,ContractCode,UserCode,ProductCode,SiteNameEN,SiteNameLC,LastMaintenanceDate,InstructionDate,ExpectedMaintenanceDate") + Environment.NewLine);
//string strContractCodeShort = string.Empty;
//string strLastMaintenanceDate = string.Empty;
//string strInstructionDate = string.Empty;
//string strExpectedMaintenanceDate = string.Empty;
//foreach (var o in listDTGetMaintenanceCheckupList)
//{
// strContractCodeShort = comUtil.ConvertContractCode(o.ContractCode, CommonUtil.CONVERT_TYPE.TO_SHORT);
// strLastMaintenanceDate = o.LastMaintenanceDate == null ? string.Empty : o.LastMaintenanceDate.Value.ToShortDateString();
// strInstructionDate = o.InstructionDate.ToShortDateString();
// strExpectedMaintenanceDate = o.ExpectedMaintenanceDate == null ? string.Empty : o.ExpectedMaintenanceDate.Value.ToShortDateString();
// //sb.Append(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8}", o.OperationOfficeCode, o.ContractCode, o.UserCode, o.ProductCode, o.SiteNameEN, o.SiteNameLC, o.LastMaintenanceDate, o.InstructionDate, o.ExpectedMaintenanceDate) + Environment.NewLine);
// sb.Append(string.Format("{0},{1},{2},{3},\"{4}\",\"{5}\",{6},{7},{8}", o.OperationOfficeCode, strContractCodeShort, o.UserCode, o.ProductCode, o.SiteNameEN, o.SiteNameLC, strLastMaintenanceDate, strInstructionDate, strExpectedMaintenanceDate) + Environment.NewLine);
// csv = sb.ToString(0, sb.Length - 1);
//}
dtMACheckupCSVDataList = CommonUtil.ClonsObjectList <dtGetMaintenanceCheckupList, dtMACheckupCSVData>(listDTGetMaintenanceCheckupList);
csv = CSVReportUtil.GenerateCSVData <dtMACheckupCSVData>(dtMACheckupCSVDataList);
return(csv);
}
catch (Exception ex)
{
throw ex;
}
}
//public CsvActionResult CTS290_DownloadAsCSV_Test()
//{
// ObjectResultData res = new ObjectResultData();
// List<CTS290_SearchResultGridData> resultGridData;
// DataTable dtResultData = new DataTable();
// try
// {
// CTS290_ScreenParameter sParam = GetScreenObject<CTS290_ScreenParameter>();
// if (sParam == null)
// sParam = new CTS290_ScreenParameter();
// resultGridData = sParam.doSearchResultGridData;
// dtResultData = CommonUtil.ConvertDoListToDataTable<CTS290_SearchResultGridData>(resultGridData);
// return new CsvActionResult(dtResultData) { FileDownloadName = "NearlyExpiredWarrantySaleContract.csv" };
// }
// catch (Exception ex)
// {
// res.AddErrorMessage(ex);
// }
// return null;
//}
/// <summary>
/// Download the result list as CSV file when click [Download as CSV] button
/// </summary>
public void CTS290_DownloadAsCSV()
{
//string strHeader = CommonUtil.CsvHeaderGrid("Contract\\CTS290");
//string strData = string.Empty;
//CTS290_ScreenParameter sParam = GetScreenObject<CTS290_ScreenParameter>();
//if (sParam != null && sParam.doSearchResultGridData != null)
//{
// string strContractCodeAndOCC = string.Empty;
// string strSaleWarrantyPeriod = string.Empty;
// string strOfficeNameAndInChargeName = string.Empty;
// string strSiteCodeAndOptOfficeName = string.Empty;
// string strRealCustomerName = string.Empty;
// string strSiteName = string.Empty;
// string strSaleProductName = string.Empty;
// int iNo = 1;
// foreach(CTS290_SearchResultGridData data in sParam.doSearchResultGridData)
// {
// strContractCodeAndOCC = String.IsNullOrEmpty(data.ContractCodeAndOCC) ? string.Empty : String.Format("\"{0}\"", data.ContractCodeAndOCC.Replace("<br/>", ""));
// strSaleWarrantyPeriod = String.IsNullOrEmpty(data.SaleWarrantyPeriod) ? string.Empty : String.Format("\"{0}\"", data.SaleWarrantyPeriod.Replace("<br/>", ""));
// strOfficeNameAndInChargeName = String.IsNullOrEmpty(data.OfficeNameAndInChargeName) ? string.Empty : String.Format("\"{0}\"", data.OfficeNameAndInChargeName.Replace("<br/>", ""));
// strSiteCodeAndOptOfficeName = String.IsNullOrEmpty(data.SiteCodeAndOptOfficeName) ? string.Empty : String.Format("\"{0}\"", data.SiteCodeAndOptOfficeName.Replace("<br/>", ""));
// strRealCustomerName = String.IsNullOrEmpty(data.RealCustomerName) ? string.Empty : String.Format("\"{0}\"", data.RealCustomerName.Replace("<br/>", ""));
// strSiteName = String.IsNullOrEmpty(data.SiteName) ? string.Empty : String.Format("\"{0}\"", data.SiteName.Replace("<br/>", ""));
// strSaleProductName = String.IsNullOrEmpty(data.SaleProductName) ? string.Empty : String.Format("\"{0}\"", data.SaleProductName.Replace("<br/>", ""));
// strData = string.Format("{0}{1},{2},{3},{4},{5},{6},{7},{8}\n", strData, iNo, strContractCodeAndOCC, strSaleWarrantyPeriod, strOfficeNameAndInChargeName, strSiteCodeAndOptOfficeName, strRealCustomerName, strSiteName, strSaleProductName);
// iNo++;
// }
//}
//string strCSVResultData = String.Format("{0}\n{1}", strHeader, strData);
//Response.Clear();
//Response.AddHeader("Content-Disposition", "attachment; filename=NearlyExpiredWarrantySaleContract.csv");
//Response.ContentType = "text/csv"; //"application/force-download";
//Response.Charset = "windows-874";
//Response.ContentEncoding = System.Text.Encoding.GetEncoding(874); //System.Text.Encoding.GetEncoding("UTF-8");
//Response.Write(strCSVResultData);
//Response.End();
CTS290_ScreenParameter sParam = GetScreenObject <CTS290_ScreenParameter>();
List <CTS290_SearchResultCSVData> csvData = CommonUtil.ClonsObjectList <dtSearchSaleWarrantyExpireResult, CTS290_SearchResultCSVData>(sParam.dtSearchSaleWarrantyExpireResultData);
string strCSVResultData = CSVReportUtil.GenerateCSVData <CTS290_SearchResultCSVData>(csvData, false);
this.DownloadCSVFile("NearlyExpiredWarrantySaleContract.csv", strCSVResultData);
}
public doGenerateDocumentResult ACC002_AgingReport(DocumentContext context)
{
#region Prepare
doGenerateDocumentResult result = new doGenerateDocumentResult()
{
ErrorFlag = false,
Total = 0,
Complete = 0,
Failed = 0,
ResultDocumentNoList = string.Empty
};
#endregion
using (TransactionScope scope = new TransactionScope())
{
try
{
ICommonHandler comHand = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler;
List <doMiscTypeCode> tmpCurrencies = comHand.GetMiscTypeCodeList(new List <doMiscTypeCode>()
{
new doMiscTypeCode()
{
FieldName = MiscType.C_CURRENCT,
ValueCode = "%"
}
}).ToList();
#region Do process
//Get business date parameter
dtAccountingBusinessDateOfAgingReport businessDate = this.GetAccountingBusinessDateOfAgingReport(context.TargetPeriodTo).FirstOrDefault();
dtAccountingConfig folder = this.getAccountingConfig(AccountingConfig.C_ACC_CONFIG_GROUP_CSV, AccountingConfig.C_ACC_CONFIG_NAME_FOLDER);
#region Generate report
//Get account data
List <dtAccountDataOfAgingReport> accountData = this.GetAccountDataOfAgingReport(businessDate.TargetPeriod.Value, businessDate.LastEndDate.Value, context.UserHQCode);
if (accountData.Count == 0)
{
result.ErrorFlag = true;
result.ErrorCode = MessageUtil.MessageList.MSG8005;
return(result);
}
for (int i = 0; i < accountData.Count(); i++)
{
accountData[i].Currencies = new List <doMiscTypeCode>(tmpCurrencies);
}
#region Write text report
//Format: ..\YYYYMM\[CSV.Folder]\ACC002YYYYMMDDHQCD.csv
string textContent = CSVReportUtil.GenerateAccountingCSVData <dtAccountDataOfAgingReport>(accountData, true, true, "No.");
string documentNo = string.Format(@"{0}{1}{2}", context.DocumentCode, businessDate.TargetPeriod.Value.ToString("yyyyMMdd"), context.UserHQCode);
string outputfilepath = string.Format(@"{0}{1}\{2}\{3}.csv", businessDate.ReportYear, businessDate.ReportMonth, folder.ConfigValue, documentNo);
string fullOutputFilePath = PathUtil.GetPathValue(PathUtil.PathName.GeneratedReportPath, outputfilepath);
WriteCSVFile egWriteCSV = new WriteCSVFile();
egWriteCSV.IfExitDeleteFile(fullOutputFilePath);
using (StreamWriter sw = new StreamWriter(fullOutputFilePath, false, Encoding.GetEncoding("TIS-620")))
{
sw.WriteLine(textContent);
sw.Close();
}
#endregion
#region Keep daily genereated document
List <tbt_AccountingDocumentList> genComplete = new List <tbt_AccountingDocumentList>();
genComplete.Add(new tbt_AccountingDocumentList()
{
DocumentNo = documentNo,
DocumentCode = context.DocumentCode,
TargetPeriodFrom = businessDate.TargetPeriod.Value,
TargetPeriodTo = businessDate.TargetPeriod.Value,
GenerateHQCode = context.UserHQCode,
ReportMonth = Convert.ToInt32(businessDate.ReportMonth),
ReportYear = Convert.ToInt32(businessDate.ReportYear),
FilePath = outputfilepath,
CreateBy = CommonUtil.dsTransData.dtUserData.EmpNo,
CreateDate = DateTime.Now,
UpdateBy = CommonUtil.dsTransData.dtUserData.EmpNo,
UpdateDate = DateTime.Now
});
this.Insert_tbt_AccountingDocumentList(CommonUtil.ConvertToXml_Store <tbt_AccountingDocumentList>(genComplete));
#endregion
scope.Complete();
//Record info
result.Total += accountData.Count;
result.Complete = result.Total;
result.ResultDocumentNoList = documentNo;
return(result);
}
catch (Exception ex)
{
scope.Dispose();
throw;
}
#endregion
#endregion
}
}
/// <summary>
/// CSV Gen File by Common CallDownloadController and call download popup screen
/// </summary>
/// <returns></returns>
public void ICS101_ExportCSV()
{
ICS101_ScreenParameter param = GetScreenObject <ICS101_ScreenParameter>();
ICS101_RegisterData RegisterData = new ICS101_RegisterData();
CommonUtil comUtil = new CommonUtil();
IOfficeMasterHandler iOfficeMasterHandler = ServiceContainer.GetService <IOfficeMasterHandler>() as IOfficeMasterHandler;
List <tbm_Office> _dotbm_Office = new List <tbm_Office>();
// reuse param that send on Register Click
if (param != null)
{
RegisterData = param.RegisterData;
}
StringBuilder sbDateFromToData = new StringBuilder();
StringBuilder sbCollectionAreaHeader = new StringBuilder();
StringBuilder sbCollectionAreaDetails = new StringBuilder();
sbDateFromToData = CSVAddNewColumn(sbDateFromToData, "Expected Collect Date");
sbDateFromToData = CSVAddNewColumn(sbDateFromToData, CommonUtil.TextDate(RegisterData.Header.dtpExpectedCollectDateFrom));
sbDateFromToData = CSVAddNewColumn(sbDateFromToData, "to");
sbDateFromToData = CSVAddNewColumn(sbDateFromToData, CommonUtil.TextDate(RegisterData.Header.dtpExpectedCollectDateTo));
sbCollectionAreaHeader = CSVAddNewColumn(sbCollectionAreaHeader, "Collection Area");
if (RegisterData.Header.chklCollectionArea != null)
{
foreach (string CollectionArea in RegisterData.Header.chklCollectionArea)
{
_dotbm_Office = iOfficeMasterHandler.GetTbm_Office(CollectionArea);
if (_dotbm_Office != null)
{
if (_dotbm_Office.Count > 0)
{
sbCollectionAreaDetails = CSVAddNewColumn(sbCollectionAreaDetails, CollectionArea);
sbCollectionAreaDetails = CSVAddNewColumn(sbCollectionAreaDetails, _dotbm_Office[0].OfficeNameEN);
sbCollectionAreaDetails = CSVAddNewColumn(sbCollectionAreaDetails, _dotbm_Office[0].OfficeNameLC);
sbCollectionAreaDetails = CSVAddNewCRLF(sbCollectionAreaDetails);
}
}
}
}
string strCSVResultData = string.Empty;
strCSVResultData = String.Format("{0}{1}{2}{3}{4}{5}"
, sbDateFromToData.ToString(), Environment.NewLine
, sbCollectionAreaHeader.ToString(), Environment.NewLine
, sbCollectionAreaDetails.ToString(), Environment.NewLine);
if (RegisterData.doICS101_CSVGridData != null)
{
foreach (var d in RegisterData.doICS101_CSVGridData)
{
try
{
d.ReceiptAmount = Convert.ToDecimal(d.ReceiptAmount).ToString("0.00");
}
catch (Exception)
{
}
}
}
strCSVResultData = strCSVResultData + CSVReportUtil.GenerateCSVData <ICS101_CSVGridData>(RegisterData.doICS101_CSVGridData, true);
strCSVResultData = String.IsNullOrEmpty(strCSVResultData) ? string.Empty : strCSVResultData.Replace("<br/>", "").Replace("<BR/>", "");
this.DownloadCSVFile("MoneyCollectionManagementinfo.csv", strCSVResultData);
}
