<CommandText>DELETE FROM [c_stick_distribute] WHERE (([e_distribute_no] = @Original_e_distribute_no) AND ((@IsNull_e_pol_no_begin = 1 AND [e_pol_no_begin] IS NULL) OR ([e_pol_no_begin] = @Original_e_pol_no_begin)) AND ((@IsNull_e_pol_no_end = 1 AND [e_pol_no_end] IS NULL) OR ([e_pol_no_end] = @Original_e_pol_no_end)) AND ((@IsNull_i_ag = 1 AND [i_ag] IS NULL) OR ([i_ag] = @Original_i_ag)) AND ((@IsNull_i_ag_sub = 1 AND [i_ag_sub] IS NULL) OR ([i_ag_sub] = @Original_i_ag_sub)) AND ((@IsNull_i_distribute = 1 AND [i_distribute] IS NULL) OR ([i_distribute] = @Original_i_distribute)) AND ((@IsNull_d_distribute = 1 AND [d_distribute] IS NULL) OR ([d_distribute] = @Original_d_distribute)) AND ((@IsNull_n_pol_dist = 1 AND [n_pol_dist] IS NULL) OR ([n_pol_dist] = @Original_n_pol_dist)) AND ((@IsNull_s_type = 1 AND [s_type] IS NULL) OR ([s_type] = @Original_s_type)))</CommandText>
<CommandText>UPDATE [c_stick_distribute] SET [e_distribute_no] = @e_distribute_no, [e_pol_no_begin] = @e_pol_no_begin, [e_pol_no_end] = @e_pol_no_end, [i_ag] = @i_ag, [i_ag_sub] = @i_ag_sub, [i_distribute] = @i_distribute, [d_distribute] = @d_distribute, [n_pol_dist] = @n_pol_dist, [s_type] = @s_type WHERE (([e_distribute_no] = @Original_e_distribute_no) AND ((@IsNull_e_pol_no_begin = 1 AND [e_pol_no_begin] IS NULL) OR ([e_pol_no_begin] = @Original_e_pol_no_begin)) AND ((@IsNull_e_pol_no_end = 1 AND [e_pol_no_end] IS NULL) OR ([e_pol_no_end] = @Original_e_pol_no_end)) AND ((@IsNull_i_ag = 1 AND [i_ag] IS NULL) OR ([i_ag] = @Original_i_ag)) AND ((@IsNull_i_ag_sub = 1 AND [i_ag_sub] IS NULL) OR ([i_ag_sub] = @Original_i_ag_sub)) AND ((@IsNull_i_distribute = 1 AND [i_distribute] IS NULL) OR ([i_distribute] = @Original_i_distribute)) AND ((@IsNull_d_distribute = 1 AND [d_distribute] IS NULL) OR ([d_distribute] = @Original_d_distribute)) AND ((@IsNull_n_pol_dist = 1 AND [n_pol_dist] IS NULL) OR ([n_pol_dist] = @Original_n_pol_dist)) AND ((@IsNull_s_type = 1 AND [s_type] IS NULL) OR ([s_type] = @Original_s_type)));
SELECT e_distribute_no, e_pol_no_begin, e_pol_no_end, i_ag, i_ag_sub, i_distribute, d_distribute, n_pol_dist, s_type FROM c_stick_distribute WHERE (e_distribute_no = @e_distribute_no)</CommandText>
<CommandText>DELETE FROM [c_stick_web] WHERE (([c_year] = @Original_c_year) AND ([s_type] = @Original_s_type) AND ([e_pol_no] = @Original_e_pol_no) AND ([i_ag] = @Original_i_ag) AND ([e_barcode] = @Original_e_barcode) AND ((@IsNull_e_bookno = 1 AND [e_bookno] IS NULL) OR ([e_bookno] = @Original_e_bookno)) AND ((@IsNull_e_receipt = 1 AND [e_receipt] IS NULL) OR ([e_receipt] = @Original_e_receipt)) AND ((@IsNull_d_approve_withdraw = 1 AND [d_approve_withdraw] IS NULL) OR ([d_approve_withdraw] = @Original_d_approve_withdraw)) AND ([i_approve_withdraw] = @Original_i_approve_withdraw) AND ([f_status] = @Original_f_status) AND ((@IsNull_d_status = 1 AND [d_status] IS NULL) OR ([d_status] = @Original_d_status)) AND ((@IsNull_i_status = 1 AND [i_status] IS NULL) OR ([i_status] = @Original_i_status)) AND ((@IsNull_i_control = 1 AND [i_control] IS NULL) OR ([i_control] = @Original_i_control)) AND ((@IsNull_i_ag_sub = 1 AND [i_ag_sub] IS NULL) OR ([i_ag_sub] = @Original_i_ag_sub)) AND ((@IsNull_f_transfer = 1 AND [f_transfer] IS NULL) OR ([f_transfer] = @Original_f_transfer)) AND ((@IsNull_d_transfer = 1 AND [d_transfer] IS NULL) OR ([d_transfer] = @Original_d_transfer)) AND ((@IsNull_d_upload_stick = 1 AND [d_upload_stick] IS NULL) OR ([d_upload_stick] = @Original_d_upload_stick)) AND ((@IsNull_i_agen_code = 1 AND [i_agen_code] IS NULL) OR ([i_agen_code] = @Original_i_agen_code)) AND ((@IsNull_c_agen_codename = 1 AND [c_agen_codename] IS NULL) OR ([c_agen_codename] = @Original_c_agen_codename)) AND ((@IsNull_i_agen_code# = 1 AND [i_agen_code#] IS NULL) OR ([i_agen_code#] = @Original_i_agen_code#)) AND ((@IsNull_f_receive_copy = 1 AND [f_receive_copy] IS NULL) OR ([f_receive_copy] = @Original_f_receive_copy)) AND ((@IsNull_i_receive_copy = 1 AND [i_receive_copy] IS NULL) OR ([i_receive_copy] = @Original_i_receive_copy)) AND ((@IsNull_d_receive_copy = 1 AND [d_receive_copy] IS NULL) OR ([d_receive_copy] = @Original_d_receive_copy)) AND ((@IsNull_f_sticker_type = 1 AND [f_sticker_type] IS NULL) OR ([f_sticker_type] = @Original_f_sticker_type)) AND ((@IsNull_f_pol_ctl = 1 AND [f_pol_ctl] IS NULL) OR ([f_pol_ctl] = @Original_f_pol_ctl)) AND ((@IsNull_e_order_no = 1 AND [e_order_no] IS NULL) OR ([e_order_no] = @Original_e_order_no)) AND ((@IsNull_e_distribute_no = 1 AND [e_distribute_no] IS NULL) OR ([e_distribute_no] = @Original_e_distribute_no)))</CommandText>
<CommandText>UPDATE [c_stick_web] SET [c_year] = @c_year, [s_type] = @s_type, [e_pol_no] = @e_pol_no, [i_ag] = @i_ag, [e_barcode] = @e_barcode, [e_bookno] = @e_bookno, [e_receipt] = @e_receipt, [d_approve_withdraw] = @d_approve_withdraw, [i_approve_withdraw] = @i_approve_withdraw, [f_status] = @f_status, [d_status] = @d_status, [i_status] = @i_status, [i_control] = @i_control, [i_ag_sub] = @i_ag_sub, [f_transfer] = @f_transfer, [d_transfer] = @d_transfer, [d_upload_stick] = @d_upload_stick, [i_agen_code] = @i_agen_code, [c_agen_codename] = @c_agen_codename, [i_agen_code#] = @i_agen_code#, [f_receive_copy] = @f_receive_copy, [i_receive_copy] = @i_receive_copy, [d_receive_copy] = @d_receive_copy, [f_sticker_type] = @f_sticker_type, [f_pol_ctl] = @f_pol_ctl, [e_order_no] = @e_order_no, [e_distribute_no] = @e_distribute_no WHERE (([c_year] = @Original_c_year) AND ([s_type] = @Original_s_type) AND ([e_pol_no] = @Original_e_pol_no) AND ([i_ag] = @Original_i_ag) AND ([e_barcode] = @Original_e_barcode) AND ((@IsNull_e_bookno = 1 AND [e_bookno] IS NULL) OR ([e_bookno] = @Original_e_bookno)) AND ((@IsNull_e_receipt = 1 AND [e_receipt] IS NULL) OR ([e_receipt] = @Original_e_receipt)) AND ((@IsNull_d_approve_withdraw = 1 AND [d_approve_withdraw] IS NULL) OR ([d_approve_withdraw] = @Original_d_approve_withdraw)) AND ([i_approve_withdraw] = @Original_i_approve_withdraw) AND ([f_status] = @Original_f_status) AND ((@IsNull_d_status = 1 AND [d_status] IS NULL) OR ([d_status] = @Original_d_status)) AND ((@IsNull_i_status = 1 AND [i_status] IS NULL) OR ([i_status] = @Original_i_status)) AND ((@IsNull_i_control = 1 AND [i_control] IS NULL) OR ([i_control] = @Original_i_control)) AND ((@IsNull_i_ag_sub = 1 AND [i_ag_sub] IS NULL) OR ([i_ag_sub] = @Original_i_ag_sub)) AND ((@IsNull_f_transfer = 1 AND [f_transfer] IS NULL) OR ([f_transfer] = @Original_f_transfer)) AND ((@IsNull_d_transfer = 1 AND [d_transfer] IS NULL) OR ([d_transfer] = @Original_d_transfer)) AND ((@IsNull_d_upload_stick = 1 AND [d_upload_stick] IS NULL) OR ([d_upload_stick] = @Original_d_upload_stick)) AND ((@IsNull_i_agen_code = 1 AND [i_agen_code] IS NULL) OR ([i_agen_code] = @Original_i_agen_code)) AND ((@IsNull_c_agen_codename = 1 AND [c_agen_codename] IS NULL) OR ([c_agen_codename] = @Original_c_agen_codename)) AND ((@IsNull_i_agen_code# = 1 AND [i_agen_code#] IS NULL) OR ([i_agen_code#] = @Original_i_agen_code#)) AND ((@IsNull_f_receive_copy = 1 AND [f_receive_copy] IS NULL) OR ([f_receive_copy] = @Original_f_receive_copy)) AND ((@IsNull_i_receive_copy = 1 AND [i_receive_copy] IS NULL) OR ([i_receive_copy] = @Original_i_receive_copy)) AND ((@IsNull_d_receive_copy = 1 AND [d_receive_copy] IS NULL) OR ([d_receive_copy] = @Original_d_receive_copy)) AND ((@IsNull_f_sticker_type = 1 AND [f_sticker_type] IS NULL) OR ([f_sticker_type] = @Original_f_sticker_type)) AND ((@IsNull_f_pol_ctl = 1 AND [f_pol_ctl] IS NULL) OR ([f_pol_ctl] = @Original_f_pol_ctl)) AND ((@IsNull_e_order_no = 1 AND [e_order_no] IS NULL) OR ([e_order_no] = @Original_e_order_no)) AND ((@IsNull_e_distribute_no = 1 AND [e_distribute_no] IS NULL) OR ([e_distribute_no] = @Original_e_distribute_no)));
