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