public static SettleEntity ApproveAutoCompleteCollectList(SettleEntity settleEntity) { SettleDBEntity dbParm = (settleEntity.SettleDBEntity.Count > 0) ? settleEntity.SettleDBEntity[0] : new SettleDBEntity(); DataCommand Cmd = DataCommandManager.GetDataCommand("GetAutoCompleteCollectList"); Cmd.SetParameterValue("@COLLECTID", dbParm.CollectID); DataSet dsResult = Cmd.ExecuteDataSet(); if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { return settleEntity; } string[] flMatch = new string[2]; foreach (DataRow drRow in dsResult.Tables[0].Rows) { // 追加自动筛选匹配逻辑 // 筛选匹配值 已账单ID + '|'风格 例如:001|030|012|422 // 筛选匹配状态 0100 已0和1表示是否匹配 flMatch = GetWriteOffAutoCompleteVal(drRow["WRITEOFFID"].ToString(), dbParm.CollectID); DataCommand unitCmd = DataCommandManager.GetDataCommand("UpdateAutoCompleteCollectList"); unitCmd.SetParameterValue("@COLLECTID", dbParm.CollectID); unitCmd.SetParameterValue("@WRITEOFFID", drRow[0].ToString()); unitCmd.SetParameterValue("@FILTERMATCHID", flMatch[0]); unitCmd.SetParameterValue("@FILTERMATCHSTATUS", flMatch[1]); unitCmd.ExecuteNonQuery(); } return settleEntity; }
/// <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; } }
//public static SettleEntity AddCollectItem(SettleEntity settleEntity) //{ // DataCommand unitCmd = DataCommandManager.GetDataCommand("AddCollectItem"); // //unitCmd.SetParameterValue("@", dbParm.); // //unitCmd.SetParameterValue("@", dbParm.); // //unitCmd.SetParameterValue("@", dbParm.); // //unitCmd.SetParameterValue("@", dbParm.); // //unitCmd.SetParameterValue("@", dbParm.); // settleEntity.Result = unitCmd.ExecuteNonQuery(); // return settleEntity; //} public static SettleEntity ApproveCollectList(SettleEntity settleEntity) { SettleDBEntity dbParm = (settleEntity.SettleDBEntity.Count > 0) ? settleEntity.SettleDBEntity[0] : new SettleDBEntity(); string strErr = string.Empty; // 0: 批量导入 1: 手工导入 if ("0".Equals(dbParm.ImportActionType)) { // 初次导入上传信息 只需要判断是否有重复导入 //CheckWriteOffReset foreach (DataRow drRow in dbParm.ImportList.Rows) { strErr = CheckWriteOffReset(drRow[0].ToString(), dbParm.CollectID); if (!String.IsNullOrEmpty(strErr)) { settleEntity.ErrorMSG = settleEntity.ErrorMSG + strErr; } } if (!String.IsNullOrEmpty(settleEntity.ErrorMSG)) { settleEntity.ErrorMSG = "下列收款记录已经导入,请修改。" + "<br/>" + settleEntity.ErrorMSG; settleEntity.Result = 2; return settleEntity; } } else { // 调整导入 判断 当去除勾选 需判断这笔回款是否已经被销账。已销账就不可去除。 状态=2 为已经销账 0:导入 1:销账 // 当勾选 需判断是否有重复导入 有重复导入不可再导入。 // 页面做处理,传值过来的数据,仅仅为在 页面上数据状态变化的数据。没有变化的数据不要传递。 foreach (DataRow drRow in dbParm.ImportList.Rows) { // 状态 1 - > 0 只需判断是否销账 if ("0".Equals(drRow[1].ToString())) { strErr = CheckWriteOffDetail(drRow[0].ToString(), dbParm.CollectID); if (!String.IsNullOrEmpty(strErr)) { settleEntity.ErrorMSG = settleEntity.ErrorMSG + "已销账不能重新调整:" + strErr; } } else { strErr = CheckWriteOffReset(drRow[0].ToString(), dbParm.CollectID); if (!String.IsNullOrEmpty(strErr)) { settleEntity.ErrorMSG = settleEntity.ErrorMSG + "重复导入:" + strErr; } } } if (!String.IsNullOrEmpty(settleEntity.ErrorMSG)) { settleEntity.Result = 2; return settleEntity; } } foreach (DataRow drRow in dbParm.ImportList.Rows) { DataCommand unitCmd = DataCommandManager.GetDataCommand("ApproveCollectList"); unitCmd.SetParameterValue("@COLLECTID", dbParm.CollectID); unitCmd.SetParameterValue("@WRITEOFFID", drRow[0].ToString()); unitCmd.SetParameterValue("@INTOSTATUS", drRow[1].ToString()); unitCmd.SetParameterValue("@INTODATE", drRow[2].ToString());//DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") unitCmd.ExecuteNonQuery(); } return settleEntity; }
public static SettleEntity ImportCollectList(SettleEntity settleEntity) { SettleDBEntity dbParm = (settleEntity.SettleDBEntity.Count > 0) ? settleEntity.SettleDBEntity[0] : new SettleDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("ImportCollectList"); cmd.SetParameterValue("@PAYMENTTYPE", dbParm.PaymentType); //cmd.SetParameterValue("@TOTALAMOUNT", dbParm.TotalUploadCount); cmd.SetParameterValue("@UPLOADFILENAME", dbParm.UploadFileName); cmd.SetParameterValue("@IMPORTTYPE", dbParm.ImportType); cmd.SetParameterValue("@TOTALCOUNT", dbParm.TotalUploadCount); cmd.SetParameterValue("@CREATEUSER", settleEntity.LogMessages.Userid); settleEntity.Result = cmd.ExecuteNonQuery(); int collectID = (int)cmd.GetParameterValue("@CollectID"); decimal decTotalUploadAmount = 0; foreach (DataRow drRow in dbParm.UpLoadList.Rows) { DataCommand unitCmd = DataCommandManager.GetDataCommand("ImportWriteOffList"); unitCmd.SetParameterValue("@COLLECTID", collectID); unitCmd.SetParameterValue("@DEALTIME", drRow[1].ToString().Trim()); unitCmd.SetParameterValue("@PAYNAME", drRow[8].ToString().Trim()); unitCmd.SetParameterValue("@PAYACCOUNT", drRow[9].ToString().Trim()); unitCmd.SetParameterValue("@INTOAMOUNT", drRow[5].ToString().Trim()); unitCmd.SetParameterValue("@DETAILSERIALNUM", drRow[12].ToString().Trim()); unitCmd.SetParameterValue("@SUMMARY", drRow[10].ToString().Trim()); unitCmd.SetParameterValue("@REMARK", drRow[11].ToString().Trim()); unitCmd.SetParameterValue("@CREATEUSER", settleEntity.LogMessages.Userid); unitCmd.ExecuteNonQuery(); decTotalUploadAmount = decTotalUploadAmount + (String.IsNullOrEmpty(drRow[5].ToString().Trim()) ? 0 : decimal.Parse(drRow[5].ToString().Trim())); } DataCommand upCmd = DataCommandManager.GetDataCommand("UpdateCollectList"); upCmd.SetParameterValue("@COLLECTID", collectID); upCmd.SetParameterValue("@TOTALAMOUNT", decTotalUploadAmount); settleEntity.Result = cmd.ExecuteNonQuery(); return settleEntity; }
public static SettleEntity GetImportCollectList(SettleEntity settleEntity) { SettleDBEntity dbParm = (settleEntity.SettleDBEntity.Count > 0) ? settleEntity.SettleDBEntity[0] : new SettleDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetImportCollectList"); cmd.SetParameterValue("@UploadStartDT", dbParm.UploadStartDT); cmd.SetParameterValue("@UploadEndDT", dbParm.UploadEndDT); cmd.SetParameterValue("@UploadAmountStart", dbParm.UploadAmountStart); cmd.SetParameterValue("@UploadAmountEnd", dbParm.UploadAmountEnd); cmd.SetParameterValue("@UploadUser", dbParm.UploadUser); cmd.SetParameterValue("@PageCurrent", settleEntity.PageCurrent); cmd.SetParameterValue("@PageSize", settleEntity.PageSize); cmd.SetParameterValue("@SortField", settleEntity.SortField); cmd.SetParameterValue("@SortType", settleEntity.SortType); settleEntity.SettleDBEntity[0].UpLoadList = cmd.ExecuteDataSet().Tables[0].Copy(); settleEntity.TotalCount = (int)cmd.GetParameterValue("@TotalCount"); return settleEntity; }
public static SettleEntity GetApproveCollectList(SettleEntity settleEntity) { SettleDBEntity dbParm = (settleEntity.SettleDBEntity.Count > 0) ? settleEntity.SettleDBEntity[0] : new SettleDBEntity(); DataCommand unitCmd = DataCommandManager.GetDataCommand("GetApproveCollectList"); unitCmd.SetParameterValue("@COLLECTID", dbParm.CollectID); settleEntity.SettleDBEntity[0].ImportList = unitCmd.ExecuteDataSet().Tables[0].Copy(); return settleEntity; }
/// <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; } }