private void LoadData(string strType) { if (strType == "1") { string strID = Request.QueryString["value"];//操作ID zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList("PartnerGUID='" + strID + "'").Tables[0]; zlzw.Model.PartnersListModel partnersListModal = partnersListBLL.GetModel(int.Parse(dt.Rows[0]["PartnerID"].ToString())); txbPartnersName.Text = partnersListModal.PartnerName; //合作伙伴名称 txbPartner.Text = partnersListModal.PartnerIntroduction; //合作伙伴简介 txbJobContactAdd.Text = partnersListModal.JobContactAdd; //联系地址 txbJobContactPhone.Text = partnersListModal.JobContactPhone; //联系电话 txbJobContactName.Text = partnersListModal.JobContactName; //联系人 if (partnersListModal.IsHot == 1) { ckbIsHot.Checked = true; } else { ckbIsHot.Checked = false; } imgUploadLogo.ImageUrl = partnersListModal.PartnerLogo; //显示上传后的图片 imgUploadBanner.ImageUrl = partnersListModal.PartnerBanner; //显示上传后的图片 imgUploadLogo.Visible = true; imgUploadBanner.Visible = true; ViewState["PartnerLogo"] = partnersListModal.PartnerLogo; //合作伙伴图片地址 ViewState["PartnerBanner"] = partnersListModal.PartnerBanner; //合作伙伴Banner ViewState["PublishDate"] = partnersListModal.PublishDate.ToString(); ViewState["PartnersGUID"] = partnersListModal.PartnerGUID.ToString(); ToolbarText2.Text = "编辑一个岗位"; } btnClose.OnClientClick = ActiveWindow.GetConfirmHideReference(); }
private int Get_EnterpriseRecordCount() { zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList("IsEnable=1").Tables[0]; return(dt.Rows.Count); }
protected void btnDel_Click(object sender, EventArgs e) { if (grid1.SelectedRowIndexArray != null && grid1.SelectedRowIndexArray.Length > 0) { string strSelectID = "0"; for (int i = 0, count = grid1.SelectedRowIndexArray.Length; i < count; i++) { int rowIndex = grid1.SelectedRowIndexArray[i]; foreach (object key in grid1.DataKeys[rowIndex]) { strSelectID = key.ToString(); } } #region 除逻辑 zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList("PartnerGUID='" + strSelectID + "'").Tables[0]; zlzw.Model.PartnersListModel partnersListModal = partnersListBLL.GetModel(int.Parse(dt.Rows[0]["PartnerID"].ToString())); partnersListModal.IsEnable = 0; partnersListBLL.Update(partnersListModal); PartnersList_BindGrid(); #endregion } else { return; } }
private string Get_PartnersID(string strPartnerGUID) { zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList("PartnerGUID='" + strPartnerGUID + "'").Tables[0]; return(dt.Rows[0]["PartnerID"].ToString()); }
private void PartnersList_BindGrid() { zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList(grid1.PageSize, grid1.PageIndex + 1, "*", "PublishDate", 0, "desc", "IsEnable=1").Tables[0]; grid1.DataSource = dt; grid1.DataBind(); }
private void Load_PartnerList() { zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList(12, "IsHot=1 and IsEnable=1", "PublishDate desc").Tables[0]; Repeater2.DataSource = dt; Repeater2.DataBind(); }
private void Load_EnterpriseList() { int nPageIndex = AspNetPager1.CurrentPageIndex; int nPageSize = AspNetPager1.PageSize = 5; zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList(nPageSize, nPageIndex, "*", "PublishDate", 0, "desc", "IsEnable=1").Tables[0]; Repeater1.DataSource = dt; Repeater1.DataBind(); }
private void Load_PartnersList() { zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList("IsEnable=1 order by PublishDate desc").Tables[0]; drpPartnerGUID.DataTextField = "PartnerName"; drpPartnerGUID.DataValueField = "PartnerGUID"; drpPartnerGUID.DataSource = dt; drpPartnerGUID.DataBind(); }
private string Get_EnterpriseName(string strEnterpriseID) { zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); System.Data.DataTable dt = partnersListBLL.GetList("PartnerGUID='" + strEnterpriseID + "'").Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows[0]["PartnerName"].ToString()); } else { return("未知"); } }
/// <summary> /// 获取总页数 /// </summary> /// <returns></returns> private int Get_PartnersListTotalCount() { zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList("IsEnable=1").Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows.Count); } else { return(0); } }
private void Load_EnterpriseInfo(string strEnterPriseGUID) { try { zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); DataTable dt = partnersListBLL.GetList("PartnerGUID='" + strEnterPriseGUID + "'").Tables[0]; txbTitle.Text = "校企英才官方合作伙伴-" + dt.Rows[0]["PartnerName"].ToString(); labEnterpriseLogo.Text = "<img style='padding-left:20px;' alt='' title='' src='" + dt.Rows[0]["PartnerLogo"].ToString().Split('~')[1] + "' />"; labBanner.Text = "<img alt='' title='' src='" + dt.Rows[0]["PartnerBanner"].ToString().Split('~')[1] + "' />"; labEnterpriseContent.Text = dt.Rows[0]["PartnerIntroduction"].ToString(); labJobContactAdd.Text = dt.Rows[0]["JobContactAdd"].ToString(); labJobContactPhone.Text = dt.Rows[0]["JobContactPhone"].ToString(); labJobContactName.Text = dt.Rows[0]["JobContactName"].ToString(); } catch (Exception exp) { Response.Redirect("../default.aspx"); } }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { if (Request.QueryString["Type"] == "1") { //编辑保存 zlzw.Model.PartnersListModel partnersListModal = new zlzw.Model.PartnersListModel(); partnersListModal.PartnerName = txbPartnersName.Text; //合作伙伴名称 partnersListModal.PartnerIntroduction = txbPartner.Text; //合作伙伴简介 if (btnImageUpload.PostedFile.ContentLength > 0) { btnImageUpload.SaveAs(Server.MapPath(ViewState["PartnerLogo"].ToString())); partnersListModal.PartnerLogo = ViewState["PartnerLogo"].ToString();//保存企业Logo路径 } else { partnersListModal.PartnerLogo = ViewState["PartnerLogo"].ToString(); } if (btnBannerUpload.PostedFile.ContentLength > 0) { btnBannerUpload.SaveAs(Server.MapPath(ViewState["PartnerBanner"].ToString())); partnersListModal.PartnerBanner = ViewState["PartnerBanner"].ToString();//保存企业Logo路径 } else { partnersListModal.PartnerBanner = ViewState["PartnerBanner"].ToString(); } if (ckbIsHot.Checked) { partnersListModal.IsHot = 1; } else { partnersListModal.IsHot = 0; } partnersListModal.JobContactAdd = txbJobContactAdd.Text; //联系地址 partnersListModal.JobContactPhone = txbJobContactPhone.Text; //联系电话 partnersListModal.JobContactName = txbJobContactName.Text; //联系人 partnersListModal.IsEnable = 1; partnersListModal.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString()); partnersListModal.PartnerID = int.Parse(Get_PartnersID(Request.QueryString["value"])); partnersListModal.PartnerGUID = new Guid(Request.QueryString["value"]); zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); partnersListBLL.Update(partnersListModal); } else { //添加保存 zlzw.Model.PartnersListModel partnersListModal = new zlzw.Model.PartnersListModel(); partnersListModal.PartnerName = txbPartnersName.Text; //合作伙伴名称 partnersListModal.PartnerIntroduction = txbPartner.Text; //合作伙伴简介 partnersListModal.IsEnable = 1; if (ckbIsHot.Checked) { partnersListModal.IsHot = 1; } else { partnersListModal.IsHot = 0; } if (btnImageUpload.HasFile) { string fileName = DateTime.Now.Ticks.ToString() + "_" + btnImageUpload.FileName; btnImageUpload.SaveAs(Server.MapPath("~/PartnersLogo/" + fileName)); partnersListModal.PartnerLogo = "~/PartnersLogo/" + fileName;//保存企业Logo路径 } else { Alert.Show("请上传一张尺寸为137 * 70 的企业Logo", "错误提醒", MessageBoxIcon.Error); return; } if (btnBannerUpload.HasFile) { string fileName = DateTime.Now.Ticks.ToString() + "_" + btnBannerUpload.FileName; btnBannerUpload.SaveAs(Server.MapPath("~/PartnersBanner/" + fileName)); partnersListModal.PartnerBanner = "~/PartnersBanner/" + fileName;//保存企业Logo路径 } else { Alert.Show("请上传一张宽度为1024px的企业Banner", "错误提醒", MessageBoxIcon.Error); return; } partnersListModal.JobContactAdd = txbJobContactAdd.Text; //联系地址 partnersListModal.JobContactPhone = txbJobContactPhone.Text; //联系电话 partnersListModal.JobContactName = txbJobContactName.Text; //联系人 partnersListModal.PartnerGUID = Guid.NewGuid(); partnersListModal.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); zlzw.BLL.PartnersListBLL partnersListBLL = new zlzw.BLL.PartnersListBLL(); partnersListBLL.Add(partnersListModal); } // 2. Close this window and Refresh parent window PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }