对应年月的预算映射

         //对应年月的预算映射
                string[] budgetArray = new string[12];
                string[] actArray = new string[12];

                budgetArray[0] = vi.Rows[i][vi.Budget1Column.ColumnName].ToString();
                budgetArray[1] = vi.Rows[i][vi.Budget2Column.ColumnName].ToString();
                budgetArray[2] = vi.Rows[i][vi.Budget3Column.ColumnName].ToString();
                budgetArray[3] = vi.Rows[i][vi.Budget4Column.ColumnName].ToString();
                budgetArray[4] = vi.Rows[i][vi.Budget5Column.ColumnName].ToString();
                budgetArray[5] = vi.Rows[i][vi.Budget6Column.ColumnName].ToString();
                budgetArray[6] = vi.Rows[i][vi.Budget7Column.ColumnName].ToString();
                budgetArray[7] = vi.Rows[i][vi.Budget8Column.ColumnName].ToString();
                budgetArray[8] = vi.Rows[i][vi.Budget9Column.ColumnName].ToString();
                budgetArray[9] = vi.Rows[i][vi.Budget10Column.ColumnName].ToString();
                budgetArray[10] = vi.Rows[i][vi.Budget11Column.ColumnName].ToString();
                budgetArray[11] = vi.Rows[i][vi.Budget12Column.ColumnName].ToString();

                actArray[0] = vi.Rows[i][vi.Act1Column.ColumnName].ToString();
                actArray[1] = vi.Rows[i][vi.Act2Column.ColumnName].ToString();
                actArray[2] = vi.Rows[i][vi.Act3Column.ColumnName].ToString();
                actArray[3] = vi.Rows[i][vi.Act4Column.ColumnName].ToString();
                actArray[4] = vi.Rows[i][vi.Act5Column.ColumnName].ToString();
                actArray[5] = vi.Rows[i][vi.Act6Column.ColumnName].ToString();
                actArray[6] = vi.Rows[i][vi.Act7Column.ColumnName].ToString();
                actArray[7] = vi.Rows[i][vi.Act8Column.ColumnName].ToString();
                actArray[8] = vi.Rows[i][vi.Act9Column.ColumnName].ToString();
                actArray[9] = vi.Rows[i][vi.Act10Column.ColumnName].ToString();
                actArray[10] = vi.Rows[i][vi.Act11Column.ColumnName].ToString();
                actArray[11] = vi.Rows[i][vi.Act12Column.ColumnName].ToString();

   
for (int j = 0; j < 12; j++)  //每一个比较 有则修改 没有则添加
                {
                    bool isHas = false;
                    foreach (DS_ExpenseSale.t_ExpenseSaleRow sRow in dtExpenseSale)
                    {
                        string tempYM = sRow.SetDate.ToString("yyyy-M");

                        if (yearMonth[j] == tempYM
                            && sRow.ProductSeriesId.Equals(vi.Rows[i][vi.ProductSeriesIdColumn.ColumnName].ToString())
                            && sRow.ProductId.Equals(vi.Rows[i][vi.ProductIdColumn.ColumnName].ToString())
                            && sRow.IsNumber.ToString().Equals(vi.Rows[i][vi.IsNumberColumn.ColumnName].ToString())
                            )
                        {
                            if (budgetArray[j].Trim() != "")
                                sRow.Budget = Convert.ToDecimal(budgetArray[j]);

                            if (actArray[j].Trim() != "")
                                sRow.Act = Convert.ToDecimal(actArray[j]);

                            isHas = true;

                            break;
                        }

                    }

                    if (!isHas)
                    {
                        DS_ExpenseSale.t_ExpenseSaleRow newRow = dtExpenseSale.Newt_ExpenseSaleRow();

                        if (budgetArray[j].Trim() != "")
                            newRow.Budget = Convert.ToDecimal(budgetArray[j]);

                        if (actArray[j].Trim() != "")
                            newRow.Act = Convert.ToDecimal(actArray[j]);

                        newRow.CompanyId = CompanyId;
                        newRow.CreateDate = DateTime.Now;
                        newRow.Creator = "zcj";
                        newRow.Est = 0;
                        newRow.IsNumber = viRow.IsNumber;
                        newRow.PriceTypeId = viRow.PriceTypeId;
                        newRow.ProductId = viRow.ProductId;
                        newRow.ProductSeriesId = viRow.ProductSeriesId;
                        newRow.SetDate = Convert.ToDateTime(yearMonth[j].ToString());
                        newRow.SetYear = yearMonth[j].Substring(0, 4);
                        newRow.SetMonth = yearMonth[j].Substring(5);
                        newRow.Updator = "zcj";
                        newRow.UpdDate = DateTime.Now;

                        dtExpenseSale.Rows.Add(newRow);
                    }
                }