/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SystemBankCard model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemBankCard(");
strSql.Append("UserId,UserName,BankCardNumber,OpenAnAccountBankCard,OpenAnAccountAdd,OpenAnAccountUser,AddTime,IsDefault");
strSql.Append(") values (");
strSql.Append("@UserId,@UserName,@BankCardNumber,@OpenAnAccountBankCard,@OpenAnAccountAdd,@OpenAnAccountUser,@AddTime,@IsDefault");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.VarChar, 20),
new SqlParameter("@BankCardNumber", SqlDbType.VarChar, 50),
new SqlParameter("@OpenAnAccountBankCard", SqlDbType.VarChar, 50),
new SqlParameter("@OpenAnAccountAdd", SqlDbType.VarChar, 100),
new SqlParameter("@OpenAnAccountUser", SqlDbType.VarChar, 50),
new SqlParameter("@AddTime", SqlDbType.VarChar, 20),
new SqlParameter("@IsDefault", SqlDbType.Bit, 1)
};
parameters[0].Value = model.UserId;
parameters[1].Value = model.UserName;
parameters[2].Value = model.BankCardNumber;
parameters[3].Value = model.OpenAnAccountBankCard;
parameters[4].Value = model.OpenAnAccountAdd;
parameters[5].Value = model.OpenAnAccountUser;
parameters[6].Value = model.AddTime;
parameters[7].Value = model.IsDefault; return(sqlhelper.ExecNon(strSql.ToString(), parameters));
}
public bool Update(SystemBankCard model, List <string> fileds, string sqlWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("update {0} set ", model.GetType().Name);
List <string> filedsList = new List <string>();
List <SqlParameter> sqlParameter = new List <SqlParameter>();
SqlParameter Param = new SqlParameter("@Id", SqlDbType.Int, 4);
if (string.IsNullOrEmpty(sqlWhere))
{
Param.Value = model.Id;
sqlParameter.Add(Param);
}
foreach (string filed in fileds)
{
filedsList.Add(string.Format("{0}=@{0}", filed));
Param = new SqlParameter(string.Format("@{0}", filed), model.GetType().GetProperty(filed).GetValue(model, null));
sqlParameter.Add(Param);
}
strSql.AppendFormat("{0}", string.Join(",", filedsList.ToArray()));
if (string.IsNullOrEmpty(sqlWhere))
{
strSql.Append(" where Id=@Id ");
}
else
{
strSql.AppendFormat(" where 1=1 and {0} ", sqlWhere);
}
SqlParameter[] parameters = sqlParameter.ToArray();
return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SystemBankCard GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, UserId, UserName, BankCardNumber, OpenAnAccountBankCard, OpenAnAccountAdd, OpenAnAccountUser, AddTime, IsDefault ");
strSql.Append(" from SystemBankCard ");
strSql.Append(" where ");
strSql.Append(where);
var dt = sqlhelper.GetTable(strSql.ToString());
SystemBankCard model = null;
if (dt.Rows.Count > 0)
{
model = Mapper.DynamicMap <IDataReader, List <SystemBankCard> >(dt.CreateDataReader()).FirstOrDefault();
}
return(model);
}
//3用户银行信息
public ActionResult UserBank()
{
ViewBag.MenuIndex = 3;
SystemUsers user = Session["UserInfo"] as SystemUsers;
if (null == user)
{
return(RedirectToAction("Login", "Home"));
}
user = http.DoGetObject <SystemUsers>(ApplicationPropertys.WEBAPI_URL + "/User/GetUserInfo/" + user.ID);
SystemBankCard bank = http.DoGetObject <SystemBankCard>(ApplicationPropertys.WEBAPI_URL + "/User/GetBindBank/" + user.ID);
if (null == user)
{
return(RedirectToAction("Login", "Home"));
}
ViewBag.PageName = "银行管理";
ViewBag.Bank = bank;
return(View());
}
/// <summary>
/// Notify 测试
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button3_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(platformUserNo))
{
Response.Write("<script>alert('请输入唯一商户号！')</script>");
return;
}
if (string.IsNullOrEmpty(TextBox2.Text.Trim()))
{
}
else
{
requestNo = TextBox2.Text.Trim();
}
string str = "";
if (rblPayType.SelectedValue == "21") //21 注册 o
{
SystemUsersOper systemUsersOper = new SystemUsersOper();
str = systemUsersOper.UpdateById("djy", 1) ? "注册成功" : "注册失败";
}
else if (rblPayType.SelectedValue == "22") //22 充值 o
{
BaseHelper baseHelper = new BaseHelper();
SqlParameter[] parameters =
{
new SqlParameter("@Uid", SqlDbType.Int),
new SqlParameter("@PayNo", SqlDbType.VarChar, 50)
};
parameters[0].Value = 5;
parameters[1].Value = 00007;
// exec [pro_Recharge] 5,'0004','0004'，'icbc'
try
{
str = baseHelper.sqlhelper.ExecByProc("pro_Recharge", parameters) + "";
}
catch (Exception)
{
str = "catch";
}
}
else if (rblPayType.SelectedValue == "23") //23 提现 o
{
BaseHelper baseHelper = new BaseHelper();
SqlParameter[] parameters =
{
new SqlParameter("@Uid", SqlDbType.Int),
new SqlParameter("@PayNo", SqlDbType.VarChar, 50)
};
parameters[0].Value = 5;
parameters[1].Value = 00007;
// exec [pro_Withdraw] 5,'00007'
try
{
str = baseHelper.sqlhelper.ExecByProc("pro_Withdraw", parameters) + "";
}
catch (Exception)
{
str = "catch";
}
}
else if (rblPayType.SelectedValue == "24") //24 绑卡 o
{
SystemBankCardOper systemBankCardOper = new SystemBankCardOper();
SystemBankCard systemBankCard = new SystemBankCard();
systemBankCard.BankCardNumber = "123456789";
systemBankCard.OpenAnAccountBankCard = "中国银行";
systemBankCard.UserId = int.Parse("12");
systemBankCard.IsDefault = true;
str = systemBankCardOper.Add(systemBankCard) == 1 ? "绑卡成功" : "绑卡失败";
}
else if (rblPayType.SelectedValue == "25")//25 取消绑卡 o
{
// 同步返回处理
SystemBankCardOper systemBankCardOper = new SystemBankCardOper();
string UserId = "12";
str = systemBankCardOper.UpdateByUserId(UserId) ? "取消绑卡成功" : "取消绑卡失败";
}
else if (rblPayType.SelectedValue == "26") //26 企业用户注册 o
{
}
else if (rblPayType.SelectedValue == "271") //27
{
}
else if (rblPayType.SelectedValue == "272") //27
{
BaseHelper baseHelper = new BaseHelper();
// 调用存储过程 ：业务处理
string errorMsg = "";
string splatformUserNo = platformUserNo;
string srequestNo = requestNo;
YeePayOper yeePayOper = new YeePayOper();
bool reuslt = yeePayOper.ToCpTransaction(srequestNo, out errorMsg);
if (reuslt)
{
MoneyCarCar.Models.YeePay.RequestModel.Complete_Transaction complete_Transaction = new MoneyCarCar.Models.YeePay.RequestModel.Complete_Transaction();
complete_Transaction.platformUserNo = platformUserNo;
complete_Transaction.requestNo = srequestNo;
complete_Transaction.mode = EnumModeCOMPLETETRANSACTION.CONFIRM.ToString();
BaseResultDto <MoneyCarCar.Models.YeePay.Response.COMPLETE_TRANSACTION.response> baseResultDtoResponse = new BaseResultDto <MoneyCarCar.Models.YeePay.Response.COMPLETE_TRANSACTION.response>();
YeePay yeepay = new YeePay();
baseResultDtoResponse = yeepay.COMPLETE_TRANSACTION(complete_Transaction);
string strs = baseResultDtoResponse.ErrorMsg;//XML 数据
}
}
else if (rblPayType.SelectedValue == "273") //27
{
}
else if (rblPayType.SelectedValue == "274") //27
{
}
else if (rblPayType.SelectedValue == "28") //28 自动投标授权 o
{
}
else if (rblPayType.SelectedValue == "29") //29 自动还款授权 o
{
}
else if (rblPayType.SelectedValue == "31") //31 账户查询 o
{
}
else if (rblPayType.SelectedValue == "32") //32 资金冻结 o
{
}
else if (rblPayType.SelectedValue == "33") //33 资金解冻 o
{
}
else if (rblPayType.SelectedValue == "34") //34 直接转账
{
}
else if (rblPayType.SelectedValue == "35") //35 自动转账授权
{
}
else if (rblPayType.SelectedValue == "36") //36 单笔业务查询
{
}
else if (rblPayType.SelectedValue == "37") //37 转账确认
{
}
txtReturnValue.Text = str;
}
