public void InitPage(List <Dal.Models.Expert> lstExpert = null)
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
if (!IsPostBack)
{
List <SysConstant> userStatus = BLL.SysConstant.GetConstantList("07", conn);
ddlStatus.DataSource = userStatus;
ddlStatus.DataTextField = "ConstantValue";
ddlStatus.DataValueField = "ConstantCode";
ddlStatus.DataBind();
}
if (lstExpert == null)
{
try
{
lstExpert = BLL.Expert.GetExpertList(conn, user);
}
catch
{
lstExpert = null;
}
}
conn.Close();
}
//初始化上级专家组下拉列表
public void InitParentGroup(int specialtyID)
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
OleDbTransaction tran = conn.BeginTransaction();
Dal.Models.UserInfo userinfo = (Dal.Models.UserInfo)Session["UserInfo"];
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn, tran);
if (activity == null)
{
Response.Redirect("../Mutual/HomePage.aspx");
return;
}
//string SpecialtyIDs = BLL.Specialty.GetSpecialtyByUserType(activity.ActivityID.Value, userinfo.UserID.Value, conn, tran);
List <Dal.Models.ExpertGroup> profession = BLL.ExpertGroup.GetGroupList(activity.ActivityID.Value, specialtyID.ToString(), conn, tran);
ddlParentGroup.DataSource = profession;
ddlParentGroup.DataTextField = "GroupName";
ddlParentGroup.DataValueField = "GroupID";
ddlParentGroup.DataBind();
ddlParentGroup.Items.Remove(ddlParentGroup.Items.FindByText(txtExpertGroupName.Text));
}
public void GetRevoteGroupViews(HttpContext context, OleDbConnection conn)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpertByUserID(user.UserID.Value, conn);
int iPrizeID = 0;
if (!Int32.TryParse(context.Request["PrizeID"], out iPrizeID))
{
context.Response.Write("暂无奖项!");
return;
}
Dal.Models.Prize prize = BLL.Prize.GetPrize(iPrizeID, conn);
if (prize == null)
{
context.Response.Write("暂无奖项!");
return;
}
var groupViews = BuildRevoteGroupViews(prize, expert, conn);
context.Response.Write(JsonConvert.SerializeObject(groupViews.ToArray()));
}
public void GetExpertRevotePrizeList(HttpContext context, OleDbConnection conn)
{
string specialtys = context.Request["Specialtys"];
string prizeType = context.Request["PrizeType"];
string prizeName = context.Request["PrizeName"];
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Activity activity = BLL.Activity.GetActivity(context.Session["ActivityType"].ToString(), conn);
if (activity == null)
{
context.Response.Write("活动未开始！");
}
List <Dal.Models.RevotePrize> lstPrize = null;
if (user.UserType == "0801" || user.UserType == "0802" || user.UserType == "0803")
{
//lstPrize = BLL.Prize.GetPrizeList(specialtys, prizeType, prizeName, conn);
}
else if (user.UserType == "0805")
{
// 专家所评审的项目对应的奖项
BLL.Revote bllRevote = new BLL.Revote();
lstPrize = bllRevote.GetExpertRevotePrize(user.UserID.Value, activity.ActivityID.Value, conn);
}
int iPageSize = 10;
if (!Int32.TryParse(context.Request["PageSize"] ?? "50", out iPageSize))
{
iPageSize = 10;
}
int iCuttentPage = 1;
if (!Int32.TryParse(context.Request["CuttentPage"] ?? "0", out iCuttentPage))
{
iCuttentPage = 1;
}
int iRecordNumber = lstPrize.Count;
int iPagesCount = Convert.ToInt32(Math.Ceiling((float)iRecordNumber / (float)iPageSize));
lstPrize = lstPrize.Skip(iPageSize * (iCuttentPage - 1)).Take(iPageSize).ToList();
Dal.Models.PageInfo <Dal.Models.Declaration> pgif = new Dal.Models.PageInfo <Dal.Models.Declaration>();
pgif.CuttentPage = iCuttentPage;
pgif.PerPage = iPageSize;
pgif.RecordNumber = iRecordNumber;
pgif.PagesCount = iPagesCount;
pgif.Table = Dal.DataTableExtensions.ToDataTable(lstPrize);
string strJson = JsonConvert.SerializeObject(pgif);
context.Response.Write(strJson);
conn.Close();
}
public void GetMenu(HttpContext context, OleDbConnection conn)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
StringBuilder sbMenu = new StringBuilder();
List <Dal.Models.SysMenu> lstMenu = BLL.SysMenu.GetMenu(user.UserID.Value, conn);
context.Response.Write(JsonConvert.SerializeObject(lstMenu));
}
public void GetUser(HttpContext context, OleDbConnection conn)
{
Dal.Models.UserInfo user = null;
int iUserID = 0;
int.TryParse(context.Request["UserID"] ?? "0", out iUserID);
user = BLL.User.GetUserInfo(iUserID, conn);
context.Response.Write(JsonConvert.SerializeObject(user));
}
private void RevotingVote(HttpContext context, OleDbConnection conn)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpertByUserID(user.UserID.Value, conn);
OleDbTransaction tran = conn.BeginTransaction();
try
{
int declarationId = 0;
int revoteGroupId = 0;
int recommended = 0;
int notRecommened = 0;
int prizeId = 0;
if (!int.TryParse(context.Request["DeclarationID"], out declarationId) ||
!int.TryParse(context.Request["RevoteGroupId"], out revoteGroupId) ||
!int.TryParse(context.Request["RevoteRecommended"], out recommended) ||
!int.TryParse(context.Request["NotRevoteRecommended"], out notRecommened) ||
!int.TryParse(context.Request["PrizeId"], out prizeId))
{
throw new Exception("参数错误！");
}
Dal.Models.Prize prize = BLL.Prize.GetPrize(prizeId, conn, tran);
if (prize == null || prize.IsStopVote)
{
throw new Exception("当前奖项及轮次已结束投票。");
}
Revote revote = new Revote();
bool saved = revote.SaveRevotingVote(revoteGroupId, declarationId, recommended, notRecommened, expert.UserID.Value,
conn, tran);
if (saved)
{
tran.Commit();
var revoteGroups = this.BuildRevoteGroupViews(prize, expert, conn);
string message = "投票成功!";
var result = new { Views = revoteGroups, Message = message };
context.Response.Write(JsonConvert.SerializeObject(result));
}
else
{
tran.Rollback();
context.Response.Write(JsonConvert.SerializeObject(new { Message = "投票错误" }));
}
}
catch (Exception ex)
{
tran.Rollback();
context.Response.Write(JsonConvert.SerializeObject(new { Message = ex.Message }));
}
}
protected void Page_Load(object sender, EventArgs e)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
if (user == null)
{
Response.Redirect("../Mutual/UserEntry.aspx");
}
if (!IsPostBack)
{
InitPage();
}
}
protected void lkbExport_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
string strQuery = txtQueryString.Text;
string strQueryStatus = hfStatus.Value;
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
DataTable dtExpert = Dal.DataTableExtensions.ToDataTable(BLL.Expert.GetExpertList(conn, user, strQuery, strQueryStatus));
ExportExpert(dtExpert);
conn.Close();
conn.Dispose();
}
protected void btnCheckedExpert_Click(object sender, EventArgs e)
{
string expertIDs = checkedExpertID.Value;
expertIDs = expertIDs.Substring(0, expertIDs.Length - 1);
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
string strQueryStatus = hfStatus.Value;
DataTable dtExpert = Dal.DataTableExtensions.ToDataTable(BLL.Expert.GetExpertList(conn, user, null, strQueryStatus, expertIDs));
ExportExpert(dtExpert);
conn.Close();
conn.Dispose();
}
protected void btnCreateUser_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
// 获取当前活动
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn);
if (activity == null)
{
Response.Redirect("../Mutual/HomePage.aspx");
return;
}
OleDbTransaction tran = conn.BeginTransaction();
Dal.Models.Expert expert = new Dal.Models.Expert();
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
expert.ExpertName = txtExpertName.Text;
expert.AcademicTitle = txtAcademicTitle.Text;
expert.Profession = txtProfession.Text;
expert.Workplace = txtWorkplace.Text;
expert.IDType = rbtnIDType.SelectedValue;
expert.IDNumber = txtIDNumber.Text;
expert.Gender = ddlGender.SelectedValue;
expert.Email = txtEmail.Text;
expert.SpecialtyIDs = checkeds.Value;
//string strDefaultPassword = System.Configuration.ConfigurationManager.AppSettings["DefaultPassword"];
string strDefaultPassword = BLL.SysConstant.GetAppSettings("DefaultPassword", conn, tran);
try
{
BLL.Expert.CreateExpert(expert, strDefaultPassword, user.UserID.Value, conn, tran);
BLL.User.SetUserSpecialty(expert.UserID.Value, activity.ActivityID.Value, expert.SpecialtyIDs, conn, tran);
tran.Commit();
hdMsg.Value = "添加成功!";
conn.Close();
}
catch (Exception ex)
{
tran.Rollback();
conn.Close();
hdMsg.Value = ex.Message;
return;
}
}
public void SubmitVote(HttpContext context, OleDbConnection conn)
{
int iPrizeID = 0;
Int32.TryParse(context.Request["PrizeID"], out iPrizeID);
Dal.Models.Prize prize = BLL.Prize.GetPrize(iPrizeID, conn);
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpertByUserID(user.UserID.Value, conn);
if (prize == null || prize.IsStopVote)
{
context.Response.Write("当前奖项及轮次已结束投票。");
return;
}
OleDbTransaction tran = conn.BeginTransaction();
try
{
//根据专家和奖项获评奖项目
List <Dal.Models.Vote> lstVote = BLL.Vote.GetVoteDeclarationList(expert, prize, conn, tran);
//获取每个奖项的已评奖数量
Dictionary <string, int> dicVote = new Dictionary <string, int>();
//获取每个奖项未评奖数量
Dictionary <string, int> dicRemain = new Dictionary <string, int>();
GetLimit(prize, lstVote, ref dicVote, ref dicRemain);
if (dicVote["Voted"] < lstVote.Count)
{
throw new Exception("尚未完成投票,提交失败!");
}
BLL.Vote.SubmitVote(expert, prize, conn, tran);
tran.Commit();
context.Response.Write("提交成功!");
}
catch (Exception ex)
{
tran.Rollback();
context.Response.Write(ex.Message);
}
}
public void GetExpertVoteList(HttpContext context, OleDbConnection conn)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpertByUserID(user.UserID.Value, conn);
int iPrizeID = 0;
if (!Int32.TryParse(context.Request["PrizeID"], out iPrizeID))
{
context.Response.Write("暂无奖项!");
return;
}
Dal.Models.Prize prize = BLL.Prize.GetPrize(iPrizeID, conn);
if (prize == null)
{
context.Response.Write("暂无奖项!");
return;
}
Dal.Models.Schedule schedule = BLL.Schedule.GetSpecialtySchedule(prize.SpecialtyID.Value, conn);
if (schedule.IsVoteStart == false)
{
context.Response.Write("投票未开始或已经结束!");
}
else
{
//根据专家和奖项获评奖项目
List <Dal.Models.Vote> lstVote = BLL.Vote.GetVoteDeclarationList(expert, prize, conn);
lstVote = lstVote.OrderBy(d => d.BigOrdinal).ToList();
//获取每个奖项的已评奖数量
Dictionary <string, int> dicVote = new Dictionary <string, int>();
//获取每个奖项未评奖数量
Dictionary <string, int> dicRemain = new Dictionary <string, int>();
GetLimit(prize, lstVote, ref dicVote, ref dicRemain);
object[] obj = { prize, lstVote, dicVote, dicRemain };
context.Response.Write(JsonConvert.SerializeObject(obj));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserInfo"] == null)
{
Response.Redirect("../Mutual/UserEntry.aspx");
}
if (!IsPostBack)
{
InitSpecialty();
int userId = Request.QueryString["id"] == null ? 0 : Convert.ToInt32(Request.QueryString["id"]);
hdUserID.Value = userId.ToString();
string type = Request.QueryString["operateType"] == null ? "" : Request.QueryString["operateType"].ToString();
if (type == "update")
{
Dal.Models.UserInfo userLogin = (Dal.Models.UserInfo)Session["UserInfo"];
if (userLogin.UserID.Value == userId)
{
hdIsSelf.Value = "true";
}
operateType.Value = type;
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
UserInfo user = BLL.User.GetUserInfo(userId, conn);
//List<UserSpecialty> userSp = BLL.User.GetUserSpecialtyList(userId, conn);
checkeds.Value = BLL.User.GetUserSpecialtyIDs(userId, conn);
conn.Close();
txtUserName.Value = user.UserName;
txtEmail.Value = user.Email;
//string temp = "";
//if (userSp.Count > 0)
//{
// for (int i = 0; i < userSp.Count; i++)
// {
// temp += userSp[i].SpecialtyID.Value.ToString() + ",";
// }
// checkeds.Value = temp.Substring(0, temp.Length - 1);
//}
InitSpecialtyList();
}
}
}
public void SubmitRevotingVote(HttpContext context, OleDbConnection conn)
{
int iPrizeID = 0;
Int32.TryParse(context.Request["PrizeID"], out iPrizeID);
Dal.Models.Prize prize = BLL.Prize.GetPrize(iPrizeID, conn);
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpertByUserID(user.UserID.Value, conn);
if (prize == null || prize.IsStopVote)
{
context.Response.Write("当前奖项及轮次已结束投票。");
return;
}
OleDbTransaction tran = conn.BeginTransaction();
try
{
BLL.Revote revote = new Revote();
RevotePrize last = revote.GetLastRevotePrize(prize, conn, tran);
bool saved = revote.SubmitRevotingVote(expert.UserID.Value, last.RevotePrizeId, conn, tran);
if (saved)
{
tran.Commit();
context.Response.Write("提交成功!");
}
else
{
tran.Commit();
context.Response.Write("提交错误!");
}
}
catch (Exception ex)
{
tran.Rollback();
context.Response.Write(ex.Message);
}
}
public void InitSpecialtyList()
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
Dal.Models.UserInfo user = ((Dal.Models.UserInfo)Session["UserInfo"]);
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn);
if (activity == null)
{
Response.Redirect("../Mutual/HomePage.aspx");
return;
}
listSpecialty.DataSource = BLL.Specialty.GetSpecialtyListByUserType(activity.ActivityID.Value, user.UserType, user.UserID.Value, true, conn);
listSpecialty.DataTextField = "SpecialtyName";
listSpecialty.DataValueField = "SpecialtyID";
listSpecialty.DataBind();
conn.Close();
}
//初始化加载专业下拉列表
public void InitDdlProfession()
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
Dal.Models.UserInfo userinfo = (Dal.Models.UserInfo)Session["UserInfo"];
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn);
if (activity == null)
{
Response.Redirect("../Mutual/HomePage.aspx");
return;
}
OleDbTransaction tran = conn.BeginTransaction();
List <Specialty> profession = BLL.Specialty.GetSpecialtyListByUserType(activity.ActivityID.Value, userinfo.UserType, userinfo.UserID.Value, false, conn, tran);//BLL.Specialty.GetSpecialtyList(activity.ActivityID.ToString(),conn, tran);
ddlSpecialty.DataSource = profession;
ddlSpecialty.DataTextField = "SpecialtyName";
ddlSpecialty.DataValueField = "SpecialtyID";
ddlSpecialty.DataBind();
}
private void BatchRevotingVote(HttpContext context, OleDbConnection conn)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpertByUserID(user.UserID.Value, conn);
int prizeId = 0;
int recommended, notRecommended;
int.TryParse(context.Request["PrizeID"], out prizeId);
int.TryParse(context.Request["Recommended"], out recommended);
int.TryParse(context.Request["NotRecommended"], out notRecommended);
Dal.Models.Prize prize = BLL.Prize.GetPrize(prizeId, conn);
if (prize == null || prize.IsStopVote)
{
context.Response.Write("当前奖项及轮次已结束投票。");
return;
}
BLL.Revote revote = new Revote();
RevotePrize revotePrize = revote.GetLastRevotePrize(prize, conn);
OleDbTransaction tran = conn.BeginTransaction();
try
{
bool saved = revote.SaveBatchRevotingVotes(revotePrize.RevotePrizeId, expert.UserID.Value, recommended, notRecommended, conn, tran);
tran.Commit();
context.Response.Write(JsonConvert.SerializeObject("投票成功!"));
}
catch (Exception ex)
{
tran.Rollback();
context.Response.Write(JsonConvert.SerializeObject(ex.Message));
}
}
public void InitPage()
{
Dal.Models.UserInfo userinfo = (Dal.Models.UserInfo)Session["UserInfo"];
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn);
if (activity == null)
{
Response.Redirect("../Mutual/HomePage.aspx");
return;
}
else
{
//ddlSpecialtyUser.DataSource = BLL.Specialty.GetSpecialtyList(activity.ActivityID.Value, false, conn);
//ddlSpecialtyUser.DataValueField = "SpecialtyID";
//ddlSpecialtyUser.DataTextField = "SpecialtyName";
//ddlSpecialtyUser.DataBind();
}
}
//public void FinishVote(HttpContext context, OleDbConnection conn)
//{
// Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
// //Issubmit="1"，是投票结果的状态为提交，专家不能再更改投票结果,投票时，此字段默认值为0
// string strIsSubmit = "1";
// //获取当前活动类型编码
// string strActivityType = context.Session["ActivityType"].ToString();
// //获取当前活动ID
// int iActivityID = BLL.Activity.GetActivity(strActivityType, conn).ActivityID.Value;
// //获取当前活动时间节点
// Dal.Models.Schedule schedule = BLL.Schedule.GetActivitySchedule(iActivityID, conn);
// //获取所有本次活动的奖项
// List<Dal.Models.Prize> lstPrize = BLL.Prize.GetPrizeList(user, strActivityType, "", conn);
// //修改Schedule的投票阶段
// BLL.Vote.UpdateScheduleVoteFinish(schedule.ScheduleID.Value, false, conn);
// foreach (var item in lstPrize)
// {
// List<Dal.Models.Vote> lstVote = BLL.Vote.GetActivityPrizeVoteList(item.PrizeID.Value, conn);
// foreach (var Vote in lstVote)
// {
// //修改Vote为已经提交
// BLL.Vote.SubmitVote(Vote.VoteID.Value, strIsSubmit, conn);
// }
// }
// context.Response.Write("投票已提交");
//}
private void Ballot(HttpContext context, OleDbConnection conn)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpertByUserID(user.UserID.Value, conn);
OleDbTransaction tran = conn.BeginTransaction();
try
{
int iDeclarationID = 0;
int iPrizeID = 0;
int iMultipleVoteRound = 0;
if (!int.TryParse(context.Request["DeclarationID"], out iDeclarationID) ||
!int.TryParse(context.Request["PrizeID"], out iPrizeID) ||
!int.TryParse(context.Request["MultipleVoteRound"], out iMultipleVoteRound))
{
throw new Exception("参数错误！");
}
Dal.Models.Prize prize = BLL.Prize.GetPrize(iPrizeID, conn, tran);
if (prize == null || prize.IsStopVote)
{
throw new Exception("当前奖项及轮次已结束投票。");
}
string strVoteCode = context.Request["VoteCode"];
string strLevelCode = context.Request["LevelCode"];
if (strLevelCode == "0404")
{
strLevelCode = "";
}
Dal.Models.Declaration decl = BLL.Declaration.GetDeclaration(iDeclarationID, conn, tran);
if (decl.PrizeID != iPrizeID)
{
throw new Exception("参数错误！");
}
prize = BLL.Prize.GetPrize(decl.AdjustedPrize.Value, conn, tran);
if (prize.MultipleVoteRound != iMultipleVoteRound)
{
throw new Exception("当前已进入新一轮投票，请重新进入本页面进行投票！");
}
Dal.Models.Vote vote = new Dal.Models.Vote()
{
UserID = user.UserID.Value,
Votor = expert.ExpertID.Value,
DeclarationID = iDeclarationID,
ActivityID = decl.ActivityID.Value,
MultipleVoteRound = prize.MultipleVoteRound ?? 1,
RevoteCode = prize.RevoteCode ?? "",
RevoteRound = prize.RevoteRound ?? 0,
IsSubmit = false,
PrizeID = prize.PrizeID.Value,
VoteCode = strVoteCode,
PrizeLevelCode = strLevelCode,
VoteType = "0502"
};
BLL.Vote.Ballot(vote, conn, tran);
//根据专家和奖项获评奖项目
List <Dal.Models.Vote> lstVote = BLL.Vote.GetVoteDeclarationList(expert, prize, conn, tran);
//获取每个奖项的已评奖数量
Dictionary <string, int> dicVote = new Dictionary <string, int>();
//获取每个奖项未评奖数量
Dictionary <string, int> dicRemain = new Dictionary <string, int>();
GetLimit(prize, lstVote, ref dicVote, ref dicRemain);
string Message = "";
//if (strVoteCode == "0601" && (dicRemain["Recommended"] == 0
// || (strLevelCode == "0401" && dicRemain["FirstPrize"] == 0)
// || (strLevelCode == "0402" && dicRemain["SecondPrize"] == 0)
// || (strLevelCode == "0403" && dicRemain["ThirdPrize"] == 0)))
//{
// Message = "所投选项名额已满，请注意！";
//}
//else
//{
Message = "投票成功!";
//}
tran.Commit();
object[] obj = { prize, lstVote, dicVote, dicRemain, Message };
context.Response.Write(JsonConvert.SerializeObject(obj));
}
catch (Exception ex)
{
tran.Rollback();
context.Response.Write(JsonConvert.SerializeObject(new object[] { ex.Message }));
}
}
private void BatchBallot(HttpContext context, OleDbConnection conn)
{
Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpertByUserID(user.UserID.Value, conn);
int iPrizeID = 0;
int.TryParse(context.Request["PrizeID"], out iPrizeID);
string strVoteCode = context.Request["VoteCode"];
string strLevelCode = context.Request["LevelCode"];
if (strLevelCode == "0404")
{
strLevelCode = "";
}
Dal.Models.Prize prize = BLL.Prize.GetPrize(iPrizeID, conn);
if (prize == null || prize.IsStopVote)
{
context.Response.Write("当前奖项及轮次已结束投票。");
return;
}
OleDbTransaction tran = conn.BeginTransaction();
try
{
//根据专家和奖项获评奖项目
List <Dal.Models.Vote> lstVote = BLL.Vote.GetVoteDeclarationList(expert, prize, conn, tran);
//获取每个奖项的已评奖数量
Dictionary <string, int> dicVote = new Dictionary <string, int>();
//获取每个奖项未评奖数量
Dictionary <string, int> dicRemain = new Dictionary <string, int>();
GetLimit(prize, lstVote, ref dicVote, ref dicRemain);
//if (strVoteCode == "0601" && (dicRemain["Recommended"] == 0
// || (strLevelCode == "0401" && dicRemain["FirstPrize"] == 0)
// || (strLevelCode == "0402" && dicRemain["SecondPrize"] == 0)
// || (strLevelCode == "0403" && dicRemain["ThirdPrize"] == 0)))
//{
// throw new Exception("所投选项名额已满，请重新投票！");
//}
Dal.Models.Vote vote = new Dal.Models.Vote()
{
UserID = user.UserID.Value,
Votor = expert.ExpertID.Value,
ActivityID = prize.ActivityID.Value,
MultipleVoteRound = prize.MultipleVoteRound ?? 1,
VoteRound = prize.MultipleVoteRound ?? 1,
IsSubmit = false,
PrizeID = prize.PrizeID.Value,
VoteCode = strVoteCode,
PrizeLevelCode = strLevelCode,
VoteType = "0502"
};
BLL.Vote.BatchBallot(vote, conn, tran);
tran.Commit();
context.Response.Write(JsonConvert.SerializeObject("投票成功!"));
}
catch (Exception ex)
{
tran.Rollback();
context.Response.Write(JsonConvert.SerializeObject(ex.Message));
}
}
private void InitPage(OleDbConnection conn)
{
btnCreateUser.Visible = false;
int iExpertId = 0;
int.TryParse(Request["epid"], out iExpertId);
if (iExpertId > 0)
{
try
{
Dal.Models.UserInfo userinfo = (Dal.Models.UserInfo)Session["UserInfo"];
Dal.Models.Expert expert = BLL.Expert.GetExpert(iExpertId, conn);
if (userinfo.UserID == expert.UserID)
{
ddlSpecialty.Enabled = false;
ddlSpecialty.Visible = false;
listSpecialty.Visible = true;
}
else
{
userinfo = BLL.User.GetUserInfo(expert.UserID.Value, conn);
}
txtExpertName.Text = expert.ExpertName;
txtUserName.Text = userinfo.UserName;
txtAcademicTitle.Text = expert.AcademicTitle;
txtProfession.Text = expert.Profession;
txtWorkplace.Text = expert.Workplace;
rbtnIDType.SelectedValue = expert.IDType;
txtIDNumber.Text = expert.IDNumber;
//if (expert.IDType == "0901" && BLL.IDOperation.CheckIDCard18(expert.IDNumber))
//{
// rbtnIDType.Enabled = false;
// txtIDNumber.Enabled = false;
//}
txtEmail.Text = userinfo.Email;
ddlGender.SelectedValue = expert.Gender;
if (expert.SpecialtyIDs != null && expert.SpecialtyIDs != "" && expert.SpecialtyNames != null && expert.SpecialtyNames != "")
{
string[] arrSpecialtyID = expert.SpecialtyIDs.Split(',');
expert.SpecialtyNames = expert.SpecialtyNames.Replace(",", "，");
string[] arrSpecialtyName = expert.SpecialtyNames.Split('，');
for (int i = 0; i < arrSpecialtyID.Length; i++)
{
listSpecialty.Items.Add(new System.Web.UI.WebControls.ListItem(arrSpecialtyName[i], arrSpecialtyID[i]));
}
checkeds.Value = string.Join(",", arrSpecialtyID);
}
hdMsg.Value = "";
}
catch (Exception ex)
{
hdMsg.Value = ex.Message;
}
}
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
if (user.UserType == "0805")
{
txtExpertName.Enabled = false;
//ddlGender.Enabled = false;
txtAcademicTitle.Enabled = false;
txtProfession.Enabled = false;
}
}
protected void btnSaveExpertGroup_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString);
conn.Open();
string strActivityType = Session["ActivityType"].ToString();
Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn);
if (activity == null)
{
hdMsg.Value = "当前活动已关闭，请联系活动管理人员！";
return;
}
Dal.Models.ExpertGroup expertGroup = new Dal.Models.ExpertGroup();
string strGroupID = Request["GroupID"];
if (!string.IsNullOrEmpty(strGroupID))
{
expertGroup.GroupID = Convert.ToInt32(strGroupID);
}
if (hfParentID.Value != "0" && hfParentID.Value != "")
{
expertGroup.ParentID = Convert.ToInt32(hfParentID.Value);
}
expertGroup.GroupName = txtExpertGroupName.Text;
expertGroup.ActivityID = activity.ActivityID;
expertGroup.SpecialtyID = Convert.ToInt32(ddlSpecialty.SelectedValue);
// 组长
if (!string.IsNullOrEmpty(txtExpertGroupLeader.Text.Trim()))
{
expertGroup.GroupLeader = Convert.ToInt32(txtExpertGroupLeader.Text.Trim());
}
else
{
hdMsg.Value = "专家组必须要有一个组长！";
return;
}
// 副组长
expertGroup.DeputyIDs = txtDeputyLeader.Text.Trim();
Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"];
OleDbTransaction tran = conn.BeginTransaction();
try
{
BLL.ExpertGroup.CreateExpertGroup(expertGroup, user, conn, tran);
tran.Commit();
hdMsg.Value = "保存成功!";
}
catch (Exception ex)
{
tran.Rollback();
hdMsg.Value = ex.Message;
conn.Close();
return;
}
conn.Close();
}