private void OpenSettingsForm() { if (isStop) { FrmSetting frmst = new FrmSetting(); frmst.Show(); } }
private void btSetting_Click(object sender, EventArgs e) { Timer.Enabled = false; var f = new FrmSetting(); f.ShowDialog(); Setting = f.ReturnSetting; btnClock_Click(sender, e); }
private void btnSetting_Click(object sender, EventArgs e) { pnMain.Controls.Clear(); FrmSetting frmSetting = new FrmSetting(); frmSetting.TopLevel = false; pnMain.Controls.Add(frmSetting); frmSetting.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None; frmSetting.Dock = DockStyle.Fill; frmSetting.Show(); }
public static void ImportExcel(FrmSetting _FrmSetting, string fileName) { EGOEntities EGOEntities = new EGOEntities(); _FrmSetting.label1.Text = "Suppression des tables"; Database.Drop(); _FrmSetting.label1.Text = "Création des tables"; Database.Create(); List <ExcelModel> ExcelModels = CreateExcelObject(_FrmSetting, fileName); _FrmSetting.label1.Text = "Insertion des données"; CreatePerson(ExcelModels, EGOEntities, _FrmSetting); }
private void ShowConfig(object sender, EventArgs e) { if (_configWindow == null) { _configWindow = new FrmSetting(); } // If we are already showing the window meerly focus it. if (_configWindow.Visible) { _configWindow.Focus(); } else { _configWindow.ShowDialog(); } }
public FrmUdHoc() { ck = BaiHocDao.Instance.Checkdb(); if (!ck) { FrmSetting frm = new FrmSetting(); frm.AddServer += frm_OK; frm.FormClosed += new FormClosedEventHandler(frm_Close); frm.ShowDialog(); } else { InitializeComponent(); UserLookAndFeel.Default.SkinName = Settings.Default["ApplicationSkinName"].ToString(); InitSkinGallery(); WebCome(); } }
/// <summary> /// 打开参数设置界面 /// </summary> public void OpenSetting() { FrmSetting frm = new FrmSetting(); frm.ShowDialog(); }
Form NewForm(string tag) { Form frm = null; switch (tag) { case "本机设置": FrmOptions frmOptions = new FrmOptions(); frmOptions.ShowDialog(); break; #region 收货管理 case "到货登记": frm = new FrmVehicle(); break; case "送货牌列表": frm = new FrmListCard(); break; case "托盘状态表": frm = new FrmContainerState(); break; case "收货单管理": frm = new FrmAsnManage(); break; case "越库收货": frm = new FrmCrossInstore(); break; case "越库收货确认": frm = new FrmCrossInstoreConfirm(); break; case "退货单管理": //Add by ZXQ 20150525 frm = new FrmReturnManage(); break; #endregion #region 销货管理 case "出库单管理": frm = new FrmSOManage(); break; case "订单排序": frm = new FrmSOSort(); break; case "订单排序(地图)": frm = new Nodes.Outstore.FrmSOSortMap(); break; case "订单排序查询": frm = new FrmSOSortMapQuery(); break; case "拣货计划": frm = new FrmPickPlans(); break; case "拣货任务管理": frm = new FrmPickTaskManager(); break; case "物流箱状态表": frm = new FrmSOLPNState(); break; case "散货称重": frm = new FrmSOWeight(); break; case "装车称重": frm = new FrmSOWeightLoading(); break; case "打印销售发货单": frm = new FrmSOLoading(); break; case "打印销售发货单(新)": frm = new FrmSOLoadingNew(); break; case "回款确认": frm = new FrmBackConfirm(); break; case "车次信息": frm = new FrmLoadingTrain(); break; case "装车信息": frm = new FrmLoadingInfo(); break; case "整货称重[简化]": frm = new FrmSOWeightLoading_Simple(); break; case "越库出库": frm = new FrmAcrossOutbound(); break; case "订单线路查询": frm = new FrmSOSortQuery(); break; case "当前订单量": frm = new FrmShowNeedSKU(); break; #endregion #region 库内管理 case "触发补货任务": frm = new FrmCreateReplenishBill(); break; case "库存查询": frm = new FrmStockQuery(); break; case "待称重集货区查询": frm = new FrmStockTemp(); break; case "库存转移": frm = new FrmStockTransfer(); break; case "移库记录表": frm = new FrmStockTransferQuery(); break; #endregion #region 盘点管理 case "创建盘点单": frm = new FrmCreateCC(); break; case "盘点差异报告": frm = new FrmCountManager(); break; case "盘点单管理": frm = new FrmCountManager(); break; case "盘点差异调整": frm = new FrmCountExecute(); break; case "盘点任务分派": frm = new FrmCountTask(); break; #endregion #region 系统管理 case "用户管理": frm = new FrmUserManager(); break; case "角色管理": frm = new FrmRoleManager(); break; case "公司信息": frm = new FrmCompanyManager(); break; case "条码规则定义": frm = new FrmBarcodeDefine(); break; case "系统设置": frm = new FrmSetting(); break; case "任务池管理": frm = new FrmTaskManager(); break; case "任务池管理(新)": frm = new FrmTaskManagerNew(); break; case "人员状态表": frm = new FrmUserState(); break; case "叫号面板": frm = new FrmCallingScreen(); break; #endregion #region 查询统计 case "库存对账查询": frm = new FrmStockAccount(); break; case "库存流水查询": frm = new FrmStockLog(); break; case "装车记录查询": frm = new FrmLoadRecords(); break; case "任务调度统计": frm = new FrmTaskReport(); break; case "商品销量统计": frm = new Reports.FrmSaleSort(); break; case "拣货记录表": frm = new FrmQueryPickRecords(); break; case "销货明细": frm = new FrmQuerySoDetails(); break; case "叉车司机任务统计": frm = new FrmQueryTransRecord(); break; case "收货绩效考核": frm = new FrmQueryAsnRecord(); break; case "装车绩效考核": frm = new FrmQueryLoadingReports2(); break; case "库房人员绩效汇总": frm = new FrmSummaryRecords2(); break; case "容器位查询": frm = new FrmContainerQuery(); break; case "容器位维护": frm = new FrmContainerLocatiomManager(); break; #endregion #region 基础管理 case "送货牌维护": frm = new FrmDriverCardManager(); break; case "客户信息": frm = new FrmCustomerManager(); break; case "仓库信息": frm = new FrmWarehouseManager(); break; case "货区信息": frm = new FrmZoneManager(); break; case "货位信息": frm = new FrmLocationManager(); break; case "物料分类": frm = new FrmMaterialTypeManager(); break; case "包装关系": frm = new FrmUnitGroupManager(); break; case "物料信息": frm = new FrmMaterialManager(); break; case "区域信息": frm = new FrmAreaManager(); break; case "品牌信息": frm = new FrmBrandManager(); break; case "不合格原因": frm = new FrmBugReasonManager(); break; case "容器信息": frm = new FrmContainerManager(); break; case "送货路线": frm = new FrmRouteManager(); break; case "叉车信息": frm = new FrmForkManager(); break; case "车辆信息": frm = new FrmVehicleManager(); break; case "推荐货位": frm = new FrmReclocationManager(); break; case "本库物料": frm = new FrmSkuWarehouseQuery(); break; #endregion case "权限管理": frm = new FrmModulesManager(); break; case "登录日志": frm = new FrmLoginLogs(); break; case "计量单位信息": frm = new FrmUnitManager(); break; case "供应商信息": frm = new FrmSupplierManager(); break; case "省份信息": frm = new FrmProvinceManager(); break; case "组织信息": frm = new FrmOrgManager(); break; case "温控信息": frm = new FrmTemperatureManager(); break; case "手持机维护": frm = new FrmPDAManager(); break; case "关联物流箱": frm = new FrmScanContainer(); break; case "修改密码": FrmChangePwd frmChangePwd = new FrmChangePwd(); frmChangePwd.ShowDialog(); break; case "商品销量": frm = new Nodes.Outstore.FrmSaleSort(); break; case "上架记录查询": frm = new FrmReportPutAway(); break; case "拣货员任务统计": frm = new FrmPickSort(); break; case "绩效考核指标": frm = new FrmPerformanceAppraisal(); break; case "配送绩效考核": frm = new FrmQueryDriverRecords(); break; //case "库存占用管理": // frm = new FrmStockOccupyManager(); // break; case "退出系统": this.Close(); break; case "帮助文档": string helpfile = AppDomain.CurrentDomain.BaseDirectory.ToString() + @"\使用手册.chm"; if (File.Exists(helpfile)) { Help.ShowHelp(this, helpfile); } else { MsgBox.Warn("无法找到相关文件,请联系技术人员!"); } break; case "货位盘点记录": frm = new FrmStockReviseRecords(); break; case "货位盘点": frm = new FrmStockReviseRecords(); break; } return(frm); }
/// <summary> /// 打开参数设置界面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOpenSetting_Click(object sender, EventArgs e) { FrmSetting frm = new FrmSetting(); frm.ShowDialog(); }
private static void CreatePerson(List <ExcelModel> _ExcelModel, EGOEntities _EGOEntities, FrmSetting _FrmSetting) { _FrmSetting.progressBar.Value = 0; _FrmSetting.progressBar.Maximum = _ExcelModel.Count; int i = 0; try { foreach (var ExcelModel in _ExcelModel) { i++; _FrmSetting.label1.Text = "Création de l'adhérent:" + ExcelModel.NOM + " " + ExcelModel.PRENOM + i + "/" + _ExcelModel.Count; _FrmSetting.label1.Refresh(); _FrmSetting.progressBar.Value = i; _FrmSetting.progressBar.Refresh(); FAMILY Family; if (!_EGOEntities.FAMILY.Any(x => x.LASTNAME == ExcelModel.NOM && x.ZIPCODE == ExcelModel.CP)) { Family = CreateFamily(ExcelModel, _EGOEntities); } else { Family = _EGOEntities.FAMILY.First(x => x.LASTNAME == ExcelModel.NOM && x.ZIPCODE == ExcelModel.CP); } PERSON Person = new PERSON(); Person.FAMILYID = Family.FAMILYID; Person.LASTNAME = ExcelModel.NOM.ToUpper(); Person.FIRSTNAME = ExcelModel.PRENOM.ToUpper(); Person.BIRTHDATE = ExcelModel.NEELE; Person.HOURLYRATE = 0; _EGOEntities.PERSON.Add(Person); GYMGROUP GymGroup; if (!_EGOEntities.GYMGROUP.Any(x => x.GYMGROUPNAME == ExcelModel.GROUPE)) { GymGroup = CreateGymGroup(ExcelModel, _EGOEntities); } else { GymGroup = _EGOEntities.GYMGROUP.First(x => x.GYMGROUPNAME == ExcelModel.GROUPE); } PERSON_GYMGROUP Person_GymGroup = new PERSON_GYMGROUP(); Person_GymGroup.GYMGROUPID = GymGroup.GYMGROUPID; Person_GymGroup.PERSONID = Person.PERSONID; Person_GymGroup.KINDID = 1; _EGOEntities.PERSON_GYMGROUP.Add(Person_GymGroup); if (!_EGOEntities.PHONE.Any(x => x.FAMILYID == Family.FAMILYID && x.PHONENUMBER == ExcelModel.TELEPHONE)) { PHONE Phone = new PHONE(); Phone.FAMILYID = Family.FAMILYID; Phone.PHONENUMBER = ExcelModel.TELEPHONE; _EGOEntities.PHONE.Add(Phone); } if (!_EGOEntities.PHONE.Any(x => x.FAMILYID == Family.FAMILYID && x.PHONENUMBER == ExcelModel.PORTABLE)) { PHONE Phone = new PHONE(); Phone.FAMILYID = Family.FAMILYID; Phone.PHONENUMBER = ExcelModel.PORTABLE; _EGOEntities.PHONE.Add(Phone); } DOCUMENT Document; if (ExcelModel.FICHE) { Document = new DOCUMENT(); Document.DOCUMENTTYPEID = 1; Document.PERSONID = Person.PERSONID; Document.DOCUMENTYEAR = Common.CurrentStartYear(); _EGOEntities.DOCUMENT.Add(Document); } if (ExcelModel.AUTPAR) { Document = new DOCUMENT(); Document.DOCUMENTTYPEID = 2; Document.PERSONID = Person.PERSONID; Document.DOCUMENTYEAR = Common.CurrentStartYear(); _EGOEntities.DOCUMENT.Add(Document); } if (ExcelModel.PHOTO) { Document = new DOCUMENT(); Document.DOCUMENTTYPEID = 3; Document.PERSONID = Person.PERSONID; Document.DOCUMENTYEAR = Common.CurrentStartYear(); _EGOEntities.DOCUMENT.Add(Document); } if (ExcelModel.CM) { Document = new DOCUMENT(); Document.DOCUMENTTYPEID = 4; Document.PERSONID = Person.PERSONID; Document.DOCUMENTYEAR = Common.CurrentStartYear(); _EGOEntities.DOCUMENT.Add(Document); } PAYMENT Payment; if (ExcelModel.ECH1MONTANT != 0) { Payment = new PAYMENT(); if (ExcelModel.ECH1NUMCHEQUE != 0) { Payment.PAYMENTTYPEID = 2; } else { Payment.PAYMENTTYPEID = 1; } Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("30/09/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH1NUMCHEQUE; Payment.AMOUNT = ExcelModel.ECH1MONTANT; _EGOEntities.PAYMENT.Add(Payment); } if (ExcelModel.ECH2MONTANT != 0) { Payment = new PAYMENT(); if (ExcelModel.ECH2NUMCHEQUE != 0) { Payment.PAYMENTTYPEID = 2; } else { Payment.PAYMENTTYPEID = 1; } Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("30/11/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH2NUMCHEQUE; Payment.AMOUNT = ExcelModel.ECH2MONTANT; _EGOEntities.PAYMENT.Add(Payment); } if (ExcelModel.ECH3MONTANT != 0) { Payment = new PAYMENT(); if (ExcelModel.ECH3NUMCHEQUE != 0) { Payment.PAYMENTTYPEID = 2; } else { Payment.PAYMENTTYPEID = 1; } Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("28/02/2021", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH3NUMCHEQUE; Payment.AMOUNT = ExcelModel.ECH3MONTANT; _EGOEntities.PAYMENT.Add(Payment); } if (ExcelModel.ECH4MONTANT != 0) { Payment = new PAYMENT(); if (ExcelModel.ECH4NUMCHEQUE != 0) { Payment.PAYMENTTYPEID = 2; } else { Payment.PAYMENTTYPEID = 1; } Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("30/04/2021", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH4NUMCHEQUE; Payment.AMOUNT = ExcelModel.ECH4MONTANT; _EGOEntities.PAYMENT.Add(Payment); } if (ExcelModel.COTISLICENCE != 0) { Payment = new PAYMENT(); Payment.PAYMENTTYPEID = 2; Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("28/09/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH4NUMCHEQUE; Payment.AMOUNT = ExcelModel.COTISLICENCE; _EGOEntities.PAYMENT.Add(Payment); } if (!ExcelModel.Nouvelle) { DISCOUNT Discount = new DISCOUNT(); Discount.FAMILYID = Family.FAMILYID; Discount.DISCOUNTYEAR = Common.CurrentStartYear(); Discount.DESCRIPTION = "Cotisation"; Discount.AMOUNT = 35; _EGOEntities.DISCOUNT.Add(Discount); Discount = new DISCOUNT(); Discount.FAMILYID = Family.FAMILYID; Discount.DISCOUNTYEAR = Common.CurrentStartYear(); Discount.DESCRIPTION = "Ancienneté"; Discount.AMOUNT = ExcelModel.REDUCANCIEN; _EGOEntities.DISCOUNT.Add(Discount); } _EGOEntities.SaveChanges(); } _FrmSetting.label1.Text = "Création des réductions familiales"; CreateFamilyDiscount(_EGOEntities); _EGOEntities.SaveChanges(); _FrmSetting.label1.Text = "Fin"; _FrmSetting.progressBar.Value = 0; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private static List <ExcelModel> CreateExcelObject(FrmSetting _FrmSetting, string fileName) { List <ExcelModel> ExcelModels = new List <ExcelModel>(); Excel.Application xlApp = new Excel.Application(); Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(fileName); Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[2]; Excel.Range xlRange = xlWorksheet.UsedRange; int rowCount = xlRange.Rows.Count; _FrmSetting.progressBar.Value = 0; _FrmSetting.progressBar.Maximum = rowCount; for (int i = 2; i <= rowCount; i++) { _FrmSetting.label1.Text = "Lecture du fichier excel - " + i + "/" + rowCount; _FrmSetting.progressBar.Value = i; _FrmSetting.progressBar.Refresh(); ExcelModel ExcelModel = new ExcelModel(); int col = 1; ExcelModel.GROUPE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.RGLTDUTT = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.REDUCANCIEN = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.NOM = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.PRENOM = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.NEELE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? DateTime.ParseExact(xlRange.Cells[i, col].Value.ToString().Substring(0, 10), "dd/MM/yyyy", CultureInfo.InvariantCulture) : new DateTime(); col++; ExcelModel.ADRESSE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.CP = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.VILLE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.TELEPHONE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.PORTABLE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.EMAIL = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; col++; ExcelModel.FICHE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() == "X" ? true : false; col++; ExcelModel.AUTPAR = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() == "X" ? true : false; col++; ExcelModel.CM = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() == "X" ? true : false; col++; ExcelModel.PHOTO = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() == "X" ? true : false; col++; ExcelModel.Nouvelle = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() == "X" ? true : false; col++; ExcelModel.RGLTDU = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; col++; ExcelModel.ECH1NUMCHEQUE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToInt32(xlRange.Cells[i, col].Value.ToString()) : Convert.ToInt32(0); col++; ExcelModel.ECH1MONTANT = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.ECH2NUMCHEQUE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToInt32(xlRange.Cells[i, col].Value.ToString().Replace(",", ".")) : Convert.ToInt32(0); col++; ExcelModel.ECH2MONTANT = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.ECH3NUMCHEQUE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToInt32(xlRange.Cells[i, col].Value.ToString()) : Convert.ToInt32(0); col++; ExcelModel.ECH3MONTANT = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.ECH4NUMCHEQUE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToInt32(xlRange.Cells[i, col].Value.ToString()) : Convert.ToInt32(0); col++; ExcelModel.ECH4MONTANT = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.COTISLICENCE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.MONTANTPAYE = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.ECART = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.REDUC = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value != null && xlRange.Cells[i, col].Value.ToString() != string.Empty ? Convert.ToSingle(xlRange.Cells[i, col].Value.ToString()) : Convert.ToSingle(0); col++; ExcelModel.Remarque = xlRange.Cells[i, col] != null && xlRange.Cells[i, col].Value != null ? xlRange.Cells[i, col].Value.ToString() : string.Empty; ExcelModels.Add(ExcelModel); } GC.Collect(); GC.WaitForPendingFinalizers(); Marshal.ReleaseComObject(xlRange); Marshal.ReleaseComObject(xlWorksheet); xlWorkbook.Close(); Marshal.ReleaseComObject(xlWorkbook); xlApp.Quit(); Marshal.ReleaseComObject(xlApp); return(ExcelModels); }