public virtual IList <PaymentInformationInfo> GetPaymentInformations(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <PaymentInformationInfo> entitys = null;
PaymentInformationInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Payment_Information";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <PaymentInformationInfo>();
while (RdrList.Read())
{
entity = new PaymentInformationInfo();
entity.Payment_ID = Tools.NullInt(RdrList["Payment_ID"]);
entity.Payment_PayingTeller = Tools.NullStr(RdrList["Payment_PayingTeller"]);
entity.Payment_Account = Tools.NullStr(RdrList["Payment_Account"]);
entity.Payment_Receivable = Tools.NullStr(RdrList["Payment_Receivable"]);
entity.Payment_Account_Receivable = Tools.NullStr(RdrList["Payment_Account_Receivable"]);
entity.Payment_Type = Tools.NullInt(RdrList["Payment_Type"]);
entity.Payment_Amount = Tools.NullDbl(RdrList["Payment_Amount"]);
entity.Payment_Remarks = Tools.NullStr(RdrList["Payment_Remarks"]);
entity.Payment_Account_Time = Tools.NullDate(RdrList["Payment_Account_Time"]);
entity.Payment_Status = Tools.NullInt(RdrList["Payment_Status"]);
entity.Payment_Flow = Tools.NullStr(RdrList["Payment_Flow"]);
entity.Payment_Remarks1 = Tools.NullStr(RdrList["Payment_Remarks1"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool EditPaymentInformation(PaymentInformationInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Payment_Information WHERE Payment_ID = " + entity.Payment_ID;
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Payment_ID"] = entity.Payment_ID;
DrAdd["Payment_PayingTeller"] = entity.Payment_PayingTeller;
DrAdd["Payment_Account"] = entity.Payment_Account;
DrAdd["Payment_Receivable"] = entity.Payment_Receivable;
DrAdd["Payment_Account_Receivable"] = entity.Payment_Account_Receivable;
DrAdd["Payment_Type"] = entity.Payment_Type;
DrAdd["Payment_Amount"] = entity.Payment_Amount;
DrAdd["Payment_Remarks"] = entity.Payment_Remarks;
DrAdd["Payment_Account_Time"] = entity.Payment_Account_Time;
DrAdd["Payment_Status"] = entity.Payment_Status;
DrAdd["Payment_Flow"] = entity.Payment_Flow;
DrAdd["Payment_Remarks1"] = entity.Payment_Remarks1;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
public virtual PaymentInformationInfo GetPaymentInformationByID(int ID)
{
PaymentInformationInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Payment_Information WHERE Payment_ID = " + ID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new PaymentInformationInfo();
entity.Payment_ID = Tools.NullInt(RdrList["Payment_ID"]);
entity.Payment_PayingTeller = Tools.NullStr(RdrList["Payment_PayingTeller"]);
entity.Payment_Account = Tools.NullStr(RdrList["Payment_Account"]);
entity.Payment_Receivable = Tools.NullStr(RdrList["Payment_Receivable"]);
entity.Payment_Account_Receivable = Tools.NullStr(RdrList["Payment_Account_Receivable"]);
entity.Payment_Type = Tools.NullInt(RdrList["Payment_Type"]);
entity.Payment_Amount = Tools.NullDbl(RdrList["Payment_Amount"]);
entity.Payment_Remarks = Tools.NullStr(RdrList["Payment_Remarks"]);
entity.Payment_Account_Time = Tools.NullDate(RdrList["Payment_Account_Time"]);
entity.Payment_Status = Tools.NullInt(RdrList["Payment_Status"]);
entity.Payment_Flow = Tools.NullStr(RdrList["Payment_Flow"]);
entity.Payment_Remarks1 = Tools.NullStr(RdrList["Payment_Remarks1"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool AddPaymentInformation(PaymentInformationInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Payment_Information";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Payment_ID"] = entity.Payment_ID;
DrAdd["Payment_PayingTeller"] = entity.Payment_PayingTeller;
DrAdd["Payment_Account"] = entity.Payment_Account;
DrAdd["Payment_Receivable"] = entity.Payment_Receivable;
DrAdd["Payment_Account_Receivable"] = entity.Payment_Account_Receivable;
DrAdd["Payment_Type"] = entity.Payment_Type;
DrAdd["Payment_Amount"] = entity.Payment_Amount;
DrAdd["Payment_Remarks"] = entity.Payment_Remarks;
DrAdd["Payment_Account_Time"] = entity.Payment_Account_Time;
DrAdd["Payment_Status"] = entity.Payment_Status;
DrAdd["Payment_Flow"] = entity.Payment_Flow;
DrAdd["Payment_Remarks1"] = entity.Payment_Remarks1;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
/// <summary>
/// 强制转账
/// </summary>
/// <param name="payAccNo">付款账号</param>
/// <param name="recvAccNo">收款账号</param>
/// <param name="recvAccNm">收款账号名</param>
/// <param name="memo">备注</param>
/// <param name="tranAmt">金额</param>
/// <param name="strResult">返回说明</param>
/// <returns></returns>
public bool Transfer(string payAccNo, string recvAccNo, string recvAccNm, string memo, double tranAmt, ref string strResult, string supplier_name)
{
StringBuilder PostData = new StringBuilder();
string Payment_Flow = DateTime.Now.ToString("yyyyMMddHHmmss") + new Public_Class().Createvkey(6);
PostData.Append("<?xml version=\"1.0\" encoding=\"GBK\" ?>");
PostData.Append("<stream>");
PostData.Append(" <action>DLMDETRN</action>");
PostData.Append(" <userName>"+ userName + "</userName>");
//PostData.Append(" <clientID>" + DateTime.Now.ToString("yyyyMMddHHmmss") + new Public_Class().Createvkey(6) + "</clientID>");
PostData.Append(" <clientID>"+ Payment_Flow + "</clientID>");
PostData.Append(" <accountNo>"+ mainAccNo + "</accountNo>");
PostData.Append(" <payAccNo>"+ payAccNo + "</payAccNo>");
PostData.Append(" <tranType>BF</tranType>");
PostData.Append(" <recvAccNo>"+ recvAccNo + "</recvAccNo>");
PostData.Append(" <recvAccNm>"+ recvAccNm + "</recvAccNm>");
PostData.Append(" <tranAmt>"+ tranAmt + "</tranAmt>");
PostData.Append(" <freezeNo></freezeNo>");
PostData.Append(" <ofreezeamt></ofreezeamt>");
PostData.Append(" <memo>"+ memo + "</memo>");
PostData.Append(" <tranFlag>1</tranFlag>");
PostData.Append("</stream>");
string xmlResult = HttpUtil.SendRequest(PostData.ToString(), PostServer, encodingStr);
DateTime CurTime = DateTime.Now;
PaymentInformationInfo payInfoEntity = new PaymentInformationInfo();
//付款账户
payInfoEntity.Payment_PayingTeller = supplier_name;
//付款账号
payInfoEntity.Payment_Account = payAccNo;
//收款账号
payInfoEntity.Payment_Receivable = recvAccNo;
//收款账户
payInfoEntity.Payment_Account_Receivable = recvAccNm;
//担保类型付款类型 1担保付款 2货款结算 3出金 4收取交易佣金 5支付投标保证金 6退还投标保证金 7支付商家保证金 8退还商家保证金 9其它
payInfoEntity.Payment_Type = 0;
//付款金额
payInfoEntity.Payment_Amount = tranAmt;
//备注信息
payInfoEntity.Payment_Remarks = memo;
//付款时间
payInfoEntity.Payment_Account_Time = CurTime;
if (xmlResult == null || xmlResult.Length == 0)
{
//付款状态
payInfoEntity.Payment_Status = 2;
payInfoEntity.Payment_Flow = Payment_Flow;
payInfoEntity.Payment_Remarks1 = "中信支付备注说明:付款账户:" + supplier_name + ",付款账号:" + payAccNo + ",收款账户:" + recvAccNm + ",收款账号:" + recvAccNo + ",付款类型:" + "" + memo + "" + ", 付款金额:" + tranAmt + ",备注信息:" + memo + ",付款时间:" + CurTime + ",请求失败(没有返回数据),流水号:" + Payment_Flow + "";
PayLogs.WriteLogs(PostData.ToString());
strResult = "请求失败";
MyPayInfo.AddPaymentInformation(payInfoEntity);
return(false);
}
if (StatusCode(xmlResult) == "t")
{
strResult = GetXMLElement(xmlResult, "/stream/statusText");
//付款状态
payInfoEntity.Payment_Status = 1;
payInfoEntity.Payment_Flow = Payment_Flow;
payInfoEntity.Payment_Remarks1 = "中信支付备注说明:付款账户:" + supplier_name + ",付款账号:" + payAccNo + ",收款账户:" + recvAccNm + ",收款账号:" + recvAccNo + ",付款类型:" + "" + memo + "" + ", 付款金额:" + tranAmt + ",备注信息:" + memo + ",付款时间:" + CurTime + ",付款成功:,流水号:" + Payment_Flow + "";
PayLogs.WriteLogs(PostData.ToString());
MyPayInfo.AddPaymentInformation(payInfoEntity);
return(true);
}
else if (tranAmt == 0)
{
strResult = GetXMLElement(xmlResult, "/stream/statusText");
//付款状态
payInfoEntity.Payment_Status = 1;
payInfoEntity.Payment_Flow = Payment_Flow;
payInfoEntity.Payment_Remarks1 = "中信支付备注说明:付款账户:" + supplier_name + ",付款账号:" + payAccNo + ",收款账户:" + recvAccNm + ",收款账号:" + recvAccNo + ",付款类型:" + "" + memo + "" + ", 付款金额:" + tranAmt + ",备注信息:" + memo + ",付款时间:" + CurTime + ",付款成功:,流水号:" + Payment_Flow + "";
PayLogs.WriteLogs(PostData.ToString());
MyPayInfo.AddPaymentInformation(payInfoEntity);
return(true);
}
else
{
strResult = GetXMLElement(xmlResult, "/stream/statusText");
payInfoEntity.Payment_Status = 0;
payInfoEntity.Payment_Flow = Payment_Flow;
payInfoEntity.Payment_Remarks1 = "中信支付备注说明:付款账户:" + supplier_name + ",付款账号:" + payAccNo + ",收款账户:" + recvAccNm + ",收款账号:" + recvAccNo + ",付款类型:" + "" + memo + "" + ", 付款金额:" + tranAmt + ",备注信息:" + memo + ",付款时间:" + CurTime + ",付款状态:付款失败,流水号:" + Payment_Flow + "";
PayLogs.WriteLogs(PostData.ToString());
MyPayInfo.AddPaymentInformation(payInfoEntity);
return(false);
}
}
public virtual bool EditPaymentInformation(PaymentInformationInfo entity)
{
return(MyDAL.EditPaymentInformation(entity));
}
