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));
}
