/// <summary>
/// 反结算
/// </summary>
/// <returns></returns>
public int Back(ref TB_BillPayEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@PKCode", SqlDbType.VarChar, 32, Entity.PKCode),
new SqlParameter("@OutOrderCode", SqlDbType.VarChar, 32, Entity.OutOrderCode),
new SqlParameter("@PayMethodCode", SqlDbType.VarChar, 32, Entity.PayMethodCode),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@PayMoney", Entity.PayMoney),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@PPKCode", Entity.PPKCode),
};
sqlParameters[0].Direction = ParameterDirection.Output;
sqlParameters[1].Direction = ParameterDirection.Output;
sqlParameters[2].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_BillPay_Back", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.PKCode = sqlParameters[0].Value.ToString();
Entity.OutOrderCode = sqlParameters[1].Value.ToString();
Entity.PayMethodCode = sqlParameters[2].Value.ToString();
}
return(intReturn);
}
/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string Id, string BusCode, string StoCode, string CCode, string CCname, string TStatus, string PKCode, string BillCode, string PayMoney, string PayMethodName, string PayMethodCode, string Remar, string OutOrderCode, string PPKCode)
{
bool rel = false;
try
{
Entity = new TB_BillPayEntity();
Entity.Id = StringHelper.StringToLong(Id);
Entity.BusCode = BusCode;
Entity.StoCode = StoCode;
Entity.CCode = CCode;
Entity.CCname = CCname;
Entity.TStatus = TStatus;
Entity.PKCode = PKCode;
Entity.BillCode = BillCode;
Entity.PayMoney = StringHelper.StringToDecimal(PayMoney);
Entity.PayMethodName = PayMethodName;
Entity.PayMethodCode = PayMethodCode;
Entity.Remar = Remar;
Entity.OutOrderCode = OutOrderCode;
Entity.PPKCode = PPKCode;
rel = true;
}
catch (System.Exception)
{
throw;
}
return(rel);
}
/// <summary>
/// 联锁端请求微信支付的结果
/// </summary>
/// <param name="dicPar"></param>
public void UpdateWxPay(Dictionary <string, object> dicPar)
{
bllTB_BillPay bllPay = new bllTB_BillPay();
//要检测的参数信息
List <string> pra = new List <string>()
{
"buscode", "stocode", "payno"
};
//检测方法需要的参数
if (!CheckActionParameters(dicPar, pra))
{
return;
}
//获取参数信息
string GUID = "";
string USER_ID = "";
string BusCode = dicPar["buscode"].ToString();
string StoCode = dicPar["stocode"].ToString();
string PKCode = dicPar["payno"].ToString();
TB_BillPayEntity UEntity = bllPay.GetEntitySigInfo(" where pkcode='" + PKCode + "'");
UEntity.TStatus = "1";
bllPay.Update(GUID, USER_ID, UEntity);
string type = bllPay.oResult.Code;
if (type != "1")
{
ErrorLog.WriteErrorMessage(ErrorLog.LogType.baselog, "支付单号：" + PKCode + "支付回调失败");
}
ReturnResultJson(bll.oResult.Code, bll.oResult.Msg);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, TB_BillPayEntity UEntity)
{
//更新数据
int result = dal.Update(UEntity);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_BillPayEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@BillCode", Entity.BillCode),
new SqlParameter("@PayMoney", Entity.PayMoney),
new SqlParameter("@PayMethodName", Entity.PayMethodName),
new SqlParameter("@PayMethodCode", Entity.PayMethodCode),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@OutOrderCode", Entity.OutOrderCode),
new SqlParameter("@PPKCode", Entity.PPKCode),
};
return(DBHelper.ExecuteNonQuery("dbo.p_TB_BillPay_Update", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TB_BillPayEntity SetEntityInfo(DataRow dr)
{
TB_BillPayEntity Entity = new TB_BillPayEntity();
Entity.Id = StringHelper.StringToLong(dr["Id"].ToString());
Entity.BusCode = dr["BusCode"].ToString();
Entity.StoCode = dr["StoCode"].ToString();
Entity.CCode = dr["CCode"].ToString();
Entity.CCname = dr["CCname"].ToString();
Entity.TStatus = dr["TStatus"].ToString();
Entity.PKCode = dr["PKCode"].ToString();
Entity.BillCode = dr["BillCode"].ToString();
Entity.PayMoney = StringHelper.StringToDecimal(dr["PayMoney"].ToString());
Entity.PayMethodName = dr["PayMethodName"].ToString();
Entity.PayMethodCode = dr["PayMethodCode"].ToString();
Entity.Remar = dr["Remar"].ToString();
Entity.OutOrderCode = dr["OutOrderCode"].ToString();
Entity.PPKCode = dr["PPKCode"].ToString();
return(Entity);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_BillPayEntity Entity, string DiscountName, string DiscountMoney, string ZeroCutMoney, string AuthCode, string AuthName, string MemberCard, string MemberName, string MemberBalance, string MemberLeve, string MemberDiscount)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@PKCode", SqlDbType.VarChar, 32)
{
Value = Entity.PKCode
},
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@BillCode", Entity.BillCode),
new SqlParameter("@PayMoney", Entity.PayMoney),
new SqlParameter("@PayMethodName", Entity.PayMethodName),
new SqlParameter("@PayMethodCode", Entity.PayMethodCode),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@OutOrderCode", Entity.OutOrderCode),
new SqlParameter("@PPKCode", Entity.PPKCode),
new SqlParameter("@DiscountMoney", DiscountMoney),
new SqlParameter("@DiscountName", DiscountName),
new SqlParameter("@zerocutmoney", ZeroCutMoney),
new SqlParameter("@AuthCode", AuthCode),
new SqlParameter("@AuthName", AuthName),
new SqlParameter("@MemberCard", MemberCard),
new SqlParameter("@MemberName", MemberName),
new SqlParameter("@MemberBalance", MemberBalance),
new SqlParameter("@MemberLeve", MemberLeve),
new SqlParameter("@MemberDiscount", MemberDiscount)
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_BillPay_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.PKCode = sqlParameters[0].Value.ToString();
}
return(intReturn);
}
