protected bool flg = true;//标识是否有印章 protected void Page_Load(object sender, EventArgs e) { if (Session["userName"] == null || Session["userName"].ToString() == "" || Session["userPw"] == null || Session["userPw"].ToString() == "") { Response.Redirect("login.aspx"); } lblUserName.Text = Session["userName"].ToString(); //lblNowTime.Text = DateTime.Now.ToString("yyyy/MM/dd"); if (!IsPostBack) { PageOffice.ZoomSeal.SealManager sealMg = new PageOffice.ZoomSeal.SealManager(Server.MapPath(".")); sealMg.DBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=|DataDirectory|seal.mdb"; //显示印章列表 if (sealMg.GetQueryCollection("").Count > 0) { flg = true; ShowList(sealMg); } else { flg = false; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowDelAll();</script>"); } } }
/// <summary> /// 删除印章 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { if (GridView1.Rows[e.RowIndex].Cells[0].Text != null && GridView1.Rows[e.RowIndex].Cells[0].Text.Trim().Length > 0) { string id = GridView1.Rows[e.RowIndex].Cells[0].Text.Trim(); PageOffice.ZoomSeal.SealManager sealMg = new PageOffice.ZoomSeal.SealManager(Server.MapPath(".")); sealMg.DBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=|DataDirectory|seal.mdb"; if (string.IsNullOrEmpty(id) || !sealMg.Exists(int.Parse(id))) { // Literal_JS.Text = "<script type='text/javascript'>alert('为获得印章的ID号,删除失败!');</script>"; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('未获得印章的ID号,删除失败!');</script>"); return; } if (sealMg.Delete(int.Parse(id))) { ShowList(sealMg); //Literal_JS.Text = "<script type='text/javascript'>alert('删除成功!');</script>"; if (sealMg.GetQueryCollection("").Count == 0) { flg = false; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowDelAll();alert('删除成功!');</script>"); Response.Redirect("seal.aspx"); } else { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('删除成功!');</script>"); Response.Redirect("seal.aspx"); } } else { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('删除失败!');</script>"); } } } catch (Exception ex) { // Literal_JS.Text = "<script type='text/javascript'>alert('删除失败!失败原因:" + ex.Message + "');</script>"; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('删除失败!失败原因:" + ex.Message + "');</script>"); return; } }
/// <summary> /// 显示印章列表 /// </summary> /// <param name="sealMg"></param> private void ShowList(PageOffice.ZoomSeal.SealManager sealMg) { GridView1.AutoGenerateColumns = false; GridView1.DataSource = sealMg.GetQueryCollection(" order by ID desc"); //GridView1.DataSource.ToString; //项 System.Diagnostics.Debug.WriteLine(sealMg.GetQueryCollection(" order by ID desc")[0].SealImage.Length); byte[] dt = sealMg.GetQueryCollection(" order by ID desc")[0].SealImage; string sValue = Convert.ToBase64String(dt); System.Diagnostics.Debug.WriteLine("sss"); sValue = "data:" + sealMg.GetQueryCollection(" order by ID desc")[0].SealImageType + ";base64," + sValue; System.Diagnostics.Debug.WriteLine(sValue); GridView1.DataBind(); }
/// <summary> /// 显示印章列表 /// </summary> /// <param name="sealMg"></param> private void ShowList(PageOffice.ZoomSeal.SealManager sealMg) { GridView1.AutoGenerateColumns = false; GridView1.DataSource = sealMg.GetQueryCollection(" order by ID desc"); GridView1.DataBind(); }
/// <summary> /// 添加印章 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddSeal_Click(object sender, EventArgs e) { if (Session["imageByte"] == null || Session["imageByte"].ToString() == "") { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('未获得上传图片路径,请重新上传!');</script>"); Image1.ImageUrl = null; return; } if (string.IsNullOrEmpty(txtSealName.Text)) { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('请输入印章名称!');</script>"); Image1.ImageUrl = null; return; } if (string.IsNullOrEmpty(txtSignerName.Text)) { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('请输入签章人姓名!');</script>"); Image1.ImageUrl = null; return; } bool flg = false; //标识是否添加了用户 false:没有;true 有 int userId = 0; //记录添加的用户Id PageOffice.ZoomSeal.SealManager sealManager = new PageOffice.ZoomSeal.SealManager(Server.MapPath(".")); sealManager.DBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=|DataDirectory|seal.mdb"; PageOffice.ZoomSeal.UserManager userManager = new PageOffice.ZoomSeal.UserManager(); userManager.DBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=|DataDirectory|seal.mdb"; PageOffice.ZoomSeal.Seal seal = new PageOffice.ZoomSeal.Seal(); try { seal.SealName = txtSealName.Text.Trim(); string signerName = txtSignerName.Text.Trim(); if (userManager.Exists(signerName) <= 0) { PageOffice.ZoomSeal.User user = new PageOffice.ZoomSeal.User(); user.DeptID = 1; user.DeptName = sealManager.GetLicOrg(); user.Password = "******"; user.UserName = signerName; userId = userManager.Add(user); if (userId <= 0) { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('用户添加失败!');</script>"); return; } else { flg = true;//标识为添加用户 } } seal.SignerID = userManager.Exists(signerName); seal.SignerName = signerName; seal.SealImage = (System.Byte[])Session["imageByte"]; seal.SealImageType = "image/" + Session["fileEx"]; seal.SealType = dropSealType.SelectedValue; seal.DeptID = 1; seal.DeptName = sealManager.GetLicOrg(); seal.AuthType = "密码"; int id = sealManager.Add(seal);//添加印章信息 if (id != -1) { sealManager.Grant(id);//颁发印章 flg = true; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script type='text/javascript'>ShowList();alert('印章添加成功!');</script>"); //ShowList(sealManager); Response.Redirect("seal.aspx"); txtSealName.Text = ""; txtSignerName.Text = ""; dropSealType.SelectedValue = "印章"; Image1.ImageUrl = ""; } else { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('印章添加失败!');</script>"); if (flg) { userManager.Delete(userId);//删除添加的用户 } return; } } catch (Exception ex) { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('印章添加失败!失败原因:" + ex.Message + "');</script>"); if (flg) { //删除添加的用户 if (!userManager.Delete(userId)) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('新添加的用户删除失败,请在数据库中手动删除!');</script>"); } } Image1.ImageUrl = ""; txtSealName.Text = ""; txtSignerName.Text = ""; dropSealType.SelectedValue = "印章"; return; } Image1.ImageUrl = ""; txtSealName.Text = ""; txtSignerName.Text = ""; dropSealType.SelectedValue = "印章"; }
/// <summary> /// 添加印章 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddSeal_Click(object sender, EventArgs e) { if (Session["imageByte"] == null || Session["imageByte"].ToString() == "") { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('未获得上传图片路径,请重新上传!');</script>"); Image1.ImageUrl = null; return; } if (string.IsNullOrEmpty(txtSealName.Text)) { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('请输入印章名称!');</script>"); Image1.ImageUrl = null; return; } if (string.IsNullOrEmpty(txtSignerName.Text)) { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('请输入签章人姓名!');</script>"); Image1.ImageUrl = null; return; } bool flg = false;//标识是否添加了用户 false:没有;true 有 int userId = 0;//记录添加的用户Id PageOffice.ZoomSeal.SealManager sealManager = new PageOffice.ZoomSeal.SealManager(Server.MapPath(".")); sealManager.DBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=|DataDirectory|seal.mdb"; PageOffice.ZoomSeal.UserManager userManager = new PageOffice.ZoomSeal.UserManager(); userManager.DBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=|DataDirectory|seal.mdb"; PageOffice.ZoomSeal.Seal seal = new PageOffice.ZoomSeal.Seal(); try { seal.SealName = txtSealName.Text.Trim(); string signerName = txtSignerName.Text.Trim(); if (userManager.Exists(signerName) <= 0) { PageOffice.ZoomSeal.User user = new PageOffice.ZoomSeal.User(); user.DeptID = 1; user.DeptName = sealManager.GetLicOrg(); user.Password = "******"; user.UserName = signerName; userId = userManager.Add(user); if (userId <= 0) { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('用户添加失败!');</script>"); return; } else { flg = true;//标识为添加用户 } } seal.SignerID = userManager.Exists(signerName); seal.SignerName = signerName; seal.SealImage = (System.Byte[])Session["imageByte"]; seal.SealImageType = "image/" + Session["fileEx"]; seal.SealType = dropSealType.SelectedValue; seal.DeptID = 1; seal.DeptName = sealManager.GetLicOrg(); seal.AuthType = "密码"; int id = sealManager.Add(seal);//添加印章信息 if (id != -1) { sealManager.Grant(id);//颁发印章 flg = true; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script type='text/javascript'>ShowList();alert('印章添加成功!');</script>"); ShowList(sealManager); txtSealName.Text = ""; txtSignerName.Text = ""; dropSealType.SelectedValue = "印章"; Image1.ImageUrl = ""; } else { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowAdd();alert('印章添加失败!');</script>"); if (flg) { userManager.Delete(userId);//删除添加的用户 } return; } } catch (Exception ex) { //防止层跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('印章添加失败!失败原因:" + ex.Message + "');</script>"); if (flg) { //删除添加的用户 if (!userManager.Delete(userId)) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('新添加的用户删除失败,请在数据库中手动删除!');</script>"); } } Image1.ImageUrl = ""; txtSealName.Text = ""; txtSignerName.Text = ""; dropSealType.SelectedValue = "印章"; return; } Image1.ImageUrl = ""; txtSealName.Text = ""; txtSignerName.Text = ""; dropSealType.SelectedValue = "印章"; }
protected void Page_Load(object sender, EventArgs e) { if (Session["userName"] == null || Session["userName"].ToString() == "" || Session["userPw"] == null || Session["userPw"].ToString() == "") { Response.Redirect("login.aspx"); } lblUserName.Text = Session["userName"].ToString(); lblNowTime.Text = DateTime.Now.ToString("yyyy/MM/dd"); if (!IsPostBack) { PageOffice.ZoomSeal.SealManager sealMg = new PageOffice.ZoomSeal.SealManager(Server.MapPath(".")); sealMg.DBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=|DataDirectory|seal.mdb"; //显示印章列表 if (sealMg.GetQueryCollection("").Count > 0) { flg = true; ShowList(sealMg); } else { flg = false; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowDelAll();</script>"); } } }
/// <summary> /// 删除印章 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { if (GridView1.Rows[e.RowIndex].Cells[0].Text != null && GridView1.Rows[e.RowIndex].Cells[0].Text.Trim().Length > 0) { string id = GridView1.Rows[e.RowIndex].Cells[0].Text.Trim(); PageOffice.ZoomSeal.SealManager sealMg = new PageOffice.ZoomSeal.SealManager(Server.MapPath(".")); sealMg.DBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=|DataDirectory|seal.mdb"; if (string.IsNullOrEmpty(id) || !sealMg.Exists(int.Parse(id))) { // Literal_JS.Text = "<script type='text/javascript'>alert('为获得印章的ID号,删除失败!');</script>"; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('未获得印章的ID号,删除失败!');</script>"); return; } if (sealMg.Delete(int.Parse(id))) { ShowList(sealMg); //Literal_JS.Text = "<script type='text/javascript'>alert('删除成功!');</script>"; if (sealMg.GetQueryCollection("").Count == 0) { flg = false; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ShowDelAll();alert('删除成功!');</script>"); } else { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('删除成功!');</script>"); } } else { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('删除失败!');</script>"); } } } catch (Exception ex) { // Literal_JS.Text = "<script type='text/javascript'>alert('删除失败!失败原因:" + ex.Message + "');</script>"; ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('删除失败!失败原因:" + ex.Message + "');</script>"); return; } }