protected void btnSubmit_Click(object sender, EventArgs e) { decimal num = ADeeWu.HuoBi3J.Libary.Utility.GetDecimal(this.txtTransferMoney.Text, 0m); if (num <= 0m) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("请填写正确转帐金额的倍数!"); return; } if (entUser.Money < ADeeWu.HuoBi3J.Web.GlobalParameter.MinTransferMoney) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg(string.Format("当前余额不足转帐最低金额:{0} 元", GlobalParameter.MinTransferMoney)); return; } decimal transferMoney = num * ADeeWu.HuoBi3J.Web.GlobalParameter.MinTransferMoney; if (transferMoney > entUser.Money) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg(string.Format("转帐金额({0}元)超出当前帐户余额 ({1}元)", transferMoney, entUser.Money)); return; } string aplipayAccount = this.txtAlipayAccount.Text.Trim(); string aplipayAccount2 = this.txtAlipayAccount2.Text.Trim(); if (aplipayAccount == "") { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("请输入需要入帐的支付宝帐号!"); return; } if (aplipayAccount2 == "") { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("请再次输入确认支付宝帐号!"); return; } if (aplipayAccount != aplipayAccount2) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("两次支付宝帐号输入不一致!"); return; } //检测是否已提交申请转帐 if (dalApplication.Exist( string.Format("UserID={0} and CheckState <> 1", entUser.ID) ) ) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("不能重复提交申请,您已提交的申请还没有处理!"); this.litMsg.Text = "不能重复提交申请,您已提交的申请还没有处理!"; return; } ADeeWu.HuoBi3J.Model.User_TransferApplications entApplication = new ADeeWu.HuoBi3J.Model.User_TransferApplications(); entApplication.CheckState = 0; entApplication.CreateTime = DateTime.Now; entApplication.ModifyTime = DateTime.Now; entApplication.TransferMoney = transferMoney; entApplication.AlipayAccount = aplipayAccount; entApplication.UserID = entUser.ID; if (dalApplication.Add(entApplication) > 0) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg(this,"提交成功,我们将尽快为您处理!如有需要请致电给我们!", "Default.aspx"); } else { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg(this, "操作失败,请与我们联系!", "Default.aspx"); } }
public ADeeWu.HuoBi3J.Model.User_TransferApplications GetEntity(string where) { DataTable dt = this.Select(where,""); if(dt.Rows.Count==0) return null; DataRow dr = dt.Rows[0]; ADeeWu.HuoBi3J.Model.User_TransferApplications Entity = new ADeeWu.HuoBi3J.Model.User_TransferApplications(); Entity.ID = long.Parse(dr["ID"].ToString()); Entity.UserID = long.Parse(dr["UserID"].ToString()); Entity.TransferMoney = decimal.Parse(dr["TransferMoney"].ToString()); Entity.AlipayAccount = (string)(dr["AlipayAccount"]); Entity.CheckState = int.Parse(dr["CheckState"].ToString()); Entity.Notes = (string)(dr["Notes"]); Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString()); Entity.ModifyTime = DateTime.Parse(dr["ModifyTime"].ToString()); return Entity; }
public ADeeWu.HuoBi3J.Model.User_TransferApplications[] GetEntityList(string orderBy,string[] columns,params object[] values) { StringBuilder builder = new StringBuilder(); builder.Append("select * from [User_TransferApplications] where 1=1"); db.Parameters.Clear(); for(int i=0;i<columns.Length;i++) { builder.AppendFormat(" and [{0}]=@{0}", columns[i]); db.Parameters.Append("@"+columns[i],values[i]); } if (!string.IsNullOrEmpty(orderBy)) { builder.AppendFormat(" order by {0}", orderBy); } DataTable dt = db.Select(builder.ToString()); ADeeWu.HuoBi3J.Model.User_TransferApplications[] EntityList = new ADeeWu.HuoBi3J.Model.User_TransferApplications[dt.Rows.Count]; if (dt.Rows.Count == 0) return EntityList; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; ADeeWu.HuoBi3J.Model.User_TransferApplications Entity = new ADeeWu.HuoBi3J.Model.User_TransferApplications(); Entity.ID = long.Parse(dr["ID"].ToString()); Entity.UserID = long.Parse(dr["UserID"].ToString()); Entity.TransferMoney = decimal.Parse(dr["TransferMoney"].ToString()); Entity.AlipayAccount = (string)(dr["AlipayAccount"]); Entity.CheckState = int.Parse(dr["CheckState"].ToString()); Entity.Notes = (string)(dr["Notes"]); Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString()); Entity.ModifyTime = DateTime.Parse(dr["ModifyTime"].ToString()); EntityList[i] = Entity; } return EntityList; }
public ADeeWu.HuoBi3J.Model.User_TransferApplications GetEntity(long ID) { db.Parameters.Clear(); db.Parameters.Append("@ID",ID); DataTable dt = db.Select("select * from [User_TransferApplications] where 1=1 and [ID]=@ID"); if(dt.Rows.Count==0) return null; DataRow dr = dt.Rows[0]; ADeeWu.HuoBi3J.Model.User_TransferApplications Entity = new ADeeWu.HuoBi3J.Model.User_TransferApplications(); Entity.ID = long.Parse(dr["ID"].ToString()); Entity.UserID = long.Parse(dr["UserID"].ToString()); Entity.TransferMoney = decimal.Parse(dr["TransferMoney"].ToString()); Entity.AlipayAccount = (string)(dr["AlipayAccount"]); Entity.CheckState = int.Parse(dr["CheckState"].ToString()); Entity.Notes = (string)(dr["Notes"]); Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString()); Entity.ModifyTime = DateTime.Parse(dr["ModifyTime"].ToString()); return Entity; }