Esempio n. 1
0
        void ModifyLeaseItem()
        {
            LeaseItems tLeaseItems = new LeaseItems();

            tLeaseItems       = BLL.LeaseBLL.GetLeaseItem(i_ItemsID);
            tLeaseItems.MName = textBoxMName.Text;
            if (radioButton1.Checked)
            {
                tLeaseItems.LeaseClass = 0;
            }
            else
            {
                tLeaseItems.LeaseClass = 1;
            }
            tLeaseItems.LeaseUnit     = textBoxLeaseUnit.Text;
            tLeaseItems.LeasePrice    = Convert.ToDecimal(textBoxLeasePrice.Text);
            tLeaseItems.LoadingUnit   = textBoxLoadingUnit.Text;
            tLeaseItems.LoadingFactor = Convert.ToDecimal(textBoxLoadingFactor.Text);
            tLeaseItems.LoadingPrice  = Convert.ToDecimal(textBoxLoadingPrice.Text);
            tLeaseItems.RepairUnit    = textBoxRepairUnit.Text;
            tLeaseItems.RepairFactor  = Convert.ToDecimal(textBoxRepairFactor.Text);
            tLeaseItems.RepairPrice   = Convert.ToDecimal(textBoxRepairPrice.Text);

            BLL.LeaseBLL.ModifyLeaseItem(tLeaseItems);
        }
Esempio n. 2
0
        void FormLeaseRecord1Load(object sender, EventArgs e)
        {
            //填充租赁项

            ds1 = BLL.LeaseBLL.GetLeaseItemsByHTID(i_HTID);
            comboBoxItemsName.DataSource    = ds1.Tables[0];
            comboBoxItemsName.ValueMember   = "ItemsID";
            comboBoxItemsName.DisplayMember = "MName";
            if (this.Text == "租赁记录-新增")
            {
            }
            else
            {
                LeaseRecord tRI = BLL.LeaseBLL.GetLeaseRecord(i_RID);
                LeaseItems  tI  = BLL.LeaseBLL.GetLeaseItem(tRI.ItemsID);
                comboBoxItemsName.SelectedValue = tI.ItemsID;
                textBoxLeaseUnit.Text           = tI.LeaseUnit;
                dateTimePickerLeaseDate.Value   = tRI.LeaseDate;
                textBoxQuality.Text             = tRI.Quality.ToString();
                textBoxHandler.Text             = tRI.Handler;
                textBoxAbstract.Text            = tRI.Abstract;
            }

            bindingFlag = true;
        }
Esempio n. 3
0
        // 修改租赁项信息
        public static void ModifyLeaseItem(LeaseItems tLeaseItem)
        {
            ISession session = NHibernateHelper.OpenSession();

            try {
                ITransaction tx = session.BeginTransaction();
                LeaseItems   t1 = session.Get <LeaseItems>(tLeaseItem.ItemsID);
                t1.HTID            = tLeaseItem.HTID;
                t1.MName           = tLeaseItem.MName;
                t1.LeaseClass      = tLeaseItem.LeaseClass;
                t1.LeaseUnit       = tLeaseItem.LeaseUnit;
                t1.LeasePrice      = tLeaseItem.LeasePrice;
                t1.LoadingUnit     = tLeaseItem.LoadingUnit;
                t1.LoadingFactor   = tLeaseItem.LoadingFactor;
                t1.LoadingPrice    = tLeaseItem.LoadingPrice;
                t1.RepairUnit      = tLeaseItem.RepairUnit;
                t1.RepairFactor    = tLeaseItem.RepairFactor;
                t1.RepairPrice     = tLeaseItem.RepairPrice;
                t1.BalanceDate     = tLeaseItem.BalanceDate;
                t1.CurLeaseQuality = tLeaseItem.CurLeaseQuality;

                tx.Commit();
            } catch (Exception e) {
                Debug.Assert(false, e.Message);
            }
            session.Close();
        }
Esempio n. 4
0
 void FormLeaseItemLoad(object sender, EventArgs e)
 {
     textBoxItemsID.Text = i_ItemsID.ToString();
     textBoxHTID.Text    = i_HTID.ToString();
     if (this.Text == "租赁项信息-修改")
     {
         LeaseItems tLeaseItem = BLL.LeaseBLL.GetLeaseItem(i_ItemsID);
         textBoxMName.Text = tLeaseItem.MName;
         if (tLeaseItem.LeaseClass == 0)
         {
             radioButton1.Checked = true;
         }
         else
         {
             radioButton2.Checked = true;
         }
         textBoxLeaseUnit.Text     = tLeaseItem.LeaseUnit;
         textBoxLeasePrice.Text    = tLeaseItem.LeasePrice.ToString();
         textBoxLoadingUnit.Text   = tLeaseItem.LoadingUnit;
         textBoxLoadingFactor.Text = tLeaseItem.LoadingFactor.ToString();
         textBoxLoadingPrice.Text  = tLeaseItem.LoadingPrice.ToString();
         textBoxRepairUnit.Text    = tLeaseItem.RepairUnit;
         textBoxRepairFactor.Text  = tLeaseItem.RepairFactor.ToString();
         textBoxRepairPrice.Text   = tLeaseItem.RepairPrice.ToString();
     }
 }
Esempio n. 5
0
 void ComboBoxItemsNameSelectedIndexChanged(object sender, EventArgs e)
 {
     if (bindingFlag && Convert.ToInt32(comboBoxItemsName.SelectedValue) > 0)
     {
         //选择了
         LeaseItems tI = BLL.LeaseBLL.GetLeaseItem(Convert.ToInt32(comboBoxItemsName.SelectedValue));
         textBoxLeaseUnit.Text = tI.LeaseUnit;
     }
 }
Esempio n. 6
0
        //获取指定的租赁项信息
        public static LeaseItems GetLeaseItem(int i_ItemsID)
        {
            ISession   session = NHibernateHelper.OpenSession();
            LeaseItems tClass  = new LeaseItems();

            try {
                tClass = session.Get <LeaseItems>(i_ItemsID);
            } catch (Exception e) {
                Debug.Assert(false, e.Message);
            }
            session.Close();
            return(tClass);
        }
Esempio n. 7
0
        //添加租赁项信息
        public static void AddLeaseItem(LeaseItems tLeaseItem)
        {
            //ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory();
            ISession     session = NHibernateHelper.sessionFactory.OpenSession();
            ITransaction tx      = session.BeginTransaction();

            try {
                session.Save(tLeaseItem);
                tx.Commit();
                session.Close();
            } catch (Exception e) {
                Debug.Assert(false, e.Message);
                tx.Rollback();
                session.Close();
            }
        }
Esempio n. 8
0
        //删除
        public static void DelLeaseItem(int i_LeaseItem)
        {
            //ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory();
            ISession     session  = NHibernateHelper.OpenSession();
            ITransaction tx       = session.BeginTransaction();
            LeaseItems   toDelete = session.Get <LeaseItems>(i_LeaseItem);

            try {
                session.Delete(toDelete);
                tx.Commit();
                session.Close();
            } catch (Exception e) {
                Debug.Assert(false, e.Message);
                tx.Rollback();
                session.Close();
            }
        }
Esempio n. 9
0
        //添加租赁结算
        public static void AddNewLeaseJS(int i_ProjectID, int i_CompanyID, string s_BillCycle, DateTime d_SDate, DateTime d_EDate, ToolStripLabel labelStatus)
        {
            labelStatus.Text = "现在开始把数据添加到数据库中...";
            Application.DoEvents();
            string[,] ALeaseAccountLeft = new string[50, 2];                    //用于保存当前剩余租赁材料

            ISession     session = NHibernateHelper.sessionFactory.OpenSession();
            ITransaction tx      = session.BeginTransaction();

            try {
                int i_SNumber = 1;                              //租赁结算顺序号

                //1.先添加租赁结算单,以得到BillID
                labelStatus.Text = "现在开始添加租赁结算单...";
                Application.DoEvents();

                Projects  tProject       = BLL.ProjectsBLL.GetProject(i_ProjectID);
                Companies tCompany       = BLL.CompanyBLL.GetCompany(i_CompanyID);
                LeaseHT   tLeaseHT       = BLL.LeaseBLL.GetLeaseHT(i_ProjectID, i_CompanyID);
                int       i_IncludeSDate = tLeaseHT.IncludeSDate;       //租金包含开始日
                int       i_IncludeEDate = tLeaseHT.IncludeEDate;       //租金包含结束日
                string    s_CalMethod    = "";                          //计算方式
                if (i_IncludeSDate == 0 && i_IncludeEDate == 0)
                {
                    s_CalMethod = "倒扣计算法,头尾都不算";
                }
                if (i_IncludeSDate == 1 && i_IncludeEDate == 0)
                {
                    s_CalMethod = "倒扣计算法,算头不算尾";
                }
                if (i_IncludeSDate == 1 && i_IncludeEDate == 1)
                {
                    s_CalMethod = "倒扣计算法,既算头又算尾";
                }
                if (i_IncludeSDate == 0 && i_IncludeEDate == 1)
                {
                    s_CalMethod = "倒扣计算法,算尾不算头";
                }
                TimeSpan tTS    = d_EDate.Subtract(d_SDate);
                int      i_Days = tTS.Days + 1;                         //结余时租赁天数

                LeaseAccount newLeaseAccount = new LeaseAccount();
                newLeaseAccount.ProjectID    = i_ProjectID;
                newLeaseAccount.CompanyID    = i_CompanyID;
                newLeaseAccount.BillCycle    = s_BillCycle;
                newLeaseAccount.SDate        = d_SDate;
                newLeaseAccount.EDate        = d_EDate;
                newLeaseAccount.CalMethod    = s_CalMethod;
                newLeaseAccount.ProjectName  = tProject.ProjectName;
                newLeaseAccount.CompanyName  = tCompany.CompanyName;
                newLeaseAccount.IncludeSDate = i_IncludeSDate;
                newLeaseAccount.IncludeEDate = i_IncludeEDate;
                session.Save(newLeaseAccount);

                StatementList newStatementList = new StatementList();
                newStatementList.ProjectID      = i_ProjectID;
                newStatementList.ProjectName    = tProject.ProjectName;
                newStatementList.CompanyID      = i_CompanyID;
                newStatementList.CompanyName    = tCompany.CompanyName;
                newStatementList.MoneyTypeID    = 10000;
                newStatementList.MoneyTypeName  = "租赁结算自动生成";
                newStatementList.StatementType  = "租赁结算";
                newStatementList.StatementMemo  = "应付租金";
                newStatementList.StatementCycle = s_BillCycle;
                newStatementList.StatementDate  = DateTime.Now.Date;
                session.Save(newStatementList);

                decimal d_BillAmt = 0.0m;
                //2.添加租赁明细单,并计算金额合计,以便完成后填写到LeaseAccount表记录中
                //把保存剩余租赁量的数组数据填好,全部是字符串
                DataSet dsTmp = BLL.LeaseBLL.GetLeaseAccountLeft(tLeaseHT.HTID);
                foreach (DataRow dr in dsTmp.Tables[0].Rows)
                {
                    string s_0 = dr["ItemsID"].ToString();
                    string s_1 = dr["QualityLeft"].ToString();

                    for (int j = 0; j < ALeaseAccountLeft.GetLength(0); j++)
                    {
                        string s0 = ALeaseAccountLeft[j, 0];
                        string s1 = ALeaseAccountLeft[j, 1];
                        if (ALeaseAccountLeft[j, 0] == null)
                        {
                            ALeaseAccountLeft[j, 0] = s_0;
                            ALeaseAccountLeft[j, 1] = s_1;
                            break;
                        }
                    }
                }
                //2.1添加结余租赁明细项目
                dsTmp = BLL.LeaseBLL.GetLeaseItemsByHTID(tLeaseHT.HTID);
                foreach (DataRow dr in dsTmp.Tables[0].Rows)
                {
                    LeaseAccountList newLeaseAccountList = new LeaseAccountList();
                    int              i_ItemsID           = Convert.ToInt32(dr["ItemsID"]);
                    LeaseItems       tLeaseItem          = BLL.LeaseBLL.GetLeaseItem(i_ItemsID);
                    LeaseAccountLeft tLeaseAccountLeft   = BLL.LeaseBLL.GetLeaseAccountLeft(tLeaseHT.HTID, i_ItemsID);
                    if (tLeaseAccountLeft == null)
                    {
                        continue;
                    }
                    newLeaseAccountList.SNumber      = i_SNumber;
                    newLeaseAccountList.BillID       = newLeaseAccount.BillID;
                    newLeaseAccountList.ItemsID      = tLeaseItem.ItemsID;
                    newLeaseAccountList.ItemsName    = tLeaseItem.MName;
                    newLeaseAccountList.LeaseClass   = 3;                   //将结余类重设
                    newLeaseAccountList.Abstract     = tLeaseItem.MName + " 上期结余";
                    newLeaseAccountList.SDate        = d_SDate;
                    newLeaseAccountList.EDate        = d_EDate;
                    newLeaseAccountList.LeaseUnit    = tLeaseItem.LeaseUnit;
                    newLeaseAccountList.LeaseQuality = tLeaseAccountLeft.QualityLeft;
                    newLeaseAccountList.LeasePrice   = tLeaseItem.LeasePrice;
                    newLeaseAccountList.LeaseDays    = i_Days;
                    newLeaseAccountList.LeaseAmt     = newLeaseAccountList.LeaseQuality * newLeaseAccountList.LeasePrice * i_Days;

                    d_BillAmt += newLeaseAccountList.LeaseAmt;

                    session.Save(newLeaseAccountList);

                    i_SNumber++;
                }
                //2.2按照未结算租赁记录添加租赁结算明细项
                dsTmp = BLL.LeaseBLL.GetLeaseRecord2(i_ProjectID, i_CompanyID);                 //未结算的记录
                foreach (DataRow dr in dsTmp.Tables[0].Rows)
                {
                    //检查租赁日期是否在结算日期范围
                    int         i_RID        = Convert.ToInt32(dr["RID"]);
                    LeaseRecord tLeaseRecord = session.Get <LeaseRecord>(i_RID);

                    if (tLeaseRecord.LeaseDate >= d_SDate && tLeaseRecord.LeaseDate <= d_EDate)
                    {
                        LeaseAccountList newLeaseAccountList = new LeaseAccountList();
                        int        i_ItemsID  = tLeaseRecord.ItemsID;
                        LeaseItems tLeaseItem = session.Get <LeaseItems>(i_ItemsID);


                        newLeaseAccountList.SNumber    = i_SNumber;
                        newLeaseAccountList.BillID     = newLeaseAccount.BillID;
                        newLeaseAccountList.ItemsID    = tLeaseItem.ItemsID;
                        newLeaseAccountList.ItemsName  = tLeaseItem.MName;
                        newLeaseAccountList.LeaseClass = tLeaseItem.LeaseClass;
                        if (tLeaseRecord.Abstract.ToString().Length != 0)
                        {
                            newLeaseAccountList.Abstract = tLeaseItem.MName + "(" + tLeaseRecord.Abstract + ")";
                        }
                        else
                        {
                            newLeaseAccountList.Abstract = tLeaseItem.MName;
                        }
                        DateTime dt1 = tLeaseRecord.LeaseDate;
                        newLeaseAccountList.SDate = dt1;
                        newLeaseAccountList.EDate = d_EDate;
                        TimeSpan tTS1  = d_EDate.Subtract(dt1);
                        int      tDays = tTS1.Days;
                        if (tLeaseRecord.Quality > 0)
                        {
                            if (i_IncludeSDate == 1)
                            {
                                tDays++;
                            }
                        }
                        else
                        {
                            if (i_IncludeEDate != 1)
                            {
                                tDays++;
                            }
                        }
                        if (tLeaseItem.LeaseClass == 0)
                        {
                            //租赁项
                            newLeaseAccountList.LeaseUnit    = tLeaseItem.LeaseUnit;
                            newLeaseAccountList.LeaseQuality = tLeaseRecord.Quality;
                            newLeaseAccountList.LeasePrice   = tLeaseItem.LeasePrice;
                            newLeaseAccountList.LeaseDays    = tDays;
                            newLeaseAccountList.LeaseAmt     = newLeaseAccountList.LeaseQuality * newLeaseAccountList.LeasePrice * tDays;

                            d_BillAmt += newLeaseAccountList.LeaseAmt;

                            newLeaseAccountList.LoadingUnit    = tLeaseItem.LoadingUnit;
                            newLeaseAccountList.LoadingFactor  = Convert.ToDecimal(tLeaseItem.LoadingFactor);
                            newLeaseAccountList.LoadingQuality = Math.Abs(newLeaseAccountList.LeaseQuality / newLeaseAccountList.LoadingFactor);
                            newLeaseAccountList.LoadingPrice   = Convert.ToDecimal(tLeaseItem.LoadingPrice);
                            newLeaseAccountList.LoadingAmt     = Math.Abs(newLeaseAccountList.LoadingPrice * newLeaseAccountList.LoadingQuality);

                            d_BillAmt += newLeaseAccountList.LoadingAmt;

                            if (tLeaseRecord.Quality < 0)
                            {
                                newLeaseAccountList.RepairUnit    = tLeaseItem.RepairUnit;
                                newLeaseAccountList.RepairFactor  = Convert.ToDecimal(tLeaseItem.RepairFactor);
                                newLeaseAccountList.RepairQuality = Math.Abs(newLeaseAccountList.LeaseQuality / newLeaseAccountList.RepairFactor);
                                newLeaseAccountList.RepairPrice   = Convert.ToDecimal(tLeaseItem.RepairPrice);
                                newLeaseAccountList.RepairAmt     = Math.Abs(newLeaseAccountList.RepairPrice * newLeaseAccountList.RepairQuality);
                                d_BillAmt += newLeaseAccountList.RepairAmt;
                            }

                            //检查此租赁项是否存在,存在则更新LeaseAccountLeft,否则添加
                            string s_0 = tLeaseItem.ItemsID.ToString();
                            string s_1 = newLeaseAccountList.LeaseQuality.ToString();
                            for (int j = 0; j < ALeaseAccountLeft.GetLength(0); j++)
                            {
                                if (ALeaseAccountLeft[j, 0] == null)
                                {
                                    ALeaseAccountLeft[j, 0] = s_0;
                                    ALeaseAccountLeft[j, 1] = s_1;
                                    break;
                                }
                                else
                                {
                                    if (ALeaseAccountLeft[j, 0] == s_0)
                                    {
                                        //找到了
                                        decimal d1 = Convert.ToDecimal(s_1) + Convert.ToDecimal(ALeaseAccountLeft[j, 1]);
                                        ALeaseAccountLeft[j, 1] = d1.ToString();
                                        break;
                                    }
                                    //继续找
                                }
                            }
                        }
                        else
                        {
                            //单独结算项
                            newLeaseAccountList.LeaseUnit    = tLeaseItem.LeaseUnit;
                            newLeaseAccountList.OtherUnit    = tLeaseItem.LeaseUnit;
                            newLeaseAccountList.OtherQuality = tLeaseRecord.Quality;
                            newLeaseAccountList.OtherPrice   = tLeaseItem.LeasePrice;
                            newLeaseAccountList.OtherAmt     = newLeaseAccountList.OtherPrice * newLeaseAccountList.OtherQuality;
                            d_BillAmt += newLeaseAccountList.OtherAmt;
                        }

                        tLeaseRecord.LeaseStatus = "已结算";
                        tLeaseRecord.BalanceDate = DateTime.Now.Date;
                        session.Update(tLeaseRecord);
                        session.Save(newLeaseAccountList);


                        i_SNumber++;
                    }
                }

                newLeaseAccount.BillAmt = Convert.ToDecimal(d_BillAmt);
                newStatementList.BillYF = Convert.ToDecimal(d_BillAmt);
                //把LeaseAccountLeft更新
                for (int j = 0; j < ALeaseAccountLeft.GetLength(0); j++)
                {
                    if (ALeaseAccountLeft[j, 0] != null)
                    {
                        int iItem = Convert.ToInt32(ALeaseAccountLeft[j, 0]);
                        LeaseAccountLeft tLeaseAccountLeft = BLL.LeaseBLL.GetLeaseAccountLeft(tLeaseHT.HTID, iItem);
                        if (tLeaseAccountLeft == null)
                        {
                            tLeaseAccountLeft               = new LeaseAccountLeft();
                            tLeaseAccountLeft.HTID          = tLeaseHT.HTID;
                            tLeaseAccountLeft.ItemsID       = iItem;
                            tLeaseAccountLeft.QualityLeft   = Convert.ToDecimal(ALeaseAccountLeft[j, 1]);
                            tLeaseAccountLeft.LastBillCycle = newLeaseAccount.BillCycle;
                            tLeaseAccountLeft.LastEDate     = DateTime.Now.Date;
                            session.Save(tLeaseAccountLeft);
                        }
                        else
                        {
                            tLeaseAccountLeft.QualityLeft   = Convert.ToDecimal(ALeaseAccountLeft[j, 1]);
                            tLeaseAccountLeft.LastBillCycle = newLeaseAccount.BillCycle;
                            tLeaseAccountLeft.LastEDate     = DateTime.Now.Date;
                            session.Update(tLeaseAccountLeft);
                        }
                    }
                    else
                    {
                        break;
                    }
                }
                tx.Commit();
                session.Close();
            } catch (Exception e) {
                Debug.Assert(false, e.Message);
                tx.Rollback();
                session.Close();
            }
            labelStatus.Text = "就绪";
        }
Esempio n. 10
0
        //填数据
        void FillReportData(DataSet FDataSet)
        {
            int      i_ProjectID    = Convert.ToInt32(comboBoxProject.SelectedValue.ToString());
            int      i_CompanyID    = Convert.ToInt32(comboBoxCompany.SelectedValue.ToString());
            int      i_SNumber      = 1;                //租赁结算顺序号
            DateTime dSDate         = dateTimePickerSDate.Value.Date;
            DateTime dEDate         = dateTimePickerEDate.Value.Date;
            TimeSpan tTS            = dEDate.Subtract(dSDate);
            int      i_Days         = tTS.Days + 1;             //结余时租赁天数
            LeaseHT  tLeaseHT       = BLL.LeaseBLL.GetLeaseHT(i_ProjectID, i_CompanyID);
            int      i_IncludeSDate = tLeaseHT.IncludeSDate;    //租金包含开始日
            int      i_IncludeEDate = tLeaseHT.IncludeEDate;    //租金包含结束日
            string   s_BillCycle    = textBoxBillCycle.Text;    //结算周期
            string   s_CalMethod    = "";                       //计算方式

            if (i_IncludeSDate == 0 && i_IncludeEDate == 0)
            {
                s_CalMethod = "倒扣计算法,头尾都不算";
            }
            if (i_IncludeSDate == 1 && i_IncludeEDate == 0)
            {
                s_CalMethod = "倒扣计算法,算头不算尾";
            }
            if (i_IncludeSDate == 1 && i_IncludeEDate == 1)
            {
                s_CalMethod = "倒扣计算法,既算头又算尾";
            }
            if (i_IncludeSDate == 0 && i_IncludeEDate == 1)
            {
                s_CalMethod = "倒扣计算法,算尾不算头";
            }
            List <ItemsLeftStru> RemainKeyValue = new List <ItemsLeftStru>();
//			myKV.ItemdID = 1;
//			myKV.ItemsName = "asdd";
//			myKV.ItemsValue = 12.80;
//			RemainKeyValue.Add(myKV);


            //1.填LeaseAccount表
            DataRow dr = FDataSet.Tables["LeaseAccount"].NewRow();

            dr["BillID"]      = 10000;
            dr["ProjectID"]   = i_ProjectID;
            dr["ProjectName"] = comboBoxProject.Text;
            dr["CompanyID"]   = i_CompanyID;
            dr["CompanyName"] = comboBoxCompany.Text;
            dr["BillCycle"]   = s_BillCycle;
            dr["CalMethod"]   = s_CalMethod;
            FDataSet.Tables["LeaseAccount"].Rows.Add(dr);

            //2.填LeaseAccountList表
            //2.1填结余租赁项
            DataSet tds = BLL.LeaseBLL.GetLeaseAccountLeft(tLeaseHT.HTID);

            foreach (DataRow drtmp in tds.Tables[0].Rows)
            {
                dr = FDataSet.Tables["LeaseAccountList"].NewRow();
                int        i_ItemsID  = Convert.ToInt32(drtmp["ItemsID"]);
                LeaseItems tLeaseItem = BLL.LeaseBLL.GetLeaseItem(i_ItemsID);
                dr["ListID"]       = i_SNumber;
                dr["SNumber"]      = i_SNumber;
                dr["BillID"]       = 10000;
                dr["Abstract"]     = tLeaseItem.MName + " 上期结余";
                dr["SDate"]        = dSDate;
                dr["EDate"]        = dEDate;
                dr["LeaseUnit"]    = tLeaseItem.LeaseUnit;
                dr["LeaseQuality"] = drtmp["QualityLeft"];
                dr["LeasePrice"]   = tLeaseItem.LeasePrice;
                dr["LeaseDays"]    = i_Days;
                dr["LeaseAmt"]     = Convert.ToDecimal(dr["LeaseQuality"]) * Convert.ToDecimal(dr["LeasePrice"]) * i_Days;

                FDataSet.Tables["LeaseAccountList"].Rows.Add(dr);

                ItemsLeftStru myKV = new ItemsLeftStru();
                myKV.ItemdID    = tLeaseItem.ItemsID;
                myKV.ItemsName  = tLeaseItem.MName;
                myKV.ItemsUnit  = tLeaseItem.LeaseUnit;
                myKV.ItemsValue = Convert.ToDouble(dr["LeaseQuality"]);
                AddKeyValue(ref RemainKeyValue, myKV);

                i_SNumber++;
            }
            //2.2按照时间顺序计算各项租金
            tds = BLL.LeaseBLL.GetLeaseRecord2(i_ProjectID, i_CompanyID);               //未结算的记录
            foreach (DataRow drtmp in tds.Tables[0].Rows)
            {
                //检查租赁日期是否在结算日期范围
                DateTime tLeaseDate = Convert.ToDateTime(drtmp["LeaseDate"]);
                if (tLeaseDate >= dSDate && tLeaseDate <= dEDate)
                {
                    dr = FDataSet.Tables["LeaseAccountList"].NewRow();
                    int        i_ItemsID  = Convert.ToInt32(drtmp["ItemsID"]);
                    LeaseItems tLeaseItem = BLL.LeaseBLL.GetLeaseItem(i_ItemsID);



                    dr["ListID"]  = i_SNumber;
                    dr["SNumber"] = i_SNumber;
                    dr["BillID"]  = 10000;
                    if (drtmp["Abstract"].ToString().Length != 0)
                    {
                        dr["Abstract"] = tLeaseItem.MName + "(" + drtmp["Abstract"] + ")";
                    }
                    else
                    {
                        dr["Abstract"] = tLeaseItem.MName;
                    }
                    DateTime dt1 = Convert.ToDateTime(drtmp["LeaseDate"]);
                    dr["SDate"] = dt1;
                    dr["EDate"] = dEDate;
                    TimeSpan tTS1  = dEDate.Subtract(dt1);
                    int      tDays = tTS1.Days;

                    if (Convert.ToDecimal(drtmp["Quality"]) > 0)
                    {
                        if (i_IncludeSDate == 1)
                        {
                            tDays++;
                        }
                    }
                    else
                    {
                        if (i_IncludeEDate != 1)
                        {
                            tDays++;
                        }
                    }

                    if (tLeaseItem.LeaseClass == 0)
                    {
                        //租赁项
                        dr["LeaseUnit"]    = tLeaseItem.LeaseUnit;
                        dr["LeaseQuality"] = drtmp["Quality"];
                        dr["LeasePrice"]   = tLeaseItem.LeasePrice;
                        dr["LeaseDays"]    = tDays;
                        dr["LeaseAmt"]     = Convert.ToDecimal(dr["LeaseQuality"]) * Convert.ToDecimal(dr["LeasePrice"]) * tDays;

                        dr["LoadingUnit"]    = tLeaseItem.LoadingUnit;
                        dr["LoadingFactor"]  = tLeaseItem.LoadingFactor;
                        dr["LoadingQuality"] = Math.Abs(Convert.ToDecimal(dr["LeaseQuality"]) / Convert.ToDecimal(dr["LoadingFactor"]));
                        dr["LoadingPrice"]   = tLeaseItem.LoadingPrice;
                        dr["LoadingAmt"]     = Math.Abs(Convert.ToDecimal(dr["LoadingPrice"]) * Convert.ToDecimal(dr["LoadingQuality"]));

                        if (Convert.ToDecimal(drtmp["Quality"]) < 0)
                        {
                            dr["RepairUnit"]    = tLeaseItem.RepairUnit;
                            dr["RepairFactor"]  = tLeaseItem.RepairFactor;
                            dr["RepairQuality"] = Math.Abs(Convert.ToDecimal(dr["LeaseQuality"]) / Convert.ToDecimal(dr["RepairFactor"]));
                            dr["RepairPrice"]   = tLeaseItem.RepairPrice;
                            dr["RepairAmt"]     = Math.Abs(Convert.ToDecimal(dr["RepairPrice"]) * Convert.ToDecimal(dr["RepairQuality"]));
                        }

                        ItemsLeftStru myKV = new ItemsLeftStru();
                        myKV.ItemdID    = tLeaseItem.ItemsID;
                        myKV.ItemsName  = tLeaseItem.MName;
                        myKV.ItemsUnit  = tLeaseItem.LeaseUnit;
                        myKV.ItemsValue = Convert.ToDouble(dr["LeaseQuality"]);
                        AddKeyValue(ref RemainKeyValue, myKV);
                    }
                    else
                    {
                        //单独结算项
                        dr["LeaseUnit"]    = tLeaseItem.LeaseUnit;
                        dr["OtherUnit"]    = tLeaseItem.LeaseUnit;
                        dr["OtherQuality"] = drtmp["Quality"];
                        dr["OtherPrice"]   = tLeaseItem.LeasePrice;
                        dr["OtherAmt"]     = Convert.ToDecimal(dr["OtherPrice"]) * Convert.ToDecimal(dr["OtherQuality"]);
                    }
                    FDataSet.Tables["LeaseAccountList"].Rows.Add(dr);



                    i_SNumber++;
                }
            }
            //2.3将计算出来的余量数据填写好
            foreach (ItemsLeftStru itemLS in RemainKeyValue)
            {
                dr                = FDataSet.Tables["LeaseAccountLeft"].NewRow();
                dr["ItemsID"]     = itemLS.ItemdID;
                dr["MName"]       = itemLS.ItemsName;
                dr["LeaseUnit"]   = itemLS.ItemsUnit;
                dr["QualityLeft"] = itemLS.ItemsValue;
                FDataSet.Tables["LeaseAccountLeft"].Rows.Add(dr);
            }
        }