コード例 #1
0
 void EditPub(int id)
 {
     excelMod         = excelBll.SelReturnModel(id);
     TableName_T.Text = excelMod.TableName;
     CNames_T.Text    = excelMod.CNames;
     Fields_T.Text    = excelMod.Fields;
     ID_Hid.Value     = excelMod.ID.ToString();
     function.Script(this, "ShowModel();");
 }
コード例 #2
0
 protected void Add_Btn_Click(object sender, EventArgs e)
 {
     excelMod = FillMod();
     if (!string.IsNullOrEmpty(ID_Hid.Value))
     {
         excelBll.UpdateByID(excelMod);
     }
     else
     {
         excelBll.Insert(excelMod);
     }
     MyBind();
 }
コード例 #3
0
        private M_Pub_Excel FillMod()
        {
            M_Pub_Excel model = new M_Pub_Excel();

            if (!string.IsNullOrEmpty(ID_Hid.Value))
            {
                model = excelBll.SelReturnModel(Convert.ToInt32(ID_Hid.Value));
            }
            model.TableName  = TableName_T.Text;
            model.CNames     = CNames_T.Text;
            model.Fields     = Fields_T.Text;
            model.UserID     = badmin.GetAdminLogin().AdminId;
            model.CreateTime = DateTime.Now;
            return(model);
        }
コード例 #4
0
        protected void DownExcel_Btn_Click(object sender, EventArgs e)
        {
            M_Pub_Excel excelMod = new M_Pub_Excel();
            B_Pub_Excel excelBll = new B_Pub_Excel();
            M_Pub       pubinfo  = pub.GetSelect(PubID);

            excelMod = excelBll.SelByTbName(pubinfo.PubTableName);
            if (excelMod == null)
            {
                function.WriteErrMsg("尚未为表:" + pubinfo.PubTableName + "指定导出规则,请先<a href='PubExcel.aspx?mid=" + pubinfo.PubModelID + "'>点此设定导出规则</a>");
            }
            OfficeHelper ofHelper = new OfficeHelper();

            SafeC.DownStr(ofHelper.GetExcelByDT(GetDT(), excelMod.Fields, excelMod.CNames), DateTime.Now.ToString("yyyyMMdd") + "互动信息.xls", Encoding.Default);
        }
コード例 #5
0
        //Excel下载
        protected void DownExcel_Btn_Click(object sender, EventArgs e)
        {
            M_Pub_Excel excelMod = new M_Pub_Excel();
            B_Pub_Excel excelBll = new B_Pub_Excel();
            int         pubid    = Convert.ToInt32(Request.QueryString["PubID"]);
            M_Pub       pubinfo  = pub.GetSelect(pubid);

            excelMod = excelBll.SelByTbName(pubinfo.PubTableName);
            if (excelMod == null)
            {
                function.WriteErrMsg("尚未为表:" + pubinfo.PubTableName + "指定导出规则,请先<a href='PubExcel.aspx'>点此设定导出规则</a>");
            }
            OfficeHelper ofHelper = new OfficeHelper();

            SafeSC.DownStr(ofHelper.GetExcelByDT(GetDT(), excelMod.Fields, excelMod.CNames), "互动回复.xls");
        }