Example #1
0
        public static bool ModifyBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
        {
            string sql =
                "UPDATE BG_FixedAssets " +
                "SET " +
                "FACode = @FACode, " +
                "FAMon = @FAMon, " +
                "FAYear = @FAYear, " +
                "FAMonth = @FAMonth " +
                "WHERE FAID = @FAID";


            try
            {
                SqlParameter[] para = new SqlParameter[]
                {
                    new SqlParameter("@FAID", bG_FixedAssets.FAID),
                    new SqlParameter("@FACode", bG_FixedAssets.FACode),
                    new SqlParameter("@FAMon", bG_FixedAssets.FAMon),
                    new SqlParameter("@FAYear", bG_FixedAssets.FAYear),
                    new SqlParameter("@FAMonth", bG_FixedAssets.FAMonth)
                };

                int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para);
                if (t > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
Example #2
0
 public static bool ModifyBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
 {
     return(BG_FixedAssetsService.ModifyBG_FixedAssets(bG_FixedAssets));
 }
Example #3
0
 public static bool DeleteBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
 {
     return(BG_FixedAssetsService.DeleteBG_FixedAssets(bG_FixedAssets));
 }
Example #4
0
 public static BG_FixedAssets AddBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
 {
     return(BG_FixedAssetsService.AddBG_FixedAssets(bG_FixedAssets));
 }
Example #5
0
 public static bool DeleteBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
 {
     return(DeleteBG_FixedAssetsByFAID(bG_FixedAssets.FAID));
 }