public DataTable tablehtml(string ParentsId = "0") { LoginUser loginuser = Session["sysadmin"] as LoginUser; MessasgeData mgdata = Datafun.MgfunctionData("select * from tb_menu where ParentsId=@ParentsId and isdel=0 and LOCATE('" + LgUser.UserLvl + "',RoleLvl)>0 ", new SqlParameter("@ParentsId", ParentsId)); return(mgdata.Mgdata); }
/// <summary> /// 添加负责人 /// </summary> /// <returns></returns> public string AddfzrAjax() { string Meeting = Request["va1"]; string UserName = Request["va2"]; string Password = Request["va3"]; string Start_Date = Request["va4"]; string End_Date = Request["va5"]; string tel = Request["va6"]; string IsSuccess = "1"; SqlParameter[] pms = { new SqlParameter("@Meeting", Meeting), new SqlParameter("@Bank", UserName), new SqlParameter("@Password", Passwd.SetPass(Password)), new SqlParameter("@Start_Date", Start_Date), new SqlParameter("@End_Date", End_Date), new SqlParameter("@UserName", tel) }; MessasgeData mgdata = Datafun.MgfunctionData("bs_NewMeeting_poc", pms, "poc"); if (Convert.ToInt32(mgdata.Mgdata.Rows[0][0].ToString()) > 0) { IsSuccess = "0"; } else { IsSuccess = "1"; } return(IsSuccess); }
/// <summary> /// 会议统计 id 为会议 ids 为是否陌生 /// </summary> /// <returns></returns> public ActionResult MeetingTJ(string id, string ids) { List <tb_gift> listorder = new List <tb_gift>(); if (id != null && ids != null) { SqlParameter[] pms = { new SqlParameter("@meeting", id), new SqlParameter("@ms", ids) }; MessasgeData mgdata = Datafun.MgfunctionData("Tj_rstj_poc", pms, "poc"); foreach (DataRow dr in mgdata.Mgdata.Rows) { tb_gift cbai = new tb_gift { UserName = dr["UserName"].ToString(), Tel = dr["Tel"].ToString(), Qdh = dr["Qdh"].ToString(), Hongbao = dr["Hongbao"].ToString(), Gift = dr["Gift"].ToString(), Added1 = dr["sjrs"].ToString(), Added2 = dr["yjrs"].ToString(), }; listorder.Add(cbai); } ; } ViewBag.id = id; ViewBag.ids = ids; return(View(listorder)); }
public ActionResult Fzr() { string sql = @"select UserName,Bank,Start_Date,End_Date,a.id,Meeting,b.MeetingName,a.GamePwd from tb_login a left join tb_Meeting b on a.Meeting=b.id where Lvl=1 and a.isdel=0 order by a.id desc"; MessasgeData mgdata = Datafun.MgfunctionData(sql); List <tb_login> listorder = new List <tb_login>(); if (mgdata.Mgdatacount > 0) { foreach (DataRow dr in mgdata.Mgdata.Rows) { tb_login cbai = new tb_login { id = Convert.ToInt32(dr["id"].ToString()), UserName = dr["UserName"].ToString(), Bank = dr["Bank"].ToString(), Start_Date = Convert.ToDateTime(dr["Start_Date"].ToString()), End_Date = Convert.ToDateTime(dr["End_Date"].ToString()), Meeting = Convert.ToInt32(dr["Meeting"].ToString()), added1 = dr["MeetingName"].ToString(), GamePwd = dr["GamePwd"].ToString() }; listorder.Add(cbai); } ; } return(View(listorder)); }
/// <summary> /// 进入游戏界面 /// </summary> /// <returns></returns> public string EnterGameAjax() { string tel = Request["va2"]; ViewBag.meeting = ""; ViewBag.id = ""; string IsSuccess = "1"; SqlParameter[] pms = { new SqlParameter("@tel", tel), }; MessasgeData mgdata = Datafun.MgfunctionData("select MeetingName,b.id from tb_login a left join tb_Meeting b on a.Meeting=b.id where a.GamePwd=@tel", pms); if (mgdata.Mgdatacount > 0) { ViewBag.meeting = mgdata.Mgdata.Rows[0]["MeetingName"]; IsSuccess = mgdata.Mgdata.Rows[0]["id"].ToString(); } else { IsSuccess = "0"; } return(IsSuccess); }
/// <summary> /// id 为奖项 ids 为中奖人数 /// </summary> /// <param name="id"></param> /// <param name="ids"></param> /// <returns></returns> public string ChoujiangAjax() { string id = Request["va1"]; string ids = Request["va2"]; string bsid = id; StringBuilder sb = new StringBuilder(); string scb = ""; string sql = ""; string sli = ""; sql = @"select top " + ids + " * from tb_InsertMeeting where jx=0 and Meeting=" + LgUser.Meetting + " order by NEWID()"; sli = @" <div class='lottery-vip-list'> <label>{$UserName$}</label> <input type='hidden' class='hide' value='{$id$}'> <span>{$tel3$}******{$tel4$}</span> </div> "; MessasgeData mgdata = Datafun.MgfunctionData(sql, new SqlParameter("@id", bsid)); foreach (DataRow dr in mgdata.Mgdata.Rows) { string tel3 = dr["Tel1"].ToString().Substring(0, 3); string tel4 = dr["Tel1"].ToString().Substring(7, 4); scb = sli.Replace("{$UserName$}", dr["UserName"].ToString()).Replace("{$tel3$}", tel3).Replace("{$tel4$}", tel4).Replace("{$id$}", dr["id"].ToString()); sb.Append(scb); } return(sb.ToString()); }
public string Upload(HttpPostedFileBase[] fileToUpload) { string Meeting = LgUser.Meetting; string Message = "<div style='text-align:center;font-size:100px;margin-top:400px'>上传失败</div>"; foreach (HttpPostedFileBase file in fileToUpload) { DateTime dtnow = System.DateTime.Now; string FileName = dtnow.Year.ToString() + dtnow.Month.ToString() + dtnow.Day.ToString() + dtnow.Hour.ToString() + dtnow.Minute.ToString() + dtnow.Second.ToString() + dtnow.Millisecond.ToString(); string ExtName = getFileExt(file.FileName).ToUpper(); FileName += "." + ExtName; string path = System.IO.Path.Combine(Server.MapPath("~/Content/excel"), System.IO.Path.GetFileName(FileName)); file.SaveAs(path); SqlParameter[] pms = { new SqlParameter("@MeetingName", Meeting), new SqlParameter("@excel", FileName) }; MessasgeData mgdata = Datafun.MgfunctionData(" update tb_Meeting set excel=@excel where id=@MeetingName select @@Identity", pms); bool success = DataInsertAjax(FileName, Meeting); if (success) { Message = "<div style='text-align:center;font-size:100px;margin-top:400px'>上传成功</div>"; } } return(Message); }
/// <summary> /// 设置桌子名称 /// </summary> /// <returns></returns> public ActionResult SetDeskName() { MessasgeData mgdata = Datafun.MgfunctionData("select id, Zh from tb_znum where Meeting=@Meeting", new SqlParameter("@Meeting", LgUser.Meetting)); ViewBag.table = mgdata.Mgdata; return(View()); }
public ActionResult GetCity(string id) { string ReturnValue = string.Empty; MessasgeData mgdata = Datafun.MgfunctionData("select ccode,cname from dbo.bm_region where pcode=@id", new SqlParameter("@id", id)); ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"'); return(ContentJson(ReturnValue)); }
public ActionResult GetQuestion() { string ReturnValue = string.Empty; MessasgeData mgdata = Datafun.MgfunctionData("select id,Question from dbo.tb_question where isdel=0"); ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"'); return(ContentJson(ReturnValue)); }
public ActionResult GetProvince() { string ReturnValue = string.Empty; MessasgeData mgdata = Datafun.MgfunctionData("select ccode,cname from dbo.bm_region where arealevel=1"); ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"'); return(ContentJson(ReturnValue)); }
/// <summary> /// 评论列表测试 /// </summary> /// <returns></returns> public ActionResult CommentResultT() { string Meeting = LgUser.Meetting; MessasgeData mgdata = Datafun.MgfunctionData(" select top 10 * from ( select a.id, a.Tel,b.UserName,a.Comment from tb_Comment a left join tb_logingame b on a.Tel=b.Tel where a.Meeting=@Meeting ) A order by id desc", new SqlParameter("@Meeting", Meeting)); ViewBag.table = mgdata.Mgdata; return(View()); }
public ActionResult GetBank() { string ReturnValue = string.Empty; MessasgeData mgdata = Datafun.MgfunctionData("select distinct Bank from tb_InsertMeeting where Meeting=@Meeting and Bank <>''", new SqlParameter("@Meeting", LgUser.Meetting)); ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"'); return(ContentJson(ReturnValue)); }
public ActionResult GetMeeting() { string ReturnValue = string.Empty; MessasgeData mgdata = Datafun.MgfunctionData(" select id,MeetingName from tb_Meeting where isdel=0 "); ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"'); return(ContentJson(ReturnValue)); }
public ActionResult IndexNofoot(string id, string ids) { MessasgeData mgdata = new MessasgeData(); ViewBag.tel = id; string sql = ""; if (LgUser == null) { return(View("Sign")); } ViewBag.message = ""; SqlParameter[] pms = { new SqlParameter("@meeting", LgUser.Meetting), new SqlParameter("@tel", id ?? "") }; mgdata = Datafun.MgfunctionData(@"select sjrs=(select top 1 sjrs from dbo.tb_InsertMeeting where meeting=@meeting and (Tel1=@tel or Tel2=@tel)) ,Sj=(select isnull(sum(CONVERT(int,isnull(sjrs,0))),0) from dbo.tb_InsertMeeting where meeting=@meeting ), Yj=(select isnull(sum(CONVERT(int,isnull(yjrs,0))),0) from dbo.tb_InsertMeeting where meeting=@meeting)", pms); if (mgdata.Mgdatacount > 0) { if (ids == "需要选桌") { ViewBag.message = "有" + mgdata.Mgdata.Rows[0][0].ToString() + "位人数需要选择座位"; sql = "select id, Nums,(Nums-Yzrs)as syrs,Color,Zh,Zname from tb_znum where Meeting=" + LgUser.Meetting + " and (Nums-Yzrs)>=" + mgdata.Mgdata.Rows[0][0].ToString() + ""; } else { ViewBag.message = "无需选择座位"; sql = "select id, Nums,(Nums-Yzrs)as syrs,Color,Zh,Zname from tb_znum where Meeting=" + LgUser.Meetting + ""; } ViewBag.Yj = Convert.ToInt32(mgdata.Mgdata.Rows[0]["Yj"].ToString()) - Convert.ToInt32(mgdata.Mgdata.Rows[0]["Sj"].ToString()); ViewBag.Sj = mgdata.Mgdata.Rows[0]["Sj"].ToString(); } mgdata = Datafun.MgfunctionData(sql); List <tb_Znum> listorder = new List <tb_Znum>(); foreach (DataRow dr in mgdata.Mgdata.Rows) { tb_Znum cbai = new tb_Znum { id = Convert.ToInt32(dr["id"].ToString()), Nums = dr["Nums"].ToString(), Yzrs = dr["syrs"].ToString(), Color = dr["Color"].ToString(), Zh = Convert.ToInt32(dr["Zh"].ToString()), Zname = dr["Zname"].ToString() }; listorder.Add(cbai); ViewBag.znum = dr["Nums"].ToString(); ViewBag.color = dr["color"].ToString(); } ; return(View(listorder)); }
/// <summary> /// 保存查询信息 /// </summary> /// <returns></returns> public void SaveSearch(string id, string uid, string cid, string cids, string pid, string xlh, string province, string city) { string zd = "电脑"; string status = ""; //string ip = Request.ServerVariables.Get("Remote_Addr"); //string ip = System.Web.HttpContext.Current.Request.UserHostAddress; //string ip = GetUserIP(); string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (ip == null) { ip = Request.ServerVariables.Get("Remote_Addr"); } bool fs = Request.Browser.IsMobileDevice;//是否手机访问 false 为PC true为手机 if (fs == true) { zd = "手机"; } string ids = GetstringIpAddress(ip); MessasgeData mgdata = Datafun.MgfunctionData("select * from bm_region where ccode=@city", new SqlParameter("@city", city)); if (mgdata.Mgdatacount > 0) { bool isdels = ids.Contains(mgdata.Mgdata.Rows[0]["cname"].ToString()); if (isdels == true) { status = "未窜货"; } else { status = "窜货"; } } else { status = "无效防伪码"; } SqlParameter[] pms = { new SqlParameter("@Bsid", id), new SqlParameter("@Ip", ip), new SqlParameter("@Zd", zd), new SqlParameter("@City", ids), new SqlParameter("@Uid", uid), new SqlParameter("@Cid", cid), new SqlParameter("@Cids", cids), new SqlParameter("@Pid", pid), new SqlParameter("@xlh", xlh), new SqlParameter("@province", province), new SqlParameter("@citycode", city), new SqlParameter("@status", status) }; MessasgeInfor mginfor = Datafun.Mgfunctioninfor("insert into tb_Bsidrecord(Bsid,Ip,Zd,City,Uid,Cid,Cids,Pid,xlh,province,citycode,Status) values(@Bsid,@Ip,@Zd,@City,@Uid,@Cid,@Cids,@Pid,@xlh,@province,@citycode,@Status)", pms); }
public string LoginActionUser() { string username = Request["va1"]; string password = Request["va2"]; string IsSuccess = "0"; string time = DateTime.Now.ToString(); string sql = @"select * from tb_login where UserName=@UserName and Password=@Password and isdel=0 and convert(nvarchar(11),Start_Date,120)<= convert(nvarchar(11),getdate(),120) and convert(nvarchar(11),End_Date,120)>= convert(nvarchar(11),getdate(),120)"; SqlParameter[] pms = { new SqlParameter("@UserName", username), new SqlParameter("@Password", Passwd.SetPass(password)) }; MessasgeData mgdata = Datafun.MgfunctionData(sql, pms); if (mgdata.Mgdatacount > 0) { DataRow dr = mgdata.Mgdata.Rows[0]; LoginUser lguser = new LoginUser { UserId = dr["id"].ToString(), UserName = dr["UserName"].ToString(), UserPwd = dr["Password"].ToString(), UserLvl = int.Parse(dr["Lvl"].ToString()), Bank = dr["Bank"].ToString(), Tel = dr["Tel"].ToString(), Meetting = dr["Meeting"].ToString() }; Session["Lguser"] = lguser; Response.Cookies["loginname"].Value = Passwd.SetPass(username); Response.Cookies["loginpwd"].Value = password; Response.Cookies["loginname"].Expires = DateTime.Now.AddDays(10); Response.Cookies["loginpwd"].Expires = DateTime.Now.AddDays(10); mgdata.Mgcontent = "登陆成功"; if (lguser.UserLvl == 0) { IsSuccess = "1"; } else { IsSuccess = "2"; } } else { mgdata.Mgcontent = "用户名密码错误"; IsSuccess = "0"; } return(IsSuccess); }
/// <summary> /// 登录游戏 /// </summary> /// <returns></returns> public ActionResult LoginGame(string id) { ViewBag.ids = id; ViewBag.MeetingName = "会议选择有错误,点击取消重新选择会议!"; MessasgeData mgdata = Datafun.MgfunctionData("select MeetingName from tb_Meeting where id=@Meeting", new SqlParameter("@Meeting", id)); if (mgdata.Mgdatacount > 0) { ViewBag.MeetingName = "是否进入" + mgdata.Mgdata.Rows[0][0] + "游戏";; } return(View()); }
/// <summary> /// 游戏结果页面 /// </summary> /// <returns></returns> public ActionResult GameResult() { if (LgUser == null) { return(RedirectToAction("Login", "Login")); } MessasgeData mgdata = Datafun.MgfunctionData(@"select* from tb_clicks where Meeting=@Meeting and isdel=0 order by Nums desc", new SqlParameter("@Meeting", LgUser.Meetting)); ViewBag.table = mgdata.Mgdata; return(View()); }
/// <summary> /// 我的错题 /// </summary> /// <returns></returns> public ActionResult MemberWrong() { ViewBag.image = LgUser.image; ViewBag.bank = LgUser.Bank; MessasgeData mgdata = new MessasgeData(); mgdata = Datafun.MgfunctionData(@"select * from tb_login where id=@id", new SqlParameter("@id", LgUser.UserId)); string exam = "0"; if (mgdata.Mgdatacount > 0) { exam = mgdata.Mgdata.Rows[0]["Wrong"].ToString().Substring(0, mgdata.Mgdata.Rows[0]["Wrong"].ToString().Length - 1); } mgdata = Datafun.MgfunctionData(@"select * from tb_Examinfor where id in (" + exam + ")"); ViewBag.table = mgdata.Mgdata; return View(); }
/// <summary> /// 游戏未开始界面 /// </summary> /// <returns></returns> public ActionResult GameNostart() { if (LgGameUser == null) { return(RedirectToAction("LoginGame", "Game")); } ViewBag.Starttime = ""; MessasgeData mgdata = Datafun.MgfunctionData("select * from tb_GameSet where Meeting=@id and status=1", new SqlParameter("@id", LgGameUser.Meeting)); if (mgdata.Mgdatacount > 0) { return(View("Nums")); } return(View()); }
/// <summary> /// 导入数据源动作 /// </summary> /// <returns></returns> public bool DataInsertAjax(string filename, string meeting) { string dtTime = DateTime.Now.ToString();; //string filename = System.Web.HttpUtility.UrlDecode(Request["txt0"]); MessasgeInfor mgInfor = new MessasgeInfor { Mgbool = false, Mgtitle = "系统提示", Mgcontent = "操作失败,请确定上传文件是否正确(请参照模板),或者文件是否有数据。" }; //Datafun.Mgfunctioninfor(string.Format("update exl_slywh set del=1 where yearMonth='{0}'", dtTime)); filename = Server.MapPath("~/Content/excel/" + filename); Excel_DR excelDr = new Excel_DR(filename, string.Format("select F1 as UserName,F2 as Tel1,F3 as Tel2 ,F4 as Znum,F5 as Yjrs,F6 as Bank from [Sheet1$] "), ""); MessasgeData mgData = excelDr.GetData(); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Tel1", SqlDbType.NVarChar, 50), new SqlParameter("@Tel2", SqlDbType.NVarChar, 50), new SqlParameter("@Znum", SqlDbType.NVarChar, 50), new SqlParameter("@Yjrs", SqlDbType.NVarChar, 50), new SqlParameter("@Bank", SqlDbType.NVarChar, 50), new SqlParameter("@Meeting", SqlDbType.NVarChar, 50) }; if (mgData.Mgdatacount > 0) { //DataTable dt1 = DataZDataActionDataTable(mgData.Mgdata, "yearMonth,userid", 0, mgData.Mgdatacount - 1, true, true, true, true, true); DataTable dt1 = Kain_class.HtmlSubstring.SubstringFunction.DataZDataActionDataTable(mgData.Mgdata, 1, mgData.Mgdatacount - 1, true, true, true, true, true); DataColumn priceColumn = new DataColumn(); priceColumn.DataType = System.Type.GetType("System.Decimal"); //该列的数据类型 priceColumn.ColumnName = "Meeting"; //该列得名称 priceColumn.DefaultValue = meeting; //该列得默认值 dt1.Columns.Add(priceColumn); mgInfor = Datafun.DataUpdate(dt1, "insert into tb_InsertMeeting(UserName,Tel1,Tel2,Znum,Yjrs,Bank,Meeting)values(@UserName,@Tel1,@Tel2,@Znum,@Yjrs,@Bank,@Meeting)", parameters); } else { mgInfor.Mgcontent = mgData.Mgcontent; } return(mgInfor.Mgbool); }
/// <summary> /// 新增嘉宾 /// </summary> /// <returns></returns> public string AddGuestAjax() { string gift = Request["va1"]; string tel = Request["va2"]; string UserName = Request["va3"]; string sjrs = Request["va4"]; string bank = Request["va5"]; string meeting = LgUser.Meetting; string IsSuccess = "1"; SqlParameter[] pms = { new SqlParameter("@gift", gift), new SqlParameter("@tel", tel), new SqlParameter("@UserName", UserName), new SqlParameter("@sjrs", sjrs), new SqlParameter("@bank", bank), new SqlParameter("@meeting", meeting) }; MessasgeData mgdata = Datafun.MgfunctionData("bs_AddGuest_poc", pms, "poc"); if (mgdata.Mgdatacount > 0) { DataRow dr = mgdata.Mgdata.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["Tel1"].ToString(), Meetting = dr["Meeting"].ToString() }; Session["Lguser"] = lguser; IsSuccess = "0"; } else { IsSuccess = "1"; } return(IsSuccess); }
public ActionResult GetMeetingFen() { string ReturnValue = string.Empty; string sql = ""; if (LgUser.Meetting == "") { sql = "select id,MeetingName from tb_Meeting where isdel=0"; } else { sql = "select id,MeetingName from tb_Meeting where isdel=0 and id=@id"; } MessasgeData mgdata = Datafun.MgfunctionData(sql, new SqlParameter("@id", LgUser.Meetting)); ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"'); return(ContentJson(ReturnValue)); }
/// <summary> /// 已经签到 /// </summary> /// <returns></returns> public ActionResult SignOver(string id) { SqlParameter[] pms = { new SqlParameter("@meeting", LgUser.Meetting), new SqlParameter("@tel", id) }; MessasgeData mgdata = Datafun.MgfunctionData(" select qdh,znum,UserName,Bank,Meeting,id,sjrs from tb_InsertMeeting where meeting=@meeting and (Tel1=@tel or Tel2=@tel)", pms); if (mgdata.Mgdatacount > 0) { ViewBag.UserName = mgdata.Mgdata.Rows[0]["UserName"]; ViewBag.qdh = mgdata.Mgdata.Rows[0]["qdh"]; ViewBag.sjrs = mgdata.Mgdata.Rows[0]["sjrs"]; ViewBag.Meeting = mgdata.Mgdata.Rows[0]["Meeting"]; } ViewBag.tel = LgUser.Tel; return(View()); }
/// <summary> /// 电话获取名称 /// </summary> /// <returns></returns> public string TelGameAjax() { string ids = Request["va1"]; string tel = Request["va2"]; string IsSuccess = ""; SqlParameter[] pms = { new SqlParameter("@Meeting", ids), new SqlParameter("@Tel", tel) }; MessasgeData mgdata = Datafun.MgfunctionData("select UserName from tb_InsertMeeting where Meeting=@Meeting and (Tel1=@Tel or Tel2=@Tel) ", pms); if (mgdata.Mgdatacount > 0) { IsSuccess = mgdata.Mgdata.Rows[0][0].ToString(); } return(IsSuccess); }
/// <summary> /// 签到后赠送礼物 /// </summary> /// <returns></returns> public ActionResult Signgift(string id, string ids) { SqlParameter[] pms = { new SqlParameter("@meeting", LgUser.Meetting), new SqlParameter("@tel", id) }; MessasgeData mgdata = Datafun.MgfunctionData(" select qdh,znum,UserName,Bank,Meeting,id,sjrs from tb_InsertMeeting where meeting=@meeting and (Tel1=@tel or Tel2=@tel)", pms); if (LgUser != null) { ViewBag.qdh = mgdata.Mgdata.Rows[0]["qdh"]; ViewBag.znum = mgdata.Mgdata.Rows[0]["znum"]; ViewBag.name = mgdata.Mgdata.Rows[0]["UserName"]; } ViewBag.tel = id; ViewBag.ids = ids; return(View()); }
/// <summary> /// 选桌子 /// </summary> /// <returns></returns> public string deskAjax() { string tel = Request["va1"]; string znum = Request["va2"]; string meeting = LgUser.Meetting; string IsSuccess = "1"; SqlParameter[] pms = { new SqlParameter("@tel", tel), new SqlParameter("@znum", znum), new SqlParameter("@meeting", meeting), }; MessasgeData mgdata = Datafun.MgfunctionData("bs_xuanzhuo_poc", pms, "poc"); IsSuccess = mgdata.Mgdata.Rows[0][0].ToString(); return(IsSuccess); }
/// <summary> /// 验证会议是否存在 /// </summary> /// <returns></returns> public string Ymeeting() { string MeetingName = Request["va1"]; string IsSuccess = "1"; SqlParameter[] pms = { new SqlParameter("@MeetingName", MeetingName) }; MessasgeData mgdata = Datafun.MgfunctionData("select * from tb_Meeting where MeetingName=@MeetingName", pms); if (mgdata.Mgdatacount > 0) { IsSuccess = "0"; } else { IsSuccess = "1"; } return(IsSuccess); }
/// <summary> /// 录入礼物红包 /// </summary> /// <returns></returns> public string AddCashAjax() { string qdh = Request["va1"]; string Meeting = LgUser.Meetting; string Hongbao = Request["va3"]; string Gift = Request["va4"]; string IsSuccess = "1"; SqlParameter[] pms = { new SqlParameter("@Qdh", qdh), new SqlParameter("@Meeting", Meeting), new SqlParameter("@Hongbao", Hongbao), new SqlParameter("@Gift", Gift) }; MessasgeData mgdata = Datafun.MgfunctionData("bs_Gift_poc", pms, "poc"); IsSuccess = mgdata.Mgdata.Rows[0][0].ToString(); return(IsSuccess); }
/// <summary> /// 礼物详情单 /// </summary> /// <returns></returns> public ActionResult GiftInfor(string id) { MessasgeData mgdata = Datafun.MgfunctionData("select a.id,UserName,Tel,Qdh,Hongbao,Gift,b.MeetingName from tb_gift A left join tb_Meeting b on a.Meeting=b.id where a.isdel=0 and Meeting=@id", new SqlParameter("@id", id)); List <tb_gift> listorder = new List <tb_gift>(); foreach (DataRow dr in mgdata.Mgdata.Rows) { tb_gift cbai = new tb_gift { id = Convert.ToInt32(dr["id"].ToString()), UserName = dr["UserName"].ToString(), Tel = dr["Tel"].ToString(), Qdh = dr["Qdh"].ToString(), Hongbao = dr["Hongbao"].ToString(), Gift = dr["Gift"].ToString(), Added1 = dr["MeetingName"].ToString() }; listorder.Add(cbai); } ; return(View(listorder)); }