예제 #1
0
        /// <summary>
        /// 傳入一個DTO,存檔,一次存檔一筆
        /// </summary>
        public void InsertData(MED01_0100 MED01_0100)
        {
            Comm   comm = new Comm();
            string sSql = " INSERT INTO " +
                          " MED01_0100 (  mo_code,  wrk_code,  mac_code,  usr_code,  date_s,  time_s,  date_e,  time_e , status ," +
                          "               user_field_01, user_field_02, user_field_03, user_field_04, user_field_05,    " +
                          "               user_field_06, user_field_07, user_field_08, user_field_09, user_field_10 )    " +
                          "     VALUES ( @mo_code, @wrk_code, @mac_code, @usr_code, @date_s, @time_s, @date_e, @time_e , @status ,     " +
                          "             @user_field_01, @user_field_02, @user_field_03, @user_field_04, @user_field_05,    " +
                          "             @user_field_06, @user_field_07, @user_field_08, @user_field_09, @user_field_10 )    ";;

            using (SqlConnection con_db = comm.Set_DBConnection())
            {
                con_db.Execute(sSql, MED01_0100);
            }
        }
예제 #2
0
        /// <summary>
        /// 傳入一個DTO,修改,一次修改一筆
        /// </summary>
        public void UpdateData(MED01_0100 MED01_0100)
        {
            Comm   comm = new Comm();
            string sSql = " UPDATE MED01_0100 " +
                          "    SET mo_code    =  @mo_code,   " +
                          "        wrk_code   =  @wrk_code,  " +
                          "        mac_code   =  @mac_code,  " +
                          "        usr_code   =  @usr_code,  " +
                          "        date_s     =  @date_s,    " +
                          "        time_s     =  @time_s,    " +
                          "        date_e     =  @date_e,    " +
                          "        time_e     =  @time_e,    " +
                          "        status     =  @status     " +
                          "  WHERE med01_0100 =  @med01_0100 ";

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