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);
}
