コード例 #1
0
        protected int UpdateAssets(AssetsDepreciation assetsDepreciation, UserInfo sysUser, string viewTitle)
        {
            Dictionary <string, object> paras = new Dictionary <string, object>();

            paras.Add("assetsId", assetsDepreciation.AssetsId);
            string    sql = @"select * from Assets where assetsId=@assetsId ";
            DataTable dt  = AppMember.DbHelper.GetDataSet(sql, paras, dbUpdate.cmd).Tables[0];

            dt.TableName = "Assets";
            dt.Rows[0]["assetsNetValue"] = DataConvert.ToDouble(dt.Rows[0]["assetsNetValue"]) - DataConvert.ToDouble(assetsDepreciation.DepreciationMonth);
            dt.Rows[0]["remainMonth"]    = DataConvert.ToInt32(dt.Rows[0]["remainMonth"]) - 1;
            Update5Field(dt, sysUser.UserId, viewTitle);
            return(dbUpdate.Update(dt));
        }
コード例 #2
0
        protected int AddDetail(Dictionary <string, object> objs, AssetsDepreciation assetsDepreciation, UserInfo sysUser, string viewTitle)
        {
            string    sql = @"select * from AssetsDepreciation where 1<>1 ";
            DataTable dt  = AppMember.DbHelper.GetDataSet(sql).Tables[0];

            dt.TableName = "AssetsDepreciation";
            DataRow dr = dt.NewRow();

            dr["assetsId"]          = assetsDepreciation.AssetsId;
            dr["fiscalYearId"]      = DataConvert.ToString(objs["fiscalYearId"]);
            dr["fiscalPeriodId"]    = DataConvert.ToString(objs["fiscalPeriodId"]);
            dr["depreciationMonth"] = assetsDepreciation.DepreciationMonth;
            Create5Field(dr, sysUser.UserId, viewTitle);
            dt.Rows.Add(dr);
            dbUpdate.Update(dt);
            UpdateAssets(assetsDepreciation, sysUser, viewTitle);
            return(1);
        }