예제 #1
0
        /// <summary>
        /// 傳入一個DTO,修改,一次修改一筆
        /// </summary>
        public void UpdateData(MED05_0000 MED05_0000)
        {
            Comm   comm = new Comm();
            string sSql = " UPDATE MED05_0000 " +
                          "    SET mo_code       =  @mo_code,       " +
                          "        wrk_code      =  @wrk_code,      " +
                          "        mac_code      =  @mac_code,      " +
                          "        except_code   =  @except_code,   " +
                          "        date_s        =  @date_s,        " +
                          "        time_s        =  @time_s,        " +
                          "        date_e        =  @date_e,        " +
                          "        time_e        =  @time_e,        " +
                          "        ins_date      =  @ins_date,      " +
                          "        ins_time      =  @ins_time,      " +
                          "        usr_code      =  @usr_code,      " +
                          "        des_memo      =  @des_memo,      " +
                          "        is_ng         =  @is_ng,         " +
                          "        is_end        =  @is_end,        " +
                          "        end_memo      =  @end_memo,      " +
                          "        end_date      =  @end_date,      " +
                          "        end_time      =  @end_time,      " +
                          "        end_usr_code  =  @end_usr_code   " +
                          "  WHERE med05_0000    =  @med05_0000     ";

            using (SqlConnection con_db = comm.Set_DBConnection())
            {
                con_db.Execute(sSql, MED05_0000);
            }
        }
예제 #2
0
        /// <summary>
        /// 傳入一個DTO,存檔,一次存檔一筆
        /// </summary>
        public void InsertData(MED05_0000 MED05_0000)
        {
            Comm   comm = new Comm();
            string sSql = " INSERT INTO " +
                          " MED05_0000 (  mo_code,  wrk_code,  mac_code,  except_code,  date_s,  time_s,  date_e,  time_e,  ins_date,  ins_time,  usr_code, " +
                          "               des_memo,  is_ng,  is_end,  end_memo,  end_date,  end_time,  end_usr_code ) " +

                          "     VALUES ( @mo_code, @wrk_code, @mac_code, @except_code, @date_s, @time_s, @date_e, @time_e, @ins_date, @ins_time, @usr_code, " +
                          "              @des_memo, @is_ng, @is_end, @end_memo, @end_date, @end_time, @end_usr_code ) ";

            using (SqlConnection con_db = comm.Set_DBConnection())
            {
                con_db.Execute(sSql, MED05_0000);
            }
        }