public void CMW030_DownloadBLR060CsvReport(DateTime?GenerateDateFrom, DateTime?GenerateDateTo) { ObjectResultData res = new ObjectResultData(); IBillingHandler billingHandler = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler; var datas = billingHandler.GetRptInvoiceIssueList(GenerateDateFrom, GenerateDateTo); MemoryStream csv = CSVCreator.CreateCSVSteam <doGetRptInvoiceIssueList>(datas, "Common\\CMS030_BLR060Csv"); string fName = string.Format("{0}BLR060_{1}-{2}.csv" , DateTime.Now.ToString("yyyyMM"), GenerateDateFrom.Value.ToString("yyyyMMdd"), GenerateDateTo.Value.ToString("yyyyMMdd")); this.DownloadCSVFile(fName, csv.ToArray()); }
/// <summary> /// Get searach result of document data /// </summary> /// <param name="cond"></param> /// <returns></returns> public ActionResult CMS030_SearchResponse(doDocumentDataCondition cond) { CommonUtil c = new CommonUtil(); ObjectResultData res = new ObjectResultData(); res.MessageType = MessageModel.MESSAGE_TYPE.WARNING; List <dtDocumentData> list = new List <dtDocumentData>(); //List<dtDocumentData> vw_list = new List<dtDocumentData>(); try { cond.QuotationTargetCode = c.ConvertQuotationTargetCode(cond.QuotationTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG); //cond.ProjectCode = c.ConvertProjectCode(cond.ProjectCode, CommonUtil.CONVERT_TYPE.TO_LONG); cond.ContractCode = c.ConvertContractCode(cond.ContractCode, CommonUtil.CONVERT_TYPE.TO_LONG); cond.BillingTargetCode = c.ConvertBillingTargetCode(cond.BillingTargetCode, CommonUtil.CONVERT_TYPE.TO_LONG); if (cond.DocumentType == DocumentType.C_DOCUMENT_TYPE_CONTRACT) { cond.DocumentNo = ConvertDocumentNo(cond.DocumentNo, CommonUtil.CONVERT_TYPE.TO_LONG.ToString()); } if (cond.DocumentType == DocumentType.C_DOCUMENT_TYPE_INCOME) { if (cond.DocumentCode == "BLR060") { List <string> fieldName = new List <string>(); List <string> controlName = new List <string>(); List <string> realFieldName = new List <string>(); if (CommonUtil.IsNullOrEmpty(cond.GenerateDateFrom)) { fieldName.Add("lblGenerateDate"); controlName.Add("GenerateDateFrom"); } if (CommonUtil.IsNullOrEmpty(cond.GenerateDateTo)) { fieldName.Add("lblGenerateDate"); controlName.Add("GenerateDateTo"); } foreach (var rawFieldName in fieldName.Distinct()) { realFieldName.Add(CommonUtil.GetLabelFromResource(MessageUtil.MODULE_COMMON, "CMS030", rawFieldName)); } if ((realFieldName.Count > 0) || (controlName.Count > 0)) { if ((realFieldName.Count > 0) && (controlName.Count > 0)) { res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0007, realFieldName.ToArray(), controlName.ToArray()); } res.MessageType = MessageModel.MESSAGE_TYPE.WARNING; return(Json(res)); } } } if (cond.DocumentType == null || cond.DocumentCode == null) { //res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0098); } else { ICommonHandler handlerCommon = ServiceContainer.GetService <ICommonHandler>() as ICommonHandler; IDocumentHandler handler = ServiceContainer.GetService <IDocumentHandler>() as IDocumentHandler; list = handler.GetDocumentDataList(cond); //vw_list = CommonUtil.ConvertObjectbyLanguage<dtDocumentData, dtDocumentData>(list, // "ConOfficeCodeName", // "OperOfficeCodeName", // "BillOfficeCodeName", // "IssueOfficeCodeName", // "DocumentName" // ); // Misc Mapping MiscTypeMappingList miscMapping = new MiscTypeMappingList(); miscMapping.AddMiscType(list.ToArray()); handlerCommon.MiscTypeMappingList(miscMapping); // Language Mapping CommonUtil.MappingObjectLanguage <dtDocumentData>(list); if (cond.DocumentType == DocumentType.C_DOCUMENT_TYPE_CONTRACT) { foreach (var item in list) { item.DocumentNo = ConvertDocumentNo(item.DocumentNo, CommonUtil.CONVERT_TYPE.TO_SHORT.ToString()); } } } } catch (Exception ex) { list = new List <dtDocumentData>(); res.MessageType = MessageModel.MESSAGE_TYPE.INFORMATION; res.AddErrorMessage(ex); } if (cond.Mode == 0) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 1) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030_Mode1", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 2) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030_Mode2", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 3) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030_Mode3", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 4) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030_Mode4", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 5) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030_Mode5", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 6) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030_Mode6", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 7) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030_Mode7_CMR020", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 8) { res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(list, "Common\\CMS030_Mode8", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } else if (cond.Mode == 9) { IBillingHandler billingHandler = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler; var datas = billingHandler.GetRptInvoiceIssueList(cond.GenerateDateFrom, cond.GenerateDateTo); List <dtDocumentData> ls = new List <dtDocumentData>(); if (datas != null && datas.Count > 0) { ls.Add(new dtDocumentData() { GenerateDateFrom = cond.GenerateDateFrom, GenerateDateTo = cond.GenerateDateTo }); } res.ResultData = CommonUtil.ConvertToXml <dtDocumentData>(ls, "Common\\CMS030_Mode9", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } return(Json(res)); }