public static void Copy(int New_Quotation_ID, int Old_Quotation_ID) { QuotationEntities entities = new QuotationEntities(); IEnumerable<Quotation_Target> TargetList = entities.Quotation_Target.Where (c => c.quotation_id == Old_Quotation_ID); foreach (Quotation_Target item in TargetList) { entities.Detach(item); item.EntityKey = null; item.quotation_id = New_Quotation_ID; //Project Target Estimate Date 以下欄位資料不能複製至新Target item.Status = "Open"; item.test_started = null; item.test_completed = null; item.certification_completed = null; item.certification_submit_to_authority = null; item.Estimated_Lead_time = string.Empty; item.Actual_Lead_time = string.Empty; item.Agent = 0; item.Country_Manager = 0; item.PR_Flag = string.Empty; item.Bill1 = null; item.Bill2 = null; item.Bill3 = null; item.BillE = null; //adams:2014/8/25 item.document_ready_to_process = null; item.certificate_type = null; item.certificate_issue_date = null; item.certificate_expiry_date = null; item.email_renewal_notice_date = null; item.renewal_confirmation_check = "0"; item.conduct_renewal_action_date = null; item.sample_received_from_client_date = null; item.customer_request_sample_returned = "0"; item.sample_returned_to_client_date = null; item.sample_shipping_tracking_no = null; item.customer_request_original_certificate_returned = "0"; item.original_certificate_mailed_to_client_date = null; item.Certificate_shipping_tracking_no = null; item.sample_can_be_returned_from_authority = "0"; item.sample_is_kept_by_local_agent = false; item.request_local_agent_to_destroy_tested_samples = false; item.returned_of_tested_sample_date = null; item.CMB1 = false; item.CMB2 = false; item.CMB3 = false; item.CMB4 = false; item.CMB5 = false; item.CMB6 = false; item.CMB7 = false; item.CMB8 = false; item.original_certificate_received_date = null; item.Lifetime = false; Add(item); } }