/// <summary> /// 选择会议统计数据 /// </summary> /// <returns></returns> public string SelectMeetingAjax() { string Meeting = Request["va1"]; string IsSuccess = "1"; SqlParameter[] pms = { new SqlParameter("@Meeting", Meeting) }; MessasgeDataSet mgdataset = Datafun.MgfunctionDataSet(@"select COUNT(id) from tb_InsertMeeting where Meeting=@Meeting;select COUNT(id) from tb_InsertMeeting where qdh <> 10000 and Meeting=@Meeting;select SUM(Hongbao) from tb_gift where Meeting=@Meeting;select COUNT(id) from tb_InsertMeeting where qdh = 10000 and Meeting=@Meeting ", pms); IsSuccess = mgdataset.MgdataSet.Tables[0].Rows[0][0] + "|" + mgdataset.MgdataSet.Tables[1].Rows[0][0] + "|" + mgdataset.MgdataSet.Tables[2].Rows[0][0] + "|" + mgdataset.MgdataSet.Tables[3].Rows[0][0]; return(IsSuccess); }
/// <summary> /// 签到 /// </summary> /// <returns></returns> public string AddSignAjax() { string meeting = LgUser.Meetting; string tel = Request["va2"]; string sjrs = Request["va1"]; string IsSuccess = "1"; SqlParameter[] pms = { new SqlParameter("@meeting", meeting), new SqlParameter("@tel", tel), new SqlParameter("@sjrs", sjrs) }; MessasgeDataSet mgdataset = Datafun.MgfunctionDataSet("bs_sign_poc", pms, "poc"); if (mgdataset.MgdataSet.Tables[1].Rows[0][0].ToString() == "0") { //DataRow dr = mgdataset.MgdataSet.Tables[0].Rows[0]; //LoginUser lguser = new LoginUser //{ // UserId = dr["id"].ToString(), // UserName = dr["UserName"].ToString(), // qdh = dr["qdh"].ToString(), // znum =dr["znum"].ToString(), // Bank = dr["Bank"].ToString(), // Tel = dr["tel"].ToString(), // Meetting = dr["Meeting"].ToString() //}; //Session["Lguser"] = lguser; IsSuccess = "0" + "|" + mgdataset.MgdataSet.Tables[0].Rows[0][0].ToString(); } else if (mgdataset.MgdataSet.Tables[1].Rows[0][0].ToString() == "1") { IsSuccess = "1" + "|" + mgdataset.MgdataSet.Tables[0].Rows[0][0].ToString(); } else { IsSuccess = "2" + "|" + mgdataset.MgdataSet.Tables[0].Rows[0][0].ToString(); } return(IsSuccess); }
/// <summary> /// 选桌子ids 为电话号码 /// </summary> /// <returns></returns> public ActionResult ChangeDesk(string id, string ids, string idss) { ViewBag.message = idss; try { ViewBag.name = LgUser.UserName; ViewBag.nums = "0"; ViewBag.zh = id; ViewBag.tel = ids; string sb = ""; string sc = ""; MessasgeDataSet mgdatadset = new MessasgeDataSet(); if (id == null) { return(Content("操作有误,规范操作")); } string meeting = LgUser.Meetting; SqlParameter[] pms = { new SqlParameter("@meeting", meeting), new SqlParameter("@znum", id), new SqlParameter("@tel", ids) }; mgdatadset = Datafun.MgfunctionDataSet(@"select UserName,Sjrs from tb_InsertMeeting where Status=1 and Meeting=@meeting and Znum=@znum;select isnull(nums,0),color from tb_znum where Meeting=@meeting and Zh=@znum;select ISNULL( SUM(CONVERT(int,sjrs)),0) from tb_InsertMeeting where Status=1 and Meeting=@meeting and Znum=@znum;select qdh from tb_InsertMeeting where Meeting=@meeting and(Tel1=@tel or Tel2=@tel)", pms); ViewBag.nums = mgdatadset.MgdataSet.Tables[1].Rows[0][0]; ViewBag.color = mgdatadset.MgdataSet.Tables[1].Rows[0][1]; ViewBag.qdh = ""; if (mgdatadset.MgdataSet.Tables[3].Rows.Count > 0) { ViewBag.qdh = mgdatadset.MgdataSet.Tables[3].Rows[0][0]; } List <string> user = new List <string>(); List <string> userxiaoyu = new List <string>(); foreach (DataRow dr in mgdatadset.MgdataSet.Tables[0].Rows) { for (int i = 0; i < Convert.ToInt32(dr["Sjrs"].ToString()); i++) { user.Add(dr["UserName"].ToString()); userxiaoyu.Add(dr["UserName"].ToString()); } } int less = Convert.ToInt32(ViewBag.nums) - Convert.ToInt32(mgdatadset.MgdataSet.Tables[2].Rows[0][0].ToString()); //剩余空位 int zhless = Convert.ToInt32(ViewBag.nums) - 10; //圆盘额外的座位 //string [] names={"关羽","岳飞","成龙","奥巴马","金龙鱼","栗色","王晓","宋江","李师师"}; //string[] namestt = { "李自成", "孝庄", "陈圆圆" }; if (Convert.ToInt32(ViewBag.nums) >= 10) //桌子设置大于10 { if (user.Count > 10) //来宾人数是否大于10 { userxiaoyu.RemoveRange(0, 10); user.RemoveRange(10, user.Count - 10); sc = dazxAjax(zhless, less, userxiaoyu); //大于10个 来的人数-10 判断3 是 小于等于10 减下来的 sb = xiaozxAjax(10, 10, user); //小于10个 记得判断人数大于10小于10个 } else { sc = ttAjax(zhless); //大于10个 来的人数-10 判断3 是 小于等于10 减下来的 圆盘下面的 sb = cczxAjax(10, zhless, user); //小于10个 记得判断人数大于10小于10个 圆盘 } } else//桌子设置小于10 { sb = xiaozxAjax(Convert.ToInt32(ViewBag.nums), less, user); } ViewBag.sb = sb; ViewBag.sc = sc; } catch (Exception e) { return(Content("选桌错误,请联系工作人员")); } return(View()); }