/// <summary> /// 更新队伍线路 /// </summary> /// <param name="ent"></param> /// <returns></returns> public int AssignsTeams(List <AssignsTeam> AssignsTeam) { int ret = -1; try { using (var db = new BFdbContext()) { for (int i = 0; i < AssignsTeam.Count; i++) { tblteams ent = GetTeamById(AssignsTeam[i].teamid); ent.Linesid = AssignsTeam[i].linesid; db.TUpdate <tblteams>(ent); } db.SaveChanges(); } ret = 0; } catch { ret = 99; } return(ret); }
/// <summary> /// 注册队伍 /// </summary> /// <param name="id"></param> /// <param name="tid"></param> /// <param name="tname"></param> /// <param name="tcom"></param> /// <returns></returns> public int RegTname(string id, string tid, string tname, string tcom, string pwd) { using (var db = new BFdbContext()) { if (db.tblteams.Any(p => p.match_id == tid && p.Teamname == tname)) { return(-1); } int uid = int.Parse(id); var usr = db.tblusers.FirstOrDefault(p => p.userid == uid.ToString()); if (usr != null) { usr.Passwd = pwd; db.Update <tblusers>(usr); } tblteams tm = new tblteams(); //tm.Company = string.IsNullOrEmpty(tcom) ? "个人" : tcom; tm.Createtime = DateTime.Now; tm.Eventid = 1; tm.Lineid = ""; tm.match_id = tid; tm.Status = 6; tm.Teamname = tname; tm.Teamno = ""; tm.Userid = id; db.Insert <tblteams>(tm); return(db.SqlQuery <autoid>("select @@identity as id").FirstOrDefault().Id); } }
/// <summary> /// 更新队伍 /// </summary> /// <param name="ent"></param> /// <returns></returns> public int EditTeam(tblteams ent) { using (var db = new BFdbContext()) { return(db.Update <tblteams>(ent)); } }
/// <summary> /// 删除队伍 /// </summary> /// <param name="ids"></param> /// <returns></returns> public int DeleteTeam(List <string> ids) { using (var db = new BFdbContext()) { int res = 0; using (var tx = db.BeginTransaction()) { try { foreach (string id in ids) { tblteams ent = db.tblteams.FirstOrDefault(p => p.teamid == id); ent.Status = 2; db.TUpdate <tblteams>(ent); } db.SaveChanges(); tx.Commit(); } catch (Exception ex) { tx.Rollback(); throw ex; } } return(res); } }
public int TeamDis(TeamDisEntiyList r) { using (var db = new BFdbContext()) { int res = -1; using (var tx = db.BeginTransaction()) { try { for (int i = 0; i < r.teams.Count; i++) { string id = r.teams[i].teamid; tblteams team = db.tblteams.FirstOrDefault(p => p.teamid == id); team.Lineid = r.lineid; team.Linesid = r.linesid; team.Teamno = r.teams[i].Teamno.PadLeft(5, '0'); db.TUpdate <tblteams>(team); //BuildSerial1(id,team.Teamno); } db.SaveChanges(); tx.Commit(); res = 0; } catch (Exception ex) { tx.Rollback(); throw ex; } } return(res); } }
public ActionResult Create(FormCollection fc) { var model = new tblteams(); model.teamid = Guid.NewGuid().ToString(); model.Teamname = fc["Teamname"].ToString(); model.Userid = fc["Userid"]; model.Company = fc["optCompany"].ToString(); model.Lineid = fc["optLine"].ToString(); model.Createtime = DateTime.Now; model.Status = Int32.Parse(fc["optStatus"].ToString()); var bll = new TeamBll(); try { bll.AddTeam(model); } catch (ValidException ex) { this.ModelState.AddModelError(ex.Name, ex.Message); return(View(model)); } return(this.RefreshParent()); }
public JsonResult changeteam(tblteams tm) { if (UserInfo == null) { return(RepReurnError("请登录系统")); } MembershipBll bll = new MembershipBll(); int res = bll.changeteam(tm); if (res >= 0) { return(RepReurnOK()); } else if (res == -1) { return(RepReurnError("队伍不存在")); } else if (res == -2) { return(RepReurnError("报名已经完成,不能修改")); } else if (res == -3) { return(RepReurnError("队伍名称重复,不能修改")); } else { return(RepReurnError("操作中出现错误")); } }
public int changeteam(tblteams tm) { using (var db = new BFdbContext()) { var team = db.tblteams.FirstOrDefault(p => p.teamid == tm.teamid); if (team == null) { return(-1); } if (team.Status.Value == 0) { return(-2); } if (db.tblteams.Any(p => p.teamid != tm.teamid && p.match_id == team.match_id && p.Teamname == tm.Teamname)) { return(-3); } string sql = string.Format("update tbl_match_users set teamname='{0}' where teamid='{1}'", tm.Teamname, tm.teamid); db.ExecuteSqlCommand(sql); team.Teamname = tm.Teamname; return(db.Update <tblteams>(team)); } }
/// <summary> /// 新增队伍 /// </summary> /// <param name="ent"></param> /// <returns></returns> public int AddTeam(tblteams ent) { using (var db = new BFdbContext()) { if (db.tblteams.Any(u => u.Teamname == ent.Teamname)) { throw new ValidException("Mobile", "此队伍名称已经存在!"); } return(db.Insert <tblteams>(ent)); } }
/// <summary> /// 更新队伍 /// </summary> /// <param name="ent"></param> /// <returns></returns> public int EditTeam(tblteams ent) { using (var db = new BFdbContext()) { tblteams team = db.tblteams.FirstOrDefault(p => p.teamid == ent.teamid); team.Userid = ent.Userid; team.Company = ent.Company; team.Lineid = ent.Lineid; team.Status = ent.Status; return(db.Update <tblteams>(team)); } }
public JsonResult ImpTeams(string matchid) { try { DataTable data = NpoiHelper.XlSToDataTable(@"C:\Work\Vki\MyDoc\MyFile\dx_dev\定向赛团体报名统计表.xlsx", "test", 0); if (data == null || data.Rows.Count < 1) { return(RepReurnError("上传的文件中没有数据")); } StringBuilder sbtError = new StringBuilder(); List <tblusers> lstUsers = new List <tblusers>(); List <tblteams> lstTeams = new List <tblteams>(); List <tblmatchusers> lstMatchusers = new List <tblmatchusers>(); int sn = 0; string lineid = ""; string teamno = ""; string teamname = ""; string company = ""; foreach (DataRow row in data.Rows) { //记录序号,以标记团队 if (!string.IsNullOrEmpty(row["序号"].ToString().Trim())) { sn = int.Parse(row["序号"].ToString().Trim()); } if (!string.IsNullOrEmpty(row["线路号"].ToString().Trim())) { lineid = row["线路号"].ToString().Trim(); } if (!string.IsNullOrEmpty(row["队列号"].ToString().Trim())) { teamno = row["队列号"].ToString().Trim(); } if (!string.IsNullOrEmpty(row["队名(6个字符以内)"].ToString().Trim())) { teamname = row["队名(6个字符以内)"].ToString().Trim(); } if (!string.IsNullOrEmpty(row["公司名称"].ToString().Trim())) { company = row["公司名称"].ToString().Trim(); } if (string.IsNullOrEmpty(row["队员编号"].ToString().Trim())) { continue; } if (string.IsNullOrEmpty(row["性别"].ToString().Trim())) { sbtError.Append("[性别]不能为空;"); } if (string.IsNullOrEmpty(row["身份证/护照"].ToString().Trim())) { sbtError.Append("[身份证/护照]不能为空;"); } if (!System.Text.RegularExpressions.Regex.IsMatch(row["手机号"].ToString().Trim(), @"^[1]+[0-9]+\d{9}")) { sbtError.AppendFormat("[手机号:{0}]格式错误;", row["手机号"]); } tblusers usr = new tblusers(); usr.cardtype = "1"; usr.Mobile = row["手机号"].ToString().Trim(); usr.sexy = row["性别"].ToString().Trim() == "男" ? "1" : "0"; usr.Status = 1; usr.userid = Guid.NewGuid().ToString(); lstUsers.Add(usr); tblteams tm = new tblteams(); tm.teamid = Guid.NewGuid().ToString(); tm.Company = ""; tm.Createtime = DateTime.Now; tm.Eventid = 1; tm.Lineid = lineid; tm.match_id = matchid; tm.Status = 1; tm.Teamname = teamname; tm.Teamno = teamno; //tm.Userid lstTeams.Add(tm); } } catch (Exception ex) { ILog log = LogManager.GetLogger(this.GetType()); log.Error(ex); return(RepReurnError("导入过程中出现错误")); } return(RepReurnOK()); }