public List <FinancePayDetailEntity> MakeFinancePayDetailList(IDataReader dr)
{
List <FinancePayDetailEntity> list = new List <FinancePayDetailEntity>();
while (dr.Read())
{
FinancePayDetailEntity financePayDetailEntity = new FinancePayDetailEntity();
financePayDetailEntity.BillID = (Int64)dr["BillID"];
financePayDetailEntity.JournalID = (Int64)dr["JournalID"];
financePayDetailEntity.AuthorID = (Int64)dr["AuthorID"];
financePayDetailEntity.EBankType = (Byte)dr["EBankType"];
financePayDetailEntity.TransactionID = (String)dr["TransactionID"];
financePayDetailEntity.TotalFee = (Decimal)dr["TotalFee"];
financePayDetailEntity.Currency = (String)dr["Currency"];
financePayDetailEntity.IsInCome = (Byte)dr["IsInCome"];
financePayDetailEntity.PayType = (Byte)dr["PayType"];
financePayDetailEntity.PayStatus = (Byte)dr["PayStatus"];
financePayDetailEntity.PayDate = (DateTime)dr["PayDate"];
financePayDetailEntity.ProductTable = (String)dr["ProductTable"];
financePayDetailEntity.ProductID = (String)dr["ProductID"];
financePayDetailEntity.ProductDes = Convert.IsDBNull(dr["ProductDes"]) ? null : (String)dr["ProductDes"];
financePayDetailEntity.UserAccount = Convert.IsDBNull(dr["UserAccount"]) ? null : (String)dr["UserAccount"];
financePayDetailEntity.BankID = Convert.IsDBNull(dr["BankID"]) ? null : (String)dr["BankID"];
financePayDetailEntity.BankNo = Convert.IsDBNull(dr["BankNo"]) ? null : (String)dr["BankNo"];
financePayDetailEntity.AddDate = (DateTime)dr["AddDate"];
list.Add(financePayDetailEntity);
}
dr.Close();
return(list);
}
public ActionResult YeepayCallback()
{
YeepayHelper myYeepay = new YeepayHelper();
string message = string.Empty;
FinancePayDetailEntity model = myYeepay.GetPayResult((msg) => { message = msg; });
if (model != null)
{
model.JournalID = CurAuthor.JournalID;
model.AuthorID = CurAuthor.AuthorID;
model.EBankType = 3;
model.PayDate = DateTime.Now;
IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>();
service.AddFinancePayDetail(model);
//更新缴费通知记录
if (model.NoticeID > 0)
{
PayNoticeQuery query = new PayNoticeQuery();
query.NoticeID = model.NoticeID;
query.Status = 2;
service.ChangePayNoticeStatus(query);
}
}
return(Content(message));
}
/// <summary>
/// 新增支付记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult AddFinancePayDetail(FinancePayDetailEntity model)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post <ExecResult, FinancePayDetailEntity>(GetAPIUrl(APIConstant.FINANCEPAYDETAIL_ADD), model);
return(result);
}
public FinancePayDetailEntity MakeFinancePayDetail(DataRow dr)
{
FinancePayDetailEntity financePayDetailEntity = null;
if (dr != null)
{
financePayDetailEntity = new FinancePayDetailEntity();
financePayDetailEntity.BillID = (Int64)dr["BillID"];
financePayDetailEntity.JournalID = (Int64)dr["JournalID"];
financePayDetailEntity.AuthorID = (Int64)dr["AuthorID"];
financePayDetailEntity.EBankType = (Byte)dr["EBankType"];
financePayDetailEntity.TransactionID = (String)dr["TransactionID"];
financePayDetailEntity.TotalFee = (Decimal)dr["TotalFee"];
financePayDetailEntity.Currency = (String)dr["Currency"];
financePayDetailEntity.IsInCome = (Byte)dr["IsInCome"];
financePayDetailEntity.PayType = (Byte)dr["PayType"];
financePayDetailEntity.PayStatus = (Byte)dr["PayStatus"];
financePayDetailEntity.PayDate = (DateTime)dr["PayDate"];
financePayDetailEntity.ProductTable = (String)dr["ProductTable"];
financePayDetailEntity.ProductID = (String)dr["ProductID"];
financePayDetailEntity.ProductDes = Convert.IsDBNull(dr["ProductDes"]) ? null : (String)dr["ProductDes"];
financePayDetailEntity.UserAccount = Convert.IsDBNull(dr["UserAccount"]) ? null : (String)dr["UserAccount"];
financePayDetailEntity.BankID = Convert.IsDBNull(dr["BankID"]) ? null : (String)dr["BankID"];
financePayDetailEntity.BankNo = Convert.IsDBNull(dr["BankNo"]) ? null : (String)dr["BankNo"];
financePayDetailEntity.AddDate = (DateTime)dr["AddDate"];
}
return(financePayDetailEntity);
}
public bool UpdateFinancePayDetail(FinancePayDetailEntity financePayDetailEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" BillID=@BillID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" JournalID=@JournalID");
sqlCommandText.Append(", AuthorID=@AuthorID");
sqlCommandText.Append(", EBankType=@EBankType");
sqlCommandText.Append(", TransactionID=@TransactionID");
sqlCommandText.Append(", TotalFee=@TotalFee");
sqlCommandText.Append(", Currency=@Currency");
sqlCommandText.Append(", IsInCome=@IsInCome");
sqlCommandText.Append(", PayType=@PayType");
sqlCommandText.Append(", PayStatus=@PayStatus");
sqlCommandText.Append(", PayDate=@PayDate");
sqlCommandText.Append(", ProductTable=@ProductTable");
sqlCommandText.Append(", ProductID=@ProductID");
sqlCommandText.Append(", ProductDes=@ProductDes");
sqlCommandText.Append(", UserAccount=@UserAccount");
sqlCommandText.Append(", BankID=@BankID");
sqlCommandText.Append(", BankNo=@BankNo");
sqlCommandText.Append(", AddDate=@AddDate");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.FinancePayDetail SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@BillID", DbType.Int64, financePayDetailEntity.BillID);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, financePayDetailEntity.JournalID);
db.AddInParameter(cmd, "@AuthorID", DbType.Int64, financePayDetailEntity.AuthorID);
db.AddInParameter(cmd, "@EBankType", DbType.Byte, financePayDetailEntity.EBankType);
db.AddInParameter(cmd, "@TransactionID", DbType.AnsiString, financePayDetailEntity.TransactionID);
db.AddInParameter(cmd, "@TotalFee", DbType.Decimal, financePayDetailEntity.TotalFee);
db.AddInParameter(cmd, "@Currency", DbType.AnsiString, financePayDetailEntity.Currency);
db.AddInParameter(cmd, "@IsInCome", DbType.Byte, financePayDetailEntity.IsInCome);
db.AddInParameter(cmd, "@PayType", DbType.Byte, financePayDetailEntity.PayType);
db.AddInParameter(cmd, "@PayStatus", DbType.Byte, financePayDetailEntity.PayStatus);
db.AddInParameter(cmd, "@PayDate", DbType.DateTime, financePayDetailEntity.PayDate);
db.AddInParameter(cmd, "@ProductTable", DbType.AnsiString, financePayDetailEntity.ProductTable);
db.AddInParameter(cmd, "@ProductID", DbType.AnsiString, financePayDetailEntity.ProductID);
db.AddInParameter(cmd, "@ProductDes", DbType.AnsiString, financePayDetailEntity.ProductDes);
db.AddInParameter(cmd, "@UserAccount", DbType.AnsiString, financePayDetailEntity.UserAccount);
db.AddInParameter(cmd, "@BankID", DbType.AnsiString, financePayDetailEntity.BankID);
db.AddInParameter(cmd, "@BankNo", DbType.AnsiString, financePayDetailEntity.BankNo);
db.AddInParameter(cmd, "@AddDate", DbType.DateTime, financePayDetailEntity.AddDate);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public bool AddFinancePayDetail(FinancePayDetailEntity financePayDetailEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @JournalID");
sqlCommandText.Append(", @AuthorID");
sqlCommandText.Append(", @EBankType");
sqlCommandText.Append(", @TransactionID");
sqlCommandText.Append(", @TotalFee");
sqlCommandText.Append(", @Currency");
sqlCommandText.Append(", @IsInCome");
sqlCommandText.Append(", @PayType");
sqlCommandText.Append(", @PayStatus");
sqlCommandText.Append(", @PayDate");
sqlCommandText.Append(", @ProductTable");
sqlCommandText.Append(", @ProductID");
sqlCommandText.Append(", @ProductDes");
sqlCommandText.Append(", @UserAccount");
sqlCommandText.Append(", @BankID");
sqlCommandText.Append(", @BankNo");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.FinancePayDetail ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, financePayDetailEntity.JournalID);
db.AddInParameter(cmd, "@AuthorID", DbType.Int64, financePayDetailEntity.AuthorID);
db.AddInParameter(cmd, "@EBankType", DbType.Byte, financePayDetailEntity.EBankType);
db.AddInParameter(cmd, "@TransactionID", DbType.AnsiString, financePayDetailEntity.TransactionID);
db.AddInParameter(cmd, "@TotalFee", DbType.Decimal, financePayDetailEntity.TotalFee);
db.AddInParameter(cmd, "@Currency", DbType.AnsiString, financePayDetailEntity.Currency);
db.AddInParameter(cmd, "@IsInCome", DbType.Byte, financePayDetailEntity.IsInCome);
db.AddInParameter(cmd, "@PayType", DbType.Byte, financePayDetailEntity.PayType);
db.AddInParameter(cmd, "@PayStatus", DbType.Byte, financePayDetailEntity.PayStatus);
db.AddInParameter(cmd, "@PayDate", DbType.DateTime, financePayDetailEntity.PayDate);
db.AddInParameter(cmd, "@ProductTable", DbType.AnsiString, financePayDetailEntity.ProductTable);
db.AddInParameter(cmd, "@ProductID", DbType.AnsiString, financePayDetailEntity.ProductID);
db.AddInParameter(cmd, "@ProductDes", DbType.AnsiString, financePayDetailEntity.ProductDes);
db.AddInParameter(cmd, "@UserAccount", DbType.AnsiString, financePayDetailEntity.UserAccount);
db.AddInParameter(cmd, "@BankID", DbType.AnsiString, financePayDetailEntity.BankID);
db.AddInParameter(cmd, "@BankNo", DbType.AnsiString, financePayDetailEntity.BankNo);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public List <FinancePayDetailEntity> MakeFinancePayDetailList(DataTable dt)
{
List <FinancePayDetailEntity> list = new List <FinancePayDetailEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
FinancePayDetailEntity financePayDetailEntity = MakeFinancePayDetail(dt.Rows[i]);
list.Add(financePayDetailEntity);
}
}
return(list);
}
public ExecResult Add(FinancePayDetailEntity model)
{
IFinancePayDetailService service = ServiceContainer.Instance.Container.Resolve <IFinancePayDetailService>();
bool result = service.AddFinancePayDetail(model);
ExecResult execResult = new ExecResult();
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "新增支付记录成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "新增支付记录失败！";
}
return(execResult);
}
public FinancePayDetailEntity GetFinancePayDetail(Int64 billID)
{
FinancePayDetailEntity financePayDetailEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 BillID,JournalID,AuthorID,EBankType,TransactionID,TotalFee,Currency,IsInCome,PayType,PayStatus,PayDate,ProductTable,ProductID,ProductDes,UserAccount,BankID,BankNo,AddDate FROM dbo.FinancePayDetail WITH(NOLOCK)");
sqlCommandText.Append(" WHERE BillID=@BillID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@BillID", DbType.Int64, billID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
financePayDetailEntity = MakeFinancePayDetail(dr);
}
return(financePayDetailEntity);
}
public bool DeleteFinancePayDetail(FinancePayDetailEntity financePayDetailEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("DELETE FROM dbo.FinancePayDetail");
sqlCommandText.Append(" WHERE BillID=@BillID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@BillID", DbType.Int64, financePayDetailEntity.BillID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="financePayDetail">FinancePayDetailEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddFinancePayDetail(FinancePayDetailEntity financePayDetail)
{
return(FinancePayDetailDataAccess.Instance.AddFinancePayDetail(financePayDetail));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="financePayDetail">FinancePayDetailEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteFinancePayDetail(FinancePayDetailEntity financePayDetail)
{
return(FinancePayDetailDataAccess.Instance.DeleteFinancePayDetail(financePayDetail));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="financePayDetail">FinancePayDetailEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteFinancePayDetail(FinancePayDetailEntity financePayDetail)
{
return(FinancePayDetailBusProvider.DeleteFinancePayDetail(financePayDetail));
}
/// <summary>
/// 更新存储媒介中的实体数据
/// </summary>
/// <param name="financePayDetail">FinancePayDetailEntity实体对象</param>
/// <returns>true:更新成功 false：更新失败</returns>
public bool UpdateFinancePayDetail(FinancePayDetailEntity financePayDetail)
{
return(FinancePayDetailBusProvider.UpdateFinancePayDetail(financePayDetail));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="financePayDetail">FinancePayDetailEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddFinancePayDetail(FinancePayDetailEntity financePayDetail)
{
return(FinancePayDetailBusProvider.AddFinancePayDetail(financePayDetail));
}
