public bool Pay(ColoPay.Model.Pay.Withdraw withdrawModel, ColoPay.Model.Pay.BalanceDetail detailModel, int userId)
{
//事务处理
List <CommandInfo> sqllist = new List <CommandInfo>();
StringBuilder strSql = new StringBuilder();
strSql.Append("update Pay_Withdraw set ");
strSql.Append("Status=@Status,");
strSql.Append("PayDate=@Date,");
strSql.Append("PayUserId=@UserId ");
strSql.Append(" where WithdrawId=@WithdrawId");
SqlParameter[] parameters =
{
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Date", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@WithdrawId", SqlDbType.Int, 4)
};
parameters[0].Value = withdrawModel.Status;
parameters[1].Value = DateTime.Now;
parameters[2].Value = userId;
parameters[3].Value = withdrawModel.WithdrawId;
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("insert into Pay_BalanceDetail(");
strSql2.Append("EnterpriseID,PayType,OriginalId,OriginalCode,PaymentFee,OrderAmount,Amount,CreatedTime)");
strSql2.Append(" values (");
strSql2.Append("@EnterpriseID,@PayType,@OriginalId,@OriginalCode,@PaymentFee,@OrderAmount,@Amount,@CreatedTime)");
SqlParameter[] parameters2 =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@PayType", SqlDbType.Int, 4),
new SqlParameter("@OriginalId", SqlDbType.Int, 4),
new SqlParameter("@OriginalCode", SqlDbType.NVarChar, 100),
new SqlParameter("@PaymentFee", SqlDbType.Money, 8),
new SqlParameter("@OrderAmount", SqlDbType.Money, 8),
new SqlParameter("@Amount", SqlDbType.Money, 8),
new SqlParameter("@CreatedTime", SqlDbType.DateTime)
};
parameters2[0].Value = detailModel.EnterpriseID;
parameters2[1].Value = detailModel.PayType;
parameters2[2].Value = detailModel.OriginalId;
parameters2[3].Value = detailModel.OriginalCode;
parameters2[4].Value = detailModel.PaymentFee;
parameters2[5].Value = detailModel.OrderAmount;
parameters2[6].Value = detailModel.Amount;
parameters2[7].Value = detailModel.CreatedTime;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
return(DBHelper.DefaultDBHelper.ExecuteSqlTran(sqllist) > 0 ? true : false);
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "Pay_BalanceDetail";
* parameters[1].Value = "DetailId";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
public bool AgentBalance(ColoPay.Model.Pay.BalanceDetail detail)
{
//事务处理
List <CommandInfo> sqllist = new List <CommandInfo>();
//更新代理商余额
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("update Pay_Agent set Balance=Balance+@PaymentFee ");
strSql1.Append(" where AgentId=@AgentId ");
SqlParameter[] parameters1 =
{
new SqlParameter("@AgentId", SqlDbType.Int, 4),
new SqlParameter("@PaymentFee", SqlDbType.Decimal)
};
parameters1[0].Value = detail.AgentId;
parameters1[1].Value = detail.PaymentFee;
CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1);
sqllist.Add(cmd);
//增加商家资金明细
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Pay_BalanceDetail(");
strSql.Append("EnterpriseID,AgentId,Type,PayType,OriginalId,OriginalCode,PaymentFee,OrderAmount,Amount,CreatedTime)");
strSql.Append(" values (");
strSql.Append("@EnterpriseID,@AgentId,@Type,@PayType,@OriginalId,@OriginalCode,@PaymentFee,@OrderAmount,@Amount,@CreatedTime)");
SqlParameter[] parameters =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@AgentId", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@PayType", SqlDbType.Int, 4),
new SqlParameter("@OriginalId", SqlDbType.Int, 4),
new SqlParameter("@OriginalCode", SqlDbType.NVarChar, 100),
new SqlParameter("@PaymentFee", SqlDbType.Money, 8),
new SqlParameter("@OrderAmount", SqlDbType.Money, 8),
new SqlParameter("@Amount", SqlDbType.Money, 8),
new SqlParameter("@CreatedTime", SqlDbType.DateTime)
};
parameters[0].Value = detail.EnterpriseID;
parameters[1].Value = detail.AgentId;
parameters[2].Value = detail.Type;
parameters[3].Value = detail.PayType;
parameters[4].Value = detail.OriginalId;
parameters[5].Value = detail.OriginalCode;
parameters[6].Value = detail.PaymentFee;
parameters[7].Value = detail.OrderAmount;
parameters[8].Value = detail.Amount;
parameters[9].Value = detail.CreatedTime;
cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
return(DBHelper.DefaultDBHelper.ExecuteSqlTran(sqllist) > 0 ? true : false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ColoPay.Model.Pay.BalanceDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Pay_BalanceDetail set ");
strSql.Append("EnterpriseID=@EnterpriseID,");
strSql.Append("AgentId=@AgentId,");
strSql.Append("Type=@Type,");
strSql.Append("PayType=@PayType,");
strSql.Append("OriginalId=@OriginalId,");
strSql.Append("OriginalCode=@OriginalCode,");
strSql.Append("PaymentFee=@PaymentFee,");
strSql.Append("OrderAmount=@OrderAmount,");
strSql.Append("Amount=@Amount,");
strSql.Append("CreatedTime=@CreatedTime");
strSql.Append(" where DetailId=@DetailId");
SqlParameter[] parameters =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@AgentId", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@PayType", SqlDbType.Int, 4),
new SqlParameter("@OriginalId", SqlDbType.Int, 4),
new SqlParameter("@OriginalCode", SqlDbType.NVarChar, 100),
new SqlParameter("@PaymentFee", SqlDbType.Money, 8),
new SqlParameter("@OrderAmount", SqlDbType.Money, 8),
new SqlParameter("@Amount", SqlDbType.Money, 8),
new SqlParameter("@CreatedTime", SqlDbType.DateTime),
new SqlParameter("@DetailId", SqlDbType.Int, 4)
};
parameters[0].Value = model.EnterpriseID;
parameters[1].Value = model.AgentId;
parameters[2].Value = model.Type;
parameters[3].Value = model.PayType;
parameters[4].Value = model.OriginalId;
parameters[5].Value = model.OriginalCode;
parameters[6].Value = model.PaymentFee;
parameters[7].Value = model.OrderAmount;
parameters[8].Value = model.Amount;
parameters[9].Value = model.CreatedTime;
parameters[10].Value = model.DetailId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ColoPay.Model.Pay.BalanceDetail DataRowToModel(DataRow row)
{
ColoPay.Model.Pay.BalanceDetail model = new ColoPay.Model.Pay.BalanceDetail();
if (row != null)
{
if (row["DetailId"] != null && row["DetailId"].ToString() != "")
{
model.DetailId = int.Parse(row["DetailId"].ToString());
}
if (row["EnterpriseID"] != null && row["EnterpriseID"].ToString() != "")
{
model.EnterpriseID = int.Parse(row["EnterpriseID"].ToString());
}
if (row["AgentId"] != null && row["AgentId"].ToString() != "")
{
model.AgentId = int.Parse(row["AgentId"].ToString());
}
if (row["Type"] != null && row["Type"].ToString() != "")
{
model.Type = int.Parse(row["Type"].ToString());
}
if (row["PayType"] != null && row["PayType"].ToString() != "")
{
model.PayType = int.Parse(row["PayType"].ToString());
}
if (row["OriginalId"] != null && row["OriginalId"].ToString() != "")
{
model.OriginalId = int.Parse(row["OriginalId"].ToString());
}
if (row["OriginalCode"] != null)
{
model.OriginalCode = row["OriginalCode"].ToString();
}
if (row["PaymentFee"] != null && row["PaymentFee"].ToString() != "")
{
model.PaymentFee = decimal.Parse(row["PaymentFee"].ToString());
}
if (row["OrderAmount"] != null && row["OrderAmount"].ToString() != "")
{
model.OrderAmount = decimal.Parse(row["OrderAmount"].ToString());
}
if (row["Amount"] != null && row["Amount"].ToString() != "")
{
model.Amount = decimal.Parse(row["Amount"].ToString());
}
if (row["CreatedTime"] != null && row["CreatedTime"].ToString() != "")
{
model.CreatedTime = DateTime.Parse(row["CreatedTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ColoPay.Model.Pay.BalanceDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Pay_BalanceDetail(");
strSql.Append("EnterpriseID,AgentId,Type,PayType,OriginalId,OriginalCode,PaymentFee,OrderAmount,Amount,CreatedTime)");
strSql.Append(" values (");
strSql.Append("@EnterpriseID,@AgentId,@Type,@PayType,@OriginalId,@OriginalCode,@PaymentFee,@OrderAmount,@Amount,@CreatedTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@AgentId", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@PayType", SqlDbType.Int, 4),
new SqlParameter("@OriginalId", SqlDbType.Int, 4),
new SqlParameter("@OriginalCode", SqlDbType.NVarChar, 100),
new SqlParameter("@PaymentFee", SqlDbType.Money, 8),
new SqlParameter("@OrderAmount", SqlDbType.Money, 8),
new SqlParameter("@Amount", SqlDbType.Money, 8),
new SqlParameter("@CreatedTime", SqlDbType.DateTime)
};
parameters[0].Value = model.EnterpriseID;
parameters[1].Value = model.AgentId;
parameters[2].Value = model.Type;
parameters[3].Value = model.PayType;
parameters[4].Value = model.OriginalId;
parameters[5].Value = model.OriginalCode;
parameters[6].Value = model.PaymentFee;
parameters[7].Value = model.OrderAmount;
parameters[8].Value = model.Amount;
parameters[9].Value = model.CreatedTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ColoPay.Model.Pay.BalanceDetail GetModel(int DetailId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 DetailId,EnterpriseID,AgentId,Type,PayType,OriginalId,OriginalCode,PaymentFee,OrderAmount,Amount,CreatedTime from Pay_BalanceDetail ");
strSql.Append(" where DetailId=@DetailId");
SqlParameter[] parameters =
{
new SqlParameter("@DetailId", SqlDbType.Int, 4)
};
parameters[0].Value = DetailId;
ColoPay.Model.Pay.BalanceDetail model = new ColoPay.Model.Pay.BalanceDetail();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}