예제 #1
0
        public List <CInvStatData> CreateMonthlyStat(int nYear, int nMonth, int nPeriod)
        {
            List <CInvStatData> list = new List <CInvStatData>();

            try
            {
                TaxStatisData data = this.taxCard.GetMonthStatistics(nYear, nMonth, nPeriod);
                if (data == null)
                {
                    return(null);
                }
                if (this.taxCard.get_RetCode() != 0)
                {
                    MessageBoxHelper.Show(MessageManager.GetMessageInfo(this.taxCard.get_ErrCode()));
                    return(null);
                }
                List <string> list2 = new List <string> {
                    "销项正废金额", "销项正数金额", "销项负废金额", "销项负数金额", "实际销售金额", "销项正废税额", "销项正数税额", "销项负废税额", "销项负数税额", "实际销项税额"
                };
                for (int i = 0; i < data.get_Count(); i++)
                {
                    InvAmountTaxStati stati = data.get_Item(i);
                    if (stati != null)
                    {
                        List <List <string> > list3 = new List <List <string> >();
                        if (stati.get_InvTypeStr().Length > 0)
                        {
                            List <string> list5;
                            List <string> list4 = new List <string> {
                                stati.PeriodEarlyStockNum.ToString(),
                                          stati.BuyNum.ToString(),
                                          stati.ReturnInvNum.ToString(),
                                          stati.PlusInvoiceNum.ToString(),
                                          stati.PlusInvWasteNum.ToString(),
                                          stati.PeriodEndStockNum.ToString(),
                                          stati.NegativeInvoiceNum.ToString(),
                                          stati.NegativeInvWasteNum.ToString()
                            };
                            if (this.bIsMainMachine && this.bHasChild)
                            {
                                list4.Add(stati.AllotInvNum.ToString());
                                list4.Add(stati.ReclaimStockNum.ToString());
                            }
                            list5 = new List <string> {
                                stati.get_Total().XXZFJE.ToString("0.00"),
                                stati.get_TaxClass17().XXZFJE.ToString("0.00"),
                                stati.get_TaxClass13().XXZFJE.ToString("0.00"),
                                stati.get_TaxClass6().XXZFJE.ToString("0.00"),
                                stati.get_TaxClass4().XXZFJE.ToString("0.00"),
                                stati.get_TaxClassOther().XXZFJE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().XXZSJE.ToString("0.00"),
                                stati.get_TaxClass17().XXZSJE.ToString("0.00"),
                                stati.get_TaxClass13().XXZSJE.ToString("0.00"),
                                stati.get_TaxClass6().XXZSJE.ToString("0.00"),
                                stati.get_TaxClass4().XXZSJE.ToString("0.00"),
                                stati.get_TaxClassOther().XXZSJE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().XXFFJE.ToString("0.00"),
                                stati.get_TaxClass17().XXFFJE.ToString("0.00"),
                                stati.get_TaxClass13().XXFFJE.ToString("0.00"),
                                stati.get_TaxClass6().XXFFJE.ToString("0.00"),
                                stati.get_TaxClass4().XXFFJE.ToString("0.00"),
                                stati.get_TaxClassOther().XXFFJE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().XXFSJE.ToString("0.00"),
                                stati.get_TaxClass17().XXFSJE.ToString("0.00"),
                                stati.get_TaxClass13().XXFSJE.ToString("0.00"),
                                stati.get_TaxClass6().XXFSJE.ToString("0.00"),
                                stati.get_TaxClass4().XXFSJE.ToString("0.00"),
                                stati.get_TaxClassOther().XXFSJE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().SJXSJE.ToString("0.00"),
                                stati.get_TaxClass17().SJXSJE.ToString("0.00"),
                                stati.get_TaxClass13().SJXSJE.ToString("0.00"),
                                stati.get_TaxClass6().SJXSJE.ToString("0.00"),
                                stati.get_TaxClass4().SJXSJE.ToString("0.00"),
                                stati.get_TaxClassOther().SJXSJE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().XXZFSE.ToString("0.00"),
                                stati.get_TaxClass17().XXZFSE.ToString("0.00"),
                                stati.get_TaxClass13().XXZFSE.ToString("0.00"),
                                stati.get_TaxClass6().XXZFSE.ToString("0.00"),
                                stati.get_TaxClass4().XXZFSE.ToString("0.00"),
                                stati.get_TaxClassOther().XXZFSE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().XXZSSE.ToString("0.00"),
                                stati.get_TaxClass17().XXZSSE.ToString("0.00"),
                                stati.get_TaxClass13().XXZSSE.ToString("0.00"),
                                stati.get_TaxClass6().XXZSSE.ToString("0.00"),
                                stati.get_TaxClass4().XXZSSE.ToString("0.00"),
                                stati.get_TaxClassOther().XXZSSE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().XXFFSE.ToString("0.00"),
                                stati.get_TaxClass17().XXFFSE.ToString("0.00"),
                                stati.get_TaxClass13().XXFFSE.ToString("0.00"),
                                stati.get_TaxClass6().XXFFSE.ToString("0.00"),
                                stati.get_TaxClass4().XXFFSE.ToString("0.00"),
                                stati.get_TaxClassOther().XXFFSE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().XXFSSE.ToString("0.00"),
                                stati.get_TaxClass17().XXFSSE.ToString("0.00"),
                                stati.get_TaxClass13().XXFSSE.ToString("0.00"),
                                stati.get_TaxClass6().XXFSSE.ToString("0.00"),
                                stati.get_TaxClass4().XXFSSE.ToString("0.00"),
                                stati.get_TaxClassOther().XXFSSE.ToString("0.00"),
                                list5
                            };
                            list5 = new List <string> {
                                stati.get_Total().SJXXSE.ToString("0.00"),
                                stati.get_TaxClass17().SJXXSE.ToString("0.00"),
                                stati.get_TaxClass13().SJXXSE.ToString("0.00"),
                                stati.get_TaxClass6().SJXXSE.ToString("0.00"),
                                stati.get_TaxClass4().SJXXSE.ToString("0.00"),
                                stati.get_TaxClassOther().SJXXSE.ToString("0.00"),
                                list5
                            };
                            if (list3.Count == list2.Count)
                            {
                                DataTable table = new DataTable();
                                table.Columns.Add("项目名称");
                                table.Columns.Add("合计");
                                table.Columns.Add("17%");
                                table.Columns.Add("13%");
                                table.Columns.Add("6%");
                                table.Columns.Add("4%");
                                table.Columns.Add("其他");
                                for (int j = 0; j < list2.Count; j++)
                                {
                                    List <object> list6 = new List <object> {
                                        list2[j]
                                    };
                                    object[] objArray = list3[j].ToArray();
                                    for (int k = 1; k < table.Columns.Count; k++)
                                    {
                                        list6.Add(objArray[k - 1]);
                                    }
                                    object[] values = list6.ToArray();
                                    table.Rows.Add(values);
                                }
                                CInvStatData item = new CInvStatData {
                                    m_strInvTypeName = stati.get_InvTypeStr(),
                                    m_strHeadValue   = list4.ToArray(),
                                    m_DataTableGrid  = table
                                };
                                list.Add(item);
                            }
                        }
                    }
                }
            }
            catch (Exception exception)
            {
                this.loger.Info(exception.Message);
                ExceptionHandler.HandleError(exception);
            }
            return(list);
        }
예제 #2
0
 public void CreateMonthlyDataGrid(ref CustomStyleDataGrid dataGridView, int nYear, int nMonth, int nPeriod, INV_TYPE InvType)
 {
     try
     {
         dataGridView.ReadOnly           = true;
         dataGridView.AllowUserToAddRows = false;
         DataTable table = new DataTable();
         table.Columns.Add("项目名称");
         table.Columns.Add("合计");
         table.Columns.Add("17%");
         table.Columns.Add("13%");
         table.Columns.Add("6%");
         table.Columns.Add("4%");
         table.Columns.Add("其他");
         TaxStatisData data = this.taxCard.GetMonthStatistics(nYear, nMonth, nPeriod);
         if (data != null)
         {
             List <string>         item  = new List <string>();
             List <List <string> > list2 = new List <List <string> >();
             List <string>         list3 = new List <string> {
                 "销项正废金额", "销项正数金额", "销项负废金额", "销项负数金额", "实际销售金额", "销项正废税额", "销项正数税额", "销项负废税额", "销项负数税额", "实际销项税额"
             };
             for (int i = 0; i < data.get_Count(); i++)
             {
                 InvAmountTaxStati stati = data.get_Item(i);
                 if (stati == null)
                 {
                     return;
                 }
                 if ((stati.get_InvTypeStr().Length > 0) && (stati.get_InvTypeStr().Trim() == InvTypeEntity.GetInvName(InvType)))
                 {
                     item.Add(stati.get_Total().XXZFJE.ToString("0.00"));
                     item.Add(stati.get_TaxClass17().XXZFJE.ToString("0.00"));
                     item.Add(stati.get_TaxClass13().XXZFJE.ToString("0.00"));
                     item.Add(stati.get_TaxClass6().XXZFJE.ToString("0.00"));
                     item.Add(stati.get_TaxClass4().XXZFJE.ToString("0.00"));
                     item.Add(stati.get_TaxClassOther().XXZFJE.ToString("0.00"));
                     list2.Add(item);
                     item = new List <string> {
                         stati.get_Total().XXZSJE.ToString("0.00"),
                         stati.get_TaxClass17().XXZSJE.ToString("0.00"),
                         stati.get_TaxClass13().XXZSJE.ToString("0.00"),
                         stati.get_TaxClass6().XXZSJE.ToString("0.00"),
                         stati.get_TaxClass4().XXZSJE.ToString("0.00"),
                         stati.get_TaxClassOther().XXZSJE.ToString("0.00"),
                         item
                     };
                     item = new List <string> {
                         stati.get_Total().XXFFJE.ToString("0.00"),
                         stati.get_TaxClass17().XXFFJE.ToString("0.00"),
                         stati.get_TaxClass13().XXFFJE.ToString("0.00"),
                         stati.get_TaxClass6().XXFFJE.ToString("0.00"),
                         stati.get_TaxClass4().XXFFJE.ToString("0.00"),
                         stati.get_TaxClassOther().XXFFJE.ToString("0.00"),
                         item
                     };
                     item = new List <string> {
                         stati.get_Total().XXFSJE.ToString("0.00"),
                         stati.get_TaxClass17().XXFSJE.ToString("0.00"),
                         stati.get_TaxClass13().XXFSJE.ToString("0.00"),
                         stati.get_TaxClass6().XXFSJE.ToString("0.00"),
                         stati.get_TaxClass4().XXFSJE.ToString("0.00"),
                         stati.get_TaxClassOther().XXFSJE.ToString("0.00"),
                         item
                     };
                     item = new List <string> {
                         stati.get_Total().SJXSJE.ToString("0.00"),
                         stati.get_TaxClass17().SJXSJE.ToString("0.00"),
                         stati.get_TaxClass13().SJXSJE.ToString("0.00"),
                         stati.get_TaxClass6().SJXSJE.ToString("0.00"),
                         stati.get_TaxClass4().SJXSJE.ToString("0.00"),
                         stati.get_TaxClassOther().SJXSJE.ToString("0.00"),
                         item
                     };
                     item = new List <string> {
                         stati.get_Total().XXZFSE.ToString("0.00"),
                         stati.get_TaxClass17().XXZFSE.ToString("0.00"),
                         stati.get_TaxClass13().XXZFSE.ToString("0.00"),
                         stati.get_TaxClass6().XXZFSE.ToString("0.00"),
                         stati.get_TaxClass4().XXZFSE.ToString("0.00"),
                         stati.get_TaxClassOther().XXZFSE.ToString("0.00"),
                         item
                     };
                     item = new List <string> {
                         stati.get_Total().XXZSSE.ToString("0.00"),
                         stati.get_TaxClass17().XXZSSE.ToString("0.00"),
                         stati.get_TaxClass13().XXZSSE.ToString("0.00"),
                         stati.get_TaxClass6().XXZSSE.ToString("0.00"),
                         stati.get_TaxClass4().XXZSSE.ToString("0.00"),
                         stati.get_TaxClassOther().XXZSSE.ToString("0.00"),
                         item
                     };
                     item = new List <string> {
                         stati.get_Total().XXFFSE.ToString("0.00"),
                         stati.get_TaxClass17().XXFFSE.ToString("0.00"),
                         stati.get_TaxClass13().XXFFSE.ToString("0.00"),
                         stati.get_TaxClass6().XXFFSE.ToString("0.00"),
                         stati.get_TaxClass4().XXFFSE.ToString("0.00"),
                         stati.get_TaxClassOther().XXFFSE.ToString("0.00"),
                         item
                     };
                     item = new List <string> {
                         stati.get_Total().XXFSSE.ToString("0.00"),
                         stati.get_TaxClass17().XXFSSE.ToString("0.00"),
                         stati.get_TaxClass13().XXFSSE.ToString("0.00"),
                         stati.get_TaxClass6().XXFSSE.ToString("0.00"),
                         stati.get_TaxClass4().XXFSSE.ToString("0.00"),
                         stati.get_TaxClassOther().XXFSSE.ToString("0.00"),
                         item
                     };
                     item = new List <string> {
                         stati.get_Total().SJXXSE.ToString("0.00"),
                         stati.get_TaxClass17().SJXXSE.ToString("0.00"),
                         stati.get_TaxClass13().SJXXSE.ToString("0.00"),
                         stati.get_TaxClass6().SJXXSE.ToString("0.00"),
                         stati.get_TaxClass4().SJXXSE.ToString("0.00"),
                         stati.get_TaxClassOther().SJXXSE.ToString("0.00"),
                         item
                     };
                 }
             }
             if (dataGridView.Rows.Count > 0)
             {
                 int count = dataGridView.Rows.Count;
                 while (count-- > 0)
                 {
                     dataGridView.Rows.RemoveAt(0);
                 }
             }
             if (list2.Count != list3.Count)
             {
                 MessageManager.ShowMsgBox("INP-253107", new string[] { "资料统计出错" });
             }
             else
             {
                 for (int j = 0; j < list3.Count; j++)
                 {
                     List <object> list4 = new List <object> {
                         list3[j]
                     };
                     object[] objArray = list2[j].ToArray();
                     for (int m = 1; m < table.Columns.Count; m++)
                     {
                         list4.Add(objArray[m - 1]);
                     }
                     object[] values = list4.ToArray();
                     table.Rows.Add(values);
                 }
                 dataGridView.DataSource = table;
                 for (int k = 0; k < dataGridView.Columns.Count; k++)
                 {
                     dataGridView.Columns[k].SortMode = DataGridViewColumnSortMode.NotSortable;
                 }
             }
         }
     }
     catch (Exception exception)
     {
         this.loger.Info(exception.Message);
         ExceptionHandler.HandleError(exception);
     }
 }