Example #1
0
 private void BindShow(int Id)
 {
     this.labTitle.Text = "邮件组审核";
     Tz888.Model.Mail.Mialgroup model = bll.GetModel(Id);
     txtName.Text       = model.groupname.Trim();
     txtdesctption.Text = model.groupremark.Trim();
     showshenhes.Attributes.Add("style", "display:block");
     this.radiocaozuo.Items.FindByValue(model.Audit.ToString().Trim()).Selected = true;
 }
Example #2
0
 protected void btnSave_Click(object sender, EventArgs e)
 {
     if (Id == 0)
     {
         Tz888.Model.Mail.Mialgroup model = new Tz888.Model.Mail.Mialgroup();
         if (txtName.Text.Trim() == "")
         {
             Response.Write("<script>alert('请输入组名称!')</script>");
             return;
         }
         model.groupname   = txtName.Text.Trim();
         model.groupremark = txtdesctption.Text.Trim();
         model.Audit       = 1;
         int result = bll.Add(model);
         if (result > 0)
         {
             Response.Redirect("MialGroupManage.aspx");
         }
         else
         {
             Response.Write("<script>alert('已经存在该组!')</script>");
         }
     }
     else
     {
         Tz888.Model.Mail.Mialgroup model = new Tz888.Model.Mail.Mialgroup();
         if (txtName.Text.Trim() == "")
         {
             Response.Write("<script>alert('请输入组名称!')</script>");
             return;
         }
         model.groupname   = txtName.Text.Trim();
         model.groupremark = txtdesctption.Text.Trim();
         model.Audit       = Convert.ToInt32(this.radiocaozuo.SelectedValue);
         model.groupID     = Id;
         int result = bll.Update(model);
         if (result > 0)
         {
             Response.Redirect("MialGroupManage.aspx");
         }
         else
         {
             Response.Write("<script>alert('已经存在该组名称,请重命名组名称!')</script>");
         }
     }
 }
Example #3
0
    protected void btnDaoChu_Click(object sender, EventArgs e)
    {
        List <Tz888.Model.Mail.MailInfo> list = mailinfobll.GetModelList(par);

        dt.Rows.Clear();
        foreach (Tz888.Model.Mail.MailInfo model in list)
        {
            DataRow dr = dt.NewRow();
            //单位名称  联系人 手机  电话  邮箱  类型 职位
            // dr["编号"] = model .UserID;
            //dr["账号"] = model.LoginName;
            dr["名称"]   = model.UserName;
            dr["公司名称"] = model.PanyName;
            Tz888.Model.Mail.Position modelpo = positionbll.GetModel(Convert.ToInt32(model.PositionId));
            if (modelpo != null)
            {
                dr["职位"] = modelpo.Name;
                //dr["地址"] = model.Address;
                //dr["网址"] = model.LinkUrl;
                Tz888.Model.Mail.MailType modeltype = mailtypebll.GetModel(Convert.ToInt32(model.typeID));
                string type = modeltype.TypeName.Trim();
                dr["类型"] = type;
                string diyu = "";
                Tz888.Model.Mail.Province modelp = provincebll.GetModel(Convert.ToInt32(model.ProvinceId));
                Tz888.Model.Mail.City     modelc = citybll.GetModel(Convert.ToInt32(model.CityId));
                if (modelc != null)
                {
                    diyu = modelp.Name + ": " + modelc.Name;
                }
                else
                {
                    diyu = modelp.Name;
                }
                // dr["地域"] = diyu;
                if (Convert.ToInt32(model.industry) != -1)
                {
                    Tz888.Model.Mail.Industry modelIndustry = industrybll.GetModel(Convert.ToInt32(model.industry));
                    string xingye = modelIndustry.Name.Trim();
                    //  dr["行业"] = xingye;
                }
                else   //dr["行业"] = "所有行业";
                {
                }
                // string statue = "";
                // if (model.audit == 0)
                //{
                //  statue = "未审核";
                //}
                //else { statue = "已审核"; }
                //dr["状态"] = statue;
                dr["邮件"] = model.Mial;
                dr["手机"] = model.Mobile;
                Tz888.Model.Mail.Mialgroup modelpr = mialgroupbll.GetModel(Convert.ToInt32(model.groupID));
                // dr["组"] = modelpr.groupname;
                // dr["备注"] = model.remark;
                //dr["时间"] = model.Mdatetime;
                //dr["操作"] = "";

                dt.Rows.Add(dr);
            }
        }

        HSSFWorkbook hssfworkbook      = new HSSFWorkbook();
        DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();

        dsi.Company = "深圳拓富投资有限公司";
        SummaryInformation si = PropertySetFactory.CreateSummaryInformation();

        si.Subject = "邮件用户管理";
        si.Author  = "颜品庄";

        si.CreateDateTime = DateTime.Now;
        hssfworkbook.DocumentSummaryInformation = dsi;
        hssfworkbook.SummaryInformation         = si;

        HSSFSheet sheet1 = hssfworkbook.CreateSheet("Sheet1");
        //sheet1.DefaultColumnWidth=10;设置列宽
        HSSFRow row = sheet1.CreateRow(0);

        // row.CreateCell(0).SetCellValue("编号");
        // row.CreateCell(1).SetCellValue("账号");
        row.CreateCell(0).SetCellValue("名称");
        row.CreateCell(1).SetCellValue("公司名称");
        row.CreateCell(2).SetCellValue("职位");
        // row.CreateCell(5).SetCellValue("地址");
        //  row.CreateCell(6).SetCellValue("网址");
        row.CreateCell(3).SetCellValue("类型");
        // row.CreateCell(8).SetCellValue("地域");
        // row.CreateCell(9).SetCellValue("行业");
        // row.CreateCell(10).SetCellValue("状态");
        row.CreateCell(4).SetCellValue("邮件");
        row.CreateCell(5).SetCellValue("手机");
        // row.CreateCell(13).SetCellValue("组");
        //  row.CreateCell(14).SetCellValue("备注");
        //row.CreateCell(6).SetCellValue("时间");
        // row.CreateCell(16).SetCellValue("操作");

        for (int i = 0; i < dt.Rows.Count; i++)
        {
            HSSFRow row0 = sheet1.CreateRow(i + 1);
            // row0.CreateCell(0).SetCellValue(dt.Rows[i]["编号"].ToString());
            // row0.CreateCell(1).SetCellValue(dt.Rows[i]["账号"].ToString());
            row0.CreateCell(0).SetCellValue(dt.Rows[i]["名称"].ToString());
            row0.CreateCell(1).SetCellValue(dt.Rows[i]["公司名称"].ToString());
            row0.CreateCell(2).SetCellValue(dt.Rows[i]["职位"].ToString());
            //row0.CreateCell(5).SetCellValue(dt.Rows[i]["地址"].ToString());
            //row0.CreateCell(6).SetCellValue(dt.Rows[i]["网址"].ToString());
            row0.CreateCell(3).SetCellValue(dt.Rows[i]["类型"].ToString());
            //row0.CreateCell(8).SetCellValue(dt.Rows[i]["地域"].ToString());
            //row0.CreateCell(9).SetCellValue(dt.Rows[i]["行业"].ToString());
            //row0.CreateCell(10).SetCellValue(dt.Rows[i]["状态"].ToString());
            row0.CreateCell(4).SetCellValue(dt.Rows[i]["邮件"].ToString());
            row0.CreateCell(5).SetCellValue(dt.Rows[i]["手机"].ToString());
            //row0.CreateCell(13).SetCellValue(dt.Rows[i]["组"].ToString());
            //row0.CreateCell(14).SetCellValue(dt.Rows[i]["备注"].ToString());
            //row0.CreateCell(15).SetCellValue(dt.Rows[i]["时间"].ToString());
            // row0.CreateCell(6).SetCellValue(dt.Rows[i]["操作"].ToString());
        }
        string t1 = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString();

        string filename = "attachment;filename=" + System.Web.HttpUtility.UrlEncode("邮件用户表" + t1, System.Text.Encoding.UTF8) + ".xls";

        Response.ContentType = "application/vnd.ms-excel";
        //Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", filename));
        Response.AppendHeader("Content-Disposition", filename);
        Response.Clear();

        //Write the stream data of workbook to the root directory
        MemoryStream filestream = new MemoryStream();

        hssfworkbook.Write(filestream);

        Response.BinaryWrite(filestream.GetBuffer());
        Response.End();
    }