public void RetestBatch() { try { CBatchFactory faBatch = new CBatchFactory(); CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch)); // --- check parity for (int i = 0; i < ListSamples.Count; i++) { CBatch_detail_aa_twofold row = ListSamples[i]; CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory(); if (Convert.ToInt32(row.Flag_mri) == 0) { // --- approved samples with additional retest mark row.Qaqc_has_retest = 1; faBatch_detail_aa_twofold.Update(row); // --- save retest string cod_type_sample = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(Convert.ToInt32(row.Idtemplate_method))).Cod_type_sample; CCorrelative oCorrelative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(cod_type_sample)); CBatchManager oBatchManager = new CBatchManager(); oBatchManager.CallSaveFromRetestFullBatch( Convert.ToInt32(row.Idtemplate_method), Convert.ToInt64(row.Idrecep_sample), Convert.ToInt64(row.Idrecep_sample_detail), Convert.ToInt64(row.Idrecep_sample_detail_elem), Convert.ToInt64(row.Cod_interno), row.Cod_sample, Comun.GetUser(), oCorrelative, row.Qaqc_par); // --- register as finished trace process CProcess_Sample_Manage.Finalize_process(Convert.ToInt64(row.Idrecep_sample_detail_elem), LimsProcess.PROCESS_IN_READING, LimsProcess.PROCESS_APPROVE_SAMPLES); } } // --- modify the batch status, put in other process CProcess oProcess = new CProcessFactory().GetByPrimaryKey(new CProcessKeys(LimsProcess.PROCESS_APPROVE_SAMPLES)); oBatch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting); oBatch.Cod_module = oProcess.Cod_module; oBatch.Cod_area = oProcess.Cod_area; oBatch.Cod_process = LimsProcess.PROCESS_APPROVE_SAMPLES; oBatch.User_approve_tray = Comun.GetUser(); oBatch.Date_approve_tray = Comun.GetDate(); faBatch.Update(oBatch); // --- register as finished trace batch Cprocess_Batch_Manage.Finalize_process(Idbatch, LimsProcess.PROCESS_IN_READING, LimsProcess.PROCESS_APPROVE_SAMPLES); } catch (Exception ex) { Comun.Save_log(ex.InnerException.ToString()); throw new Exception("pivot data::approve::Error occured.", ex); } }
public static void Finalize_process(long idbatch, string process, string sgtProcess) { CTrace_batchFactory faTrace_batch = new CTrace_batchFactory(); // --- get a process existing CTrace_batch oTrace_batch = new LimsProject.BusinessLayer.Modules.ModProcessBatch().GetLastProcessBatch(process, idbatch); CProcess oProcess = new CProcessFactory().GetByPrimaryKey(new CProcessKeys(process)); if (oTrace_batch == null) { oTrace_batch = new CTrace_batch(); oTrace_batch.Date_in = Comun.GetDate(); oTrace_batch.Usernew = Comun.GetUser(); oTrace_batch.Idbatch = idbatch; } oTrace_batch.Date_out = Comun.GetDate(); oTrace_batch.Cod_process = process; //oTrace_batch.Cod_module = modulo; oTrace_batch.Useredit = Comun.GetUser(); oTrace_batch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Finished); if (!faTrace_batch.Update(oTrace_batch)) { faTrace_batch.Insert(oTrace_batch); } // --- create a new process Initialize_process(idbatch, sgtProcess); }
public static void Advance_process(long idbatch, string process) { CTrace_batchFactory faTrace_batch = new CTrace_batchFactory(); // --- get a process existing CTrace_batch oTrace_batch = new LimsProject.BusinessLayer.Modules.ModProcessBatch().GetLastProcessBatch(process, idbatch); if (oTrace_batch == null) { oTrace_batch = new CTrace_batch(); oTrace_batch.Date_in = Comun.GetDate(); oTrace_batch.Usernew = Comun.GetUser(); oTrace_batch.Idbatch = idbatch; } oTrace_batch.Cod_process = process; //oTrace_batch.Cod_module = module; oTrace_batch.Usernew = Comun.GetUser(); oTrace_batch.Useredit = Comun.GetUser(); oTrace_batch.Status_process = Convert.ToChar(LimsProcess.Status_Process.InProcess); if (!faTrace_batch.Update(oTrace_batch)) { faTrace_batch.Insert(oTrace_batch); } }
public static void Finalize_process(long idrecep_sample_detail_elem, string process, string sgtProcess) { CTrace_sample_elemFactory faTrace_sample_elem = new CTrace_sample_elemFactory(); // --- get a process existing CTrace_sample_elem oTrace_sample_elem = faTrace_sample_elem.GetAll() .Where(x => x.Idrecep_sample_detail_elem == idrecep_sample_detail_elem && x.Cod_process == process) .OrderBy(x => x.Idtrace_sample_elem).OrderByDescending(x => x.Date_in).FirstOrDefault(); if (oTrace_sample_elem == null) { oTrace_sample_elem = new CTrace_sample_elem(); oTrace_sample_elem.Date_in = Comun.GetDate(); oTrace_sample_elem.Usernew = Comun.User_system.Cod_user; oTrace_sample_elem.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; //oTrace_sample_elem.Cod_module = module; oTrace_sample_elem.Cod_process = process; } oTrace_sample_elem.Date_out = Comun.GetDate(); oTrace_sample_elem.Status_process = Convert.ToChar(LimsProcess.Status_Process.Finished); oTrace_sample_elem.Useredit = Comun.GetUser(); if (!faTrace_sample_elem.Update(oTrace_sample_elem)) { faTrace_sample_elem.Insert(oTrace_sample_elem); } // --- create a new process Initialize_process(idrecep_sample_detail_elem, sgtProcess); }
public static void Advance_process(long idrecep_sample_detail_elem, string process) { CTrace_sample_elemFactory faTrace_sample_elem = new CTrace_sample_elemFactory(); // --- get a process existing CTrace_sample_elem oTrace_sample_elem = faTrace_sample_elem.GetAll() .Where(x => x.Idrecep_sample_detail_elem == idrecep_sample_detail_elem && x.Cod_process == process) .OrderBy(x => x.Idtrace_sample_elem).OrderByDescending(x => x.Date_in).FirstOrDefault(); if (oTrace_sample_elem == null) { oTrace_sample_elem = new CTrace_sample_elem(); oTrace_sample_elem.Usernew = Comun.GetUser(); oTrace_sample_elem.Date_in = Comun.GetDate(); } oTrace_sample_elem.Cod_process = process; oTrace_sample_elem.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; oTrace_sample_elem.Status_process = Convert.ToChar(LimsProcess.ModuleStatus.InProcess); oTrace_sample_elem.Useredit = Comun.GetUser(); if (!faTrace_sample_elem.Update(oTrace_sample_elem)) { faTrace_sample_elem.Insert(oTrace_sample_elem); } }
protected override bool Grabar_Registro() { try { // borrar datos foreach (CCompound item in new CCompoundFactory().GetAll()) { item.Status = false; new CCompoundFactory().Update(item); } // guardar grid foreach (CCompound item in gcCompound.DataSource as BindingList <CCompound> ) { item.Status = true; item.Useredit = Comun.GetUser(); item.Dateedit = Comun.GetDate(); if (!new CCompoundFactory().Update(item)) { item.Usernew = Comun.GetUser(); item.Datenew = Comun.GetDate(); new CCompoundFactory().Insert(item); } } return(true); } catch (Exception ex) { ComunForm.Send_message("Compuestos", TypeMsg.error, ex.Message); return(false); } }
protected override bool Grabar_Registro() { CElement oElement = new CElement(); oElement.Idelement = Idelement; oElement.Cod_element = tbCodElement.Text; oElement.Name_element = tbDenomination.Text; oElement.Description = tbDescription.Text; oElement.Native_element = tbGroup.Text; oElement.Type_element = 'C'; if (Idelement == 0) { oElement.Usernew = Comun.GetUser(); oElement.Useredit = Comun.GetUser(); oElement.Datenew = Comun.GetDate(); oElement.Dateedit = Comun.GetDate(); } else { oElement.Datenew = Comun.GetDate(); oElement.Dateedit = Comun.GetDate(); } CElementFactory faElement = new CElementFactory(); if (!faElement.Update(oElement)) { faElement.Insert(oElement); } ComunForm.Send_message(this.Text, TypeMsg.ok, ""); return(true); }
protected override bool Grabar_Registro() { try { // eliminar todo foreach (CFactor_estequiometrico item in new CFactor_estequiometricoFactory().GetAll()) { item.Status = false; new CFactor_estequiometricoFactory().Update(item); } // guardar foreach (CFactor_estequiometrico item in gcFactorEstequ.DataSource as BindingList <CFactor_estequiometrico> ) { item.Status = true; item.Dateedit = Comun.GetDate(); item.Useredit = Comun.GetUser(); if (!new CFactor_estequiometricoFactory().Update(item)) { item.Useredit = Comun.GetUser(); item.Datenew = Comun.GetDate(); new CFactor_estequiometricoFactory().Insert(item); } } return(true); } catch (Exception ex) { ComunForm.Send_message("Factores estequiométricos", TypeMsg.error, ex.Message); return(true); } }
protected override bool Grabar_Registro() { CType_solutionFactory faType_solution = new CType_solutionFactory(); try { // --- remove all List <CType_solution> lstType_solution = new List <CType_solution>(new CType_solutionFactory().GetAll()); for (int i = 0; i < lstType_solution.Count; i++) { CType_solution current_row = lstType_solution[i]; if (current_row.Idtype_solution > 0) { current_row.Status = false; faType_solution.Update(current_row); } } // --- save all for (int i = 0; i < gvTypeSolution.RowCount; i++) { CType_solution current_row = gvTypeSolution.GetRow(i) as CType_solution; if (current_row.Idtype_solution == 0) { current_row.Usernew = Comun.GetUser(); current_row.Datenew = Comun.GetDate(); current_row.Status = true; } else { current_row.Useredit = Comun.GetUser(); current_row.Dateedit = Comun.GetDate(); current_row.Status = true; } if (!faType_solution.Update(current_row)) { faType_solution.Insert(current_row); } } return(true); } catch (Exception ex) { ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message); return(false); } }
void AddParentNode() { // --- this method add a son node for one selected node CDocumentation_User_File oDocUserFile = new CDocumentation_User_File { Iddocumentation = -1, Idtemplate_method = null, Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue), Name_doc = "Certificado", Procedure_type = Convert.ToChar(cbProcedure.EditValue), Type_doc = 'C', Image_index = 0, Id = GetNewIdNode(), Parentid = 0, Date_ini = DateTime.Now, Date_end = DateTime.Now.AddMonths(12), Rank_valid_inmonth = 12, Prev_authorized = false }; lstDocumentation_user_file.Add(oDocUserFile); // --- save CDocumentationFactory faDocumentation = new CDocumentationFactory(); CDocumentation oDocumentation = new CDocumentation(); oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation; oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder; oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method; oDocumentation.Image_index = oDocUserFile.Image_index; oDocumentation.Name_doc = oDocUserFile.Name_doc; oDocumentation.Procedure_type = oDocUserFile.Procedure_type; oDocumentation.Type_doc = oDocUserFile.Type_doc; oDocumentation.Flag_enabled = true; oDocumentation.Id = oDocUserFile.Id; oDocumentation.Parentid = oDocUserFile.Parentid; oDocumentation.Usernew = Comun.GetUser(); oDocumentation.Useredit = Comun.GetUser(); oDocumentation.Datenew = DateTime.Now; oDocumentation.Dateedit = DateTime.Now; oDocumentation.Status = true; treeAuthorization.DataSource = lstDocumentation_user_file; faDocumentation.Insert(oDocumentation); treeAuthorization.DataSource = lstDocumentation_user_file; }
void SaveData() { //guardar las filas cuyo valor de idelement_wavelength sea igual a 0 foreach (CElement_wavelength item in gcElemWavelength.DataSource as BindingList <CElement_wavelength> ) { if (item.Idelement_wavelength == 0) { item.Status = true; item.Dateedit = Comun.GetDate(); item.Useredit = Comun.GetUser(); new CElement_wavelengthFactory().Insert(item); } } }
protected override bool Grabar_Registro() { CCompanyFactory faCompany = new CCompanyFactory(); CCompany oCompany; if ((oCompany = faCompany.GetByPrimaryKey(new CCompanyKeys(IDCompany))) == null) { oCompany = new CCompany(); } oCompany.Idcompany = IDCompany; oCompany.Business_name = tbBusinessName.Text; oCompany.Domicile = tbClientDomicile.Text; oCompany.Mail = tbClientEmail.Text; oCompany.Phone_client = tbClientPhone.Text; oCompany.Ruc = tbClientRuc.Text; oCompany.Type_company = Convert.ToChar(cbTypeCompany.EditValue); if (IDCompany == 0) { oCompany.Usernew = Comun.GetUser(); oCompany.Useredit = Comun.GetUser(); oCompany.Datenew = Comun.GetDate(); oCompany.Dateedit = Comun.GetDate(); } else { oCompany.Useredit = Comun.GetUser(); oCompany.Dateedit = Comun.GetDate(); } bool result = false; if (!(result = faCompany.Update(oCompany))) { if (!result) { result = faCompany.Insert(oCompany); } } if (result) { LoadDataMasterSearh(new CCompanyFactory().GetAllDataTable()); } return(result); }
public static void Initialize_process(long idbatch, string process) { // --- register the finished process, CTrace_batchFactory faTrace_batch = new CTrace_batchFactory(); CTrace_batch oTrace_batch = new CTrace_batch(); // --- register the initiatied process oTrace_batch = new CTrace_batch(); oTrace_batch.Date_in = Comun.GetDate(); oTrace_batch.Cod_process = process; //oTrace_batch.Cod_module = module; oTrace_batch.Idbatch = idbatch; oTrace_batch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting); oTrace_batch.Usernew = Comun.GetUser(); oTrace_batch.Datenew = Comun.GetDate(); faTrace_batch.Insert(oTrace_batch); }
public static void Initialize_process(long idrecep_sample_detail_elem, string process) { // --- register the finished process, CTrace_sample_elemFactory faTrace_sample_elem = new CTrace_sample_elemFactory(); CTrace_sample_elem oTrace_sample_elem = new CTrace_sample_elem(); // --- register the initiatied process oTrace_sample_elem = new CTrace_sample_elem(); oTrace_sample_elem.Date_in = Comun.GetDate(); //oTrace_sample_elem.Cod_module = module; oTrace_sample_elem.Cod_process = process; oTrace_sample_elem.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; oTrace_sample_elem.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting); oTrace_sample_elem.Usernew = Comun.GetUser(); oTrace_sample_elem.Useredit = Comun.GetUser(); faTrace_sample_elem.Insert(oTrace_sample_elem); }
void InitData() { CReactiveFactory faReactive = new CReactiveFactory(); List <CReactive> lstReactive = faReactive.GetAll(); lstReactive.Add(new CReactive() { Idreactive = 0, Reactive_name = "---", Chemical_formula = "---" }); cbMedium.Properties.DataSource = lstReactive; cbMedium.Properties.ValueMember = "Idreactive"; cbMedium.Properties.DisplayMember = "Reactive_name"; cbModif.Properties.DataSource = lstReactive; cbModif.Properties.ValueMember = "Idreactive"; cbModif.Properties.DisplayMember = "Reactive_name"; CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); idreactive_medium = oTemplate_method_aa.Medium; idreactive_modif = oTemplate_method_aa.Modif; LstAllCalibs = oModCalibStd.GetCustomCalibStd(idelement, idmr_detail, idreactive_medium, idreactive_modif); gcCalibStd.DataSource = LstAllCalibs; gvCalibStd.ExpandAllGroups(); //oGroup_solution = oModCalibStd.GetMethodCalib(idelement, idmr_detail, idreactive_medium, idreactive_modif); CElement oElement = new CElementFactory() .GetByPrimaryKey(new CElementKeys(Convert.ToInt16(idelement))); ucTraceUser1.UserSign = Comun.GetUser(); ucTraceUser1.DateSign = Comun.GetDate(); }
private void tbPwd_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (tbPwd.Text.Length == 0) { btLock.ImageIndex = 0; } else { if (Comun.AreUserAndPwdRight(Comun.GetUser(), tbPwd.Text)) { btLock.ImageIndex = 1; OnSignPwd(true); } else { btLock.ImageIndex = 2; OnSignPwd(false); } } } }
private void treeAuthorization_CellValueChanged(object sender, DevExpress.XtraTreeList.CellValueChangedEventArgs e) { if (e.Column == gcDoc_Rank_valid_inmonth || e.Column == gcDoc_Prev_authorized) { DateTime fend = Convert.ToDateTime(e.Node.GetValue("Date_ini")).AddMonths(Convert.ToInt32(e.Node.GetValue("Rank_valid_inmonth"))); e.Node.SetValue("Date_end", fend); // --- save CDocumentationFactory faDocumentation = new CDocumentationFactory(); CDocumentation oDocumentation = faDocumentation .GetByPrimaryKey(new CDocumentationKeys(Convert.ToInt16(e.Node.GetValue("Iddocumentation")))); if (oDocumentation == null) { oDocumentation = new CDocumentation(); oDocumentation.Iddocumentation = 0; } oDocumentation.Idconfiguration_folder = Convert.ToInt16(e.Node.GetValue("Idconfiguration_folder")); if (e.Node.GetValue("Idtemplate_method") != null) { oDocumentation.Idtemplate_method = Convert.ToInt32(e.Node.GetValue("Idtemplate_method")); } oDocumentation.Image_index = Convert.ToInt32(e.Node.GetValue("Image_index")); oDocumentation.Name_doc = e.Node.GetValue("Name_doc").ToString(); oDocumentation.Procedure_type = Convert.ToChar(e.Node.GetValue("Procedure_type")); oDocumentation.Type_doc = Convert.ToChar(e.Node.GetValue("Type_doc")); oDocumentation.Flag_enabled = true; oDocumentation.Id = Convert.ToInt32(e.Node.GetValue("Id")); oDocumentation.Parentid = Convert.ToInt32(e.Node.GetValue("Parentid")); oDocumentation.Usernew = Comun.GetUser(); oDocumentation.Useredit = Comun.GetUser(); oDocumentation.Datenew = DateTime.Now; oDocumentation.Dateedit = DateTime.Now; oDocumentation.Status = true; treeAuthorization.DataSource = lstDocumentation_user_file; bool result = false; if (!(result = faDocumentation.Update(oDocumentation))) { result = faDocumentation.Insert(oDocumentation); } // --- Guardar acceso el usuario if (result) { CDocumentation_userFactory faDocumentation_user = new CDocumentation_userFactory(); CDocumentation_user oDocumentation_user = new CDocumentation_user(); List <CDocumentation_user> lst = faDocumentation_user.GetAll(); if (lst.Exists(c => c.Iddocumentation == oDocumentation.Iddocumentation && c.Iduser == Convert.ToInt16(cbUser.EditValue))) { oDocumentation_user = faDocumentation_user .GetAll() .Single(c => c.Iddocumentation == oDocumentation.Iddocumentation && c.Iduser == Convert.ToInt16(cbUser.EditValue)); } else { oDocumentation_user = new CDocumentation_user(); oDocumentation_user.Iddocumentation_user = 0; } oDocumentation_user.Iddocumentation = oDocumentation.Iddocumentation; oDocumentation_user.Date_ini = Convert.ToDateTime(e.Node.GetValue("Date_ini")); oDocumentation_user.Date_end = Convert.ToDateTime(e.Node.GetValue("Date_end")); oDocumentation_user.Rank_valid_inmonth = Convert.ToInt32(e.Node.GetValue("Rank_valid_inmonth")); oDocumentation_user.Prev_authorized = Convert.ToBoolean(e.Node.GetValue("Prev_authorized")); oDocumentation_user.Iduser = Convert.ToInt16(cbUser.EditValue); if (!faDocumentation_user.Update(oDocumentation_user)) { faDocumentation_user.Insert(oDocumentation_user); } } } }
bool SaveAA() { try { string Cod_method = gluCod_method.Text; string Title = tbTitle.Text; string messageOk = ""; Methods oMethods = new Methods(); Comun.MethodSaveProperty InspectionChanges = RequireNewVersionOrMethod(Comun.GetTypeAnalysis(Convert.ToChar(cbTypeAnalysis.EditValue))); if (InspectionChanges == Comun.MethodSaveProperty.NewMethod) { Num_version = 1; messageOk = "Se guardó un nuevo método con código " + Cod_method + "\ncon título " + Title; } if (InspectionChanges == Comun.MethodSaveProperty.InspectionNewVersion) { // --- save as new version or overwrite FormConfirmSaveMethod fmConfirmSaveMethod = new FormConfirmSaveMethod(true); if (fmConfirmSaveMethod.ShowDialog() == System.Windows.Forms.DialogResult.OK) { if (fmConfirmSaveMethod.SaveType == Comun.Save_type.SaveAs) { FormMethodSaveAs fmMethodSaveAs = new FormMethodSaveAs(); fmMethodSaveAs.ListTemplate = oMethods.GetAllLastVersionMethods( Convert.ToInt32(cbElement.EditValue), cbTypeSample.EditValue.ToString(), Convert.ToChar(cbTypeAnalysis.EditValue)); if (fmMethodSaveAs.ShowDialog() == System.Windows.Forms.DialogResult.OK) { Num_version = 1; IDTemplate_Method = 0; Cod_method = fmMethodSaveAs.Cod_method; Title = fmMethodSaveAs.Title; messageOk = "Se guardó un nuevo método con código " + fmMethodSaveAs.Cod_method + "\n con título '" + fmMethodSaveAs.Title + "'"; } else { return(false); } } if (fmConfirmSaveMethod.SaveType == Comun.Save_type.Save) { Num_version = oMethods.GetNumNewVersion(IDTemplate_Method); IDTemplate_Method = 0; messageOk = "Se guardó una nueva versión [" + Num_version.ToString() + "] del método " + Cod_method; } } else { return(false); } } if (InspectionChanges == Comun.MethodSaveProperty.InspectionNewMethod) { FormMethodSaveAs fmMethodSaveAs = new FormMethodSaveAs(); fmMethodSaveAs.ListTemplate = oMethods.GetAllLastVersionMethods( Convert.ToInt32(cbElement.EditValue), cbTypeSample.EditValue.ToString(), Convert.ToChar(cbTypeAnalysis.EditValue)); if (fmMethodSaveAs.ShowDialog() == System.Windows.Forms.DialogResult.OK) { Num_version = 1; IDTemplate_Method = 0; Cod_method = fmMethodSaveAs.Cod_method; Title = fmMethodSaveAs.Title; messageOk = "Se guardó un nuevo método con código " + fmMethodSaveAs.Cod_method + "\n con título " + fmMethodSaveAs.Title; } else { return(false); } } if (InspectionChanges == Comun.MethodSaveProperty.Nothing) { messageOk = "Se guardó correctamente"; } // --- save head CTemplate_methodFactory faTemplate_Method = new CTemplate_methodFactory(); CTemplate_method oTemplate_Method = new CTemplate_method(); oTemplate_Method.Idtemplate_method = IDTemplate_Method; oTemplate_Method.Num_version = Num_version; oTemplate_Method.Idelement = Convert.ToInt32(cbElement.EditValue); oTemplate_Method.Cod_template_method = Cod_method; oTemplate_Method.Title = Title; oTemplate_Method.Cod_digestion_method = cbDigestion.EditValue.ToString(); oTemplate_Method.Cod_repetition = Convert.ToInt16(cbRepetition.EditValue); oTemplate_Method.Abbreviation = tbAbreviation.Text; oTemplate_Method.Recognized = ckRecognized.Checked; oTemplate_Method.Cod_type_sample = cbTypeSample.EditValue.ToString(); oTemplate_Method.Cost_method = tbCost_Method.Value; oTemplate_Method.Type_analisys = Convert.ToChar(cbTypeAnalysis.EditValue); oTemplate_Method.Status = true; if (IDTemplate_Method == 0) { oTemplate_Method.Usernew = Comun.GetUser(); oTemplate_Method.Datenew = Comun.GetDate(); oTemplate_Method.Useredit = Comun.GetUser(); oTemplate_Method.Dateedit = Comun.GetDate(); } else { oTemplate_Method.Useredit = Comun.GetUser(); oTemplate_Method.Dateedit = Comun.GetDate(); } bool result_template_method = false; if (!(result_template_method = faTemplate_Method.Update(oTemplate_Method))) { result_template_method = faTemplate_Method.Insert(oTemplate_Method); } if (result_template_method) { IDTemplate_Method = oTemplate_Method.Idtemplate_method; SaveTypeAnalysis(); } FormResult fmResult = new FormResult(); fmResult.Message = messageOk; fmResult.ShowDialog(); gluCod_method.Text = Cod_method; return(true); } catch (Exception ex) { ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message); return(false); } }
public void Review() { try { CBatchFactory faBatch = new CBatchFactory(); CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch)); // --- save trace CRecep_sample_detail_elemFactory faRecep_sample_detail_elem = new CRecep_sample_detail_elemFactory(); for (int i = 0; i < ListSamples.Count; i++) { CBatch_detail_aa_twofold current_row = ListSamples[i]; int status_result = Convert.ToInt32(current_row.Qaqc_status_result); if (Convert.ToInt32(current_row.Flag_mri) == 0) { // --- set how accepted sample // Espera = 0, // Incorrecto = 1, // Plausible = 2, // Aceptado = 3, // IncorrectoPlausible = 4, // Espera reensayos = 5 // --- save only the accept samples long Idrecep_sample_detail_elem = Convert.ToInt64(current_row.Idrecep_sample_detail_elem); if (Convert.ToBoolean(oBatch.Flag_correct_mri) && Convert.ToBoolean(oBatch.Flag_correct_lrb)) { if (status_result == Convert.ToInt32(Comun.Status_result.Plausible)) { current_row.Qaqc_status_result = Convert.ToInt16(Comun.Status_result.Aceptado); } Qaqc oQaqc = new Qaqc(); if (!oQaqc.IsRetest(Idrecep_sample_detail_elem, Idbatch)) { // --- save final element law if (current_row.Qaqc_status_result == Convert.ToInt16(Comun.Status_result.Aceptado)) { CRecep_sample_detail_elem oRecep_sample_detail_elem = faRecep_sample_detail_elem.GetByPrimaryKey(new CRecep_sample_detail_elemKeys(Idrecep_sample_detail_elem)); oRecep_sample_detail_elem.Result_analysis = current_row.Result_analysis; oRecep_sample_detail_elem.Str_result_analysis = current_row.Str_result_analysis.ToString(); oRecep_sample_detail_elem.With_result = true; if (current_row.Str_result_analysis == null) { oRecep_sample_detail_elem.With_result = false; } faRecep_sample_detail_elem.Update(oRecep_sample_detail_elem); } CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory(); faBatch_detail_aa_twofold.Update(current_row); } else// --- es un reensayo { if (!oQaqc.ExistsResultPendingSel(Idrecep_sample_detail_elem, Idbatch)) { // --- si no está pendiente de seleccionar entre varios análisis // --- save final element law if (current_row.Qaqc_status_result == Convert.ToInt16(Comun.Status_result.Aceptado)) { CRecep_sample_detail_elem oRecep_sample_detail_elem = faRecep_sample_detail_elem.GetByPrimaryKey(new CRecep_sample_detail_elemKeys(Idrecep_sample_detail_elem)); oRecep_sample_detail_elem.Result_analysis = current_row.Result_analysis; oRecep_sample_detail_elem.Str_result_analysis = current_row.Str_result_analysis.ToString(); oRecep_sample_detail_elem.With_result = true; if (current_row.Str_result_analysis == null) { oRecep_sample_detail_elem.With_result = false; } faRecep_sample_detail_elem.Update(oRecep_sample_detail_elem); } CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory(); faBatch_detail_aa_twofold.Update(current_row); } } // --- save retest if (current_row.Qaqc_tmp_retest == 1) { string cod_type_sample = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(Convert.ToInt32(current_row.Idtemplate_method))).Cod_type_sample; CCorrelative oCorrelative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(cod_type_sample)); CBatchManager oBatchManager = new CBatchManager(); oBatchManager.CallSaveSampleBatchWithRetest( Convert.ToInt32(current_row.Idtemplate_method), Convert.ToInt64(current_row.Idrecep_sample), Convert.ToInt64(current_row.Idrecep_sample_detail), Convert.ToInt64(current_row.Idrecep_sample_detail_elem), Convert.ToInt64(current_row.Cod_interno), current_row.Cod_sample, Comun.GetUser(), oCorrelative, Convert.ToInt32(current_row.Qaqc_par), Idbatch); } // --- register as finished trace process CProcess_Sample_Manage.Finalize_process(Idrecep_sample_detail_elem, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS); } else { // --- the samples pertain to batch with full batch retest CProcess_Sample_Manage.Finalize_process(Idrecep_sample_detail_elem, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS); } } } // --- modify the batch status, put in other process CProcess oProcess = new CProcessFactory().GetByPrimaryKey(new CProcessKeys(LimsProcess.PROCESS_ACCEPT_RESULTS)); oBatch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting); oBatch.Cod_module = oProcess.Cod_module; oBatch.Cod_area = oProcess.Cod_area; oBatch.Cod_process = LimsProcess.PROCESS_ACCEPT_RESULTS; oBatch.User_review_tray = Comun.GetUser(); oBatch.Date_review_tray = Comun.GetDate(); faBatch.Update(oBatch); // --- register as finished trace batch Cprocess_Batch_Manage.Finalize_process(Idbatch, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS); } catch (Exception ex) { Comun.Save_log(ex.InnerException.ToString()); throw new Exception("pivot data::approve::Error occured.", ex); } }
private void gvPrepSample_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column == gcol_Weight_gross) { // actualizar fecha entrada y usuario CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; oPrep_sample.Weight_gross_date = Comun.GetDate(); oPrep_sample.Weight_gross_user = Comun.GetUser(); SetComplete(oPrep_sample); new CPrep_samplesFactory().Update(oPrep_sample); } else if (e.Column == gcol_Weight_moisture) { // actualizar fecha de peso húmedo y usuario CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; if (oPrep_sample.Weight_moisture != null && oPrep_sample.Weight_dry != null && oPrep_sample.Weight_dry > 0 && oPrep_sample.Weight_moisture > 0) { oPrep_sample.Percent_moisture = Math.Round(Convert.ToDecimal((oPrep_sample.Weight_moisture - oPrep_sample.Weight_dry) / oPrep_sample.Weight_moisture), 2); } oPrep_sample.Weight_moisture_date = Comun.GetDate(); oPrep_sample.Weight_moisture_user = Comun.GetUser(); SetComplete(oPrep_sample); new CPrep_samplesFactory().Update(oPrep_sample); } else if (e.Column == gcol_Weight_dry) { // actualizar fecha de peso seco y usuario y calcular la humedad CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; if (oPrep_sample.Weight_moisture != null && oPrep_sample.Weight_dry != null && oPrep_sample.Weight_dry > 0 && oPrep_sample.Weight_moisture > 0) { oPrep_sample.Percent_moisture = Math.Round(Convert.ToDecimal((oPrep_sample.Weight_moisture - oPrep_sample.Weight_dry) / oPrep_sample.Weight_moisture), 2); oPrep_sample.Weight_dry_date = Comun.GetDate(); oPrep_sample.Weight_dry_user = Comun.GetUser(); SetComplete(oPrep_sample); new CPrep_samplesFactory().Update(oPrep_sample); } } else if (e.Column == gcol_Weight_gross_reject) { // actualizar fecha de rechazo y usuario CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; oPrep_sample.Weight_gross_reject_date = Comun.GetDate(); oPrep_sample.Weight_gross_reject_user = Comun.GetUser(); SetComplete(oPrep_sample); new CPrep_samplesFactory().Update(oPrep_sample); } else if (e.Column == gcol_Moisture_reject) { // actualizar fecha, usuario de humedad CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; oPrep_sample.Moisture_reject_date = Comun.GetDate(); oPrep_sample.Moisture_reject_user = Comun.GetUser(); SetComplete(oPrep_sample); new CPrep_samplesFactory().Update(oPrep_sample); } else if (e.Column == gcol_Output_flag_sample) { // actualizar fecha, usuario en salida de muestra CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; oPrep_sample.Output_date_sample = Comun.GetDate(); oPrep_sample.Output_user_sample = Comun.GetUser(); SetComplete(oPrep_sample); new CPrep_samplesFactory().Update(oPrep_sample); } else if (e.Column == gcol_Output_flag_cs) { // actualizar fecha, usuario en salida de contramuestra CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; oPrep_sample.Output_date_cs = Comun.GetDate(); oPrep_sample.Output_user_cs = Comun.GetUser(); SetComplete(oPrep_sample); new CPrep_samplesFactory().Update(oPrep_sample); } else if (e.Column == gcol_Output_flag_re) { // actualizar fecha, usuario en salida de contramuestra CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; oPrep_sample.Output_date_re = Comun.GetDate(); oPrep_sample.Output_user_re = Comun.GetUser(); SetComplete(oPrep_sample); new CPrep_samplesFactory().Update(oPrep_sample); } else if (e.Column == gcol_Observation1 || e.Column == gcol_Observation2) { CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples; new CPrep_samplesFactory().Update(oPrep_sample); } }
public void SaveCalibs(CSolution_interm pSolution_interm) { solution_interm = pSolution_interm; Date_init = Convert.ToDateTime(solution_interm.Date_begin); Date_end = Convert.ToDateTime(solution_interm.Date_end); UserSign = Comun.GetUser(); DateSign = Comun.GetDate(); //poner como historico la actual grupo de calibraciones CSet_calibs oSet_calib = oModCalibStd.GetSet_CalibBy(solution_interm.Idsolution_interm, idtemplate_method); if (oSet_calib != null) { oSet_calib.Last_calib = false; new CSet_calibsFactory().Update(oSet_calib); } // --- guardar la nueva calibración oSet_calib = new CSet_calibs(); oSet_calib.Idset_calibs = 0; oSet_calib.Idtemplate_method = idtemplate_method; oSet_calib.Idsolution_interm = solution_interm.Idsolution_interm; oSet_calib.Datesign = Comun.GetDate(); oSet_calib.Usersign = Comun.GetUser(); oSet_calib.Last_calib = true; bool result_set_calib = new CSet_calibsFactory().Insert(oSet_calib); // --- guardar estandares de calibración if (result_set_calib) { for (int i = 0; i < gvCalibStd.RowCount; i++) { CSet_calibsFactory faSet_calibs = new CSet_calibsFactory(); CCustomCalibStd customCalibStd = gvCalibStd.GetRow(i) as CCustomCalibStd; // --- guardar calibración CCalib_stdFactory faCalib_std = new CCalib_stdFactory(); CCalib_std oCalib_std = new CCalib_std(); oCalib_std = new CCalib_std(); oCalib_std.Idcalib = customCalibStd.Idcalib; oCalib_std.Absorbance = customCalibStd.Absorbance; oCalib_std.Concentration = customCalibStd.Concentration; oCalib_std.Idset_calibs = oSet_calib.Idset_calibs; oCalib_std.Idsolution_interm = solution_interm.Idsolution_interm; oCalib_std.Idtemplate_method = idtemplate_method; bool result_std = false; if (!(result_std = faCalib_std.Update(oCalib_std))) { result_std = faCalib_std.Insert(oCalib_std); } if (result_std) { gvCalibStd.SetRowCellValue(i, gcCal_Idcalib_std, oCalib_std.Idcalib_std); } } } }
void AddChildNode() { // --- if (treeAuthorization.FocusedNode.Level == 0) { CDocumentation_User_File oDocUserFile = new CDocumentation_User_File { Iddocumentation = -1, Idtemplate_method = null, Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue), Name_doc = "Adjunto", Procedure_type = Convert.ToChar(cbProcedure.EditValue), Type_doc = 'E', Id = GetNewIdNode(), Image_index = 1, Parentid = Convert.ToInt32(treeAuthorization.FocusedNode["Id"]), Date_ini = DateTime.Now, Date_end = DateTime.Now.AddMonths(12), Rank_valid_inmonth = 12, Prev_authorized = false }; lstDocumentation_user_file.Add(oDocUserFile); // --- save CDocumentationFactory faDocumentation = new CDocumentationFactory(); CDocumentation oDocumentation = new CDocumentation(); oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation; oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder; oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method; oDocumentation.Image_index = oDocUserFile.Image_index; oDocumentation.Name_doc = oDocUserFile.Name_doc; oDocumentation.Procedure_type = oDocUserFile.Procedure_type; oDocumentation.Type_doc = oDocUserFile.Type_doc; oDocumentation.Flag_enabled = true; oDocumentation.Id = oDocUserFile.Id; oDocumentation.Parentid = oDocUserFile.Parentid; oDocumentation.Usernew = Comun.GetUser(); oDocumentation.Useredit = Comun.GetUser(); oDocumentation.Datenew = DateTime.Now; oDocumentation.Dateedit = DateTime.Now; oDocumentation.Status = true; treeAuthorization.DataSource = lstDocumentation_user_file; //faDocumentation.Insert(oDocumentation); treeAuthorization.DataSource = lstDocumentation_user_file; treeAuthorization.FocusedNode.ExpandAll(); } else if (treeAuthorization.FocusedNode.Level == 1) { CDocumentation_User_File oDocUserFile = new CDocumentation_User_File { Iddocumentation = -1, Idtemplate_method = null, Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue), Procedure_type = Convert.ToChar(cbProcedure.EditValue), Type_doc = 'E', Id = GetNewIdNode(), Image_index = 1, Parentid = Convert.ToInt32(treeAuthorization.FocusedNode.ParentNode["Id"]), Date_ini = DateTime.Now, Date_end = DateTime.Now.AddMonths(12), Rank_valid_inmonth = 12, Prev_authorized = false }; lstDocumentation_user_file.Add(oDocUserFile); // --- save CDocumentationFactory faDocumentation = new CDocumentationFactory(); CDocumentation oDocumentation = new CDocumentation(); oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation; oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder; oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method; oDocumentation.Image_index = oDocUserFile.Image_index; oDocumentation.Name_doc = oDocUserFile.Name_doc; oDocumentation.Procedure_type = oDocUserFile.Procedure_type; oDocumentation.Type_doc = oDocUserFile.Type_doc; oDocumentation.Flag_enabled = true; oDocumentation.Id = oDocUserFile.Id; oDocumentation.Parentid = oDocUserFile.Parentid; oDocumentation.Usernew = Comun.GetUser(); oDocumentation.Useredit = Comun.GetUser(); oDocumentation.Datenew = DateTime.Now; oDocumentation.Dateedit = DateTime.Now; oDocumentation.Status = true; treeAuthorization.DataSource = lstDocumentation_user_file; //faDocumentation.Insert(oDocumentation); } }