///// <summary> ///// 用户激活状态,需要参数ConstantType ///// </summary> ///// <param name="context"></param> //public void GetUserStatus(HttpContext context, OleDbConnection conn) //{ // string strConstantType = context.Request["ConstantType"]; // List<Dal.Models.SysConstant> lstuserstatus = BLL.SysConstant.GetConstantList(strConstantType, conn); // context.Response.Write(JsonConvert.SerializeObject(lstuserstatus)); //} /// <summary> /// 删除用户,需要参数,UserID /// </summary> /// <param name="context"></param> public void DelUser(HttpContext context, OleDbConnection conn) { Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"]; OleDbTransaction tran = conn.BeginTransaction(); try { string id = context.Request["UserID"]; int iUserID = Convert.ToInt32(id); if (iUserID == user.UserID.Value) { throw new Exception("不能禁用或删除当前操作用户!"); } string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn, tran); if (activity == null) { throw new Exception("没有激活的活动!"); } int count = BLL.Declaration.DeclarationExsitUserCount(activity.ActivityID.Value, id, conn, tran); if (count > 0) { throw new Exception("当前用户已经申报过项目,所以不能删除!"); } BLL.User.DeleteUser(Convert.ToInt32(id), activity.ActivityID.Value, conn, tran); tran.Commit(); context.Response.Write("删除成功!"); } catch (Exception ex) { tran.Rollback(); context.Response.Write(ex.Message); } conn.Close(); }
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); Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; if (activity == null) { return; } else { //专业列表绑定 ddlSpecialtyID.DataSource = BLL.Specialty.GetSpecialtyList(activity.ActivityID.Value, true, conn); ddlSpecialtyID.DataValueField = "SpecialtyID"; ddlSpecialtyID.DataTextField = "SpecialtyName"; ddlSpecialtyID.DataBind(); //奖项类别绑定 ddlPrize.DataSource = BLL.SysConstant.GetConstantList("03", conn); ddlPrize.DataValueField = "ConstantCode"; ddlPrize.DataTextField = "ConstantValue"; ddlPrize.DataBind(); } conn.Close(); hfVoteType.Value = Request.QueryString["VoteType"]; }
protected void Page_Load(object sender, EventArgs e) { txtUploadLimitMax.Attributes.Add("onkeyup", "value.replace(/[^\\d]/g, '')"); Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; if (user == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } 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 = "当前没有已经激活的申报活动,请确认。"; } else { InitPage(conn); } conn.Close(); }
public void InitPage() { 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; } ddlPrizeName.DataSource = BLL.Prize.GetPrizeList(userinfo, strActivityType, "", conn); ddlPrizeName.DataValueField = "PrizeID"; ddlPrizeName.DataTextField = "PrizeName"; ddlPrizeName.DataBind(); //申报状态绑值 ddlDeclarationStatus.DataSource = BLL.SysConstant.GetConstantList("18", conn); ddlDeclarationStatus.DataValueField = "ConstantCode"; ddlDeclarationStatus.DataTextField = "ConstantValue"; ddlDeclarationStatus.DataBind(); conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { //if (Request.QueryString["specialtyMSg"] != null && Request.QueryString["specialtyMSg"] != "") //{ // hdMsg.Value = Request.QueryString["specialtyMSg"]; //} Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; if (user == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); conn.Close(); if (activity == null) { hdMsg.Value = "当前没有已经激活的申报活动,请确认。"; } else { if (!IsPostBack) { InitPage(); } } }
//protected void gvSpecialty_RowCommand(object sender, GridViewCommandEventArgs e) //{ // OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); // conn.Open(); // switch (e.CommandName) // { // case "Delete": // OleDbTransaction tran = conn.BeginTransaction(); // try // { // int iSpecialtyID = Convert.ToInt32(e.CommandArgument); // BLL.Specialty.DeleteSpecialty(0,iSpecialtyID, conn, tran); // tran.Commit(); // //Response.Write("<script>alert('专业删除成功')</script>"); // hdMsg.Value = "专业删除成功!"; // } // catch (Exception ex) // { // tran.Rollback(); // //Response.Write("<script>alert('" + ex.Message + "')</script>"); // hdMsg.Value = ex.Message; // } // InitPage(); // break; // } // conn.Close(); //} public void InitPage() { Dal.Models.UserInfo user = (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) { hdMsg.Value = "当前没有已经激活的申报活动,请确认。"; } else { if (user.UserType == "0804") { ddlSpecialty.DataSource = BLL.Specialty.GetUserSpecialtyList(activity.ActivityID.Value, user.UserID.Value, true, conn); } else { ddlSpecialty.DataSource = BLL.Specialty.GetSpecialtyList(activity.ActivityID.Value, true, conn); } ddlSpecialty.DataTextField = "SpecialtyName"; ddlSpecialty.DataValueField = "SpecialtyID"; ddlSpecialty.DataBind(); } conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserInfo"] == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } if (!IsPostBack) { 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"); } else { ddlSpecialty.DataSource = BLL.Specialty.GetSpecialtyList(activity.ActivityID.Value, false, conn); ddlSpecialty.DataTextField = "SpecialtyName"; ddlSpecialty.DataValueField = "SpecialtyID"; ddlSpecialty.DataBind(); } } }
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"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn); if (actActivated == null) { Response.Redirect("../Mutual/HomePage.aspx"); return; } //if (!IsPostBack) //{ // ddlSpecialty.DataSource = BLL.Specialty.GetSpecialtyListByUserType(actActivated.ActivityID.Value, user.UserType, user.UserID.Value, true, conn); // ddlSpecialty.DataTextField = "SpecialtyName"; // ddlSpecialty.DataValueField = "SpecialtyID"; // ddlSpecialty.DataBind(); //} conn.Close(); conn.Dispose(); }
/// <summary> /// 加载公告标题 /// </summary> public void GetNotice() { 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) { int activityID = Convert.ToInt32(activity.ActivityID); OleDbTransaction tran = conn.BeginTransaction(); List <Dal.Models.Notice> notice = BLL.Notice.GetNoticeList(activityID, conn, tran); for (int i = 0; i < notice.Count; i++) { HtmlTableRow tr = new HtmlTableRow(); HtmlTableCell td1 = new HtmlTableCell("td"); HtmlTableCell td2 = new HtmlTableCell("td"); HtmlTableCell td3 = new HtmlTableCell("td"); td1.InnerHtml = "<a href='../../View/ActivityManage/Notice.aspx?nid=" + notice[i].NoticeID + "&statype=3'>" + notice[i].Title + "</a>"; td2.InnerHtml = Convert.ToDateTime(notice[i].EffectTime).ToString("yyyy-MM-dd"); td3.InnerHtml = notice[i].Clicks.ToString(); tr.Cells.Add(td1); tr.Cells.Add(td2); tr.Cells.Add(td3); tbNotice.Rows.Add(tr); } } }
//public void GetAllExpertGroupList(HttpContext context, OleDbConnection conn) //{ // string strActivityType = context.Session["ActivityType"].ToString(); // Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); // if (activity == null) // { // context.Response.Write("当前活动已关闭,请联系活动管理人员!"); // return; // } // List<Dal.Models.ExpertGroup> lstExpertGroup = BLL.ExpertGroup.GetGroupList(activity.ActivityID.Value, null, conn); // List<Dal.Models.ExpertGroup> lstParentExpertGroup = new List<Dal.Models.ExpertGroup>(); // for (int i = 0; i < lstExpertGroup.Count(); i++) // { // for (int j = 0; j < lstExpertGroup.Count(); j++) // { // if (lstExpertGroup[i].GroupID == lstExpertGroup[j].ParentID) // { // lstParentExpertGroup.Add(lstExpertGroup[i]); // } // } // } // for (int o = 0; o < lstParentExpertGroup.Count(); o++) // { // lstExpertGroup.Remove(lstParentExpertGroup[o]); // } // context.Response.Write(JsonConvert.SerializeObject(lstExpertGroup)); //} public void GetExpertGroupListByPrize(HttpContext context, OleDbConnection conn) { int iPrize = context.Request["PrizeID"] == "" ? 0 : Convert.ToInt32(context.Request["PrizeID"]); string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { context.Response.Write("当前活动已关闭,请联系活动管理人员!"); return; } List <Dal.Models.ExpertGroup> lstExpertGroup = BLL.ExpertGroup.GetExpertGroupByPrizeID(activity.ActivityID.Value, iPrize, conn); List <Dal.Models.ExpertGroup> lstParentExpertGroup = new List <Dal.Models.ExpertGroup>(); for (int i = 0; i < lstExpertGroup.Count(); i++) { for (int j = 0; j < lstExpertGroup.Count(); j++) { if (lstExpertGroup[i].GroupID == lstExpertGroup[j].ParentID) { lstParentExpertGroup.Add(lstExpertGroup[i]); } } } for (int o = 0; o < lstParentExpertGroup.Count(); o++) { lstExpertGroup.Remove(lstParentExpertGroup[o]); } context.Response.Write(JsonConvert.SerializeObject(lstExpertGroup)); }
protected void Page_Load(object sender, EventArgs e) { 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/UserEntry.aspx"); return; } ddlPrizeName.DataSource = BLL.Prize.GetPrizeList(userinfo, strActivityType, null, conn); ddlPrizeName.DataValueField = "PrizeID"; ddlPrizeName.DataTextField = "PrizeName"; ddlPrizeName.DataBind(); //申报状态绑值 ddlDeclarationStatus.DataSource = BLL.SysConstant.GetConstantList("18", conn).Where(s => "1802,1803".Contains(s.ConstantCode)).ToList(); ddlDeclarationStatus.DataValueField = "ConstantCode"; ddlDeclarationStatus.DataTextField = "ConstantValue"; ddlDeclarationStatus.DataBind(); conn.Close(); }
protected void lkbCreateActivity_Click(object sender, EventArgs e) { Dal.Models.Activity activity = new Dal.Models.Activity(); activity.ActivityName = txtActivityName.Text; activity.ActivityTypeCode = Session["ActivityType"].ToString(); OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); OleDbTransaction trans = conn.BeginTransaction(); string strMessage = ""; int result = 0; try { result = BLL.Activity.CreateActivity(activity, conn, trans); trans.Commit(); strMessage = "创建成功!"; } catch (Exception ex) { trans.Rollback(); strMessage = ex.Message; } ucSchedule.activityRefresh(); panelCreateActivity.Visible = false; panelActivityInfo.Visible = true; txtCurrentActivity.Text = activity.ActivityName; hdMsg.Value = strMessage; conn.Close(); }
protected void lkbFinishActivity_Click(object sender, EventArgs e) { string strMessage = ""; string strActivityType = Session["ActivityType"].ToString(); OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); OleDbTransaction tran = conn.BeginTransaction(); try { Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn, tran); actActivated.ActivityStatus = "1110"; BLL.Activity.UpdateActivity(actActivated, conn, tran); tran.Commit(); strMessage = "活动结束!"; } catch (Exception ex) { tran.Rollback(); strMessage = ex.Message; } panelActivityInfo.Visible = false; panelCreateActivity.Visible = true; gvActivity.DataSource = BLL.Activity.GetActivityList(strActivityType, conn); gvActivity.DataBind(); hdMsg.Value = strMessage; conn.Close(); }
/// <summary> /// 创建管理员 /// </summary> /// <param name="context"></param> /// <param name="conn"></param> public void CreateUserM(HttpContext context, OleDbConnection conn) { string sType = context.Request["oType"]; Dal.Models.UserInfo user = new Dal.Models.UserInfo(); user.UserName = context.Request["UserName"]; user.Email = context.Request["Email"]; user.IsPasswordChanged = false; string SpecialtyIDs = context.Request["SpecialtyIDs"]; OleDbTransaction tran = conn.BeginTransaction(); try { string strActivityType = context.Session["ActivityType"].ToString(); int iUserID = 0; Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn, tran); if (actActivated == null) { throw new ApplicationException("没有激活的活动!"); } if (sType == "update") { if (context.Request["UserID"] != null && context.Request["UserID"] != "") { user.UserID = Convert.ToInt32(context.Request["UserID"]); } else { throw new NoNullAllowedException("用户编号不允许为空!"); } iUserID = BLL.User.Update(user, conn, tran); } else { user.UserType = context.Request["UserType"]; user.Password = BLL.SysConstant.GetAppSettings("DefaultPassword", conn, tran);; user.CreateUser = ((Dal.Models.UserInfo)context.Session["UserInfo"]).UserID; user.UserID = BLL.User.CreateUser(user, conn, tran); } if (user.UserID != ((Dal.Models.UserInfo)context.Session["UserInfo"]).UserID) { BLL.User.SetUserSpecialty(user.UserID.Value, actActivated.ActivityID.Value, SpecialtyIDs, conn, tran); } tran.Commit(); context.Response.Write("创建成功!"); } catch (Exception ex) { tran.Rollback(); context.Response.Write(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserInfo"] == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity act = BLL.Activity.GetActivity(strActivityType, conn); if (act == null) { hdMsg.Value = "当前没有已经激活的申报活动。"; } else { Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; txtUser.Text = user.UserType; try { txtLastUpdateTime.Text = BLL.Schedule.GetActivitySchedule(Convert.ToInt32(act.ActivityID), conn).DeclarationEndDate.ToString(); } catch { txtLastUpdateTime.Text = DateTime.Now.ToString(); } string id = Request["DeclarationID"]; string Img = Request["UploadFileID"]; if (user.UserType == "0806" || user.UserType == "0807") { txtDeclarationUnit.Visible = false; txtUserType.Text = "会员"; } //奖项绑值 ddlPrizeName.DataSource = BLL.Prize.GetPrizeList(user, strActivityType, "", conn); ddlPrizeName.DataValueField = "PrizeID"; ddlPrizeName.DataTextField = "PrizeName"; ddlPrizeName.DataBind(); //申报状态绑值 ddlDeclarationStatus.DataSource = BLL.SysConstant.GetConstantList("18", conn); ddlDeclarationStatus.DataValueField = "ConstantCode"; ddlDeclarationStatus.DataTextField = "ConstantValue"; ddlDeclarationStatus.DataBind(); ddlDeclarationStatus.Items.Remove(ddlDeclarationStatus.Items.FindByValue("1805")); ddlDeclarationStatus.Items.Remove(ddlDeclarationStatus.Items.FindByValue("1806")); } conn.Close(); }
/// <summary> /// /// </summary> /// <param name="context"></param> /// <param name="conn"></param> public void GetExpertGroupList(HttpContext context, OleDbConnection conn) { string strSpecialtyID = context.Request["Specialtys"]; string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { context.Response.Write("当前活动已关闭,请联系活动管理人员!"); return; } 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; } Dal.Models.PageInfo <Dal.Models.Declaration> pgif = new Dal.Models.PageInfo <Dal.Models.Declaration>(); pgif.CuttentPage = iCuttentPage; pgif.PerPage = iPageSize; List <Dal.Models.ExpertGroup> lstExpertGroup = BLL.ExpertGroup.GetGroupList(activity.ActivityID.Value, strSpecialtyID, conn); if (lstExpertGroup.Count > 0) { lstExpertGroup = lstExpertGroup.OrderByDescending(r => r.GroupID).ToList(); } int iRecordNumber = lstExpertGroup.Count; int iPagesCount = Convert.ToInt32(Math.Ceiling((float)iRecordNumber / (float)iPageSize)); lstExpertGroup = lstExpertGroup.Skip(iPageSize * (iCuttentPage - 1)).Take(iPageSize).ToList(); DataTable dtExpertGroup = Dal.DataTableExtensions.ToDataTable(lstExpertGroup); pgif.RecordNumber = iRecordNumber; pgif.PagesCount = iPagesCount; pgif.Table = dtExpertGroup; context.Response.Write(JsonConvert.SerializeObject(pgif)); }
private void InitPage(OleDbConnection conn) { string strActivityType = Session["ActivityType"].ToString(); // 获取指定活动类型的当前激活活动 Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn); string strErrorMessage = ""; if (!IsPostBack) { txtActivityType.Text = BLL.SysConstant.GetConstant(strActivityType, conn).ConstantValue; if (actActivated == null) { panelActivityInfo.Visible = false; panelCreateActivity.Visible = true; // 评优活动列表数据绑定 gvActivity.DataSource = BLL.Activity.GetActivityList(strActivityType, conn); gvActivity.DataBind(); } else { panelCreateActivity.Visible = false; panelActivityInfo.Visible = true; txtCurrentActivity.Text = actActivated.ActivityName; try { ucSchedule.UcSchedule = BLL.Schedule.GetActivitySchedule(actActivated.ActivityID.Value, conn); } catch (Exception ex) { strErrorMessage = ex.Message; } if (ucSchedule.UcSchedule == null) { ucSchedule.UcSchedule = new Dal.Models.Schedule(); } ucSchedule.UcSchedule.ActivityID = actActivated.ActivityID; } } ucSchedule.OnSaveSchedule += SaveSchedule; hdMsg.Value = strErrorMessage; }
public void GetParentGroup(HttpContext context, OleDbConnection conn) { int specialtyID = Convert.ToInt32(context.Request["SpecialtyID"]); string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { context.Response.Write("当前活动已关闭,请联系活动管理人员!"); return; } List <Dal.Models.ExpertGroup> profession = BLL.ExpertGroup.GetGroupList(activity.ActivityID.Value, specialtyID.ToString(), conn); context.Response.Write(JsonConvert.SerializeObject(profession)); }
//获取奖项下专业下的所有组员 public void GetExpertsByGroupID(HttpContext context, OleDbConnection conn) { int iExpertGroupID = context.Request["ExpertGroupID"] == "" ? 0 : Convert.ToInt32(context.Request["ExpertGroupID"]); string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { context.Response.Write("当前活动已关闭,请联系活动管理人员!"); return; } List <Dal.Models.GroupMember> lstExpertGroup = BLL.GroupMember.GetExpertsByPrizeID(iExpertGroupID, conn); List <Dal.Models.GroupMember> lstParentExpertGroup = new List <Dal.Models.GroupMember>(); context.Response.Write(JsonConvert.SerializeObject(lstExpertGroup)); }
/// <summary> /// 加载最新申报信息 /// </summary> public void GetNewDeclaration() { Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn); List <Dal.Models.Declaration> decl = null; if (actActivated != null) { decl = BLL.Declaration.GetDeclarationList(user, Convert.ToInt32(actActivated.ActivityID), conn); if (user.UserType == "0805") { decl = decl.Where(d => d.DeclarationStatus == "1803").OrderByDescending(d => d.DeclareDate).Take(4).ToList(); } else { decl = decl.Where(d => !(new string[] { "1805", "1806" }.Contains(d.DeclarationStatus))).OrderByDescending(d => d.DeclareDate).Take(4).ToList(); } for (int i = 0; i < decl.Count; i++) { HtmlTableRow tr = new HtmlTableRow(); HtmlTableCell td1 = new HtmlTableCell("td"); HtmlTableCell td2 = new HtmlTableCell("td"); HtmlTableCell td3 = new HtmlTableCell("td"); HtmlTableCell td4 = new HtmlTableCell("td"); td1.InnerHtml = decl[i].DeclarationCode.ToString(); td2.InnerHtml = "<a href='../Declaration/Declaration.aspx?DeclarationID=" + decl[i].DeclarationID + "&Situation=ExpertReview'>" + decl[i].DeclarationName.ToString() + "</a>"; td3.InnerHtml = decl[i].SpecialtyName; td4.InnerHtml = decl[i].PrizeName; tr.Cells.Add(td1); tr.Cells.Add(td2); tr.Cells.Add(td3); tr.Cells.Add(td4); NewDeclaration.Rows.Add(tr); } } conn.Close(); }
/// <summary> /// 删除多选用户列表Gqx /// </summary> /// <param name="context"></param> public void MultiselectDelUserList(HttpContext context, OleDbConnection conn) { string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { context.Response.Write("没有激活的活动!"); return; } string strUserID = context.Request["UserID"]; int count = BLL.Declaration.DeclarationExsitUserCount(activity.ActivityID.Value, strUserID, conn); if (count > 0) { context.Response.Write("当前选中项中存在已经申报过项目的用户,所以不能删除!"); } else { string[] arrayUserID = strUserID.Split(','); List <int> listUserID = new List <int>(); foreach (var item in arrayUserID) { listUserID.Add(Convert.ToInt32(item)); } OleDbTransaction trans = conn.BeginTransaction(); try { for (int i = 0; i < listUserID.Count(); i++) { int iUserID = Convert.ToInt32(listUserID[i]); BLL.User.DeleteUser(iUserID, Convert.ToInt32(activity.ActivityID), conn, trans); } trans.Commit(); context.Response.Write("删除成功!"); } catch (Exception ex) { trans.Rollback(); context.Response.Write(ex.Message); } } conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { Dal.Models.UserInfo user = (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) { //这里要提示错误 return; } List <Dal.Models.Specialty> lstSpecialty = BLL.Specialty.GetSpecialtyList(activity.ActivityID.Value, false, conn); int iPerPage = 10; if (!Int32.TryParse(Request["PerPage"] ?? "10", out iPerPage)) { iPerPage = 10; } int iCuttentPage = 1; if (!Int32.TryParse(Request["CuttentPage"] ?? "1", out iCuttentPage)) { iCuttentPage = 1; } int iRecordNumber = lstSpecialty.Count(); int iPagesCount = Convert.ToInt32(Math.Ceiling((float)iRecordNumber / (float)iPerPage)); ViewState["PerPage"] = iPerPage; ViewState["CuttentPage"] = iCuttentPage; ViewState["RecordNumber"] = iRecordNumber; ViewState["PagesCount"] = iPagesCount; lstSpecialty = lstSpecialty.Skip(iPerPage * (iCuttentPage - 1)).Take(iPerPage).ToList(); conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserInfo"] == null) { Response.Redirect("../Mutual/UserEntry.aspx"); return; } if (!IsPostBack) { 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; } } InitPage(); }
public void MultiselectDelExpertList(HttpContext context, OleDbConnection conn) { string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { context.Response.Write("当前活动已关闭,请联系活动管理人员!"); return; } OleDbTransaction trans = conn.BeginTransaction(); string strExpertID = context.Request["ExpertID"]; string[] arrayExpertID = strExpertID.Split(','); List <int> listExpertID = new List <int>(); foreach (var item in arrayExpertID) { listExpertID.Add(Convert.ToInt32(item)); } try { for (int i = 0; i < listExpertID.Count(); i++) { int iExpertID = Convert.ToInt32(listExpertID[i]); BLL.Expert.DeleteExpert(iExpertID, activity.ActivityID.Value, conn, trans); } trans.Commit(); context.Response.Write("删除成功!"); } catch (Exception ex) { trans.Rollback(); context.Response.Write(ex.Message); } }
/// <summary> /// 删除专家,需要参数,ExpertID /// </summary> /// <param name="context"></param> public void DelExpert(HttpContext context, OleDbConnection conn) { OleDbTransaction tran = conn.BeginTransaction(); try { string id = context.Request["ExpertID"]; string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn, tran); if (activity == null) { throw new Exception("当前活动已关闭,请联系活动管理人员!"); } BLL.Expert.DeleteExpert(Convert.ToInt32(id), activity.ActivityID.Value, conn, tran); tran.Commit(); context.Response.Write("success"); } catch (Exception ex) { tran.Rollback(); context.Response.Write(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 { ddlSpecialty.DataSource = BLL.Specialty.GetSpecialtyListByUserType(activity.ActivityID.Value, userinfo.UserType, userinfo.UserID.Value, false, conn); ddlSpecialty.DataValueField = "SpecialtyID"; ddlSpecialty.DataTextField = "SpecialtyName"; ddlSpecialty.DataBind(); } }
/// <summary> /// 修改活动信息 /// </summary> /// <param name="activity"></param> /// <param name="trans"></param> /// <returns></returns> public static int UpdateActivity(Dal.Models.Activity activity, OleDbConnection conn, OleDbTransaction trans) { if (activity.ActivityID == null || string.IsNullOrEmpty(activity.ActivityName) || string.IsNullOrEmpty(activity.ActivityStatus)) { return -1; } if (activity.LastUpdateTime == null) { activity.LastUpdateTime = DateTime.Now; } StringBuilder sbSql = new StringBuilder(); sbSql.Append(" UPDATE Activity SET"); sbSql.Append(" ActivityName = ? "); sbSql.Append(" ,ActivityStatus = ? "); sbSql.Append(" ,LastUpdateTime = GETDATE() "); sbSql.Append(" WHERE ActivityID = ? "); return Dal.OleDbHlper.ExecuteNonQuery(sbSql.ToString(), conn, CommandType.Text, trans , new OleDbParameter("@ActivityName", OleDbType.VarWChar) { Value = activity.ActivityName } , new OleDbParameter("@ActivityStatus", OleDbType.VarWChar) { Value = activity.ActivityStatus } , new OleDbParameter("@ActivityID", OleDbType.Integer) { Value = activity.ActivityID }); }
protected void Page_Load(object sender, EventArgs e) { if (Session["ActivityType"] == null || Session["UserInfo"] == null) { Response.Redirect("../Mutual/UserEntry.aspx"); return; } if (!IsPostBack) { //根据当前模板状态显示部件 //Dal.Models.TemplateInfo tempInfo = (Dal.Models.TemplateInfo)Session["TemplateInfo"]; Dal.Models.TemplateInfo tempInfo = null; try { tempInfo = ((Declaration)Context.Handler).TempInfo; } catch { Response.Redirect("../Mutual/UserEntry.aspx"); } if (tempInfo == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); //显示模板的当前编辑部分 //divfather.FindControl(tempInfo.Anchor).Visible = true; Dal.Models.Template_10_CivilAirDefence tempCivilAirDefence = BLL.Declaration.GetDeclarationData <Dal.Models.Template_10_CivilAirDefence>(tempInfo.DeclarationID.Value, conn); Dal.Models.Declaration decl = BLL.Declaration.GetDeclaration(tempInfo.DeclarationID.Value, conn); SetDropDownList(DesignCategory, BLL.SysConstant.GetConstantList("14", conn)); SetDropDownList(InvestSource, BLL.SysConstant.GetConstantList("15", conn)); SetDropDownList(ProfessionalCategories, BLL.SysConstant.GetConstantList("28", conn)); //SetDropDownList(DeclarationLevel, BLL.SysConstant.GetConstantList("04", conn)); List <Dal.Models.SysConstant> lstDomesticOrAbord = BLL.SysConstant.GetConstantList("19", conn); SetDropDownList(DomesticOrAbord1, lstDomesticOrAbord); SetDropDownList(DomesticOrAbord2, lstDomesticOrAbord); SetDropDownList(DomesticOrAbord3, lstDomesticOrAbord); SetDropDownList(DomesticOrAbord4, lstDomesticOrAbord); List <Dal.Models.SysConstant> lstCollaborativePhase = BLL.SysConstant.GetConstantList("20", conn); SetDropDownList(CollaborativePhase01, lstCollaborativePhase); CollaborativePhase01.Items.Insert(0, new ListItem("")); SetDropDownList(CollaborativePhase02, lstCollaborativePhase); CollaborativePhase02.Items.Insert(0, new ListItem("")); SetDropDownList(CollaborativePhase03, lstCollaborativePhase); CollaborativePhase03.Items.Insert(0, new ListItem("")); SetDropDownList(CollaborativePhase04, lstCollaborativePhase); CollaborativePhase04.Items.Insert(0, new ListItem("")); //为控件赋值 BLL.Common.SetData <Dal.Models.Template_10_CivilAirDefence>(tempCivilAirDefence, divfather); // 设置参与人员 ucParticipant.ParticipantList = BLL.Declaration.GetParticipant(tempInfo.DeclarationID.Value, conn); Dal.Models.Organization org = BLL.Organization.GetOrganization(decl.OrganizationID.Value, conn); DeclarationName.Text = decl.DeclarationName; DeclarationUnit.Text = org.OrganizationName; PostalAddress.Text = org.OrganizationAddress; Linkman.Text = org.Linkman; TelephoneNumber.Text = org.TelephoneNumber; FaxNumber.Text = org.FaxNumber; MobileNumber.Text = org.MobileNumber; Postcode.Text = org.Postcode; EmailAddress.Text = org.EmailAddress;;//org.EmailAddress txtDeclarationID.Text = decl.DeclarationID.ToString(); txtTemplate.Text = tempInfo.TemplateCode; ucLegalStates.Org = org; ucLegalStates.Decl = decl; ucCertificate.Org = org; ucCertificate.Decl = decl; ucParticipant.Org = org; ucParticipant.Decl = decl; ucComments.Org = org; ucComments.Decl = decl; //接受登录人员 Dal.Models.UserInfo userInfo = (Dal.Models.UserInfo)Session["UserInfo"]; txtUser.Text = userInfo.UserType; //接受场景 if (!string.IsNullOrEmpty(tempInfo.Situation.ToString())) { txtSituation.Text = tempInfo.Situation.ToString(); } if (tempInfo.Situation.ToString() == "Declara") { string strActivityType = Session["ActivityType"].ToString(); // 获取指定活动类型的当前激活活动 Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn); if (actActivated == null) { conn.Close(); Response.Redirect("../Mutual/UserEntry.aspx"); return; } int iActivity = actActivated.ActivityID.Value; string strSpecialty = decl.DeclarationCode.Substring(4, 6); Dal.Models.Specialty dSpecialty = BLL.Specialty.GetSpecialtyByCode(strSpecialty, iActivity, conn); conn.Close(); nav02.InnerText = dSpecialty.SpecialtyName; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["ActivityType"] == null || Session["UserInfo"] == null) { Response.Redirect("../Mutual/UserEntry.aspx"); return; } if (!IsPostBack) { //根据当前模板状态显示部件 // Dal.Models.TemplateInfo tempInfo = (Dal.Models.TemplateInfo)Session["TemplateInfo"]; Dal.Models.TemplateInfo tempInfo = null; try { tempInfo = ((Declaration)Context.Handler).TempInfo; } catch { Response.Redirect("../Mutual/UserEntry.aspx"); } if (tempInfo == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); //显示模板的当前编辑部分 //divfather.FindControl(tempInfo.Anchor).Visible = true; Dal.Models.Template_17_Standard tempStandard = BLL.Declaration.GetDeclarationData <Dal.Models.Template_17_Standard>(tempInfo.DeclarationID.Value, conn); Dal.Models.Declaration decl = BLL.Declaration.GetDeclaration(tempInfo.DeclarationID.Value, conn); ListItem item = new ListItem(); item.Text = "行业"; item.Value = "2401"; ListItem item2 = new ListItem(); item2.Text = "地方"; item2.Value = "2402"; ListItem item3 = new ListItem(); item3.Text = "国家"; item3.Value = "2403"; ListItem item4 = new ListItem(); item4.Text = "其他"; item4.Value = "2404"; ProjectSource.Items.Add(item); ProjectSource.Items.Add(item2); ProjectSource.Items.Add(item3); ProjectSource.Items.Add(item4); //为控件赋值 BLL.Common.SetData <Dal.Models.Template_17_Standard>(tempStandard, divfather); if (FileCatalog.Text == "") { FileCatalog.Text = BLL.SysConstant.GetTemplateConstant(tempInfo.TemplateCode, "FileCatalogDefaultText", conn); } // 设置参与人员 ucParticipant.ParticipantList = BLL.Declaration.GetParticipant(tempInfo.DeclarationID.Value, conn); Dal.Models.Organization org = BLL.Organization.GetOrganization(decl.OrganizationID.Value, conn); StandardName.Text = decl.DeclarationName; ChiefEditorUnit.Text = org.OrganizationName; PostalAddress.Text = org.OrganizationAddress; Linkman.Text = org.Linkman; TelephoneNumber.Text = org.TelephoneNumber; FaxNumber.Text = org.FaxNumber; MobileNumber.Text = org.MobileNumber; Postcode.Text = org.Postcode; EmailAddress.Text = org.EmailAddress;;//org.EmailAddress txtDeclarationID.Text = decl.DeclarationID.ToString(); txtTemplate.Text = tempInfo.TemplateCode; ucLegalStates.Org = org; ucLegalStates.Decl = decl; ucCertificate.Org = org; ucCertificate.Decl = decl; ucParticipant.Org = org; ucParticipant.Decl = decl; ucComments.Org = org; ucComments.Decl = decl; //接受登录人员 Dal.Models.UserInfo userInfo = (Dal.Models.UserInfo)Session["UserInfo"]; txtUser.Text = userInfo.UserType; //接受场景 if (!string.IsNullOrEmpty(tempInfo.Situation.ToString())) { txtSituation.Text = tempInfo.Situation.ToString(); } if (tempInfo.Situation.ToString() == "Declara") { string strActivityType = Session["ActivityType"].ToString(); // 获取指定活动类型的当前激活活动 Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn); if (actActivated == null) { conn.Close(); Response.Redirect("../Mutual/UserEntry.aspx"); return; } int iActivity = actActivated.ActivityID.Value; string strSpecialty = decl.DeclarationCode.Substring(4, 6); Dal.Models.Specialty dSpecialty = BLL.Specialty.GetSpecialtyByCode(strSpecialty, iActivity, conn); conn.Close(); nav02.InnerText = dSpecialty.SpecialtyName; } //string sourceText = ProjectSource.SelectedItem.Text; //ProjectSource.Text = sourceText; } }
/// <summary> /// 导入专家 /// </summary> /// <param name="context"></param> /// <param name="conn"></param> /// <remarks>第一个对象标识:0 没有文件 1 有文件 第二个对象:成功列表 第三个对象:失败列表及失败原因</remarks> public void ImportExpert(HttpContext context, OleDbConnection conn) { List <object> lstResult = new List <object>(); if (context.Session["ActivityType"] == null) { lstResult.Add("-1"); lstResult.Add("当前会话已结束,请重新登录!"); context.Response.Write(JsonConvert.SerializeObject(lstResult)); return; } string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { lstResult.Add("-1"); lstResult.Add("当前活动已关闭,请联系活动管理人员!"); context.Response.Write(JsonConvert.SerializeObject(lstResult)); return; } //int specialtyID = Convert.ToInt32(context.Request["SpecialtyID"]); if (context.Request.Files.Count <= 0) { lstResult.Add("-1"); lstResult.Add("请选择文件!"); context.Response.Write(JsonConvert.SerializeObject(lstResult)); return; } // 接收上传文件 string excelFile = UploadFile(context); // 读取文件中的数据 DataTable dtExpert = BLL.Common.ReadExcelByNPOI(excelFile, true, 0); if (dtExpert == null) { lstResult.Add("-1"); lstResult.Add("读取文件中的数据失败!"); context.Response.Write(JsonConvert.SerializeObject(lstResult)); return; } List <DataRow> removelist = new List <DataRow>(); for (int i = 0; i < dtExpert.Rows.Count; i++) { bool IsNull = true; for (int j = 0; j < dtExpert.Columns.Count; j++) { if (!string.IsNullOrEmpty(dtExpert.Rows[i][j].ToString().Trim())) { IsNull = false; break; } } if (IsNull) { removelist.Add(dtExpert.Rows[i]); } } for (int i = 0; i < removelist.Count; i++) { dtExpert.Rows.Remove(removelist[i]); } Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"]; Dal.Models.Expert expert = null; Dal.Models.Expert expertOriginal = null; Dal.Models.UserInfo userOriginal = null; List <Dal.Models.Expert> lstExpert = new List <Dal.Models.Expert>(); //创建专家,如果专家创建失败,加入到这里 List <KeyValuePair <string, Dal.Models.Expert> > lstError = new List <KeyValuePair <string, Dal.Models.Expert> >(); List <Dal.Models.SysConstant> lstConstant = BLL.SysConstant.GetConstantList("09", conn); string strDefaultPassword = BLL.SysConstant.GetAppSettings("DefaultPassword", conn); Dal.Models.SysConstant cnstIDType = null; foreach (DataRow row in dtExpert.Rows) { if (string.IsNullOrEmpty(row["姓名"].ToString().Trim())) { continue; } expert = new Dal.Models.Expert(); expert.ExpertName = row["姓名"].ToString().Trim(); expert.Gender = row["性别"].ToString().Trim(); expert.IDTypeText = row["证件类别"].ToString().Trim(); expert.IDNumber = row["证件号码"].ToString().Trim(); expert.Email = row["电子邮箱"].ToString().Trim(); expert.AcademicTitle = row["职称"].ToString().Trim(); expert.Profession = row["研究方向"].ToString().Trim(); expert.Workplace = row["工作单位"].ToString().Trim(); expert.SpecialtyNames = row["评优专业"].ToString().Trim(); OleDbTransaction tran = conn.BeginTransaction(); try { if (string.IsNullOrEmpty(expert.IDTypeText) || string.IsNullOrEmpty(expert.IDNumber) || string.IsNullOrEmpty(expert.Email) || string.IsNullOrEmpty(expert.SpecialtyNames)) { throw new Exception("专家信息不完整!"); } // 判断证件类别 cnstIDType = lstConstant.Find(delegate(Dal.Models.SysConstant item) { return(item.ConstantValue == expert.IDTypeText); }); if (cnstIDType == null) { throw new Exception("证件类别输入错误!"); } else { expert.IDType = cnstIDType.ConstantCode; if (expert.IDType == "0901" && !BLL.IDOperation.CheckIDCard18(expert.IDNumber)) { throw new Exception("所输入的身份证号码不是有效身份证号码!"); } } // 判断证件号 expertOriginal = BLL.Expert.GetExpert(expert.ExpertName, conn, tran); if (expertOriginal != null) { if (expertOriginal.ExpertName != expert.ExpertName && expertOriginal.IDType == expert.IDType && expertOriginal.IDNumber == expert.IDNumber) { throw new Exception("专家库中存在证件类别和证件号相同,但是不同名的专家!"); } } // 判断邮箱地址 if (!BLL.Common.IsValidEmail(expert.Email)) { throw new Exception("电子邮件地址格式错误!"); } else { userOriginal = BLL.User.GetUserByMail(expert.Email, conn, tran); if (userOriginal != null && (expertOriginal == null || userOriginal.UserID != expertOriginal.UserID)) { throw new Exception("电子邮件地址已被占用,请更换电子邮件地址!"); } } // 判断专业 List <Dal.Models.Specialty> lstSpecialty = BLL.Specialty.GetSpecialtyList(activity.ActivityID.Value, true, conn, tran); string[] specialtyNames = expert.SpecialtyNames.Replace(",", ",").Split(','); expert.SpecialtyNames = ""; List <Dal.Models.Specialty> lstInputSpecialty = null; for (int i = 0; i < specialtyNames.Count(); i++) { lstInputSpecialty = lstSpecialty.Where(s => s.SpecialtyName == specialtyNames[i]).ToList(); if (lstInputSpecialty.Count > 0) { if (user.UserType != "0804" || user.SpecialtyNames.Split().Contains(lstInputSpecialty[i].SpecialtyName)) { expert.SpecialtyIDs += lstInputSpecialty[0].SpecialtyID + ","; expert.SpecialtyNames += lstInputSpecialty[0].SpecialtyName + ","; } } } if (!string.IsNullOrEmpty(expert.SpecialtyIDs)) { expert.SpecialtyIDs = expert.SpecialtyIDs.TrimEnd(','); expert.SpecialtyNames = expert.SpecialtyNames.TrimEnd(','); } else { throw new Exception("评优专业不匹配!"); } // 专家数据入库 if (expertOriginal != null) { expert.ExpertID = expertOriginal.ExpertID; expert.UserID = expertOriginal.UserID; BLL.Expert.UpdateExpert(expert, conn, tran); } else { expert.ExpertID = BLL.Expert.CreateExpert(expert, strDefaultPassword, user.UserID.Value, conn, tran); } if (expert.SpecialtyIDs.Length > 0) { string[] specialtyIDs = expert.SpecialtyIDs.Split(','); for (int i = 0; i < specialtyIDs.Count(); i++) { BLL.User.AddUserSpecialty(expert.UserID.Value, Convert.ToInt32(specialtyIDs[i]), conn, tran); } } //BLL.User.SetUserSpecialty(expert.UserID.Value, activity.ActivityID.Value, expert.SpecialtyIDs, conn, tran); // 添加到成功数据中 lstExpert.Add(expert); tran.Commit(); } catch (Exception ex) { tran.Rollback(); // 添加失败数据及失败原因 lstError.Add(new KeyValuePair <string, Dal.Models.Expert>(ex.Message, expert)); } } lstResult.Add(dtExpert.Rows.Count); lstResult.Add(lstExpert.Count); lstResult.Add(lstExpert); lstResult.Add(lstError); context.Response.Write(JsonConvert.SerializeObject(lstResult)); }