コード例 #1
0
        /// <summary>
        /// Update data full for table DECLARATIONDETAIL
        /// you must set attribute at application tier
        /// </summary>
        /// <param name="obj"> type of DECLARATIONDETAIL</param>
        public static bool Update(DECLARATIONDETAIL declarationDetail, bool isTmp)
        {
            string procedure = isTmp ? "spDECLARATIONDETAILtmpUpdate" : "spDECLARATIONDETAILUpdate";
            int    i         = SqlHelper.ExecuteNonQuery(procedure,
                                                         declarationDetail.DECD_AUTOID,
                                                         declarationDetail.COT_DOCUMENTID,
                                                         declarationDetail.PIT_AUTOID,
                                                         declarationDetail.ITG_AUTOID,
                                                         declarationDetail.UOM_AUTOID,
                                                         declarationDetail.TR_AUTOID,
                                                         declarationDetail.PK_AUTOID,
                                                         declarationDetail.CP_AUTOID,
                                                         declarationDetail.ITT_AUTOID,
                                                         declarationDetail.WH_AUTOID,
                                                         declarationDetail.PRJ_AUTOID,
                                                         declarationDetail.DEC_DOCUMENTID,
                                                         declarationDetail.PIT_ITEMNO,
                                                         declarationDetail.PIT_ITEMNAME,
                                                         declarationDetail.PIT_UNITPRICE,
                                                         declarationDetail.DECD_POIVQUANTITY,
                                                         declarationDetail.DECD_QUANTITY,
                                                         declarationDetail.DECD_AMOUNT,
                                                         declarationDetail.DECD_EITAXPERCENT,
                                                         declarationDetail.DECD_REDUCEPERCENT,
                                                         declarationDetail.DECD_TAXPERCENT,
                                                         declarationDetail.DECD_BASEAMOUNT,
                                                         declarationDetail.DECD_NOTE,
                                                         declarationDetail.DOC_DOCUMENTID);

            if (i > 0)
            {
                return(true);
            }
            return(false);
        }
コード例 #2
0
        /// <summary>
        ///Select data full for table DECLARATIONDETAIL
        /// return oneDECLARATIONDETAIL
        /// you must set attribute at application tier
        /// </summary>
        /// <param name="DECD_AUTOID"> type of DECD_AUTOID</param>
        public static DECLARATIONDETAIL SelectByID(int DECD_AUTOID)
        {
            DataSet           ds     = new DataSet();
            DECLARATIONDETAIL result = new DECLARATIONDETAIL();

            SqlHelper.ExecuteDataset(ds, "spDECLARATIONDETAILGetByID", DECD_AUTOID);
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    result = new DECLARATIONDETAIL(ds.Tables[0].Rows[0]);
                }
            }
            ds.Dispose();
            return(result);
        }