public List <lgk.Model.tb_PhoneOrder> DataTableToList(DataTable dt) { List <lgk.Model.tb_PhoneOrder> modelList = new List <lgk.Model.tb_PhoneOrder>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { lgk.Model.tb_PhoneOrder model; for (int n = 0; n < rowsCount; n++) { model = new lgk.Model.tb_PhoneOrder(); if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "") { model.UserID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["PhoneNO"] != null && dt.Rows[n]["PhoneNO"].ToString() != "") { model.PhoneNO = dt.Rows[n]["PhoneNO"].ToString(); } if (dt.Rows[n]["CardNum"] != null && dt.Rows[n]["CardNum"].ToString() != "") { model.CardNum = int.Parse(dt.Rows[n]["CardNum"].ToString()); } if (dt.Rows[n]["UorderID"] != null && dt.Rows[n]["UorderID"].ToString() != "") { model.UorderID = dt.Rows[n]["UorderID"].ToString(); } if (dt.Rows[n]["CardID"] != null && dt.Rows[n]["CardID"].ToString() != "") { model.CardID = dt.Rows[n]["CardID"].ToString(); } if (dt.Rows[n]["OrderCash"] != null && dt.Rows[n]["OrderCash"].ToString() != "") { model.OrderCash = dt.Rows[n]["OrderCash"].ToString(); } if (dt.Rows[n]["CardName"] != null && dt.Rows[n]["CardName"].ToString() != "") { model.CardName = dt.Rows[n]["CardName"].ToString(); } if (dt.Rows[n]["SporderID"] != null && dt.Rows[n]["SporderID"].ToString() != "") { model.SporderID = dt.Rows[n]["SporderID"].ToString(); } if (dt.Rows[n]["State"] != null && dt.Rows[n]["State"].ToString() != "") { model.State = int.Parse(dt.Rows[n]["State"].ToString()); } if (dt.Rows[n]["AddDate"] != null && dt.Rows[n]["AddDate"].ToString() != "") { model.AddDate = Convert.ToDateTime(dt.Rows[n]["AddDate"].ToString()); } if (dt.Rows[n]["UserID"] != null && dt.Rows[n]["UserID"].ToString() != "") { model.UserID = int.Parse(dt.Rows[n]["UserID"].ToString()); } modelList.Add(model); } } return(modelList); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string s = "\r\n" + "\r\n" + "\r\n" + "\r\n" + "记录时间" + DateTime.Now.ToString() + "\r\n"; try { context.Response.ContentType = "text/plain"; string sporder_id = context.Request["sporder_id"]; string orderid = context.Request["orderid"]; string sta = context.Request["sta"]; string sign = context.Request["sign"]; string err_msg = context.Request["err_msg"]; s = s + "接受内容信息:聚合订单号:" + sporder_id + ",本地订单号:" + orderid + ",订单状态:" + sta + ",签名:" + sign + "\r\n"; //var emResult = JsonConvert.DeserializeObject<data>(data); if (!string.IsNullOrEmpty(sporder_id)) { lgk.Model.tb_PhoneOrder Modelreback = orderBLL.GetModel(" SporderID='" + sporder_id + "'"); if (Modelreback != null) { //if() Modelreback.State = Convert.ToInt32(sta); orderBLL.Update(Modelreback); //充值失败处理 if (sta == "9") { lgk.Model.tb_user model = userBLL.GetModel(Modelreback.UserID); model.Emoney += Convert.ToDecimal(Modelreback.OrderCash); userBLL.Update(model); string bramk = "充值失败" + Modelreback.UorderID + ",返回原始币:" + Modelreback.OrderCash; JournalAdd(Modelreback.UserID, bramk, 1, Convert.ToDecimal(Modelreback.OrderCash)); bllaccount.UpdateBanlcen("PhoneAccount", Convert.ToDecimal(Modelreback.OrderCash), 2); } context.Response.Write("success"); } else { s = s + "订单不存在\r\n"; context.Response.Write("订单不存在"); } } else { s = s + "没有回调\r\n"; context.Response.Write("没有回调数据"); } } catch (Exception ex) { s = s + "回调异常,错误信息" + ex.Message + "\r\n"; context.Response.Write("回调异常,错误信息" + ex.Message); } System.IO.File.AppendAllText(context.Server.MapPath("~/log/RequestPhoneBacklog/RequestPhoneBacklog" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + ".txt"), s); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_PhoneOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_PhoneOrder set "); strSql.Append("PhoneNO=@PhoneNO,"); strSql.Append("CardNum=@CardNum,"); strSql.Append("UorderID=@UorderID,"); strSql.Append("CardID=@CardID,"); strSql.Append("OrderCash=@OrderCash,"); strSql.Append("CardName=@CardName,"); strSql.Append("SporderID=@SporderID,"); strSql.Append("State=@State,"); strSql.Append("AddDate=@AddDate"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@PhoneNO", SqlDbType.VarChar, 100), new SqlParameter("@CardNum", SqlDbType.Int), new SqlParameter("@UorderID", SqlDbType.VarChar, 100), new SqlParameter("@CardID", SqlDbType.VarChar, 100), new SqlParameter("@OrderCash", SqlDbType.VarChar, 100), new SqlParameter("@CardName", SqlDbType.VarChar), new SqlParameter("@SporderID", SqlDbType.VarChar), new SqlParameter("@State", SqlDbType.Int), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.PhoneNO; parameters[1].Value = model.CardNum; parameters[2].Value = model.UorderID; parameters[3].Value = model.CardID; parameters[4].Value = model.OrderCash; parameters[5].Value = model.CardName; parameters[6].Value = model.SporderID; parameters[7].Value = model.State; parameters[8].Value = model.AddDate; parameters[9].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_PhoneOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_PhoneOrder("); strSql.Append("PhoneNO,CardNum,UorderID,CardID,OrderCash,CardName,SporderID,State,AddDate,UserID)"); strSql.Append(" values ("); strSql.Append("@PhoneNO,@CardNum,@UorderID,@CardID,@OrderCash,@CardName,@SporderID,@State,@AddDate,@UserID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@PhoneNO", SqlDbType.VarChar, 100), new SqlParameter("@CardNum", SqlDbType.Int), new SqlParameter("@UorderID", SqlDbType.VarChar, 100), new SqlParameter("@CardID", SqlDbType.VarChar, 100), new SqlParameter("@OrderCash", SqlDbType.VarChar, 100), new SqlParameter("@CardName", SqlDbType.VarChar), new SqlParameter("@SporderID", SqlDbType.VarChar), new SqlParameter("@State", SqlDbType.Int), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@UserID", SqlDbType.Int) }; parameters[0].Value = model.PhoneNO; parameters[1].Value = model.CardNum; parameters[2].Value = model.UorderID; parameters[3].Value = model.CardID; parameters[4].Value = model.OrderCash; parameters[5].Value = model.CardName; parameters[6].Value = model.SporderID; parameters[7].Value = model.State; parameters[8].Value = model.AddDate; parameters[9].Value = model.UserID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 充值订单处理 /// </summary> /// <param name="act"></param> /// <param name="dic1"></param> /// <param name="dic2"></param> /// <returns></returns> private bool OnlineOrder(string act, Dictionary <string, string> dic1, Dictionary <string, string> dic2, out object msg) { long _userid; long.TryParse(dic2["userid"].ToString(), out _userid); decimal allprice = Convert.ToDecimal(dic2["cardnum"].ToString()); var user = userBLL.GetModel(_userid); decimal banlcen = bllaccount.BanlceAcount("PhoneAccount"); if (banlcen >= allprice) { if (user == null) { msg = "用户不存在"; return(false); } if (!ValidPassword(user.SecondPassword, dic2["paypassword"].ToString())) { msg = "支付密码错误"; return(false); } if (user.IsLock == 1) { msg = "账户已冻结,话费充值失败"; return(false); } lgk.Model.tb_user usermodel = userBLL.GetModel(Convert.ToInt32(dic2["userid"].ToLower())); if (allprice > usermodel.Emoney) { msg = "注册分不足"; return(false); } dic2.Add("orderid", Util.CreateNo()); //订单编号 string sign = OpenID + AppKey + dic2["phoneno"].ToString().Trim() + dic2["cardnum"].ToString().Trim() + dic2["orderid"].ToString().Trim(); dic2.Add("sign", Util.SignTopRequest(sign)); //签名 string respon = RequestSumit(dic2, dic1["RequestUrl"].ToString(), act); if (respon != "error") { var Result = JsonConvert.DeserializeObject <RespondResult>(respon); if (Result.result != null) { lgk.Model.tb_PhoneOrder model = new lgk.Model.tb_PhoneOrder(); model.PhoneNO = dic2["phoneno"].ToString().Trim(); model.State = Convert.ToInt32(Result.result.game_state); model.CardNum = Convert.ToInt32(Result.result.cardnum); model.OrderCash = allprice.ToString();//充值金额 model.UorderID = dic2["orderid"].ToString().Trim(); model.SporderID = Result.result.sporder_id; model.AddDate = DateTime.Now; model.UserID = Convert.ToInt32(dic2["userid"].ToString().Trim()); phor.Add(model); Bonus(usermodel, allprice); //扣除奖励分金额 bllaccount.UpdateBanlcen("PhoneAccount", allprice, 1); } else { msg = CheckCode(Result.error_code); return(false); } msg = Result; return(true); } else { msg = "error"; return(true); } } else { msg = "该功能正在维护中"; //msg = "平台余额不足,该功能已暂停使用"; return(false); } }
public lgk.Model.tb_PhoneOrder GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from tb_PhoneOrder "); strSql.Append(" where " + where); lgk.Model.tb_PhoneOrder model = new lgk.Model.tb_PhoneOrder(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["PhoneNO"] != null && ds.Tables[0].Rows[0]["PhoneNO"].ToString() != "") { model.PhoneNO = ds.Tables[0].Rows[0]["PhoneNO"].ToString(); } if (ds.Tables[0].Rows[0]["CardNum"] != null && ds.Tables[0].Rows[0]["CardNum"].ToString() != "") { model.CardNum = Convert.ToInt32(ds.Tables[0].Rows[0]["CardNum"].ToString()); } if (ds.Tables[0].Rows[0]["UorderID"] != null && ds.Tables[0].Rows[0]["UorderID"].ToString() != "") { model.UorderID = ds.Tables[0].Rows[0]["UorderID"].ToString(); } if (ds.Tables[0].Rows[0]["CardID"] != null && ds.Tables[0].Rows[0]["CardID"].ToString() != "") { model.CardID = ds.Tables[0].Rows[0]["CardID"].ToString(); } if (ds.Tables[0].Rows[0]["OrderCash"] != null && ds.Tables[0].Rows[0]["OrderCash"].ToString() != "") { model.OrderCash = ds.Tables[0].Rows[0]["OrderCash"].ToString(); } if (ds.Tables[0].Rows[0]["CardName"] != null && ds.Tables[0].Rows[0]["CardName"].ToString() != "") { model.CardName = ds.Tables[0].Rows[0]["CardName"].ToString(); } if (ds.Tables[0].Rows[0]["SporderID"] != null && ds.Tables[0].Rows[0]["SporderID"].ToString() != "") { model.SporderID = ds.Tables[0].Rows[0]["SporderID"].ToString(); } if (ds.Tables[0].Rows[0]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "") { model.State = Convert.ToInt32(ds.Tables[0].Rows[0]["State"].ToString()); } if (ds.Tables[0].Rows[0]["AddDate"] != null && ds.Tables[0].Rows[0]["AddDate"].ToString() != "") { model.AddDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["AddDate"].ToString()); } if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = Convert.ToInt32(ds.Tables[0].Rows[0]["UserID"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_PhoneOrder model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_PhoneOrder model) { return(dal.Add(model)); }