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