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 string SetGameAjax()
{
string Meeting = LgUser.Meetting;
string Start_Date = Request["va2"];
string End_Date = Request["va3"];
string IsSuccess = "1";
SqlParameter[] pms =
{
new SqlParameter("@Meeting", Meeting),
new SqlParameter("@Start_Date", Start_Date),
new SqlParameter("@End_Date", End_Date),
};
MessasgeInfor mginfor = Datafun.Mgfunctioninfor(@"if not exists(select * from tb_GameSet where Meeting=@Meeting and isdel=0) begin insert into tb_GameSet (Meeting,Start_Date,End_Date)
values(@Meeting,@Start_Date,@End_Date) end", pms);
if (mginfor.Mgdatacount > 0)
{
IsSuccess = "0";
}
else
{
IsSuccess = "1";
}
return(IsSuccess);
}
/// <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());
}
/// <summary>
/// 保存点击数据
/// </summary>
/// <returns></returns>
public string ClicksAjax()
{
string IsSuccess = "1";
if (LgGameUser == null)
{
return(IsSuccess = "1");
}
string nums = Request["va1"];
SqlParameter[] pms =
{
new SqlParameter("@nums", nums),
new SqlParameter("@Meeting", LgGameUser.Meeting),
new SqlParameter("@Tel", LgGameUser.Tel),
new SqlParameter("@UserName", LgGameUser.UserName)
};
MessasgeInfor mginfor = Datafun.Mgfunctioninfor("insert into tb_clicks(Nums,Meeting,Tel,LoginName)values(@nums,@Meeting,@Tel,@UserName)", pms);
if (mginfor.Mgdatacount > 0)
{
IsSuccess = "0";
}
return(IsSuccess);
}
/// <summary>
/// 录入参会人员
/// </summary>
/// <returns></returns>
public string AddchAjax()
{
string UserName = Request["va1"];
string tel1 = Request["va2"];
string tel2 = Request["va3"];
string znum = Request["va4"];
string yjrs = Request["va5"];
string Bank = Request["va6"];
string Meeting = LgUser.Meetting;
string IsSuccess = "1";
SqlParameter[] pms =
{
new SqlParameter("@Meeting", Meeting),
new SqlParameter("@UserName", UserName),
new SqlParameter("@Tel1", tel1),
new SqlParameter("@Tel2", tel2),
new SqlParameter("@znum", znum),
new SqlParameter("@yjrs", yjrs),
new SqlParameter("@Bank", Bank)
};
MessasgeInfor mginfor = Datafun.Mgfunctioninfor("insert into tb_InsertMeeting(UserName,Tel1,Tel2,znum,yjrs,Bank,Meeting)values(@UserName,@Tel1,@Tel2,@znum,@yjrs,@Bank,@Meeting)", pms);
if (mginfor.Mgdatacount > 0)
{
IsSuccess = "0";
}
else
{
IsSuccess = "1";
}
return(IsSuccess);
}
/// <summary>
/// 填写用户信息
/// </summary>
/// <returns></returns>
public string UserInforGameAjax()
{
string ids = Request["va1"];
string tel = Request["va2"];
string name = Request["va3"];
string IsSuccess = "1";
SqlParameter[] pms =
{
new SqlParameter("@Meeting", ids),
new SqlParameter("@UserName", name),
new SqlParameter("@Tel", tel)
};
MessasgeInfor mginfor = Datafun.Mgfunctioninfor(@" if not exists(select * from tb_logingame where Meeting=@Meeting and Tel=@Tel ) begin insert into tb_logingame(UserName,Tel,Meeting)values(@UserName,@Tel,@Meeting) end ", pms);
LoginGameUser lguser = new LoginGameUser
{
UserName = name,
Meeting = ids,
Tel = tel
};
Session["LgGameuser"] = lguser;
IsSuccess = "0";
return(IsSuccess);
}
/// <summary>
/// 填写评论
/// </summary>
/// <returns></returns>
public string CommentAjax()
{
string IsSuccess = "1";
if (LgGameUser == null)
{
return(IsSuccess = "1");
}
string Comment = Request["va1"];
SqlParameter[] pms =
{
new SqlParameter("@Comment", Comment),
new SqlParameter("@Meeting", LgGameUser.Meeting),
new SqlParameter("@Tel", LgGameUser.Tel)
};
MessasgeInfor mginfor = Datafun.Mgfunctioninfor("insert into tb_Comment(Comment,Meeting,Tel)values(@Comment,@Meeting,@Tel)", pms);
if (mginfor.Mgdatacount > 0)
{
IsSuccess = "0";
}
return(IsSuccess);
}
/// <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);
}
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>
/// 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());
}
/// <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));
}
/// <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>
/// 赠送礼物
/// </summary>
/// <returns></returns>
public string AddGiftAjax()
{
string gift = Request["va1"];
string tel = Request["va3"];
string IsSuccess = "1";
SqlParameter[] pms =
{
new SqlParameter("@gift", gift),
new SqlParameter("@meeting", LgUser.Meetting),
new SqlParameter("@tel", tel)
};
MessasgeInfor mginfor = Datafun.Mgfunctioninfor(" update tb_InsertMeeting set gift=@gift where meeting=@meeting and(Tel1=@tel or Tel2=@tel)", pms);
if (mginfor.Mgdatacount > 0)
{
IsSuccess = "0";
}
else
{
IsSuccess = "1";
}
return(IsSuccess);
}
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 UpdatePassWordAjax()
{
string UserID = LgUser.UserId;
string password = Request["va1"];
string IsSuccess = "1";
SqlParameter[] pms =
{
new SqlParameter("@UserID", UserID),
new SqlParameter("@password", Passwd.SetPass(password))
};
MessasgeInfor mginfor = Datafun.Mgfunctioninfor(@"update tb_login set Password=@password where id=@UserID", pms);
if (mginfor.Mgdatacount > 0)
{
IsSuccess = "0";
}
else
{
IsSuccess = "1";
}
return(IsSuccess);
}
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));
}
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));
}
/// <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 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 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 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 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 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 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 string AddChoujiangAjax()
{
string ids = Request["va1"];
string jx = Request["va2"];
string[] id = ids.Split(',');
string IsSuccess = "0";
foreach (string mt in id)
{
MessasgeInfor mginfor = Datafun.Mgfunctioninfor(@"update tb_InsertMeeting set jx=" + jx + " where id=" + mt + "");
}
return(IsSuccess);
}
/// <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 EndClick()
{
string Meeting = LgUser.Meetting;
string IsSuccess = "0";
MessasgeInfor mginfor = Datafun.Mgfunctioninfor(@"update tb_GameSet set status=0 where Meeting=@Meeting", new SqlParameter("@Meeting", Meeting));
if (mginfor.Mgdatacount > 0)
{
IsSuccess = "0";
}
else
{
IsSuccess = "1";
}
return(IsSuccess);
}
