/// <summary> /// 获取产品汇总费用分布 /// </summary> /// <param name="req"><see cref="DescribeBillSummaryByProductRequest"/></param> /// <returns><see cref="DescribeBillSummaryByProductResponse"/></returns> public DescribeBillSummaryByProductResponse DescribeBillSummaryByProductSync(DescribeBillSummaryByProductRequest req) { JsonResponseModel <DescribeBillSummaryByProductResponse> rsp = null; try { var strResp = this.InternalRequestSync(req, "DescribeBillSummaryByProduct"); rsp = JsonConvert.DeserializeObject <JsonResponseModel <DescribeBillSummaryByProductResponse> >(strResp); } catch (JsonSerializationException e) { throw new TencentCloudSDKException(e.Message); } return(rsp.Response); }
public void Test() { int createFileIndex = 1; string[] allFiles = Directory.GetFiles(path, "*.xlsx"); foreach (string strFile in allFiles) { File.Delete(strFile); } ListBoxItemAdd(this, this.listBox1, "프로그램 시작 합니다. ^_^"); foreach (int indexChecked in checkedListBox1.CheckedIndices) { String lineStr = tt[indexChecked].ToString(); Console.WriteLine(lineStr); try { string[] sArray = lineStr.Split(' '); if (sArray.Count() < 2) //작업완료 판단 { break; } Company = sArray[0]; UIN = sArray[1].Replace(" ", ""); SecretIdfromeFile = sArray[2].Replace(" ", ""); SecretKeyfromeFile = sArray[3].Replace(" ", ""); SecretKeyfromeFile = sArray[3].Replace(" ", ""); CVMRegion = sArray[4].Replace(" ", ""); BeginTime = dateTimePicker1.Value.ToString("yyyy-MM-01 00:00:00"); EndTime = dateTimePicker1.Value.ToString("yyyy-MM-01 00:00:01"); months = dateTimePicker1.Value.ToString("yyyy년MM월"); Console.WriteLine(Company); Console.WriteLine(UIN); Console.WriteLine(SecretIdfromeFile); Console.WriteLine(SecretKeyfromeFile); Console.WriteLine(BeginTime); Console.WriteLine(EndTime); Thread.Sleep(1000); ListBoxItemAdd(this, this.listBox1, "======<< 업체명 : " + Company + " >>====="); fileName = createFileIndex + "-" + Company + "-" + months + ".xlsx"; //파일생성 WriteExel(fileName, 1, 1, "TotalCost"); WriteExel("모든업체-" + months + ".xlsx", allCompanyIndex, 1, Company); Credential cred = new Credential { SecretId = SecretIdfromeFile, SecretKey = SecretKeyfromeFile }; ClientProfile clientProfile = new ClientProfile(); HttpProfile httpProfile = new HttpProfile(); httpProfile.Endpoint = ("billing.tencentcloudapi.com"); clientProfile.HttpProfile = httpProfile; BillingClient client = new BillingClient(cred, CVMRegion, clientProfile); DescribeBillSummaryByProductRequest req = new DescribeBillSummaryByProductRequest(); string strParams = "{\"PayerUin\":\"" + UIN + "\",\"BeginTime\":\"" + BeginTime + "\",\"EndTime\":\"" + EndTime + "\"}"; req = DescribeBillSummaryByProductRequest.FromJsonString <DescribeBillSummaryByProductRequest>(strParams); DescribeBillSummaryByProductResponse resp = client.DescribeBillSummaryByProduct(req).ConfigureAwait(false).GetAwaiter().GetResult(); // Console.WriteLine(AbstractModel.ToJsonString(resp)); String ttt = AbstractModel.ToJsonString(resp); String total = GetSummaryTotal(ttt); WriteExel(fileName, 1, 2, total); WriteExel("모든업체-" + months + ".xlsx", allCompanyIndex, 2, total); allCompanyIndex++; ListBoxItemAdd(this, this.listBox1, "Total : =》 " + total); Dictionary <string, string> Overview = GetSummaryOverview(ttt); exelIndex = 2; foreach (var item in Overview) { Console.WriteLine(item.Key + item.Value); WriteExel(fileName, exelIndex, 1, item.Key); WriteExel(fileName, exelIndex, 2, item.Value); exelIndex++; ListBoxItemAdd(this, this.listBox1, item.Key + " ---> " + item.Value); } createFileIndex++; Thread.Sleep(100); } catch (Exception e) { //WriteExel(fileName, exelIndex, 1, Company); WriteExel("모든업체-" + months + ".xlsx", allCompanyIndex, 2, "에러"); createFileIndex++; ListBoxItemAdd(this, this.listBox1, "<< 업체명 : " + Company + " >> 요금 실패~~"); } ListBoxItemAdd(this, this.listBox1, " "); ListBoxItemAdd(this, this.listBox1, " "); } }