Exemplo n.º 1
0
        public bool UpdateTstkm00(Tstkm00 paramter, SqlConnection conn, SqlTransaction tran)
        {
            #region 參數
            string            sqlExecute = string.Empty;
            DynamicParameters sqlParam   = new DynamicParameters();
            sqlParam.Add("@tick_qtax", paramter.tick_qtax);
            sqlParam.Add("@tick_cost", paramter.tick_cost);
            sqlParam.Add("@tick_tot_amt", paramter.tick_tot_amt);
            sqlParam.Add("@tick_tot_cost", paramter.tick_tot_cost());
            sqlParam.Add("@tick_tkno", paramter.tick_tkno);
            sqlParam.Add("@tick_tkseq", paramter.tick_tkseq);
            #endregion

            #region SQL 語法
            sqlExecute = @"
                  UPDATE TSTKM00 SET tick_qtax = @tick_qtax, tick_cost = @tick_cost, tick_tot_amt = @tick_tot_amt, tick_tot_cost = @tick_tot_cost
					WHERE tick_tkno = @tick_tkno AND tick_tkseq = @tick_tkseq ;"                    ;
            #endregion

            #region SQL 查詢

            return(conn.Execute(sqlExecute, sqlParam, tran) > 0);

            #endregion
        }
Exemplo n.º 2
0
        public double getErat(Tstkm00 paramter)
        {
            #region SQL 語法
            string sqlQuery = @"
					select tick_erat from tstkm00 WHERE tick_tkno = @tick_tkno AND tick_tkseq = @tick_tkseq ;"                    ;
            #endregion

            DynamicParameters sqlParam = new DynamicParameters();
            sqlParam.Add("@tick_tkno", paramter.tick_tkno);
            sqlParam.Add("@tick_tkseq", paramter.tick_tkseq);

            #region SQL 查詢
            using (SqlConnection conn = SQLFunc.OpenConnection(_connectString))
            {
                return(conn.Query <double>(sqlQuery, sqlParam).FirstOrDefault());
            }
            #endregion
        }