/// <summary> /// 确认(调整导入)收款记录 /// </summary> /// <param name="settleEntity"></param> /// <returns></returns> public static SettleEntity ApproveCollectList(SettleEntity settleEntity) { //liquidateEntity.LogMessages.MsgType = MessageType.INFO; //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select"; //LoggerHelper.LogWriter(liquidateEntity.LogMessages); try { return SettleDA.ApproveCollectList(settleEntity); } catch (Exception ex) { //liquidateEntity.LogMessages.MsgType = MessageType.ERROR; //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select Error: " + ex.Message; //LoggerHelper.LogWriter(liquidateEntity.LogMessages); throw ex; } }
/// <summary> /// 批量导入收款记录 /// </summary> /// <param name="settleEntity"></param> /// <returns></returns> public static SettleEntity ImportCollectList(SettleEntity settleEntity) { //liquidateEntity.LogMessages.MsgType = MessageType.INFO; //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select"; //LoggerHelper.LogWriter(liquidateEntity.LogMessages); try { //if (String.IsNullOrEmpty(PhoneFlUpload.FileName)) //{ // return ""; //} //StringBuilder sbPhonelist = new StringBuilder(); //string fileName = Guid.NewGuid().ToString() + System.IO.Path.GetExtension(PhoneFlUpload.FileName);// OrderFlUpload.FileName.Substring(OrderFlUpload.FileName.IndexOf('.')); //获取文件名 //string folder = Server.MapPath("../Excel"); //if (!Directory.Exists(folder)) // Directory.CreateDirectory(folder); //PhoneFlUpload.SaveAs(Server.MapPath("../Excel" + "\\" + fileName)); //上传文件到Excel文件夹下 SettleDBEntity dbParm = (settleEntity.SettleDBEntity.Count > 0) ? settleEntity.SettleDBEntity[0] : new SettleDBEntity(); DataTable dtImport = new DataTable(); if ("0".Equals(dbParm.ImportType)) { dtImport = LoadExcelToDataTable(System.Web.HttpContext.Current.Server.MapPath(@"~\SettleUploadExcel\" + dbParm.UploadFileName)); if (dtImport.Rows.Count < 10) { settleEntity.Result = 0; return settleEntity; } for (int i = 0; i < 10; i++) { dtImport.Rows.RemoveAt(i); } dtImport.AcceptChanges(); } else { for (int i=0; i < 14; i++) { dtImport.Columns.Add("col" + i.ToString()); } DataRow drRow = dtImport.NewRow(); drRow[5] = dbParm.IntoAmount; drRow[8] = dbParm.PayName; drRow[10] = dbParm.Summary; drRow[11] = dbParm.Remark; dtImport.Rows.Add(drRow); } settleEntity.SettleDBEntity[0].TotalUploadCount = (dtImport.Rows.Count - 9).ToString(); settleEntity.SettleDBEntity[0].UpLoadList = dtImport; return SettleDA.ImportCollectList(settleEntity); } catch (Exception ex) { //liquidateEntity.LogMessages.MsgType = MessageType.ERROR; //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select Error: " + ex.Message; //LoggerHelper.LogWriter(liquidateEntity.LogMessages); throw ex; } }