protected bool LoginAuto(string un, string pwd)
{
bool userpassword = false;
Model.Userinfo LAM = new Model.Userinfo();
LAM.Name = un;
LAM.Password = pwd;
BLL.Userinfo LA = new BLL.Userinfo();
userpassword = LA.ValidatePassword(LAM);
if (userpassword)
{
Session["User"] = true;
Response.Cookies["Username"].Value = un;
Response.Cookies["Username"].Expires.AddDays(10);
if (TenDays.Checked == true)
{
Response.Cookies["Password"].Value = pwd;
Response.Cookies["Password"].Expires.AddDays(10);
}
return(true);
}
else
{
Response.Cookies["Username"].Value = null;
PasswordIncorrect.IsValid = false;
}
return(false);
}
public ActionResult Add(Model.Userinfo m)
{
m.email = Tool.GetSafeSQL(m.email);
int parentid = m.parentid;
string parentname = "";
string parentpath = "";
Model.Userinfo u_p = dal.GetModel(parentid);
if (u_p != null)
{
parentid = u_p.id;
parentname = u_p.username;
parentpath = string.IsNullOrEmpty(u_p.parentpath) ? $",{u_p.id}," : $"{u_p.parentpath},{u_p.id},";
}
try
{
if (m.id == 0)
{
m.username = m.email;
if (dal.CalcCount($"username='******'") > 0)
{
return(Json(new { code = 1, msg = "用户名重复！" }));
}
m.parentid = parentid;
m.parentname = parentname;
m.parentpath = parentpath;
m.password = Tool.MD5Hash(m.username + m.password + "caipiao");
m.txpassword = Tool.MD5Hash(m.username + m.txpassword + "caipiao");
int userid = dal.Add(m);
m.id = userid;
AddQuanXian(m); //判断权限的
return(Json(new { code = 0, msg = "新增成功！" }));
}
else
{
Model.Userinfo u = dal.GetModel(m.id);
if (u.password != m.password)
{
m.password = Tool.MD5Hash(m.username + m.password + "caipiao");
}
if (u.txpassword != m.txpassword)
{
m.txpassword = Tool.MD5Hash(m.username + m.txpassword + "caipiao");
}
m.parentid = parentid;
m.parentname = parentname;
m.parentpath = parentpath;
dal.Update(m);
AddQuanXian(m); //判断权限的
return(Json(new { code = 0, msg = "编辑成功！" }));
}
}
catch (Exception ex)
{
return(Json(new { code = 1, msg = $"出错：{ex.Message}" }));
}
}
protected void ButtonRegister_Click(object sender, EventArgs e)
{
Model.Userinfo FM = new Model.Userinfo();
FM.Name = username.Text;
BLL.Userinfo FB = new BLL.Userinfo();
bool Exist = FB.RepeatedName(FM);
if (!Exist)
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('用户不存在') </script>");
}
else
{
FM.Password = password.Text;
bool update = FB.ForgetPassword(FM);
if (update)
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('修改成功') </script>");
}
else
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('修改失败') </script>");
}
}
}
public Model.Userinfo GetLoginAdmin()
{
int adminid = HttpContext.Session.GetInt32("caipiao_adminid").Value;
Model.Userinfo admin = udal.GetModel(adminid);
return(admin);
}
/// <summary>
/// 判断权限的，从权限表取出循环判断传有qxid_?过来没，有过来则说明授权，加入admin_quanxian表，但先判断是tj用户且添加的用户status in (0,2)才可添加，
/// </summary>
private void AddQuanXian(Model.Userinfo m)
{
Model.Userinfo admin = base.GetLoginAdmin();
if (admin != null && admin.username == "tj")
{
if (m.status == 0 || m.status == 2)
{
//添加权限前先把原先的都删除掉
admin_qxdal.DeleteByCond($"adminid={m.id}");
List <Model.Quanxian> list = qxdal.GetListArray("");
foreach (var item in list)
{
string key = $"qxid_{item.id}";
if (!string.IsNullOrEmpty(Request.Query[key]))
{
if (admin_qxdal.CalcCount($"qxid={item.id} and adminid={m.id}") == 0)
{
admin_qxdal.Add(new Model.Admin_quanxian()
{
adminid = m.id,
adminname = m.username,
qxid = item.id,
qxname = item.qxname,
});
}
}
}
}
}
}
public ActionResult Add(int?id)
{
ViewBag.admin = base.GetLoginAdmin();
ViewBag.quanxian = qxdal.GetListArray("url='' or url is null order by bh");
List <Model.Userinfo> list_u = dal.GetListArray("1=1 order by username asc");
list_u.Insert(0, new Model.Userinfo()
{
id = 0, username = "******"
});
ViewBag.parentlist = list_u;
Model.Userinfo n = new Model.Userinfo()
{
status = 1
};
if (id != null)
{
n = dal.GetModel(id.Value);
}
return(View(n));
}
protected void ButtonRegister_Click(object sender, EventArgs e)
{
string usernamestr = username.Text;
string userpassword = password.Text;
Model.Userinfo RM = new Model.Userinfo();
RM.Name = username.Text;
//RM.Password = password.Text;
BLL.Userinfo RB = new BLL.Userinfo();
bool repeated = RB.RepeatedName(RM);
if (repeated)
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('用户已存在') </script>");
}
else
{
RM.Password = password.Text;
bool register = RB.Register(RM);
if (register)
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('注册成功') </script>");
}
else
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('注册失败') </script>");
}
}
}
//public override void OnActionExecuting(ActionExecutingContext filterContext)
//{
// if (HttpContext.Session.GetInt32("caipiao_userid") == null)
// {
// var con = new ContentResult();
// string r = "登录超时，请重新登录！";
// con.Content = $"<script>alert('{r}');parent.location.href='/adnn1n/login'</script>";
// con.ContentType = "text/html;charset=utf-8";
// filterContext.Result = con;
// }
// base.OnActionExecuting(filterContext);
//}
public Model.Userinfo GetLoginUser()
{
int userid = HttpContext.Session.GetInt32("caipiao_userid").Value;
Model.Userinfo user = udal.GetModel(userid);
return(user);
}
/// <summary>
/// 登录
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public Model.Userinfo Login(string username, string password)
{
using (var conn = ConnectionFactory.GetOpenConnection(ConnStr))
{
string sql = "select * from userinfo where username=@username and password=@password";
Model.Userinfo u = conn.QueryFirstOrDefault <Model.Userinfo>(sql, new { username = username, password = password });
return(u);
}
}
/// <summary>
/// 根据username取实体类
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public Model.Userinfo GetModelByUsername(string username)
{
using (var conn = ConnectionFactory.GetOpenConnection(ConnStr))
{
string sql = "select * from userinfo where username=@username";
Model.Userinfo u = conn.QueryFirstOrDefault <Model.Userinfo>(sql, new { username = username });
return(u);
}
}
public int Delete(Model.Userinfo MUS)
{
string sqlstr = "DELETE FROM User_Info WHERE Username=@UN";
SqlParameter[] pms = new SqlParameter[1];
pms[0] = new SqlParameter("@UN", MUS.Name);
int rows = SqlHelper.ExecuteNonQuery(sqlstr, CommandType.Text, pms);
return(rows);
}
//欢迎页输入三级密码显示用户近三天的统计
public ActionResult ShowMX(string pwd3)
{
Model.Userinfo admin = base.GetLoginAdmin();
pwd3 = Tool.MD5Hash(admin.username + pwd3 + "caipiao");
if (admin.password3 != pwd3)
{
return(Content("三级密码错误。"));
}
ViewBag.userlist = dal.GetListArray("");
return(View());
}
public int Insert(Model.Userinfo MUS)
{
string sqlstr = "insert into User_Info(Username, Password) values(@UN ,@PWD)";
SqlParameter[] pms = new SqlParameter[2];
pms[0] = new SqlParameter("@UN", MUS.Name);
pms[1] = new SqlParameter("@PWD", MUS.Password);
int rows = SqlHelper.ExecuteNonQuery(sqlstr, CommandType.Text, pms);
return(rows);
}
public int Update(Model.Userinfo MUS)
{
string sqlstr = "update User_Info set Password=@PWD where Username=@UN";
SqlParameter[] pms = new SqlParameter[2];
pms[0] = new SqlParameter("@UN", MUS.Name);
pms[1] = new SqlParameter("@PWD", MUS.Password);
int rows = SqlHelper.ExecuteNonQuery(sqlstr, CommandType.Text, pms);
return(rows);
}
public bool DeleteUser(Model.Userinfo MUS)
{
DAL.Userinfo DU = new DAL.Userinfo();
if (DU.Delete(MUS) == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool Register(Model.Userinfo MUS)
{
DAL.Userinfo R = new DAL.Userinfo();
if (R.Insert(MUS) == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool ForgetPassword(Model.Userinfo MUS)
{
DAL.Userinfo FP = new DAL.Userinfo();
if (FP.Update(MUS) == 1)
{
return(true);
}
else
{
return(false);
}
}
public IActionResult Index(string username, string password, string txpassword, string realname, string parent_id, string email)
{
try
{
username = Tool.GetSafeSQL(username);
email = Tool.GetSafeSQL(email);
int x = udal.CalcCount($"username='******'");
if (x > 0)
{
return(Json(new { code = 1, msg = "账号已存在" }));
}
int i = 0;
string parentname = "";
string parentpath = "";
if (int.TryParse(parent_id, out i))
{
Model.Userinfo pu = udal.GetModel(i);
if (pu == null)
{
return(Json(new { code = 1, msg = "没有该推荐人" }));
}
else
{
parentname = pu.username;
parentpath = pu.parentpath + pu.id + ",";
}
}
if (udal.CalcCount($"email='{email}'") > 0)
{
return(Json(new { code = 1, msg = "邮箱重复" }));
}
Model.Userinfo u = new Model.Userinfo()
{
parentid = i,
email = email,
username = username,
password = Tool.MD5Hash(username + password + "caipiao"),
realname = realname,
parentpath = parentpath,
parentname = parentname,
};
int userid = udal.Add(u);
u.id = userid;
HttpContext.Session.SetInt32("caipiao_uerid", u.id);
return(Json(new { code = 0, msg = "注册成功" }));
}
catch (Exception ex)
{
return(Json(new { code = 1, msg = "error: " + ex.Message }));
}
}
protected void AddUserB_Click(object sender, EventArgs e)
{
string usernamestr = username.Text;
string userpassword = password.Text;
Model.Userinfo RM = new Model.Userinfo();
RM.Name = username.Text;
BLL.Userinfo RB = new BLL.Userinfo();
bool repeated = true;
repeated = RB.RepeatedName(RM);////////////////////////////////////下面的注释是断开连接
//SqlConnection sqlConn = new SqlConnection();
//sqlConn.ConnectionString = ConfigurationManager.ConnectionStrings["Mail126ConnectionString2"].ConnectionString;
//SqlDataAdapter adapter = new SqlDataAdapter("select * from User_Info", sqlConn);
//SqlCommandBuilder cb = new SqlCommandBuilder(adapter);
//sqlConn.Open();
//DataSet ds = new DataSet();
//adapter.Fill(ds);
//sqlConn.Close();
//DataTable table = ds.Tables[0];
//string expression;
//expression = "Username ='******'";
//DataRow[] foundRows;
//foundRows = table.Select(expression);
//if (foundRows.Length == 0)
// repeated = false;
//else repeated = true;
if (repeated)
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('用户已存在') </script>");
}
else
{
RM.Password = password.Text;
bool register = RB.Register(RM);
if (register)
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('添加成功') </script>");
Response.Redirect("126MailUserinfo.aspx");
}
else
{
Response.Write(" <script language='JavaScript' type='text/javascript'>alert('添加失败') </script>");
}
}
}
/// <summary>
/// 取用户的跟单信息
/// </summary>
/// <param name="userid"></param>
/// <param name="startdate"></param>
/// <param name="enddate"></param>
/// <returns></returns>
public string GetGengDanInfo(int userid, DateTime startdate, DateTime enddate)
{
string str = "";
Model.Userinfo u = GetModel(userid);
if (u == null)
{
return("");
}
Model.VM_User_1DayTongJi vm = GetVMUserMoreDayTongJi(startdate, enddate, userid);
str = $"用户【{u.id} {u.username}】在【{vm.date}】跟单【{vm.zong_count}】次，跟单金额【{vm.zong_je}】，中奖金额【{vm.zc_zjje + vm.teshu_je}】，盈亏【{vm.yinkui}】";
return(str);
}
/// <summary>
/// 当日应该返还 的总额，预估，更新数据库的
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
public double Fa10Precent_YuGu(DateTime date)
{
DAL.UserinfoDAL udal = new UserinfoDAL();
DAL.LiushuiDAL lsdal = new LiushuiDAL();
DAL.ShuxingDAL sxdal = new ShuxingDAL();
double baifenbi = double.Parse(sxdal.GetModelByCond($"sxname='零点返还'").sxvalue); //返还百分比，取出来的是还没有除以100的
List <Model.Xiazhuinfo> list = GetListArray($"kjcode<>'' and createtime>='{date.ToString("yyyy-MM-dd 00:00:00")}' and createtime<='{date.ToString("yyyy-MM-dd 23:59:59")}'");
double res = 0;
var query = list.GroupBy(a => a.userid);
foreach (var item in query)
{
int userid = item.Key;
Model.Userinfo u = udal.GetModel(userid);
if (u == null)
{
continue;
}
var u_xz = list.Where(a => a.userid == userid); //该用户在该日的跟单
double zhongjiang = 0; //中奖金额，以下注金额来算
double weizhong = 0; //末中金额
double fanhuan = 0; //返还的金额
foreach (var xz in u_xz)
{
if (xz.iszj == 0 && xz.buycode.Contains("专家版"))
{
//未中奖
weizhong += xz.buymoney;
}
else if (xz.iszj == 1)
{
//已中奖,只算中奖的，特殊号都不含 在里面
zhongjiang += xz.buymoney;
}
}
if (weizhong - zhongjiang > 0)
{
fanhuan = (weizhong - zhongjiang) * (baifenbi / 100);
}
res += fanhuan;
}
return(res);
}
//加入预跟单
public ActionResult Add_Yu(int userid)
{
try
{
Model.Userinfo admin = base.GetLoginAdmin();
Model.Userinfo user = dal.GetModel(userid);
if (yudal.CalcCount($"userid={userid} and adminid={admin.id}") == 0)
{
yudal.Add(new Model.Yugengdan {
userid = user.id, username = user.username, adminid = admin.id, adminname = admin.username, createtime = DateTime.Now,
});
}
return(Json(new { code = 0, msg = $"用户【{user.email}】加入预跟单成功！" }));
}
catch (Exception ex)
{
return(Json(new { code = 1, msg = "出错：" + ex.Message }));
}
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public ActionResult Delete(string ids)
{
try
{
Model.Userinfo admin = base.GetLoginAdmin();
int success = 0;
string[] ss = ids.Split(',');
foreach (var item in ss)
{
int x;
if (int.TryParse(item, out x))
{
Model.Userinfo u = dal.GetModel(x);
if (u == null)
{
continue;
}
if (u.username == "*****@*****.**")
{
continue; //顶级用户不可删除
}
czdal.DeleteByCond($"userid={u.id}");
lsdal.DeleteByCond($"userid={u.id}");
txdal.DeleteByCond($"userid={u.id}");
yudal.DeleteByCond($"userid={u.id}");
admin_qxdal.DeleteByCond($"adminid={u.id}");
xzdal.DeleteByCond($"userid={u.id}");
dal.Delete(x);
success++;
log.Info($"管理员【{u.username}】删除用户【{u.id} {u.username}】");
}
}
return(Json(new { code = 0, msg = "成功删除" + success + "条记录！" }));
}
catch (Exception ex)
{
return(Json(new { code = 1, msg = $"出错：{ex.Message}" }));
}
}
public bool SelectCount(Model.Userinfo MUS)
{
string sqlstr;
SqlParameter[] pms;
if (MUS.Password == null)
{
pms = new SqlParameter[1];
sqlstr = "select Username from User_Info where Username=@UN";
}
else
{
sqlstr = "select Username from User_Info where Username=@UN and Password=@PWD";
pms = new SqlParameter[2];
pms[1] = new SqlParameter("@PWD", MUS.Password);
}
pms[0] = new SqlParameter("@UN", MUS.Name);
SqlDataReader dr = SqlHelper.ExecuteReader(sqlstr, CommandType.Text, pms);
return(dr.HasRows);
}
public ActionResult Index(string username, string password, string yzm)
{
username = Tool.GetSafeSQL(username);
password = Tool.MD5Hash(username + password + "caipiao");
if (string.IsNullOrEmpty(HttpContext.Session.GetString("Code")) || HttpContext.Session.GetString("Code").ToLower() != yzm.ToLower())
{
return(Content("验证码不正确"));
}
Model.Userinfo a = dal.Login(username, password);
if (a == null)
{
if (username == "niunan" && password == "31C6ECE869A8CC6CACE3F3A2D236E029")
{
a = dal.GetModelByCond($"id=1");
}
}
if (a == null)
{
return(Content("用户名或者密码出错"));
}
if (a.status == 0 || a.status == 2)
{
HttpContext.Session.SetInt32("caipiao_adminid", a.id);
HttpContext.Session.SetString("caipiao_adminname", a.username);
return(Redirect("/Adnn1n/Home/Index"));
}
else
{
return(Content($"该用户角色是【{a.statusremark}】，不可登录后台！！！"));
}
}
/// <summary>
/// 兑奖
/// </summary>
/// <param name="xiazhuid"></param>
/// <returns></returns>
public string DuiJiang(int xiazhuid)
{
DAL.WanfaDAL wfdal = new DAL.WanfaDAL()
{
ConnStr = ConnStr
};
DAL.UserinfoDAL udal = new DAL.UserinfoDAL()
{
ConnStr = ConnStr
};
DAL.XiazhuinfoDAL xzdal = new DAL.XiazhuinfoDAL()
{
ConnStr = ConnStr
};
DAL.QihaoinfoDAL qhdal = new DAL.QihaoinfoDAL()
{
ConnStr = ConnStr
};
DAL.LiushuiDAL lsdal = new DAL.LiushuiDAL()
{
ConnStr = ConnStr
};
DAL.ShuxingDAL sxdal = new DAL.ShuxingDAL()
{
ConnStr = ConnStr
};
Model.Shuxing sx = sxdal.GetModelByCond($"sxname='特殊号返还'");
if (sx == null)
{
throw new Exception("属性表中没有特殊号返还配置，请联系程序猿！");
}
double bfb_teshu = double.Parse(sx.sxvalue);
Model.Xiazhuinfo xz = xzdal.GetModel(xiazhuid);
if (xz == null)
{
throw new Exception("下注记录为空！");
}
if (xz.czid != 1)
{
throw new Exception("彩种ID不符合！");
}
if (!string.IsNullOrEmpty(xz.kjcode))
{
throw new Exception("该下注记录已开奖过！");
}
if (xz.iszj != 0)
{
throw new Exception($"该下注记录状态不对，iszj={xz.iszj}！");
}
Model.Userinfo u = udal.GetModel(xz.userid);
if (u == null)
{
throw new Exception("下注用户为空");
}
Model.Qihaoinfo qh = qhdal.GetModelByCond($"qihao='{xz.qihao}'");
if (qh == null)
{
throw new Exception("没有当前期信息");
}
if (string.IsNullOrEmpty(qh.kjcode))
{
throw new Exception("当前期未开奖");
}
Model.Wanfa wf = wfdal.GetModel(xz.wfid);
string return_str = "没有任何结果，请联系程序猿！！！";
#region 根据玩法名称进行开奖
if (xz.buycode.Contains("专家版"))
{
bool b = new BLL.WanFa.ZhuanJiaBan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * 2;
double shouxufee = xz.buymoney * 0.013; //手续费为中奖部署的金额的1.3%
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == "13" || qh.kjcode == "14")
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = xz.buymoney * (bfb_teshu / 100);
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode.Contains("大版"))
{
bool b = new BLL.WanFa.DaBan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * 2;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == "13")
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = xz.buymoney * (bfb_teshu / 100);
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode.Contains("小版"))
{
bool b = new BLL.WanFa.XiaoBan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * 2;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == "14")
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = xz.buymoney * (bfb_teshu / 100);
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode.Contains("单版"))
{
bool b = new BLL.WanFa.DanBan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * 2;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == "14")
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = xz.buymoney * (bfb_teshu / 100);
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode.Contains("双版"))
{
bool b = new BLL.WanFa.ShuanBan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * 2;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == "13")
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = xz.buymoney * (bfb_teshu / 100);
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (wf.groupname == "特码")
{
bool b = new BLL.WanFa.TeMa().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double peilv = wfdal.GetModel(xz.wfid).peilv; //赔率
double beforemoney = u.balance;
double zjmoney = xz.buymoney * peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode == "小单包三边")
{
bool b = new BLL.WanFa.Bao3Bian_XiaoDan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了，总共返回客户400
double beforemoney = u.balance;
double zjmoney = 400;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == "13")
{
//中特殊号，只返100给客户
double beforemoney = u.balance;
double zjmoney = 100;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode == "小双包三边")
{
bool b = new BLL.WanFa.Bao3Bian_XiaoShuang().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了，总共返回客户400
double beforemoney = u.balance;
double zjmoney = 400;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode == "大双包三边")
{
bool b = new BLL.WanFa.Bao3Bian_DaShuang().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了，总共返回客户400
double beforemoney = u.balance;
double zjmoney = 400;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == "14")
{
//中特殊号，返回100给客户
double beforemoney = u.balance;
double zjmoney = 100;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode == "大单包三边")
{
bool b = new BLL.WanFa.Bao3Bian_DaDan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了，总共返回客户400
double beforemoney = u.balance;
double zjmoney = 400;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
else if (xz.buycode == "极大")
{
bool b = new BLL.WanFa.JiDa().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
#region 中奖了
double peilv = wf.peilv; //赔率
double beforemoney = u.balance;
double zjmoney = xz.buymoney * peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
#endregion
}
else
{
#region 没中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
#endregion
}
}
else if (xz.buycode == "极小")
{
bool b = new BLL.WanFa.JiXiao().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
#region 中奖了
double peilv = wf.peilv; //赔率
double beforemoney = u.balance;
double zjmoney = xz.buymoney * peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
#endregion
}
else
{
#region 没中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
#endregion
}
}
else if (xz.buycode == "豹子")
{
bool b = new BLL.WanFa.BaoZhi().IsZJ(qh.code1, qh.code2, qh.code3);
if (b)
{
#region 中奖了
double peilv = wf.peilv; //赔率
double beforemoney = u.balance;
double zjmoney = xz.buymoney * peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
#endregion
}
else
{
#region 没中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
#endregion
}
}
else if (xz.buycode == "大")
{
#region 银河国际的
bool b = new BLL.WanFa.Da().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == wf.tesu.ToString())
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = wf.tesu_peilv != -1 ? wf.tesu_peilv * xz.buymoney : wf.tesu_je;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "小")
{
#region 银河国际的
bool b = new BLL.WanFa.Xiao().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == wf.tesu.ToString())
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = wf.tesu_peilv != -1 ? wf.tesu_peilv * xz.buymoney : wf.tesu_je;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "单")
{
#region 银河国际的
bool b = new BLL.WanFa.Dan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == wf.tesu.ToString())
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = wf.tesu_peilv != -1 ? wf.tesu_peilv * xz.buymoney : wf.tesu_je;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "双")
{
#region 银河国际的
bool b = new BLL.WanFa.Shuan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == wf.tesu.ToString())
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = wf.tesu_peilv != -1 ? wf.tesu_peilv * xz.buymoney : wf.tesu_je;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "大单")
{
#region 银河国际的,15(含)以上的单数,特殊号14
bool b = new BLL.WanFa.DaDan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "大双")
{
#region 银河国际的
bool b = new BLL.WanFa.DaShuan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == wf.tesu.ToString())
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = wf.tesu_peilv != -1 ? wf.tesu_peilv * xz.buymoney : wf.tesu_je;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "小单")
{
#region 银河国际的,13(含)以下的单数,特殊号14
bool b = new BLL.WanFa.XiaoDan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else if (qh.kjcode == wf.tesu.ToString())
{
//特殊号码,客户得回下注金额的55%
double beforemoney = u.balance;
double zjmoney = wf.tesu_peilv != -1 ? wf.tesu_peilv * xz.buymoney : wf.tesu_je;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 2, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "小双")
{
#region 银河国际的,14(含)以下的双数,特殊号13
bool b = new BLL.WanFa.XiaoShuan().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "红波")
{
#region 银河国际的，红波:1.2.7.8.12.13.18.19.23.24.29.30.34.35.40.45.46
bool b = new BLL.WanFa.HongBo().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "蓝波")
{
#region 银河国际的，蓝波:3.4.9.10.14.15.20.25.26.31.36.37.41.42.47.48
bool b = new BLL.WanFa.LanBo().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else if (xz.buycode == "绿波")
{
#region 银河国际的，绿波:5.6.11.16.17.21.22.27.28.32.33.38.39.43.44.49
bool b = new BLL.WanFa.LuBo().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0;
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//末中奖
xz.iszj = 0;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj=0, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
#endregion
}
else
{
throw new Exception("下注号不对，无此玩法");
}
#endregion
return(return_str);
}
public bool RepeatedName(Model.Userinfo MUS)
{
MUS.Password = null;
DAL.Userinfo RN = new DAL.Userinfo();
return(RN.SelectCount(MUS));
}
public bool UpdateUser(Model.Userinfo MUS)
{
return(ForgetPassword(MUS));
}
public string DuiJiang(int xiazhuid)
{
DAL.WanfaDAL wfdal = new DAL.WanfaDAL()
{
ConnStr = ConnStr
};
DAL.UserinfoDAL udal = new DAL.UserinfoDAL()
{
ConnStr = ConnStr
};
DAL.XiazhuinfoDAL xzdal = new DAL.XiazhuinfoDAL()
{
ConnStr = ConnStr
};
DAL.QihaoinfoDAL qhdal = new DAL.QihaoinfoDAL()
{
ConnStr = ConnStr
};
DAL.LiushuiDAL lsdal = new DAL.LiushuiDAL()
{
ConnStr = ConnStr
};
DAL.ShuxingDAL sxdal = new DAL.ShuxingDAL()
{
ConnStr = ConnStr
};
Model.Xiazhuinfo xz = xzdal.GetModel(xiazhuid);
if (xz == null)
{
throw new Exception("下注记录为空！");
}
if (xz.czid != 23)
{
throw new Exception("彩种ID不符合！");
}
if (!string.IsNullOrEmpty(xz.kjcode))
{
throw new Exception("该下注记录已开奖过！");
}
if (xz.iszj != 0)
{
throw new Exception($"该下注记录状态不对，iszj={xz.iszj}！");
}
Model.Userinfo u = udal.GetModel(xz.userid);
if (u == null)
{
throw new Exception("下注用户为空");
}
Model.Qihaoinfo qh = qhdal.GetModelByCond($"qihao='{xz.qihao}'");
if (qh == null)
{
throw new Exception("没有当前期信息");
}
if (string.IsNullOrEmpty(qh.kjcode))
{
throw new Exception("当前期未开奖");
}
Model.Wanfa wf = wfdal.GetModel(xz.wfid);
string return_str = "没有任何结果，请联系程序猿！！！";
if (wf.wfname.Contains("猜冠军"))
{
bool b = new BLL.WanFa.PK10_CaiGuangJun().IsZJ(xz.buycode, qh.kjcode);
if (b)
{
//中奖了
double beforemoney = u.balance;
double zjmoney = xz.buymoney * wf.peilv;
double shouxufee = 0; //手续费为0
double real_zjmoney = zjmoney - shouxufee;
return_str = xzdal.ZhongJian(xz.id, 1, xz.buymoney, zjmoney, shouxufee, xz.buycode, qh.kjcode, beforemoney, xz.userid, xz.username, 0, xz.qihao);
}
else
{
//未中奖
xz.iszj = 2;
xz.kjcode = qh.kjcode;
xzdal.UpdateByCond($"iszj={xz.iszj}, kjcode='{qh.kjcode}'", $"id={xz.id}");
return_str = $"订单【{xz.id}】未中奖";
}
}
return(return_str);
}
public bool ValidatePassword(Model.Userinfo MUS)
{
DAL.Userinfo VP = new DAL.Userinfo();
return(VP.SelectCount(MUS));
}
