private JumboECMS.Entity.Normal_CategoryTree getTree(DbOperHandler _doh, string _categoryid, bool _includechild)
{
JumboECMS.Entity.Normal_CategoryTree _tree = new JumboECMS.Entity.Normal_CategoryTree();
JumboECMS.Entity.Normal_Category _category = new JumboECMS.DAL.Normal_CategoryDAL().GetEntity(_categoryid, "");
_tree.Id = Str2Int(_categoryid);
_tree.Name = _category.Title;
_tree.Link = Go2Category(_categoryid, 1);
_tree.HasChild = HasChild(_categoryid);
List <JumboECMS.Entity.Normal_CategoryTree> subtree = new List <JumboECMS.Entity.Normal_CategoryTree>();
if (_includechild)
{
_doh.Reset();
_doh.SqlCmd = "SELECT Id FROM [" + base.CategoryTable + "] WHERE [ParentId]=" + _categoryid + " order by code";
DataTable dtCategory = _doh.GetDataTable();
for (int i = 0; i < dtCategory.Rows.Count; i++)
{
string _subcategoryid = dtCategory.Rows[i]["Id"].ToString();
subtree.Add(getTree(_doh, _subcategoryid, _includechild));
}
dtCategory.Clear();
dtCategory.Dispose();
}
_tree.SubChild = subtree;
return(_tree);
}
protected void getEditDropDownList(ref DropDownList ddlClassId, decimal point, int ClassDepth)
{
if (!this.Page.IsPostBack)
{
this.doh.Reset();
this.doh.SqlCmd = string.Concat(new object[]
{
"SELECT [Id],[Point],[Title],[Bonus],[Score],[Times],[Sort] FROM [N_UserLevel] where point>=",
point,
" and point<",
this.AdminPoint
});
DbOperHandler expr_61 = this.doh;
expr_61.SqlCmd += " ORDER BY Bonus";
DataTable dataTable = this.doh.GetDataTable();
if (dataTable.Rows.Count == 0)
{
this.doh.Reset();
this.doh.SqlCmd = "SELECT [Id],[Point],[Title],[Bonus],[Score],[Times],[Sort] FROM [N_UserLevel] where point=" + this.AdminPoint;
DbOperHandler expr_BE = this.doh;
expr_BE.SqlCmd += " ORDER BY Bonus";
DataTable dataTable2 = this.doh.GetDataTable();
for (int i = 0; i < dataTable2.Rows.Count; i++)
{
ddlClassId.Items.Add(new ListItem(dataTable2.Rows[i]["Bonus"].ToString() + "_" + Convert.ToDecimal(Convert.ToDecimal(dataTable2.Rows[i]["Point"]) / 10m).ToString("0.00") + "%", dataTable2.Rows[i]["Point"].ToString()));
}
}
for (int j = 0; j < dataTable.Rows.Count; j++)
{
ddlClassId.Items.Add(new ListItem(dataTable.Rows[j]["Bonus"].ToString() + "_" + Convert.ToDecimal(Convert.ToDecimal(dataTable.Rows[j]["Point"]) / 10m).ToString("0.00") + "%", dataTable.Rows[j]["Point"].ToString()));
}
dataTable.Clear();
dataTable.Dispose();
}
}
protected string leftMenuJson()
{
this.AdminId = base.Str2Str(Cookie.GetValue(this.site.CookiePrev + "admin", "id"));
this.doh.Reset();
this.doh.SqlCmd = "SELECT top 1 * FROM [Sys_Admin] a left join [Sys_Role] b on a.RoleId=b.Id where a.Id=" + this.AdminId;
DataTable dataTable = this.doh.GetDataTable();
if (dataTable.Rows.Count > 0)
{
this.AdminIsSuper = "1".Equals(dataTable.Rows[0]["IsSuper"].ToString().Trim());
this.AdminSetting = dataTable.Rows[0]["Setting"].ToString();
}
else
{
this.AdminIsSuper = false;
this.AdminSetting = "";
}
if (this.AdminSetting.Length > 2)
{
this.AdminSetting = this.AdminSetting.Substring(1, this.AdminSetting.Length - 2);
}
string str = "";
this.doh.Reset();
this.doh.SqlCmd = "SELECT * FROM Sys_Menu WHERE IsUsed=0";
if (!this.AdminIsSuper)
{
if (this.AdminSetting.Length > 2)
{
DbOperHandler expr_13A = this.doh;
expr_13A.SqlCmd = expr_13A.SqlCmd + " and Id in (" + this.AdminSetting + ")";
str = " and Id in (" + this.AdminSetting + ")";
}
else
{
DbOperHandler expr_178 = this.doh;
expr_178.SqlCmd += " and Id in (0)";
str = " and Id in (0)";
}
}
DbOperHandler expr_199 = this.doh;
expr_199.SqlCmd += " ORDER BY Sort asc";
DataTable dataTable2 = this.doh.GetDataTable();
this.doh.Reset();
this.doh.SqlCmd = "SELECT * FROM Sys_Menu WHERE IsUsed=0 and pId=0";
if (!this.AdminIsSuper && dataTable2.Rows.Count > 0)
{
DbOperHandler expr_1F1 = this.doh;
expr_1F1.SqlCmd = expr_1F1.SqlCmd + " and Id in (SELECT Pid FROM Sys_Menu WHERE IsUsed=0 " + str + " group by Pid)";
}
DbOperHandler expr_212 = this.doh;
expr_212.SqlCmd += " ORDER BY Sort asc";
DataTable dataTable3 = this.doh.GetDataTable();
return(dtHelp.DT2JSONAdminLeft(dataTable3, dataTable2));
}
public void GetChargeSetJSON(ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.SqlCmd = "SELECT * from Sys_ChargeSet where IsUsed=0 and Id<>1020";
DbOperHandler expr_17 = dbOperHandler;
expr_17.SqlCmd += " ORDER BY Sort asc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(dataTable) + "}";
dataTable.Clear();
dataTable.Dispose();
}
}
public void GetIphoneChargeSetJSON(string Id, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.SqlCmd = "SELECT * from Sys_ChargeSet where Id in (" + Id + ")";
DbOperHandler expr_22 = dbOperHandler;
expr_22.SqlCmd += " ORDER BY Id asc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(dataTable) + "}";
dataTable.Clear();
dataTable.Dispose();
}
}
public void getChargeSetByIdJson(string Id, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.SqlCmd = "SELECT * from Sys_ChargeSet where Id=" + Id;
DbOperHandler expr_1D = dbOperHandler;
expr_1D.SqlCmd += " ORDER BY Id asc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
public void getChargeSetJson(string Type, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.SqlCmd = "SELECT Id,MerName from Sys_ChargeSet where IsUsed=0";
DbOperHandler expr_17 = dbOperHandler;
expr_17.SqlCmd += " ORDER BY sort asc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
public void getChargeSysBankJson(ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.SqlCmd = "SELECT Id,Bank from Sys_Bank where IsCharge=0 and IsUsed=0";
DbOperHandler expr_17 = dbOperHandler;
expr_17.SqlCmd += " ORDER BY id asc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
private void ConnectDb()
{
if (this.doh != null)
{
return;
}
try
{
this.doh = (DbOperHandler) new SqlDbOperHandler(new SqlConnection(Const.ConnectionString));
}
catch (Exception ex)
{
throw ex;
}
}
public void getUserPointListJson(string UserId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", UserId);
object field = dbOperHandler.GetField("N_User", "Point");
dbOperHandler.SqlCmd = "SELECT point,Convert(varchar(10),cast(round([Point]/10.0,2) as numeric(5,2)))+'%' as title FROM [N_UserLevel] where point>=100 and point<" + field;
DbOperHandler expr_4B = dbOperHandler;
expr_4B.SqlCmd += " ORDER BY Bonus desc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
public void GetIphoneBankInfoJSON(string UserId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId;
dbOperHandler.Count("N_UserBank");
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select top 3 * from V_UserBankInfo where UserId=" + UserId;
DbOperHandler expr_46 = dbOperHandler;
expr_46.SqlCmd += "order by Id desc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(dataTable) + "}";
dataTable.Clear();
dataTable.Dispose();
}
}
/// <summary>
/// 实时判断会员是不是客服
/// </summary>
/// <param name="_id"></param>
/// <param name="doh"></param>
/// <param name="_servicename"></param>
/// <returns></returns>
public bool Service(string _id, DbOperHandler doh, ref string _servicename)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.SqlCmd = "SELECT [ServiceName] FROM [jcms_normal_user] WHERE ServiceId>0 AND [Id]=" + _id;
DataTable dt = _doh.GetDataTable();
//_doh.Dispose();
if (dt.Rows.Count > 0)
{
_servicename = dt.Rows[0]["ServiceName"].ToString();
return(true);
}
else
{
return(false);
}
}
}
public void getSysBankBinByIdJson(string BankId, string BankBin, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.SqlCmd = string.Concat(new string[]
{
"SELECT top 1 * from Sys_BankBinInfo where BankId=",
BankId,
" and BankBin='",
BankBin,
"'"
});
DbOperHandler expr_3F = dbOperHandler;
expr_3F.SqlCmd += " ORDER BY Id asc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
protected void getActiveEditDropDownList(ref DropDownList ddlClassId, int ClassDepth)
{
if (!this.Page.IsPostBack)
{
this.doh.Reset();
this.doh.SqlCmd = "SELECT [Code],[Name] FROM [Act_ActiveSet] where Isuse=1";
DbOperHandler expr_31 = this.doh;
expr_31.SqlCmd += " ORDER BY Id";
DataTable dataTable = this.doh.GetDataTable();
if (dataTable.Rows.Count == 0)
{
return;
}
for (int i = 0; i < dataTable.Rows.Count; i++)
{
ddlClassId.Items.Add(new ListItem(dataTable.Rows[i]["Name"].ToString(), dataTable.Rows[i]["Code"].ToString()));
}
dataTable.Clear();
dataTable.Dispose();
}
}
protected void getRoleDropDownList(ref DropDownList ddlClassId, int ClassDepth)
{
if (!this.Page.IsPostBack)
{
this.doh.Reset();
this.doh.SqlCmd = "SELECT [Id],[Name] FROM [Sys_Role] where IsUsed=0";
DbOperHandler expr_31 = this.doh;
expr_31.SqlCmd += " ORDER BY Sort";
DataTable dataTable = this.doh.GetDataTable();
if (dataTable.Rows.Count == 0)
{
return;
}
for (int i = 0; i < dataTable.Rows.Count; i++)
{
ddlClassId.Items.Add(new ListItem(dataTable.Rows[i]["Name"].ToString(), dataTable.Rows[i]["Id"].ToString()));
}
dataTable.Clear();
dataTable.Dispose();
}
}
protected void getEditDropDownList(ref DropDownList ddlClassId, int ClassDepth)
{
if (!this.Page.IsPostBack)
{
this.doh.Reset();
this.doh.SqlCmd = "SELECT [Id],[Point],[Title],[Bonus],[Score],[Times],[Sort] FROM [N_UserLevel]";
DbOperHandler expr_31 = this.doh;
expr_31.SqlCmd += " ORDER BY Bonus desc";
DataTable dataTable = this.doh.GetDataTable();
if (dataTable.Rows.Count == 0)
{
return;
}
for (int i = 0; i < dataTable.Rows.Count; i++)
{
ddlClassId.Items.Add(new ListItem(dataTable.Rows[i]["Bonus"].ToString() + "_" + Convert.ToDecimal(Convert.ToDecimal(dataTable.Rows[i]["Point"]) / 10m).ToString("0.00") + "%", dataTable.Rows[i]["Point"].ToString()));
}
dataTable.Clear();
dataTable.Dispose();
}
}
private SiteGroupCms.Entity.Normal_ClassTree getTree(DbOperHandler _doh, string _channelid, string _classid, bool _includechild)
{
SiteGroupCms.Entity.Normal_ClassTree _tree = new SiteGroupCms.Entity.Normal_ClassTree();
SiteGroupCms.Entity.Normal_Channel _channel = new SiteGroupCms.Dal.Normal_ChannelDAL().GetEntity(_channelid);
bool _channelishtml = true;
if (_classid == "0")//表示从根节点开始
{
_tree.Id = _channel.ID.ToString();
_tree.Name = _channel.Title;
_tree.Link = Go2Channel(_channelid, 0);
_tree.RssUrl = "";
}
else
{
SiteGroupCms.Entity.Normal_Class _class = new SiteGroupCms.Dal.Normal_ClassDAL().GetEntity(_classid);
_tree.Id = _classid;
_tree.Name = _class.Title;
_tree.Link = Go2Class(1, _channelishtml, _channelid, _classid, false);
// _tree.RssUrl = Go2Rss(1, false, _channelid, _classid);
}
_tree.HasChild = HasChild(_channelid, _classid);
List <SiteGroupCms.Entity.Normal_ClassTree> subtree = new List <SiteGroupCms.Entity.Normal_ClassTree>();
if (_includechild)
{
_doh.Reset();
_doh.SqlCmd = "SELECT Id FROM [jcms_normal_class] WHERE [ChannelId]=" + _channelid + " AND [ParentId]=" + _classid + " order by code";
DataTable dtClass = _doh.GetDataTable();
for (int i = 0; i < dtClass.Rows.Count; i++)
{
string _subclassid = dtClass.Rows[i]["Id"].ToString();
subtree.Add(getTree(_doh, _channelid, _subclassid, _includechild));
}
dtClass.Clear();
dtClass.Dispose();
}
_tree.SubChild = subtree;
return(_tree);
}
/// <summary>
/// 插入GUID
/// </summary>
/// <param name="_id"></param>
public string InsertGUID(string _id, DbOperHandler doh)
{
using (DbOperHandler _doh = new Common().Doh())
{
string _guid = "";
_doh.Reset();
_doh.SqlCmd = "SELECT [GUID] FROM [jcms_normal_user] WHERE [Id]=" + _id;
DataTable dt = _doh.GetDataTable();
if (dt.Rows.Count > 0)
{
_guid = dt.Rows[0][0].ToString();
}
if (_guid.Length != 36)
{
_guid = Guid.NewGuid().ToString();
_doh.ConditionExpress = "id=" + _id;
_doh.AddFieldItem("guid", _guid);
_doh.Update("jcms_normal_user");
}
return(_guid);
}
}
private void OptionsInfo()
{
string str = base.q("t");
string text = base.q("w");
string text2 = base.q("n");
if (string.IsNullOrEmpty(text2))
{
text2 = "name";
}
this.doh.Reset();
this.doh.SqlCmd = "select id," + text2 + " as name from " + str;
if (!string.IsNullOrEmpty(text))
{
DbOperHandler expr_75 = this.doh;
expr_75.SqlCmd = expr_75.SqlCmd + " where " + text;
}
DataTable dataTable = this.doh.GetDataTable();
this._response = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(dataTable) + "}";
dataTable.Clear();
dataTable.Dispose();
}
public void getUserUpPointListJson(string UserId, string MinPoint, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", UserId);
object field = dbOperHandler.GetField("N_User", "Point");
dbOperHandler.SqlCmd = string.Concat(new object[]
{
"SELECT point,Convert(varchar(10),cast(round([Point]/10.0,2) as numeric(5,2)))+'%' as title FROM [N_UserLevel] where point<",
field,
" and point>=",
Convert.ToDouble(MinPoint.Replace("%", "")) * 10.0
});
DbOperHandler expr_88 = dbOperHandler;
expr_88.SqlCmd += " ORDER BY Bonus asc";
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = base.ConverTableToJSON(dataTable);
dataTable.Clear();
dataTable.Dispose();
}
}
private void OptionsInfo()
{
string str1 = this.q("t");
string str2 = this.q("w");
string str3 = this.q("n");
if (string.IsNullOrEmpty(str3))
{
str3 = "name";
}
this.doh.Reset();
this.doh.SqlCmd = "select id," + str3 + " as name from " + str1;
if (!string.IsNullOrEmpty(str2))
{
DbOperHandler doh = this.doh;
doh.SqlCmd = doh.SqlCmd + " where " + str2;
}
DataTable dataTable = this.doh.GetDataTable();
this._response = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(dataTable) + "}";
dataTable.Clear();
dataTable.Dispose();
}
private void ajaxBetting2()
{
if (this.AdminId == "")
{
this._response = this.JsonResult(0, "投注失败,请重新登录后再进行投注!");
}
else if (this.site.BetIsOpen == 1)
{
this._response = this.JsonResult(0, "系统正在维护，不能投注！");
}
else
{
HttpContext.Current.Response.ContentType = "application/json";
List <ajaxBetting.RequestDataJSON> requestDataJsonList = ajaxBetting.JSONToObject <List <ajaxBetting.RequestDataJSON> >(HttpUtility.UrlDecode(new StreamReader(HttpContext.Current.Request.InputStream).ReadToEnd()));
ajaxBetting.RequestDataJSON requestDataJson1 = new ajaxBetting.RequestDataJSON();
int lotteryId1 = requestDataJsonList[0].lotteryId; //投注信息
int int32_1 = Convert.ToInt32(this.AdminId); //会员Id
LotteryDAL lotDal = new LotteryDAL();
FlexDAL.UserBetDAL betDal = new FlexDAL.UserBetDAL();
SysLotteryModel lottery = lotDal.GetSysLotteryById(lotteryId1);
if (betDal.CheckBetTime(lotteryId1) == false)
{
this._response = this.JsonResult(0, string.Format("凌晨1点55分到上午10点, [{0}]暂停开奖", lottery.Title));
return;
}
Decimal num1 = new Decimal(0);
try
{
//获取当前一期时间和期号
string[] issueTimeAndSn = betDal.GetIssueTimeAndSN(lotteryId1);
string str1 = issueTimeAndSn[0]; //期号
DateTime dateTime = Convert.ToDateTime(issueTimeAndSn[1]); //开奖时间
DateTime serverTime = FlexDAL.PublicDAL.GetServerTime(); //系统时间
for (int index = 0; index < requestDataJsonList.Count; ++index)
{
ajaxBetting.RequestDataJSON requestDataJson2 = requestDataJsonList[index];
num1 += requestDataJson2.price * (Decimal)requestDataJson2.Num * requestDataJson2.times;
}
string str2 = betDal.CheckBet(int32_1, lotteryId1, Convert.ToDecimal(num1), dateTime);
if (!string.IsNullOrEmpty(str2))
{
this._response = this.JsonResult(0, str2);
}
else
{
int num2 = 0;
for (int index = 0; index < requestDataJsonList.Count; ++index)
{
ajaxBetting.RequestDataJSON requestDataJson2 = requestDataJsonList[index];
this.doh.Reset();
this.doh.ConditionExpress = "Id=@Id";
DbOperHandler doh = this.doh;
string _conditionName = "@Id";
int playId1 = requestDataJson2.playId;
string str3 = playId1.ToString();
doh.AddConditionParameter(_conditionName, (object)str3);
string str4 = string.Concat(this.doh.GetField("Sys_PlaySmallType", "Title2"));
Decimal singelBouns = new Decimal(0);
if (lotteryId1 != 5001)
{
if (Convert.ToDecimal(requestDataJson2.price) < new Decimal(0) || Convert.ToDecimal(requestDataJson2.Num) < new Decimal(1) || Convert.ToDecimal(requestDataJson2.times) < new Decimal(1))
{
this._response = this.JsonResult(0, "投注错误！请重新投注！");
return;
}
int userId = int32_1;
int lotteryId2 = lotteryId1;
string balls = requestDataJson2.balls;
playId1 = requestDataJson2.playId;
string playId2 = playId1.ToString();
string strPos = requestDataJson2.strPos;
int int32_2 = Convert.ToInt32(requestDataJson2.Num);
Decimal Point = Convert.ToDecimal(requestDataJson2.Point);
string str5 = Calculate.BetNumerice(userId, lotteryId2, balls, playId2, strPos, int32_2, Point, ref singelBouns);
if (!string.IsNullOrEmpty(str5))
{
this._response = str5.Replace("[", "").Replace("]", "");
return;
}
if (singelBouns <= new Decimal(0))
{
this._response = this.JsonResult(0, "投注失败,返点错误，请重新投注！");
return;
}
}
UserBetModel model = new UserBetModel();
model.UserId = int32_1;
model.UserMoney = new Decimal(0);
model.LotteryId = lotteryId1;
model.PlayId = Convert.ToInt32(requestDataJson2.playId);
model.PlayCode = str4;
model.IssueNum = str1;
model.SingleMoney = Convert.ToDecimal(requestDataJson2.price);
model.Num = Convert.ToInt32(requestDataJson2.Num);
model.Detail = requestDataJson2.balls;
model.Point = Convert.ToDecimal(requestDataJson2.Point);
model.Bonus = singelBouns;
model.Pos = requestDataJson2.strPos;
model.STime = dateTime;
model.STime2 = serverTime;
model.IsDelay = 0;
model.Times = Convert.ToDecimal(requestDataJson2.times);
model.ZHID = 0;
num2 = !model.Pos.Equals("") ?
betDal.InsertBetPos(model, "手机端") :
(!model.PlayCode.Equals("P_5ZH") && !model.PlayCode.Equals("P_4ZH_L") && (!model.PlayCode.Equals("P_4ZH_R") && !model.PlayCode.Equals("P_3ZH_L")) && !model.PlayCode.Equals("P_3ZH_C") && !model.PlayCode.Equals("P_3ZH_R") ?
betDal.InsertBet(model, "手机端") :
betDal.InsertBetZH(model, "手机端"));
}
if (num2 > 0)
{
this._response = this.JsonResult(1, "第" + str1 + "期投注成功，请期待开奖！");
}
else
{
this._response = this.JsonResult(0, "对不起,投注失败！");
}
//this._response = this.JsonResult(1, "第" + str1 + "期投注成功，请期待开奖！");
}
}
catch (Exception ex)
{
this._response = this.JsonResult(0, "对不起,投注失败！");
}
}
}
private void ajaxZHBetting()
{
if (this.AdminId == "")
{
this._response = this.JsonResult(0, "投注失败,请重新登录后再进行投注!");
}
else
{
HttpContext.Current.Response.ContentType = "application/json";
List <ajaxBetting.RequestDataJSONZH> requestDataJsonzhList = ajaxBetting.JSONToObject <List <ajaxBetting.RequestDataJSONZH> >("[" + new StreamReader(HttpContext.Current.Request.InputStream).ReadToEnd() + "]");
ajaxBetting.RequestDataJSONZH requestDataJsonzh1 = new ajaxBetting.RequestDataJSONZH();
int int32_1 = Convert.ToInt32(this.AdminId);
int int32_2 = Convert.ToInt32(requestDataJsonzhList[0].lotteryId);
int int32_3 = Convert.ToInt32(requestDataJsonzhList[0].IsStop);
int int32_4 = Convert.ToInt32(requestDataJsonzhList[0].ZHNums);
Decimal num = Convert.ToDecimal(requestDataJsonzhList[0].ZHSums);
LotteryDAL lotDal = new LotteryDAL();
FlexDAL.UserBetDAL betDal = new FlexDAL.UserBetDAL();
SysLotteryModel lottery = lotDal.GetSysLotteryById(int32_2);
if (betDal.CheckBetTime(int32_2) == false)
{
this._response = this.JsonResult(0, string.Format("凌晨1点55分到上午10点, [{0}]暂停开奖", lottery.Title));
return;
}
try
{
string[] issueTimeAndSn = betDal.GetIssueTimeAndSN(int32_2);
string str1 = issueTimeAndSn[0];
DateTime dateTime = Convert.ToDateTime(issueTimeAndSn[1]);
DateTime serverTime = FlexDAL.PublicDAL.GetServerTime();
string str2 = betDal.CheckBet(int32_1, int32_2, Convert.ToDecimal(num), dateTime);
if (!string.IsNullOrEmpty(str2))
{
this._response = this.JsonResult(0, str2);
}
else
{
Decimal money = new Decimal(0);
UserZhBetModel zhmodel = new UserZhBetModel();
zhmodel.UserId = int32_1;
zhmodel.LotteryId = int32_2;
zhmodel.PlayId = 0;
zhmodel.StartIssueNum = str1;
zhmodel.TotalNums = int32_4;
zhmodel.IsStop = int32_3;
zhmodel.STime = DateTime.Now;
List <UserBetModel> userBetModelList = new List <UserBetModel>();
List <UserZhDetailModel> listZh = new List <UserZhDetailModel>();
for (int index1 = 0; index1 < requestDataJsonzhList.Count; ++index1)
{
ajaxBetting.RequestDataJSONZH requestDataJsonzh2 = requestDataJsonzhList[index1];
this.doh.Reset();
this.doh.ConditionExpress = "Id=@Id";
DbOperHandler doh = this.doh;
string _conditionName = "@Id";
int playId1 = requestDataJsonzh2.playId;
string str3 = playId1.ToString();
doh.AddConditionParameter(_conditionName, (object)str3);
string str4 = string.Concat(this.doh.GetField("Sys_PlaySmallType", "Title2"));
if (Convert.ToDecimal(requestDataJsonzh2.price) < new Decimal(0) || Convert.ToDecimal(requestDataJsonzh2.Num) < new Decimal(1) || Convert.ToDecimal(requestDataJsonzh2.times) < new Decimal(1))
{
this._response = this.JsonResult(0, "投注错误！请重新投注！");
return;
}
Decimal singelBouns = new Decimal(0);
int userId = int32_1;
int lotteryId = int32_2;
string balls = requestDataJsonzh2.balls;
playId1 = requestDataJsonzh2.playId;
string playId2 = playId1.ToString();
string strPos = requestDataJsonzh2.strPos;
int int32_5 = Convert.ToInt32(requestDataJsonzh2.Num);
Decimal Point = Convert.ToDecimal(requestDataJsonzh2.Point);
string str5 = Calculate.BetNumerice(userId, lotteryId, balls, playId2, strPos, int32_5, Point, ref singelBouns);
if (!string.IsNullOrEmpty(str5))
{
this._response = str5;
return;
}
if (singelBouns <= new Decimal(0))
{
this._response = this.JsonResult(0, "投注失败,返点错误，请重新投注！");
return;
}
UserBetModel userBetModel = new UserBetModel();
userBetModel.UserId = int32_1;
userBetModel.UserMoney = new Decimal(0);
userBetModel.LotteryId = int32_2;
userBetModel.PlayId = Convert.ToInt32(requestDataJsonzh2.playId);
userBetModel.PlayCode = str4;
userBetModel.SingleMoney = Convert.ToDecimal(requestDataJsonzh2.price);
userBetModel.Num = Convert.ToInt32(requestDataJsonzh2.Num);
userBetModel.Detail = requestDataJsonzh2.balls;
userBetModel.Point = Convert.ToDecimal(requestDataJsonzh2.Point);
userBetModel.Bonus = singelBouns;
userBetModel.Pos = requestDataJsonzh2.strPos;
userBetModel.STime2 = serverTime;
userBetModel.IsDelay = 0;
userBetModel.ZHID = 0;
for (int index2 = 0; index2 < requestDataJsonzh2.table2.Count; ++index2)
{
ajaxBetting.RequestDataJSONZH2 requestDataJsonzH2 = requestDataJsonzh2.table2[index2];
if (Convert.ToInt32(requestDataJsonzH2.ZHTimes) > 0 && Convert.ToDecimal(requestDataJsonzH2.ZHIssueNum.Replace("-", "")) >= Convert.ToDecimal(str1.Replace("-", "")))
{
UserZhDetailModel userZhDetailModel = new UserZhDetailModel();
userZhDetailModel.IssueNum = requestDataJsonzH2.ZHIssueNum;
userZhDetailModel.Times = Convert.ToInt32(requestDataJsonzH2.ZHTimes);
userZhDetailModel.STime = Convert.ToDateTime(requestDataJsonzH2.ZHSTime);
userZhDetailModel.Lists.Add(userBetModel);
money += userBetModel.SingleMoney * (Decimal)userBetModel.Num * (Decimal)userZhDetailModel.Times;
listZh.Add(userZhDetailModel);
}
}
}
zhmodel.TotalSums = money;
if (listZh.Count > 0)
{
if (betDal.InsertZhBet(zhmodel, listZh, money, "手机追号") > 0)
{
this._response = this.JsonResult(1, "追号成功！请等待开奖！");
}
else
{
this._response = this.JsonResult(0, "对不起,投注失败！");
}
}
else
{
this._response = this.JsonResult(0, "对不起,投注失败！");
}
}
}
catch (Exception ex)
{
this._response = this.JsonResult(0, "对不起,投注失败！");
}
}
}
