public void ProcessRequest(HttpContext context) { System.IO.StreamReader sm = new System.IO.StreamReader(context.Request.InputStream); string MoneyRequestStr = sm.ReadToEnd(); try { context.Response.ContentType = "text/plain"; // MoneyRequest _MoneyRequest = new MoneyRequest(); // _MoneyRequest.UserId = 100; MoneyRequest _MoneyRequest = LitJson.JsonMapper.ToObject <MoneyRequest>(MoneyRequestStr); MoneyReturn newMoneyReturn = new MoneyReturn(); newMoneyReturn.code = 0; newMoneyReturn.msg = ""; { var prams = new List <DbParameter>(); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("dwUserID", _MoneyRequest.UserId)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("dwBindType", _MoneyRequest.BankAccountType)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("szBindId", _MoneyRequest.AccountNo)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("szBindAccountName", _MoneyRequest.BankAccountUsername)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("szBindBankName", _MoneyRequest.Bank)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("strErrorDescribe", "suss")); FacadeManage.aideAccountsFacade.DataProvider.GetDbHelper().RunProc("GSP_GP_AccountBankBind", prams); } context.Response.Write(LitJson.JsonMapper.ToJson(newMoneyReturn)); } catch (Exception exp) { MoneyReturn newMoneyReturn = new MoneyReturn(); newMoneyReturn.code = 1; newMoneyReturn.msg = exp.Message.ToString(); context.Response.Write(MoneyRequestStr + "--" + LitJson.JsonMapper.ToJson(newMoneyReturn)); } }
public void ProcessRequest(HttpContext context) { try { MoneyReturn newMoneyReturn = new MoneyReturn(); context.Response.ContentType = "text/plain"; System.IO.StreamReader sm = new System.IO.StreamReader(context.Request.InputStream); string MoneyRequestStr = sm.ReadToEnd(); MoneyRequest _MoneyRequest = LitJson.JsonMapper.ToObject <MoneyRequest>(MoneyRequestStr); _MoneyRequest.Money *= 100; // string sql = string.Format("SELECT UserID FROM AccontPayChangeMoney WHERE UserID={0} and ChangeStatus=0", _MoneyRequest.UserId); // { // DataSet ds = FacadeManage.aideAccountsFacade.DataProvider.GetDbHelper().ExecuteDataset(CommandType.Text, sql); // if (ds.Tables[0].Rows.Count > 0) // { // newMoneyReturn.code = 1; // newMoneyReturn.msg = "不能重复申请"; // context.Response.Write(LitJson.JsonMapper.ToJson(newMoneyReturn)); // return; // } // } { DataSet ds = FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().ExecuteDataset(CommandType.Text, "select Score from GameScoreInfo where UserID=" + _MoneyRequest.UserId); if (ds.Tables[0].Rows.Count > 0) { int src = Convert.ToInt32(ds.Tables[0].Rows[0]["Score"]); if (src < _MoneyRequest.Money) { newMoneyReturn.code = 2; newMoneyReturn.msg = "余额不足"; context.Response.Write(LitJson.JsonMapper.ToJson(newMoneyReturn)); return; } else { string MyUpdate = "Update GameScoreInfo set Score=Score-" + ((int)_MoneyRequest.Money).ToString() + " where UserID=" + _MoneyRequest.UserId; FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().ExecuteDataset(CommandType.Text, MyUpdate); } } } var prams = new List <DbParameter>(); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("dwUserID", _MoneyRequest.UserId)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("szRequestTime", DateTime.Now.ToString())); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("szCheckTime", DateTime.Now.ToString())); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("fAmount", _MoneyRequest.Money)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("dwBankAccountType", _MoneyRequest.BankAccountType)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("dwChangeStatus", 0)); prams.Add(FacadeManage.aideTreasureFacade.DataProvider.GetDbHelper().MakeInParam("strErrorDescribe", "")); object payId = FacadeManage.aideAccountsFacade.DataProvider.GetDbHelper().ExecuteScalar(CommandType.StoredProcedure, "GSP_GP_AccountPayChangeMoney", prams.ToArray()); var sqlBuilder = new StringBuilder(); sqlBuilder.Append("EXEC NET_PM_RecordScoreChanged ") .AppendFormat("'{0}',", _MoneyRequest.UserId) .AppendFormat("'{0}',", -_MoneyRequest.Money) .AppendFormat("'{0}',", payId) .AppendFormat("'{0}',", "GET_MONEY") .AppendFormat("'{0}',", "提现") .AppendFormat("'{0}'", "ChangedNumber为提现申请表中的PayId"); FacadeManage.aideAccountsFacade.DataProvider.GetDbHelper().ExecuteNonQuery(sqlBuilder.ToString()); newMoneyReturn.code = 0; newMoneyReturn.msg = ""; context.Response.Write(LitJson.JsonMapper.ToJson(newMoneyReturn)); } catch (Exception exp) { MoneyReturn newMoneyReturn = new MoneyReturn(); newMoneyReturn.code = 1; newMoneyReturn.msg = exp.Message.ToString(); context.Response.Write(LitJson.JsonMapper.ToJson(newMoneyReturn)); } }