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