public JsonResult postMember()
{
Hashtable aHT = Authorizes.GetAuthorizeCache(Request);
if (aHT != null)
{
DictSetUtil ds_member = new DictSetUtil(new DataSet());
ds_member.SetValue("nickname", Request["nickname"]);
ds_member.SetValue("email", Request["email"]);
ds_member.SetValue("realname", Request["realname"]);
ds_member.SetValue("idtype", Request["idtype"]);
ds_member.SetValue("id", Request["id"]);
ds_member.SetValue("ask", Request["ask"]);
ds_member.SetValue("answer", Request["answer"]);
ParamUtil aPU = new ParamUtil()
.SetCmd(AAccountUtil.CPostMemberInfo)
.SetParam(aHT["DOMAINUSER"]).SetParam("c_pass", Request["c_pass"]).SetParam("member", ds_member.MyDS)
.ExecuteCmd(new AAccountUtil());
if (aPU.IsOK())
{
return(Json(new { flag = "y", message = "success" }));
}
else
{
return(Json(new { flag = "n", message = aPU.GetError() }));
}
}
return(Json(new { flag = "n", message = "账户登录状态失效" }));
}
public static void SetAuthorizeCache(HttpRequestBase Request, HttpResponseBase Response, Hashtable aHT)
{
if (string.IsNullOrEmpty(Request["account"]))
{
throw new ArgumentNullException("account");
}
if (string.IsNullOrEmpty(Request["vcode"]))
{
throw new ArgumentNullException("vcode");
}
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
1,
string.Format("{0}@{1}", Request["account"], aHT["DOMAINNAME"]),
DateTime.Now,
Request["remeber"] == "on" ? DateTime.Now.AddDays(10) : DateTime.Now.AddDays(1),
false,
Request.UserHostAddress
);
// 通过IP+时间戳+验证码生成一个唯一的sessionid。
string __sid = new DictSetUtil(null).PushSLItem(Request.UserHostAddress).PushSLItem(Functions.ToTimestamp(DateTime.Now)).PushSLItem(Request["vcode"])
.DoSignature();
// 缓存到服务器内存中（仅保存30分钟，如果30分钟内处于闲置状态则会清除）
ACachTool.PickCachTool().SetValue(__sid, FormsAuthentication.Encrypt(authTicket), 30);
ACachTool.PickCachTool().SetValue(authTicket.Name, aHT, 30);
// cookie保存一个月
HttpCookie cookie = new HttpCookie("__sid", __sid);
cookie.Expires = DateTime.Now.AddMonths(1);
Response.Cookies.Add(cookie);
}
public JsonResult changeBank()
{
Hashtable aHT = Authorizes.GetAuthorizeCache(Request);
if (aHT != null)
{
DictSetUtil ds_digest = new DictSetUtil(new DataSet());
ds_digest.SetValue("realname", Request["realname"]);
ds_digest.SetValue("bankno", Request["bankno"]);
ds_digest.SetValue("bankname", Request["bankname"]);
ds_digest.SetValue("province", Request["province"]);
ds_digest.SetValue("province_name", Request["province_name"]);
ds_digest.SetValue("city", Request["city"]);
ds_digest.SetValue("city_name", Request["city_name"]);
ds_digest.SetValue("subbank", Request["subbank"]);
ds_digest.SetValue("cardnum", Request["cardnum"]);
ParamUtil aPU = new ParamUtil()
.SetCmd(AAccountUtil.CChangeBank)
.SetParam(aHT["DOMAINUSER"]).SetParam("c_pass", Request["c_pass"]).SetParam("realname", Request["realname"]).SetParam("digest", ds_digest.MyDS)
.ExecuteCmd(new AAccountUtil());
if (aPU.IsOK())
{
return(Json(new { flag = "y", message = "success" }));
}
else
{
return(Json(new { flag = "n", message = aPU.GetError() }));
}
}
return(Json(new { flag = "n", message = "账户登录状态失效" }));
}
private void ChangeBank(Hashtable Params)
{
string account = PickParam(Params).GetValueAsString();
string c_pass = PickParam(Params).GetValueAsString("c_pass");
string realname = PickParam(Params).GetValueAsString("realname");
DataSet ds_digest = PickParam(Params).GetValueAsDataSet("digest");
try
{
if (string.IsNullOrEmpty(account))
{
throw new ArgumentNullException("account", "未传入账户名");
}
if (string.IsNullOrEmpty(c_pass))
{
throw new ArgumentNullException("c_pass", "未传入支付密码");
}
if (string.IsNullOrEmpty(realname))
{
throw new ArgumentNullException("realname", "未传入开户人姓名");
}
if (ds_digest == null)
{
throw new ArgumentNullException("digest", "未传入银行卡签名数据");
}
// 验证密码
ParamUtil verifyPwd = new ParamUtil().SetCmd(CVerifyPasswrod).SetParam(account).SetParam("pwd", c_pass).SetParam("type", "pay").ExecuteCmd(this);
if (verifyPwd.GetValueAsBool() == false)
{
throw new Exception(verifyPwd.GetError());
}
else
{
// 修改银行卡信息
string passport = string.Format("{0}@caika.com", account);
DataSet dsMember = new ParamUtil()
.SQLCmdLoadData()
.SQLEntityScript("CAIKA_MEMBER", string.Format("SELECT * FROM CAIKA_MEMBER WHERE SSOPST='{0}'", passport))
.ExecuteCmd(ADataLoader.DataLoader())
.GetValueAsDataSet();
string key = new DictSetUtil(null).PushSLItem(passport).PushSLItem(c_pass).PushSLItem("Bank").DoSignature();
if (AEntryDic.Pick(GetControl()).SetDic(ds_digest, key))
{
dsMember.Tables[0].Rows[0]["REALNAME"] = realname;
dsMember.Tables[0].Rows[0]["BANKDIGEST"] = key;
dsMember.Tables[0].Rows[0]["ETIME"] = DateTime.Now;
new ParamUtil().SQLCmdPersistent().SetParam(dsMember).ExecuteCmd(ADataLoader.DataLoader());
}
}
}
catch (Exception ex1)
{
PickParam(Params).Clear().SetError(ex1.Message);
}
}
private void AppendJournal(Hashtable Params)
{
string username = PickParam(Params).GetValueAsString("username");
string t_id = PickParam(Params).GetValueAsString("t_id");
string journal_type = PickParam(Params).GetValueAsString();
try
{
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(t_id) || string.IsNullOrEmpty(journal_type))
{
throw new ArgumentException("接收到的参数列表存在错误！");
}
string passport = string.Format("{0}@caika.com", username);
DataSet dsPersistent = new ParamUtil()
.SQLCmdLoadData()
.SQLEntityScript("CAIKA_MEMBER_JOURNAL", string.Format("SELECT * FROM CAIKA_MEMBER_JOURNAL WHERE ID='{0}' AND SSOPST='{1}'", t_id, passport))
.ExecuteCmd(ADataLoader.DataLoader()).GetValueAsDataSet();
DataRow row_joural = null;
if (dsPersistent.Tables["CAIKA_MEMBER_JOURNAL"].Rows.Count == 0)
{
row_joural = dsPersistent.Tables["CAIKA_MEMBER_JOURNAL"].NewRow();
row_joural["ID"] = t_id;
row_joural["SSOPST"] = passport;
row_joural["CTIME"] = DateTime.Now;
dsPersistent.Tables["CAIKA_MEMBER_JOURNAL"].Rows.Add(row_joural);
}
row_joural = dsPersistent.Tables["CAIKA_MEMBER_JOURNAL"].Rows[0];
row_joural["JOURNALTIME"] = DateTime.Now;
row_joural["TYPE"] = BASE.journal_type.充值;
row_joural["AMOUNT"] = PickParam(Params).GetValue("amount");
// 通行证+超级密码
string key = new DictSetUtil(null).PushSLItem(passport).PushSLItem("6B276432FFAF4FD4E086E739009256B3")
.DoSignature();
row_joural["AVAILABLE"] = new DictSetUtil(AEntryDic.Pick().GetDic(key)).GetValue("AVAILABLE");
row_joural["CHECKSIGNATURE"] = new DictSetUtil(null).PushSLItem(passport).PushSLItem(t_id).DoSignature();
row_joural["STATE"] = journal_state.待审核;
row_joural["ETIME"] = DateTime.Now;
// 生成一个流水账的对账单
DictSetUtil ds_record = new DictSetUtil(new DataSet());
ds_record.SetValue("channel", PickParam(Params).GetValueAsString("channel"));
ds_record.SetValue("bank", PickParam(Params).GetValueAsString("bank"));
ds_record.SetValue("amount", PickParam(Params).GetValueAsString("amount"));
if (AEntryDic.Pick().SetDic(ds_record.MyDS, row_joural.Field <string>("CHECKSIGNATURE")))
{
new ParamUtil().SQLCmdPersistent().SetParam(dsPersistent).ExecuteCmd(ADataLoader.DataLoader());
}
}
catch (Exception ex1)
{
PickParam(Params).Clear().SetError(ex1.Message);
}
}
private void PostMemberInfo(Hashtable Params)
{
string account = PickParam(Params).GetValueAsString();
string c_pass = PickParam(Params).GetValueAsString("c_pass");
DataSet ds_member = PickParam(Params).GetValueAsDataSet("member");
try
{
if (string.IsNullOrEmpty(account))
{
throw new ArgumentNullException("account", "未传入账户名");
}
if (string.IsNullOrEmpty(c_pass))
{
throw new ArgumentNullException("c_pass", "未传入登录密码");
}
if (ds_member == null)
{
throw new ArgumentNullException("member", "未传入会员数据");
}
DictSetUtil dsinfo = new DictSetUtil(ds_member);
// 验证密码
ParamUtil verifyPwd = new ParamUtil().SetCmd(CVerifyPasswrod).SetParam(account).SetParam("pwd", c_pass).SetParam("type", "pay").ExecuteCmd(this);
if (verifyPwd.GetValueAsBool() == false)
{
throw new Exception(verifyPwd.GetError());
}
else
{
// 修改会员信息
string passport = string.Format("{0}@caika.com", account);
DataSet dsMember = new ParamUtil()
.SQLCmdLoadData()
.SQLEntityScript("CAIKA_MEMBER", string.Format("SELECT * FROM CAIKA_MEMBER WHERE SSOPST='{0}'", passport))
.ExecuteCmd(ADataLoader.DataLoader())
.GetValueAsDataSet();
dsMember.Tables[0].Rows[0]["NICKNAME"] = dsinfo.GetValue("nickname");
dsMember.Tables[0].Rows[0]["EMAIL"] = dsinfo.GetValue("email");
dsMember.Tables[0].Rows[0]["REALNAME"] = dsinfo.GetValue("realname");
dsMember.Tables[0].Rows[0]["IDTYPE"] = dsinfo.GetValue("idtype");
dsMember.Tables[0].Rows[0]["UID"] = dsinfo.GetValue("id");
dsMember.Tables[0].Rows[0]["ASKID"] = dsinfo.GetValue("ask");
dsMember.Tables[0].Rows[0]["ANSWER"] = dsinfo.GetValue("answer");
dsMember.Tables[0].Rows[0]["ETIME"] = DateTime.Now;
new ParamUtil().SQLCmdPersistent().SetParam(dsMember).ExecuteCmd(ADataLoader.DataLoader());
}
}
catch (Exception ex1)
{
PickParam(Params).Clear().SetError(ex1.Message);
}
}
private void DIGEST(Hashtable Params)
{
// 编辑器属性成员集合
MyPropertyDescriptorCollection properties = PickParam(Params).GetValue() as MyPropertyDescriptorCollection;
if (properties != null)
{
MyPropertyItemDescriptor curProperty = properties.FirstOrDefault(cm => cm.PropertyName == PickParam(Params).GetCmd());
if (curProperty == null)
{
throw new Exception(string.Format("在当前编辑器内未解析到【{0}】属性信息。", PickParam(Params).GetCmd()));
}
// 得到账户的资金摘要
DictSetUtil dictDigest = new DictSetUtil(AEntryDic.Pick(GetControl()).GetDic(curProperty.Value as string));
DataRow curRow = (DataRow)PickParam(Params).GetValue(ActionUtil.Current);
curRow["TOTALAMOUNT"] = dictDigest.GetValue("TOTALAMOUNT");
curRow["AVAILABLE"] = dictDigest.GetValue("AVAILABLE");
curRow["FREEZED"] = dictDigest.GetValue("FREEZED");
curRow["SCORE"] = dictDigest.GetValue("SCORE");
// 总资金
MyPropertyItemDescriptor total = properties.FirstOrDefault(cm => cm.PropertyName == "TOTALAMOUNT");
if (total != null)
{
total.Value = dictDigest.GetValue("TOTALAMOUNT");
}
// 可用资金
MyPropertyItemDescriptor available = properties.FirstOrDefault(cm => cm.PropertyName == "AVAILABLE");
if (available != null)
{
available.Value = dictDigest.GetValue("AVAILABLE");
}
// 冻结资金
MyPropertyItemDescriptor freezed = properties.FirstOrDefault(cm => cm.PropertyName == "FREEZED");
if (freezed != null)
{
freezed.Value = dictDigest.GetValue("FREEZED");
}
// 积分
MyPropertyItemDescriptor score = properties.FirstOrDefault(cm => cm.PropertyName == "SCORE");
if (score != null)
{
score.Value = dictDigest.GetValue("SCORE");
}
}
}
private void GetAccountSummary(Hashtable Params)
{
string passport = PickParam(Params).GetValueAsString();
if (string.IsNullOrEmpty(passport))
{
PickParam(Params).Clear().SetError("未传入通行证");
}
else
{
// 得到会员信息
DataSet dsMember = new ParamUtil().SQLCmdLoadData().SQLEntityScript("CAIKA_MEMBER", string.Format("SELECT * FROM CAIKA_MEMBER WHERE SSOPST='{0}'", passport))
.ExecuteCmd(ADataLoader.DataLoader()).GetValueAsDataSet();
if (dsMember.Tables["CAIKA_MEMBER"].Rows.Count == 0)
{
PickParam(Params).Clear().SetError("未找到会员记录");
}
else
{
// 通行证+超级密码
string key = new DictSetUtil(null).PushSLItem(passport).PushSLItem("6B276432FFAF4FD4E086E739009256B3")
.DoSignature();
DictSetUtil dsSummary = new DictSetUtil(AEntryDic.Pick().GetDic(key));
dsSummary.SetValue("NICKNAME", dsMember.Tables["CAIKA_MEMBER"].Rows[0]["NICKNAME"].ToString());
PickParam(Params).Clear();
PickParam(Params).SetParam(dsSummary.MyDS);
// 将账户摘要同步到Member表中
if (dsMember.Tables["CAIKA_MEMBER"].Rows[0]["UPDFLAG"].ToString() != "N")
{
dsMember.Tables["CAIKA_MEMBER"].Rows[0]["TOTALAMOUNT"] = dsSummary.GetValue("TOTALAMOUNT");
dsMember.Tables["CAIKA_MEMBER"].Rows[0]["AVAILABLE"] = dsSummary.GetValue("AVAILABLE");
dsMember.Tables["CAIKA_MEMBER"].Rows[0]["FREEZED"] = dsSummary.GetValue("FREEZED");
dsMember.Tables["CAIKA_MEMBER"].Rows[0]["SCORE"] = dsSummary.GetValue("SCORE");
dsMember.Tables["CAIKA_MEMBER"].Rows[0]["UPDFLAG"] = "N";
new ParamUtil().SQLCmdPersistent().SetParam(dsMember).ExecuteCmd(ADataLoader.DataLoader());
}
}
}
}
public static DataSet GetMemberInfo(string account)
{
try
{
DataSet dsMember = new ParamUtil()
.SQLCmdLoadData()
.SQLWithOutSchema()
.SQLEntityScript("CAIKA_MEMBER", string.Format("SELECT * FROM CAIKA_MEMBER WHERE SSOPST='{0}'", account))
.ExecuteCmd(ADataLoader.DataLoader())
.GetValueAsDataSet();
DictSetUtil dsInfo = new DictSetUtil(new UriUtil().ImportRow(dsMember.Tables[0].Rows[0]).DSQueryItem);
return(dsInfo.MyDS);
}
catch (Exception)
{
return(null);
}
}
public JsonResult queryJournalList()
{
Hashtable aHT = Authorizes.GetAuthorizeCache(Request);
if (aHT != null)
{
// 返回账户流水清单
DataSet ds_result = new ParamUtil()
.SetCmd(AAccountUtil.CGetJournalList)
.SetParam(aHT["DOMAINUSER"]).SetParam("type", Request["t"]).SetParam("time", Request["m"]).SetParam("pageno", Request["pageno"])
.ExecuteCmd(new AAccountUtil())
.GetValueAsDataSet();
var rows = ds_result.Tables["list"].Rows.OfType <DataRow>().Select(
cm => new journalItem()
{
t_id = cm["ID"].ToString(),
time = cm["JOURNALTIME"].ToString(),
type = cm["TYPE"].ToString(),
amount = string.Format("{0:f}", cm["AMOUNT"]),
available = string.Format("{0:f}", cm["AVAILABLE"]),
remark = cm["REMARK"].ToString(),
state = cm["STATE"].ToString()
});
DictSetUtil ds_total = new DictSetUtil(ds_result);
return(Json(new
{
flag = "y",
pagenums = ds_result.Tables["pages"].Rows.Count > 0 ? ds_result.Tables["pages"].Rows[0][0] : 0,
pageno = string.IsNullOrEmpty(Request["pageno"]) ? "1" : Request["pageno"],
deposited = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.充值)) ? "0.00" : ds_total.GetValue(journal_type.充值)),
bonus = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.中奖)) ? "0.00" : ds_total.GetValue(journal_type.中奖)),
exchanged = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.积分兑换)) ? "0.00" : ds_total.GetValue(journal_type.积分兑换)),
returned = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.返点)) ? "0.00" : ds_total.GetValue(journal_type.返点)),
consume = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.投注)) ? "0.00" : ds_total.GetValue(journal_type.投注)),
withdraw = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.提现)) ? "0.00" : ds_total.GetValue(journal_type.提现)),
rows = rows.ToList()
}));
}
return(Json(new { flag = "n" }));
}
/// <summary>
/// 获取会员账号的资金摘要信息
/// </summary>
/// <param name="objControl"></param>
/// <param name="accountId"></param>
/// <returns></returns>
public static DataSet GetMemberDigest(IControl objControl, string accountId = "")
{
DictSetUtil digestDS = new DictSetUtil(new DataSet());
try
{
digestDS.SetValue("TOTALAMOUNT", "0.00"); // 账户总额
digestDS.SetValue("AVAILABLE", "0.00"); // 可用余额
digestDS.SetValue("FREEZED", "0.00"); // 冻结金额
digestDS.SetValue("SCORE", "0"); // 积分
digestDS.SetValue("DEPOSITED", "0.0"); // 充值金额
digestDS.SetValue("BONUS", "0.0"); // 中奖金额
digestDS.SetValue("EXCHANGED", "0.0"); // 积分兑换
digestDS.SetValue("RETURNED", "0.0"); // 游戏返点
digestDS.SetValue("CONSUME", "0.0"); // 投注金额
digestDS.SetValue("WITHDRAW", "0.0"); // 提款金额
// 得到会员账号的资金摘要信息
if (!string.IsNullOrEmpty(accountId))
{
ParamUtil aPU = new ParamUtil()
.SQLCmdLoadData()
.SQLEntityScript("CAIKA_MEMBER", string.Format("SELECT * FROM CAIKA_MEMBER WHERE ACCOUNTID='{0}'", accountId))
.SQLWithOutSchema()
.ExecuteCmd(ADataLoader.DataLoader());
if (aPU.IsOK())
{
DataSet dsDigest = AEntryDic.Pick(objControl).GetDic(aPU.GetValueAsDataSet().Tables["CAIKA_MEMBER"].Rows[0].Field <string>("DIGEST"));
if (dsDigest != null)
{
digestDS.MyDS.Merge(dsDigest);
digestDS.AcceptChanges();
}
}
}
}
catch (Exception)
{
}
return(digestDS.MyDS);
}
public PageModel(BaseController controller, string file)
{
Parameters = new DynamicParameters();
ParamUtil aPU = new ParamUtil().SQLCmdLoadDataFromXML(file).ExecuteCmd(ADataLoader.LocalDataLoader());
if (!aPU.IsOK())
{
throw new InvalidOperationException(string.Format("上下文中未匹配到合适的Model信息！ file={0}", file));
}
DictSetUtil aXTCS = new DictSetUtil(aPU.GetValueAsDataSet());
Title = aXTCS.GetValue("Title");
Description = aXTCS.GetValue("Description");
Keywords = aXTCS.GetValue("Keywords");
ResConfigFile = aXTCS.GetValue("ResConfigFile");
AppDomain = controller.AppDomain;
ResVersion = controller.ResVersion;
}
private void GetQRImage(Hashtable Params)
{
DictSetUtil dictSet = new DictSetUtil(PickParam(Params).ExportDS());
DictSetUtil dictParams = new DictSetUtil(new DSUtil(dictSet.MyDS).SetFilter(DictSet.TableName, string.Format("{0} LIKE 'params.%'", DictSet.FN_MCCanShu)).ExportDS());
string s_id = PickParam(Params).GetValueAsString("v");
string u_id = PickParam(Params).GetValueAsString("u");
string a_id = PickParam(Params).GetValueAsString("a");
string orderId = new DictSetUtil(null).PushSLItem(s_id).PushSLItem(u_id).DoSignature();
List <string> aList = new List <string>();
aList.Add("parter=" + dictParams.GetValue("params.customerid")); // 商户id，由分配
aList.Add("type=" + dictParams.GetValue("params.paytype")); //银行类型，具体请参考附录1
aList.Add("value=" + a_id); //单位元（人民币），2位小数，最小支付金额为0.02
aList.Add("orderid=" + "12345678910"); // 商户系统订单号，该订单号将作为接口的返回数据。该值需在商户系统内唯一，系统暂时不检查该值是否唯一
aList.Add("callbackurl=" + dictParams.GetValue("params.callbackurl")); //下行异步通知过程的返回地址，需要以http://开头且没有任何参数
string sign = PaymentUtil.EncryptMD5(string.Join("&", aList) + dictParams.GetValue("params.paymentkey"));
aList.Add("refbackurl=" + dictParams.GetValue("params.refbackurl")); // 页面通知地址
aList.Add("payerIp=127.0.0.1"); //用户在下单时的真实IP，接口将会判断玩家支付时的ip和该值是否相同。若不相同，接口将提示用户支付风险(可为空)
aList.Add("attach=test"); //备注信息，下行中会原样返回。若该值包含中文，请注意编码
aList.Add("sign=" + sign); // 签名信息 ，MD5 后32位小写
string postDataStr = string.Join("&", aList);
HttpWebRequest aRequest = (HttpWebRequest)WebRequest.Create("http://pay.shengyuanpay.com/chargebank.aspx" + (postDataStr == "" ? "" : "?") + postDataStr);
aRequest.Method = "GET";
aRequest.ContentType = "text/html; charset=UTF-8";
using (HttpWebResponse postResponse = aRequest.GetResponse() as HttpWebResponse)
{
using (StreamReader aStream = new StreamReader(postResponse.GetResponseStream(), Encoding.UTF8))
{
string retString = aStream.ReadToEnd();
}
}
}
private void VerifyPasswrod(Hashtable Params)
{
string account = PickParam(Params).GetValueAsString();
string pwd = PickParam(Params).GetValueAsString("pwd");
string type = PickParam(Params).GetValueAsString("type");
try
{
if (type == "pay")
{
DataSet dsMember = new ParamUtil()
.SQLCmdLoadData()
.SQLWithOutSchema()
.SQLEntityScript("CAIKA_MEMBER", string.Format("SELECT * FROM CAIKA_MEMBER WHERE SSOPST='{0}@caika.com'", account))
.ExecuteCmd(ADataLoader.DataLoader())
.GetValueAsDataSet();
DataRow rowMember = dsMember.Tables[0].Rows[0];
string signature = new DictSetUtil(null).DoSignature(pwd);
if (signature == rowMember.Field <string>("WITHDRAWALS").Trim())
{
PickParam(Params).Clear().SetParam(true);
}
else
{
PickParam(Params).Clear().SetError("密码输入不正确");
PickParam(Params).SetParam(false);
}
}
else
{
// 得到通行证数据
DataSet dsPassport = new ParamUtil()
.SQLCmdLoadData()
.SQLEntityScript("SSODOMAINREF", string.Format("SELECT * FROM SSODOMAINREF WHERE DOMAINNAME='caika.com' AND DOMAINUSER='******'", account))
.SQLEntityScript("SSOPASSPORT", string.Format("SELECT * FROM SSOPASSPORT WHERE SSOPST = '{0}@caika.com'", account))
.ExecuteCmd(ADataLoader.DataLoader())
.GetValueAsDataSet();
if (dsPassport.Tables["SSODOMAINREF"].Rows.Count == 0 || dsPassport.Tables["SSOPASSPORT"].Rows.Count == 0)
{
PickParam(Params).Clear().SetError("用户名或密码错误");
PickParam(Params).SetParam(false);
}
else
{
ParamUtil aPU = new ParamUtil().SetCmd(CVerifyPasswrod).SetParam(dsPassport).SetParam("PSTPWD", pwd).ExecuteCmd(new APassport());
if (aPU.IsOK())
{
PickParam(Params).Clear();
PickParam(Params).SetParam(aPU.GetValue());
}
else
{
PickParam(Params).Clear().SetError(aPU.GetError());
PickParam(Params).SetParam(false);
}
}
}
}
catch (Exception)
{
PickParam(Params).Clear().SetError("校验密码出错");
PickParam(Params).SetParam(false);
}
}
public ActionResult UserCenter(string id)
{
Hashtable aHT = Authorizes.GetAuthorizeCache(Request);
if (aHT != null)
{
if (string.IsNullOrEmpty(id))
{
id = "zhmx";
}
PageModel model = new PageModel(this, @"model\usercenter.xml");
model.Parameters.Subpage = id;
model.Parameters.Pid = string.Format("{0}{1}", id, Request["t"]);
model.Parameters.Account = ParamUtil.Pick(aHT).GetValueAsString("DOMAINUSER");
model.Parameters.NickName = ParamUtil.Pick(aHT).GetValueAsString("NICKNAME");
model.Parameters.LoginTime = ParamUtil.Pick(aHT).GetValueAsString("LOGINTIME");
model.Parameters.Available = string.Format("{0:f2}", Convert.ToDecimal(aHT["AVAILABLE"]));
model.Parameters.Freezed = string.Format("{0:f2}", Convert.ToDecimal(aHT["FREEZED"]));
model.Parameters.Score = aHT["SCORE"].ToString();
switch (id)
{
case "czlink":
model.Parameters.PayList = CommonDBUtils.GetPaymentList();
break;
case "zhmx":
// 返回账户流水清单
DataSet ds_result = new ParamUtil()
.SetCmd(AAccountUtil.CGetJournalList)
.SetParam(model.Parameters.Account).SetParam("type", Request["t"]).SetParam("time", Request["m"]).SetParam("pageno", Request["pageno"])
.ExecuteCmd(new AAccountUtil())
.GetValueAsDataSet();
model.Parameters.List = ds_result.Tables["list"];
DictSetUtil ds_total = new DictSetUtil(ds_result);
model.Parameters.Deposited = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.充值)) ? "0.00" : ds_total.GetValue(journal_type.充值));
model.Parameters.Bonus = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.中奖)) ? "0.00" : ds_total.GetValue(journal_type.中奖));
model.Parameters.Exchanged = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.积分兑换)) ? "0.00" : ds_total.GetValue(journal_type.积分兑换));
model.Parameters.Returned = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.返点)) ? "0.00" : ds_total.GetValue(journal_type.返点));
model.Parameters.Consume = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.投注)) ? "0.00" : ds_total.GetValue(journal_type.投注));
model.Parameters.Withdraw = string.Format("{0:f}", string.IsNullOrEmpty(ds_total.GetValue(journal_type.提现)) ? "0.00" : ds_total.GetValue(journal_type.提现));
model.Parameters.Type = Request["t"];
model.Parameters.Time = Request["m"];
model.Parameters.PageNo = string.IsNullOrEmpty(Request["pageno"]) ? "1" : Request["pageno"];
model.Parameters.PageNums = 0;
if (ds_result.Tables["pages"].Rows.Count > 0)
{
model.Parameters.PageNums = ds_result.Tables["pages"].Rows[0][0];
}
break;
case "zhmm":
model.Parameters.WithdrawIsEmpty = AAccountUtil.WithdrawIsEmpty(ParamUtil.Pick(aHT).GetValueAsString("DOMAINUSER"));
break;
case "bdyhk":
model.Parameters.Provinces = CommonDBUtils.GetAreas();
// 返回账户的绑定的银行卡数据
DictSetUtil ds_bank = new DictSetUtil(AAccountUtil.GetBankData(ParamUtil.Pick(aHT).GetValueAsString("DOMAINUSER")));
model.Parameters.BankData = ds_bank.MyDS;
model.Parameters.HaveBank = ds_bank.DSxtcs.Rows.Count > 0;
break;
case "grzl":
DictSetUtil ds_info = new DictSetUtil(AAccountUtil.GetMemberInfo(ParamUtil.Pick(aHT).GetValueAsString("DOMAINUSER")));
model.Parameters.MemberInfo = ds_info.MyDS;
model.Parameters.InfoIsFull = !string.IsNullOrEmpty(ds_info.GetValue("REALNAME")) && !string.IsNullOrEmpty(ds_info.GetValue("UID")) && !string.IsNullOrEmpty(ds_info.GetValue("ANSWER"));
break;
case "msglist":
DataSet ds_msglist = AAccountUtil.GetMessageList(ParamUtil.Pick(aHT).GetValueAsString("DOMAINUSER"), Request["pageno"]);
model.Parameters.List = ds_msglist.Tables["list"];
model.Parameters.PageNums = ds_msglist.Tables["pages"].Rows.Count > 0 ? ds_msglist.Tables["pages"].Rows[0][0] : 0;
model.Parameters.PageNo = string.IsNullOrEmpty(Request["pageno"]) ? "1" : Request["pageno"];
break;
}
return(View("UserCenter", model));
}
return(Redirect("/"));
}
private void GetQRImage(Hashtable Params)
{
DictSetUtil dictSet = new DictSetUtil(PickParam(Params).ExportDS());
DictSetUtil dictParams = new DictSetUtil(new DSUtil(dictSet.MyDS).SetFilter(DictSet.TableName, string.Format("{0} LIKE 'params.%'", DictSet.FN_MCCanShu)).ExportDS());
string s_id = PickParam(Params).GetValueAsString("v");
string u_id = PickParam(Params).GetValueAsString("u");
string a_id = PickParam(Params).GetValueAsString("a");
string orderId = new DictSetUtil(null).PushSLItem(s_id).PushSLItem(u_id).DoSignature();
List <string> aList = new List <string>();
/*------------天下付----------------
* //aList.Add("customerid=" + dictParams.GetValue("params.customerid")); // 商户ID
* //aList.Add("paytype=" + dictParams.GetValue("params.paytype")); // 支付方式
* //aList.Add("total_fee=" + a_id); // 支付金额
* //aList.Add("sdorderno=" + orderId); // 商户平台唯一订单号
* //aList.Add("notifyurl=" + dictParams.GetValue("params.notifyurl")); // 商户异步回调通知地址
* //aList.Add("returnurl=" + dictParams.GetValue("params.returnurl")); // 商户同步通知地址
* //aList.Add("version=" + dictParams.GetValue("params.version")); // 版本号
* //aList.Add("remark="); //备注(可为空)
* //aList.Add("bankcode="); // 网银直连不可为空，其他支付方式可为空
* //aList.Add("sign="+ PaymentUtil.EncryptMD5(string.Join("&", aList)+"&"+ dictParams.GetValue("params.paymentkey")));// 签名
* ------------------------------------*/
aList.Add("Amount=" + a_id.Split('.')[0]);
aList.Add("MerNo=" + dictParams.GetValue("params.customerid")); // 商户号
aList.Add("NotifyUrl=" + dictParams.GetValue("params.notifyurl")); //异步通知URL
aList.Add("PdtName=" + "测试账户"); //商品名称,不可空
aList.Add("ProductId=" + dictParams.GetValue("params.ProductId")); // 产品类型(0601：微信扫码,0602 ：支付宝扫码,0603 ：银联扫码,0604 ：QQ扫码)
aList.Add("Remark=test"); //备注(可为空)
aList.Add("ReturnUrl=" + dictParams.GetValue("params.returnurl")); // 页面通知地址
aList.Add("TxCode=" + dictParams.GetValue("params.TxCode")); // 交易编码 ，默认值 ：210110
aList.Add("TxSN=" + DateTime.Now.ToString("yyyyMMddHHmmss")); // AosuApp.Functions.ToTimestamp(DateTime.Now)商户交易流水号 唯一orderId
string sign = PaymentUtil.EncryptMD5(HttpUtility.UrlEncode(PaymentUtil.Encode(string.Join("&", aList)), Encoding.UTF8) + dictParams.GetValue("params.paymentkey"));
aList.Add("Signature=" + sign); // 签名信息 ，MD5 后32位小写
aList.Add("SignMethod=" + "MD5"); // 签名方法 ，默认值 ：MD5
byte[] data = Encoding.UTF8.GetBytes(string.Join("&", aList));
//http://pay.095pay.com/api/order/pay
HttpWebRequest aRequest = HttpWebRequest.Create("http://api.1yigou.com.cn:8881/merchant-trade-api/command") as HttpWebRequest;
aRequest.Method = "POST";
aRequest.ContentType = "application/x-www-form-urlencoded; charset=UTF-8";
aRequest.ContentLength = data.Length;
using (Stream postStream = aRequest.GetRequestStream())
{
postStream.Write(data, 0, data.Length);
}
using (HttpWebResponse postResponse = aRequest.GetResponse() as HttpWebResponse)
{
using (StreamReader aStream = new StreamReader(postResponse.GetResponseStream(), Encoding.UTF8))
{
txf_qr_response response_data = AosuApp.DataToJsonString.Deserialize <txf_qr_response>(aStream.ReadToEnd());
if (response_data != null)
{
switch (response_data.Status)
{
case 1:
//PickParam(Params).SetParam(response_data);
//PickParam(Params).SetParam(imgstream);
//PickParam(Params).SetParam("content-type", "image/png");
using (HttpWebResponse response = HttpWebRequest.Create(response_data.ImgUrl).GetResponse() as HttpWebResponse)
{
using (Image img = new Bitmap(response.GetResponseStream()))
{
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
PickParam(Params).SetParam(ms.ToArray());
PickParam(Params).SetParam("content-type", "image/png");
}
}
break;
default:
PickParam(Params).SetError(response_data.RspCod + response_data.RspMsg);
break;
}
}
}
}
}
private void PostRequest(Hashtable Params)
{
string account = PickParam(Params).GetValueAsString();
string type = PickParam(Params).GetValueAsString("type");
string msgid = PickParam(Params).GetValueAsString("msgid");
try
{
if (string.IsNullOrEmpty(account))
{
throw new ArgumentNullException("account", "未传入账户名");
}
if (string.IsNullOrEmpty(type))
{
throw new ArgumentNullException("type", "未传入请求类型");
}
if (string.IsNullOrEmpty(msgid))
{
throw new ArgumentNullException("msgid", "未传入请求ID");
}
string uid = new DictSetUtil(null).DoSignature(msgid);
// 修改会员信息
string passport = string.Format("{0}@caika.com", account);
DataSet dsPersistent = new ParamUtil()
.SQLCmdLoadData()
.SQLEntityScript("CAIKA_MEMBER_MESSAGE", string.Format("SELECT * FROM CAIKA_MEMBER_MESSAGE WHERE MSGID='{0}'", uid))
.ExecuteCmd(ADataLoader.DataLoader())
.GetValueAsDataSet();
if (dsPersistent.Tables[0].Rows.Count == 0)
{
DataRow row_message1 = dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"].NewRow();
row_message1["MSGID"] = uid;
row_message1["SSOPST"] = "*****@*****.**";
switch (type)
{
case "1":
row_message1["MSGTYPE"] = message_id.UserRequest_ChangeMemberInfo;
row_message1["MSGTITLE"] = string.Format("{0}提交修改个人资料的请求", passport);
break;
case "2":
row_message1["MSGTYPE"] = message_id.UserRequest_ChangePayPassword;
row_message1["MSGTITLE"] = string.Format("{0}提交修改支付密码的请求", passport);
break;
}
row_message1["MSGBODY"] = "";
row_message1["STATE"] = message_state.UnRead;
row_message1["CTIME"] = DateTime.Now;
dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"].Rows.Add(row_message1);
new ParamUtil().SQLCmdPersistent().SetParam(dsPersistent).ExecuteCmd(ADataLoader.DataLoader());
}
}
catch (Exception ex1)
{
PickParam(Params).Clear().SetError(ex1.Message);
}
}
private void GetQRImage(Hashtable Params)
{
// HTTP请求参数
// 商户ID p1_mchtid 是 int 商户ID,由金阳支付分配
// 支付方式 p2_paytype 是 String(20) WEIXIN 支付网关(参见附录说明4.3)
// 支付金额 p3_paymoney 是 decimal 0.01 订单金额最小0.01(以元为单位）
// 商户平台唯一订单号 p4_orderno 是 String(50) 商户系统内部订单号，要求50字符以内，同一商户号下订单号唯一
// 商户异步回调通知地址 p5_callbackurl 是 String(200) 商户异步回调通知地址
// 商户同步通知地址 p6_notifyurl 否 String(200) 商户同步通知地址
// 版本号 p7_version 是 String(4) V2.8 V2.8
// 签名加密方式 p8_signtype 是 int 1.MD5 签名加密方式
// 备注信息，上行中attach原样返回 p9_attach 否 String(128) 备注信息，上行中attach原样返回
// 分成标识 p10_appname 否 Strng(25) 分成标识
// 是否显示收银台 p11_isshow 是 int 0 是否显示PC收银台
// 商户的用户下单IP p12_orderip 否 String(20) 192.168.10.1 商户的用户下单IP
// 签名 sign 是 String(40) MD5签名
// HTTP响应数据（JSON）
// rspCode 响应码 int 响应码（参见附录说明4.2） 是
// rspMsg 响应消息 String 200 Http请求响应消息 是
// data 响应结果 JSON类 是
// DATA的JSON格式：
// r1_mchtid 商户ID int 商户ID 是
// r2_systemorderno 系统平台订单号 String 50 第三方平台订单号码 是
// r3_orderno 商户的平台订单号 String 50 商户系统内部订单号，要求50字符以内，同一商户号下订单号唯一 是
// r4_amount 支付金额 decimal 订单金额(以元为单位） 是
// r5_version 版本号 string 4 版本号（与请求参数一致） 是
// r6_qrcode 二维码信息 String 200 二维码信息(QQ，支付宝，微信，银联，百度，京东) 是
// r7_paytype 支付方式 String 20 支付网关(参见附录说明4.3) 是
// sign 签名 String 40 MD5签名 是
DictSetUtil dictSet = new DictSetUtil(PickParam(Params).ExportDS());
DictSetUtil dictParams = new DictSetUtil(new DSUtil(dictSet.MyDS).SetFilter(DictSet.TableName, string.Format("{0} LIKE 'params.%'", DictSet.FN_MCCanShu)).ExportDS());
string s_id = PickParam(Params).GetValueAsString("v");
string u_id = PickParam(Params).GetValueAsString("u");
string a_id = PickParam(Params).GetValueAsString("a");
string orderId = new DictSetUtil(null).PushSLItem(s_id).PushSLItem(u_id).DoSignature();
List <string> aList = new List <string>();
aList.Add("p1_mchtid=" + dictParams.GetValue("params.p1_mchtid")); // 商户ID
aList.Add("p2_paytype=" + dictParams.GetValue("params.p2_paytype")); // 支付方式
aList.Add("p3_paymoney=" + a_id); // 支付金额
aList.Add("p4_orderno=" + orderId); // 商户平台唯一订单号
aList.Add("p5_callbackurl=" + dictParams.GetValue("params.p5_callbackurl")); // 商户异步回调通知地址
aList.Add("p6_notifyurl=" + dictParams.GetValue("params.p6_notifyurl")); // 商户同步通知地址
aList.Add("p7_version=" + dictParams.GetValue("params.p7_version")); // 版本号
aList.Add("p8_signtype=" + dictParams.GetValue("params.p8_signtype")); // 签名加密方式
aList.Add("p9_attach="); // 备注信息，上行中attach原样返回
aList.Add("p10_appname="); // 分成标识
aList.Add("p11_isshow="); // 是否显示收银台
aList.Add("p12_orderip="); // 商户的用户下单IP
aList.Add("sign="); // 签名
byte[] data = Encoding.UTF8.GetBytes(string.Join("&", aList));
HttpWebRequest aRequest = HttpWebRequest.Create("http://pay.095pay.com/api/order/pay") as HttpWebRequest;
aRequest.Method = "POST";
aRequest.ContentType = "application/x-www-form-urlencoded; charset=UTF-8";
aRequest.ContentLength = data.Length;
using (Stream postStream = aRequest.GetRequestStream())
{
postStream.Write(data, 0, data.Length);
}
using (HttpWebResponse postResponse = aRequest.GetResponse() as HttpWebResponse)
{
using (StreamReader aStream = new StreamReader(postResponse.GetResponseStream(), Encoding.UTF8))
{
jy_qr_response response_data = AosuApp.DataToJsonString.Deserialize <jy_qr_response>(aStream.ReadToEnd());
if (response_data != null)
{
response_data.data = new jy_qr_response.jy_qr_response_data();
response_data.data.r6_qrcode = "http://www.55tx.cn/img/ewmlogo/1001025.png";
response_data.rspCode = 1;
switch (response_data.rspCode)
{
case 1:
using (HttpWebResponse response = HttpWebRequest.Create(response_data.data.r6_qrcode).GetResponse() as HttpWebResponse)
{
using (Image img = new Bitmap(response.GetResponseStream()))
{
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
PickParam(Params).SetParam(ms.ToArray());
PickParam(Params).SetParam("content-type", "image/png");
}
}
break;
default:
PickParam(Params).SetError(response_data.rspMsg);
break;
}
}
}
}
}
private void CreateNewAccount(Hashtable Params)
{
string account = PickParam(Params).GetValueAsString("DOMAINUSER");
string domain = PickParam(Params).GetValueAsString("DOMAINNAME");
try
{
// 注册通行证
ParamUtil register = PickParam(Params).SetCmd(APassport.CRegister).ExecuteCmd(new APassport());
if (register.IsOK())
{
ParamUtil aPU = new ParamUtil()
.SQLCmdLoadData()
.SQLEntityScript("CAIKA_MEMBER", string.Format("SELECT * FROM CAIKA_MEMBER WHERE SSOPST='{0}'", register.GetValue()))
.SQLEntityScript("CAIKA_MEMBER_MESSAGE", string.Format("SELECT * FROM CAIKA_MEMBER_MESSAGE WHERE SSOPST='{0}'", register.GetValue()))
.ExecuteCmd(ADataLoader.DataLoader());
if (aPU.IsOK())
{
DataSet dsPersistent = aPU.GetValueAsDataSet();
if (dsPersistent.Tables["CAIKA_MEMBER"].Rows.Count == 0)
{
DataRow rowNew = dsPersistent.Tables["CAIKA_MEMBER"].NewRow();
rowNew["SSOPST"] = register.GetValue();
rowNew["NICKNAME"] = account;
rowNew["UPDFLAG"] = "Y";
rowNew["STATE"] = AosuApp.state.Enabled;
rowNew["CTIME"] = DateTime.Now;
rowNew["ETIME"] = DateTime.Now;
dsPersistent.Tables["CAIKA_MEMBER"].Rows.Add(rowNew);
// 添加提示信息 - 详细资料
DataRow row_message1 = AosuApp.Functions.FindRow(string.Format("MSGTYPE={0}", message_id.Account_KeyIn_DetailInfo), dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"]);
if (row_message1 == null)
{
row_message1 = dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"].NewRow();
row_message1["MSGID"] = Guid.NewGuid();
row_message1["SSOPST"] = register.GetValue();
row_message1["MSGTYPE"] = message_id.Account_KeyIn_DetailInfo;
row_message1["MSGTITLE"] = "请完善用户基本资料";
row_message1["MSGBODY"] = "<strong>完善用户基本资料提醒</strong><br/></br/>为了确保彩咖网更好的服务于您，请您完善<a href='/member/usercenter/grzl'><strong>个人资料信息</strong></a>。";
row_message1["STATE"] = message_state.UnRead;
row_message1["CTIME"] = DateTime.Now;
dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"].Rows.Add(row_message1);
}
// 添加提示信息 - 设置提款密码
DataRow row_message2 = AosuApp.Functions.FindRow(string.Format("MSGTYPE={0}", message_id.Account_KeyIn_Withdrawals), dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"]);
if (row_message2 == null)
{
row_message2 = dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"].NewRow();
row_message2["MSGID"] = Guid.NewGuid();
row_message2["SSOPST"] = register.GetValue();
row_message2["MSGTYPE"] = message_id.Account_KeyIn_Withdrawals;
row_message2["MSGTITLE"] = "请设置提款密码";
row_message2["MSGBODY"] = "<strong>设置提款密码提醒</strong><br/></br/>提款密码用于提取彩咖网账户可用余额的安全密码，请您务必设置<a href='/member/usercenter/zhmm'><strong>提款密码</strong></a>。定期重新设置提款密码能提高您的账户安全性！";
row_message2["STATE"] = message_state.UnRead;
row_message2["CTIME"] = DateTime.Now;
dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"].Rows.Add(row_message2);
}
// 添加提示信息 - 绑定银行卡
DataRow row_message3 = AosuApp.Functions.FindRow(string.Format("MSGTYPE={0}", message_id.Account_KeyIn_BankCard), dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"]);
if (row_message3 == null)
{
row_message3 = dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"].NewRow();
row_message3["MSGID"] = Guid.NewGuid();
row_message3["SSOPST"] = register.GetValue();
row_message3["MSGTYPE"] = message_id.Account_KeyIn_BankCard;
row_message3["MSGTITLE"] = "请绑定银行卡";
row_message3["MSGBODY"] = "<strong>绑定银行卡提醒</strong><br/></br/>当您购彩中奖后，彩咖网将会依据您提交的银行卡信息将彩金转入你的真实有效的银行卡账户中；所以请您务必<a href='/member/usercenter/bdyhk'><strong>绑定银行卡</strong></a>，并确保银行卡的真实有效。";
row_message3["STATE"] = message_state.UnRead;
row_message3["CTIME"] = DateTime.Now;
dsPersistent.Tables["CAIKA_MEMBER_MESSAGE"].Rows.Add(row_message3);
}
if (new ParamUtil().SQLCmdPersistent().SetParam(dsPersistent).ExecuteCmd(ADataLoader.DataLoader()).IsOK())
{
// 生成账户的摘要集
DictSetUtil ds_summary = new DictSetUtil(new DataSet());
ds_summary.SetValue("TOTALAMOUNT", "0.00"); // 账户总额
ds_summary.SetValue("AVAILABLE", "0.00"); // 可用余额
ds_summary.SetValue("FREEZED", "0.00"); // 冻结金额
ds_summary.SetValue("SCORE", "0"); // 积分
ds_summary.SetValue("DEPOSITED", "0.0"); // 充值金额
ds_summary.SetValue("BONUS", "0.0"); // 中奖金额
ds_summary.SetValue("EXCHANGED", "0.0"); // 积分兑换
ds_summary.SetValue("RETURNED", "0.0"); // 游戏返点
ds_summary.SetValue("CONSUME", "0.0"); // 投注金额
ds_summary.SetValue("WITHDRAW", "0.0"); // 提款金额
// 通行证+超级密码
string key = new DictSetUtil(null).PushSLItem(PickParam(Params).GetValueAsString()).PushSLItem("6B276432FFAF4FD4E086E739009256B3")
.DoSignature();
AEntryDic.Pick(GetControl()).SetDic(ds_summary.MyDS, key);
}
else
{
PickParam(Params).Clear().SetError("注册失败");
}
}
else
{
PickParam(Params).Clear().SetError("账户名已存在");
}
}
else
{
PickParam(Params).Clear().SetError(aPU.GetError());
}
}
else
{
PickParam(Params).Clear().SetError(register.GetError());
}
}
catch
{
PickParam(Params).Clear().SetError("注册失败");
}
}
/// <summary>
/// 创建一个新的会员账号
/// </summary>
/// <param name="objControl"></param>
/// <param name="Params"></param>
public static void CreateMemberRecord(IControl objControl, Hashtable Params)
{
Hashtable aHT = new Hashtable();
ParamUtil.Pick(aHT).SQLEntityScript("CAIKA_MEMBER", string.Format("SELECT * FROM CAIKA_MEMBER WHERE ACCOUNTID='{0}'", Params["DOMAINUSER"]));
ParamUtil.Pick(aHT).SQLEntityScript("BASE_CATEGORY", string.Format("SELECT * FROM BASE_CATEGORY WHERE CATEGORYID LIKE '{0}%' ORDER BY CATEGORYID DESC", Params["PARENTAGENT"]));
// 得到一个待持久化的记录集
if (ParamUtil.Pick(aHT).SQLCmdLoadData().ExecuteCmd(ADataLoader.DataLoader()).IsOK())
{
DataSet dsPersistent = ParamUtil.Pick(aHT).GetValueAsDataSet();
if (dsPersistent.Tables["CAIKA_MEMBER"].Rows.Count == 0)
{
// 生成当前账号的代理编号
if (ParamUtil.Pick(Params).IsNullOrEmpty("PARENTAGENT") || dsPersistent.Tables["BASE_CATEGORY"].Rows.Count == 0)
{
throw new Exception("参数列表中没有解析到上级代理商编号。");
}
string strAgentCode = "";
int intLevel = 0;
int intSeqNo = 0;
if (dsPersistent.Tables["BASE_CATEGORY"].Rows.Count == 1)
{
strAgentCode = string.Format("{0}001", Params["PARENTAGENT"]);
intLevel = Convert.ToInt32(dsPersistent.Tables["BASE_CATEGORY"].Rows[0]["LEVEL"]) + 1;
intSeqNo = 1;
}
else
{
int idx = 0;
string curCode = dsPersistent.Tables["BASE_CATEGORY"].Rows[0]["CATEGORYID"] + "";
if (!int.TryParse(curCode.Substring(curCode.Length - 3), out idx))
{
throw new Exception(string.Format("解析代理商{0}的索引值出错。", dsPersistent.Tables["BASE_CATEGORY"].Rows[0]["CATEGORYID"]));
}
if ((idx + 1) > 998)
{
throw new Exception(string.Format("代理商{0}的下级代理数量已满。", Params["PARENTAGENT"]));
}
strAgentCode = Params["PARENTAGENT"] + (idx + 1).ToString().PadLeft(3, '0');
intLevel = Convert.ToInt32(dsPersistent.Tables["BASE_CATEGORY"].Rows[0]["LEVEL"]);
intSeqNo = Convert.ToInt32(dsPersistent.Tables["BASE_CATEGORY"].Rows[0]["SEQNO"]) + 1;
}
DataRow rowNew = dsPersistent.Tables["CAIKA_MEMBER"].NewRow();
rowNew["ACCOUNTID"] = Params["DOMAINUSER"];
rowNew["NICKNAME"] = Params["DOMAINUSER"];
rowNew["TYPE"] = Params["TYPE"];
if (Params["TYPE"].ToString() == account_type.AgentAccount)
{
rowNew["LEVEL"] = member_level.L3;
}
else
{
rowNew["LEVEL"] = member_level.L5;
}
rowNew["AGENTCODE"] = strAgentCode;
rowNew["CERTTYPE"] = "身份证";
rowNew["STATE"] = state.Enabled;
rowNew["CTIME"] = DateTime.Now;
rowNew["CUSER"] = objControl.GetContext().MyInfo["USERID"];
rowNew["ETIME"] = DateTime.Now;
rowNew["EUSER"] = objControl.GetContext().MyInfo["USERID"];
// 通行证+超级密码
string key = new DictSetUtil(null)
.PushSLItem(string.Format("{0}@{1}", Params["DOMAINUSER"], Params["DOMAINNAME"]))
.DoSignature();
rowNew["DIGEST"] = key;
DictSetUtil dictDigest = new DictSetUtil(ParamUtil.Pick(Params).GetValueAsDataSet());
rowNew["TOTALAMOUNT"] = dictDigest.GetValue("TOTALAMOUNT");
rowNew["AVAILABLE"] = dictDigest.GetValue("AVAILABLE");
rowNew["FREEZED"] = dictDigest.GetValue("FREEZED");
rowNew["SCORE"] = dictDigest.GetValue("SCORE");
dsPersistent.Tables["CAIKA_MEMBER"].Rows.Add(rowNew);
DataRow rowAgent = dsPersistent.Tables["BASE_CATEGORY"].NewRow();
rowAgent["CATEGORYID"] = strAgentCode;
rowAgent["NAME"] = Params["DOMAINUSER"];
rowAgent["DESC"] = Params["DOMAINUSER"];
rowAgent["PARENTID"] = Params["PARENTAGENT"];
rowAgent["LEVEL"] = intLevel;
rowAgent["SEQNO"] = intSeqNo;
rowAgent["ISEND"] = "Y";
rowAgent["CTYPE"] = category.CType_Label;
rowAgent["STATE"] = state.Enabled;
rowAgent["CTIME"] = DateTime.Now;
rowAgent["CUSER"] = objControl.GetContext().MyInfo["USERID"];
rowAgent["ETIME"] = DateTime.Now;
rowAgent["EUSER"] = objControl.GetContext().MyInfo["USERID"];
dsPersistent.Tables["BASE_CATEGORY"].Rows.Add(rowAgent);
dsPersistent.Tables["BASE_CATEGORY"].Rows[dsPersistent.Tables["BASE_CATEGORY"].Rows.Count - 1]["ISEND"] = "N";
if (new ParamUtil().SQLCmdPersistent().SetParam(dsPersistent).ExecuteCmd(ADataLoader.DataLoader()).IsOK())
{
// 会员账户的金额摘要数据
if (AEntryDic.Pick(objControl).SetDic(dictDigest.MyDS, key))
{
ParamUtil.Pick(Params).Clear();
ParamUtil.Pick(Params).SetError(ActionUtil.DefaultError);
}
}
}
}
}
