Exemplo n.º 1
0
        /// <summary>
        /// ɾ��
        /// </summary>
        /// <returns></returns>
        public bool Delete()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                //��ɾ��ѡ��
                String sql_option = "delete from JpVoteOptions where id=@id ";
                SqlParameter[] sqlparam_option = {
                    db.MakeInParam("@id",SqlDbType.Int,id),
                };
                db.Execute(sql_option, sqlparam_option);

                String sql = "delete from JpVote where id=@id ";
                SqlParameter[] sqlparam = {
                    db.MakeInParam("@id",SqlDbType.Int,id),
                };
                db.Execute(sql, sqlparam);

            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 2
0
        /// <summary>
        /// 插入
        /// </summary>
        /// <returns></returns>
        public bool Insert()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sqlInsert = " insert into hy_verifycode(hy_tel,hy_code,hy_addtime)  values (@hy_tel,@hy_code,@hy_addtime)";
                SqlParameter[] sqlparam = {db.MakeInParam("@hy_addtime",SqlDbType.DateTime,hy_addtime),
                                              db.MakeInParam("@hy_tel",SqlDbType.VarChar,hy_tel),
                                              db.MakeInParam("@hy_code",SqlDbType.VarChar,hy_code)
                                         };
                db.Execute(sqlInsert, sqlparam);
            }
            catch (Exception ex)
            {
                throw ex;
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 3
0
        /// <summary>
        /// ɾ��
        /// </summary>
        /// <returns></returns>
        public bool Delete()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sql = "delete from JpDepts where deptid=@deptid ";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@deptid",SqlDbType.VarChar,deptid),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 4
0
        /// <summary>
        /// ɾ��ij��Ŀ�����й���
        /// </summary>
        /// <returns></returns>
        public bool DeleteBycid(string cid)
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                string sql = " delete JpColumnRelations where cid=@cid ";
                SqlParameter[] sqlparam = {
                    db.MakeInParam("@cid",SqlDbType.VarChar,cid),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 5
0
        /// <summary>
        /// ɾ��
        /// </summary>
        /// <returns></returns>
        public bool Delete()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sql = "delete from JpOpinionHF where id=@id ";
                SqlParameter[] sqlparam = {
                    db.MakeInParam("@id",SqlDbType.Int,id),
                };
                db.Execute(sql, sqlparam);

            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 6
0
        /// <summary>
        /// ɾ�����
        /// </summary>
        /// <returns></returns>
        public bool DeleteAll(string uids)
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sql = "delete from JpStudents where @uid like '%,'+uid+',%'";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@uid",SqlDbType.VarChar,uids),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 7
0
        /// <summary>
        /// 删除
        /// </summary>
        /// <returns></returns>
        public bool Delete()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                //先删除选项
                String sql_option = "delete from hy_guidepage where id=@id ";
                SqlParameter[] sqlparam_option = {
                    db.MakeInParam("@id",SqlDbType.Int,id),
                };
                db.Execute(sql_option, sqlparam_option);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 8
0
        /// <summary>
        /// ɾ��
        /// </summary>
        /// <returns></returns>
        public bool Delete()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                string sql = "delete from JpTemplate where url=@url ";
                SqlParameter[] sqlparam = {
                    db.MakeInParam("@url",SqlDbType.VarChar,url),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 9
0
    //提交
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (this.Session["uid"] == null || this.Session["uid"].ToString() == "")
        {
            this.Response.Redirect("../login.aspx");
        }

        string ls_tip = "审核成功!";

        TPortalClass.JpActivity JpActivity = new TPortalClass.JpActivity();
        TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
        TPortalClass.DAO db = new TPortalClass.DAO();
        string sql_cg = "update hy_activity set hy_ifsh=2 where id=" + System.Int32.Parse(this.txtid.Value) + "";
        db.Execute(sql_cg);
        //写系统日志
        string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
        if (userip == null || userip == "")
        {
            userip = Request.ServerVariables["REMOTE_ADDR"];
        }
        JpCommon.WriteLog(userip, "审核", "审核活动记录[id:" + this.txtid.Value + "]", Session["uid"].ToString(), Session["uname"].ToString());
        JpActivity.Update();

        Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
    }
Exemplo n.º 10
0
    //受理
    protected void btnDeal_Click(object sender, EventArgs e)
    {
        TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
        TPortalClass.JpAdver JpAdver = new TPortalClass.JpAdver();
        string ls_tip = "受理成功!";
        for (int i = 0; i < rptList.Items.Count; i++)
        {
            string id = ((HiddenField)rptList.Items[i].FindControl("hidId")).Value;
            CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
            if (cb.Checked)
            {
                TPortalClass.DAO db = new DAO();
                string sql = "update hy_help set hy_ifsh=1 where id=" + int.Parse(id) + "";
                db.Execute(sql);
            }
        }
        string pageUrl = JpCommon.CombUrlTxt("list_help_sh.aspx", "page={0}&rnd={1}",
            "" + this.txtPage.Text + "", "" + System.Guid.NewGuid().ToString() + "");

        //写系统日志

        string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
        if (userip == null || userip == "")
        {
            userip = Request.ServerVariables["REMOTE_ADDR"];
        }
        JpCommon.WriteLog(userip, "审核", "批量受理帮办记录", Session["uid"].ToString(), Session["uname"].ToString());
        Response.Write("<script>alert('" + ls_tip + "');window.location='" + pageUrl + "';</script>");
    }
Exemplo n.º 11
0
 //答复
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     if (this.Session["uid"] == null || this.Session["uid"].ToString() == "")
     {
         this.Response.Redirect("../login.aspx");
     }
     string ls_tip = "答复成功!";
     TPortalClass.DAO db = new TPortalClass.DAO();
     TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
     string ls_ = txthy_reply.Text;
     int ls_hy_ifsh = 2;
     //写系统日志
     string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
     if (userip == null || userip == "")
     {
         userip = Request.ServerVariables["REMOTE_ADDR"];
     }
     JpCommon.WriteLog(userip, "答复", "答复求助记录[id:" + this.txtid.Value + "]", Session["uid"].ToString(), Session["uname"].ToString());
     string sql_Update = "  UPDATE  hy_help SET";
     sql_Update += "   hy_reply  ='" + txthy_reply.Text + "'";
     sql_Update += " , hy_replytime ='" + DateTime.Now.ToString("yyyy-MM-dd") + "'";
     sql_Update += " , hy_ifsh =" + ls_hy_ifsh + "   where id=" + Convert.ToInt32(txtid.Value.Trim()) + "";
     db.Execute(sql_Update);
     Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
 }
Exemplo n.º 12
0
        public bool Update()
        {
            bool ret = true;
            DAO db = new DAO();
            try
            {
                String sql = "UPDATE JpPubHtml SET pages=@pages,days=@days,status=@status where id=@id";
                SqlParameter[] sqlparam = {
                    db.MakeInParam("@id",SqlDbType.VarChar,id),
                    db.MakeInParam("@pages",SqlDbType.VarChar,pages),
                    db.MakeInParam("@days",SqlDbType.VarChar,days),
                    db.MakeInParam("@status",SqlDbType.VarChar,status),
                };
                db.Execute(sql, sqlparam);

            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 13
0
        public bool Insert()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                string sql = " insert into JpPubHtml(id,pages,days,status) values (@id,@pages,@days,@status)";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@id",SqlDbType.VarChar,id),
                    db.MakeInParam("@pages",SqlDbType.VarChar,pages),
                    db.MakeInParam("@days",SqlDbType.VarChar,days),
                    db.MakeInParam("@status",SqlDbType.VarChar,status),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 14
0
        public bool DeleteImg(string id)
        {
            bool ret = true;
            DAO db = new DAO();
            try
            {
                string sql = "delete from hy_fileatt where  id=@id  ";
                SqlParameter[] sqlparam = new SqlParameter[]
                {
                    db.MakeInParam("@id", SqlDbType.VarChar, id)
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 15
0
 //ɾ��
 public void DeleteAll(String ids)
 {
     DAO db = new DAO();
     String sql = "Delete FROM JpNews where @aids like '%,'+cast(aid as varchar(12))+',%'";
     SqlParameter[] prams ={
         db.MakeInParam("@aids", SqlDbType.VarChar, ids)
     };
     db.Execute(sql, prams);
     db.Close();
 }
Exemplo n.º 16
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.CacheControl = "no-cache";

        string ls_update = "";
        string ls_filename = "";
        string ls_path = "";
        string ls_id = Request.Form["id"].ToString();

        //string lshy_fatherfield = Request.Form["txtcurloginuserid"].ToString();
        //string lshy_fatherid = Request.Form["fatherid"].ToString();
        //string hy_userid = Request.Form["userid"].ToString();
             //Request.Params["fatherid"].ToString()+"\\"+Request.Params["fatherfield"].ToString();

                //string Datedir = DateTime.Now.ToString("yy-MM-dd");
                //string updir = s_rpath + "\\" + Datedir;
                //string updir = s_rpath;
        if (Request.Files["file"].ContentLength > 0)
        {
            try
            {
                string updir = Server.MapPath("~/") + "upload\\original\\rytx\\";
                DAO db = new DAO();
                DataTable dt = new DataTable();
                HttpPostedFile uploadFile = Request.Files["file"];

                //if (uploadFile.ContentLength > 0)
                //{
                    if (!Directory.Exists(updir))
                    {
                        Directory.CreateDirectory(updir);
                    }
                    //string extname = Path.GetExtension(uploadFile.FileName);

                    //string filename = uploadFile.FileName;
                    //lsfilename = filename;
                    //lsurl = "fileatt\\" + filename; //存放的文件夹
                    //uploadFile.SaveAs(string.Format("{0}\\{1}", updir, filename));

                    ls_filename = ls_id + ".jpg";
                    uploadFile.SaveAs(updir + ls_filename);
                    ls_path = "upload\\original\\rytx\\" + ls_filename;
                    string sql_user = "******" + ls_path + "' ";
                    sql_user += " where hy_id='" + ls_id + "'";
                    db.Execute(sql_user);

                //}
            }
            catch (Exception ex)
            {
                Response.Write("Message"+ ex.ToString());
            }
        }
    }
Exemplo n.º 17
0
        public void DeleteAll(String cid)
        {
            DAO db = new DAO();
            String sql = "Delete FROM JpColumnsStyle where cid=@cid ";
            SqlParameter[] prams ={
                db.MakeInParam("@cid", SqlDbType.VarChar, cid)
            };

            db.Execute(sql, prams);
            db.Close();
        }
Exemplo n.º 18
0
        public Int32 Insert()
        {
            try
            {
                String sql = "INSERT INTO JpNews(cid,kcid,title,subhead,content,authorid,author,status,crtime,modtime,pubtime,hits,GUID)";
                sql += " VALUES(@cid,@kcid,@title,@subhead,@content,@authorid,@author,@status,getdate(),getdate(),getdate(),0,@GUID)";
                GUID = System.Guid.NewGuid().ToString();
                DAO db = new DAO();
                SqlParameter[] prams ={
                db.MakeInParam("@cid",SqlDbType.VarChar,cid),
                db.MakeInParam("@kcid",SqlDbType.VarChar,kcid),
                db.MakeInParam("@title",SqlDbType.VarChar,title),
                db.MakeInParam("@subhead",SqlDbType.VarChar,subhead),
                db.MakeInParam("@content",SqlDbType.VarChar,content),
                db.MakeInParam("@authorid",SqlDbType.VarChar,authorid),
                db.MakeInParam("@author",SqlDbType.VarChar,author),
                db.MakeInParam("@status",SqlDbType.VarChar,status),
                db.MakeInParam("@GUID",SqlDbType.VarChar,GUID),
            };
                db.Execute(sql, prams);

                db.Close();
                sql = "Select aid from JpNews where GUID=@GUID";
                SqlParameter[] prams1 ={
                db.MakeInParam("@GUID",SqlDbType.VarChar,GUID),
            };
                DataTable dt = db.GetDataTable(sql, prams1);
                if (dt.Rows.Count > 0)
                {
                    this.aid = System.Int32.Parse(dt.Rows[0]["aid"].ToString());
                }
                return aid;
            }
            catch
            {
                return -2;
            }
            finally
            {

            }
        }
Exemplo n.º 19
0
 /// <summary>
 /// ɾ�����
 /// roleids��ʽ��,1111,2222,33333,
 /// </summary>
 /// <returns></returns>
 public bool DeleteAll(string roleids)
 {
     bool ret = true;
     String sql = "delete from JpRole where @hy_roleid like '%,'+hy_roleid+',%'";
     DAO db = new DAO();
     SqlParameter[] prams ={
             db.MakeInParam("@hy_roleid",SqlDbType.VarChar,roleids),
         };
     try
     {
         db.Execute(sql, prams);
     }
     catch
     {
         ret = false;
     }
     finally
     {
         db.Close();
         db.Dispose();
     }
     return ret;
 }
Exemplo n.º 20
0
        //ɾ����ɫ�е���Ա
        public bool Delete(string groupid,string uid)
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sql = " delete from JpGroupUser ";
                sql += " where groupid='" + groupid + "'";
                sql += " and uid='" + uid + "'";
                db.Execute(sql);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 21
0
        /// <summary>
        /// ɾ������
        /// </summary>
        /// <returns></returns>
        public bool Delete()
        {
            bool ret = true;

            String sql = "delete from JpLog where ID=@ID ";
            DAO db = new DAO();
            SqlParameter[] prams ={
                    db.MakeInParam("@ID",SqlDbType.VarChar,ID),
                };
            try
            {
                db.Execute(sql, prams);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 22
0
        /// <summary>
        /// ɾ������
        /// </summary>
        /// <returns></returns>
        public bool DeleteByDate(String hits_date)
        {
            bool ret = true;

            String sql = "delete from JpHits where hits_date=@hits_date ";
            DAO db = new DAO();
            SqlParameter[] prams ={
                    db.MakeInParam("@hits_date",SqlDbType.VarChar,hits_date),
                };
            try
            {
                db.Execute(sql, prams);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 23
0
        /// <summary>
        /// ɾ������
        /// </summary>
        /// <returns></returns>
        public bool DeleteById(String id)
        {
            bool ret = true;

            String sql = "delete from JpHits where id=@id ";
            DAO db = new DAO();
            SqlParameter[] prams ={
                    db.MakeInParam("@id",SqlDbType.VarChar,id),
                };
            try
            {
                db.Execute(sql, prams);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 24
0
        /// <summary>
        /// ���
        /// </summary>
        /// <returns></returns>
        public bool Insert()
        {
            bool ret = true;

            String sql = "insert into JpLog(ID,hy_createtime,hy_oppip,hy_opptype,hy_oppcontent,hy_oppuserid,hy_oppusername) values ";
            sql += "(@ID,@hy_createtime,@hy_oppip,@hy_opptype,@hy_oppcontent,@hy_oppuserid,@hy_oppusername) ";
            DAO db = new DAO();
            SqlParameter[] prams ={
                    db.MakeInParam("@ID",SqlDbType.VarChar,ID),
                    db.MakeInParam("@hy_createtime",SqlDbType.VarChar,hy_createtime),
                    db.MakeInParam("@hy_oppip",SqlDbType.VarChar,hy_oppip),
                    db.MakeInParam("@hy_opptype",SqlDbType.VarChar,hy_opptype),
                    db.MakeInParam("@hy_oppcontent",SqlDbType.VarChar,hy_oppcontent),
                    db.MakeInParam("@hy_oppuserid",SqlDbType.VarChar,hy_oppuserid),
                    db.MakeInParam("@hy_oppusername",SqlDbType.VarChar,hy_oppusername),
                };
            try
            {
                db.Execute(sql, prams);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 25
0
        /// <summary>
        /// ���Ʋɼ�
        /// </summary>
        /// <returns></returns>
        public bool Copydoc()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                string sql = "insert into JpCollect (ItemName,ClassId,WebEncode,WebName,WebUrl,ItemRemark,Script_Iframe";
                sql += ",Script_Object,Script_Script,Script_Div,Script_Table,Script_Span,Script_Img,Script_Font";
                sql += ",Script_A,Script_Html,IsSaveImg,IsDesc,CollecNum,ListUrl,ListStart";
                sql += ",ListEnd,LinkStart,LinkEnd,TitleStart,TitleEnd,RemoveTitle,KeyWordStart";
                sql += ",KeyWordEnd,DateStart,DateEnd,SourceStart,SourceEnd,ContentStart,ContentEnd";
                sql += ",RemoveBodyStart,RemoveBodyEnd,NextPageRegex) values (";
                sql += "@ItemName,@ClassId,@WebEncode,@WebName,@WebUrl,@ItemRemark,@Script_Iframe";
                sql += ",@Script_Object,@Script_Script,@Script_Div,@Script_Table,@Script_Span,@Script_Img,@Script_Font";
                sql += ",@Script_A,@Script_Html,@IsSaveImg,@IsDesc,@CollecNum,@ListUrl,@ListStart";
                sql += ",@ListEnd,@LinkStart,@LinkEnd,@TitleStart,@TitleEnd,@RemoveTitle,@KeyWordStart";
                sql += ",@KeyWordEnd,@DateStart,@DateEnd,@SourceStart,@SourceEnd,@ContentStart,@ContentEnd";
                sql += ",@RemoveBodyStart,@RemoveBodyEnd,@NextPageRegex";
                sql += ")";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@ItemName",SqlDbType.VarChar,ItemName),
                    db.MakeInParam("@ClassId",SqlDbType.VarChar,ClassId),
                    db.MakeInParam("@WebEncode",SqlDbType.VarChar,WebEncode),
                    db.MakeInParam("@WebName",SqlDbType.VarChar,WebName),
                    db.MakeInParam("@WebUrl",SqlDbType.VarChar,WebUrl),
                    db.MakeInParam("@ItemRemark",SqlDbType.VarChar,ItemRemark),
                    db.MakeInParam("@Script_Iframe",SqlDbType.Int,Script_Iframe),
                    db.MakeInParam("@Script_Object",SqlDbType.Int,Script_Object),
                    db.MakeInParam("@Script_Script",SqlDbType.Int,Script_Script),
                    db.MakeInParam("@Script_Div",SqlDbType.Int,Script_Div),
                    db.MakeInParam("@Script_Table",SqlDbType.Int,Script_Table),
                    db.MakeInParam("@Script_Span",SqlDbType.Int,Script_Span),
                    db.MakeInParam("@Script_Img",SqlDbType.Int,Script_Img),
                    db.MakeInParam("@Script_Font",SqlDbType.Int,Script_Font),
                    db.MakeInParam("@Script_A",SqlDbType.Int,Script_A),
                    db.MakeInParam("@Script_Html",SqlDbType.Int,Script_Html),
                    db.MakeInParam("@IsSaveImg",SqlDbType.Int,IsSaveImg),
                    db.MakeInParam("@IsDesc",SqlDbType.Int,IsDesc),
                    db.MakeInParam("@CollecNum",SqlDbType.Int,CollecNum),
                    db.MakeInParam("@ListUrl",SqlDbType.VarChar,ListUrl),
                    db.MakeInParam("@ListStart",SqlDbType.VarChar,ListStart),
                    db.MakeInParam("@ListEnd",SqlDbType.VarChar,ListEnd),
                    db.MakeInParam("@LinkStart",SqlDbType.VarChar,LinkStart),
                    db.MakeInParam("@LinkEnd",SqlDbType.VarChar,LinkEnd),
                    db.MakeInParam("@TitleStart",SqlDbType.VarChar,TitleStart),
                    db.MakeInParam("@TitleEnd",SqlDbType.VarChar,TitleEnd),
                    db.MakeInParam("@RemoveTitle",SqlDbType.VarChar,RemoveTitle),
                    db.MakeInParam("@KeyWordStart",SqlDbType.VarChar,KeyWordStart),
                    db.MakeInParam("@KeyWordEnd",SqlDbType.VarChar,KeyWordEnd),
                    db.MakeInParam("@DateStart",SqlDbType.VarChar,DateStart),
                    db.MakeInParam("@DateEnd",SqlDbType.VarChar,DateEnd),
                    db.MakeInParam("@SourceStart",SqlDbType.VarChar,SourceStart),
                    db.MakeInParam("@SourceEnd",SqlDbType.VarChar,SourceEnd),
                    db.MakeInParam("@ContentStart",SqlDbType.VarChar,ContentStart),
                    db.MakeInParam("@ContentEnd",SqlDbType.VarChar,ContentEnd),
                    db.MakeInParam("@RemoveBodyStart",SqlDbType.VarChar,RemoveBodyStart),
                    db.MakeInParam("@RemoveBodyEnd",SqlDbType.VarChar,RemoveBodyEnd),
                    db.MakeInParam("@NextPageRegex",SqlDbType.VarChar,NextPageRegex),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 26
0
        /// <summary>
        /// �޸IJɼ����ݲ���
        /// </summary>
        /// <returns></returns>
        public bool UpdateCjnrcs()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sql = "update JpCollect set State='0' where Id=@Id";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@Id",SqlDbType.Int,Id),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 27
0
        /// <summary>
        /// �޸IJɼ�����
        /// </summary>
        /// <returns></returns>
        public bool UpdateCjnr()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sql = "update JpCollect set TitleStart=@TitleStart,TitleEnd=@TitleEnd,RemoveTitle=@RemoveTitle";
                sql += ",KeyWordStart=@KeyWordStart,KeyWordEnd=@KeyWordEnd,DateStart=@DateStart,DateEnd=@DateEnd";
                sql += ",SourceStart=@SourceStart,SourceEnd=@SourceEnd,ContentStart=@ContentStart,ContentEnd=@ContentEnd";
                sql += ",RemoveBodyStart=@RemoveBodyStart,RemoveBodyEnd=@RemoveBodyEnd,NextPageRegex=@NextPageRegex";
                sql += " where Id=@Id";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@Id",SqlDbType.Int,Id),
                    db.MakeInParam("@TitleStart",SqlDbType.VarChar,TitleStart),
                    db.MakeInParam("@TitleEnd",SqlDbType.VarChar,TitleEnd),
                    db.MakeInParam("@RemoveTitle",SqlDbType.VarChar,RemoveTitle),
                    db.MakeInParam("@KeyWordStart",SqlDbType.VarChar,KeyWordStart),
                    db.MakeInParam("@KeyWordEnd",SqlDbType.VarChar,KeyWordEnd),
                    db.MakeInParam("@DateStart",SqlDbType.VarChar,DateStart),
                    db.MakeInParam("@DateEnd",SqlDbType.VarChar,DateEnd),
                    db.MakeInParam("@SourceStart",SqlDbType.VarChar,SourceStart),
                    db.MakeInParam("@SourceEnd",SqlDbType.VarChar,SourceEnd),
                    db.MakeInParam("@ContentStart",SqlDbType.VarChar,ContentStart),
                    db.MakeInParam("@ContentEnd",SqlDbType.VarChar,ContentEnd),
                    db.MakeInParam("@RemoveBodyStart",SqlDbType.VarChar,RemoveBodyStart),
                    db.MakeInParam("@RemoveBodyEnd",SqlDbType.VarChar,RemoveBodyEnd),
                    db.MakeInParam("@NextPageRegex",SqlDbType.VarChar,NextPageRegex),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 28
0
        /// <summary>
        /// �޸IJɼ��б�����
        /// </summary>
        /// <returns></returns>
        public bool UpdateCjlblj()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sql = "update JpCollect set LinkStart=@LinkStart,LinkEnd=@LinkEnd";
                sql += " where Id=@Id";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@Id",SqlDbType.Int,Id),
                    db.MakeInParam("@LinkStart",SqlDbType.VarChar,LinkStart),
                    db.MakeInParam("@LinkEnd",SqlDbType.VarChar,LinkEnd),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 29
0
        /// <summary>
        /// �޸IJɼ�������Ϣ
        /// </summary>
        /// <returns></returns>
        public bool UpdateCjjbxx()
        {
            bool ret = true;
            DAO db = new DAO();

            try
            {
                String sql = "update JpCollect set ItemName=@ItemName,ClassId=@ClassId,WebEncode=@WebEncode";
                sql += ",WebName=@WebName,WebUrl=@WebUrl,ItemRemark=@ItemRemark";
                sql += ",Script_Iframe=@Script_Iframe,Script_Object=@Script_Object,Script_Script=@Script_Script";
                sql += ",Script_Div=@Script_Div,Script_Table=@Script_Table,Script_Span=@Script_Span";
                sql += ",Script_Img=@Script_Img,Script_Font=@Script_Font,Script_A=@Script_A";
                sql += ",Script_Html=@Script_Html,IsSaveImg=@IsSaveImg,IsDesc=@IsDesc";
                sql += ",CollecNum=@CollecNum where Id=@Id";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@Id",SqlDbType.Int,Id),
                    db.MakeInParam("@ItemName",SqlDbType.VarChar,ItemName),
                    db.MakeInParam("@ClassId",SqlDbType.VarChar,ClassId),
                    db.MakeInParam("@WebEncode",SqlDbType.VarChar,WebEncode),
                    db.MakeInParam("@WebName",SqlDbType.VarChar,WebName),
                    db.MakeInParam("@WebUrl",SqlDbType.VarChar,WebUrl),
                    db.MakeInParam("@ItemRemark",SqlDbType.VarChar,ItemRemark),
                    db.MakeInParam("@Script_Iframe",SqlDbType.Int,Script_Iframe),
                    db.MakeInParam("@Script_Object",SqlDbType.Int,Script_Object),
                    db.MakeInParam("@Script_Script",SqlDbType.Int,Script_Script),
                    db.MakeInParam("@Script_Div",SqlDbType.Int,Script_Div),
                    db.MakeInParam("@Script_Table",SqlDbType.Int,Script_Table),
                    db.MakeInParam("@Script_Span",SqlDbType.Int,Script_Span),
                    db.MakeInParam("@Script_Img",SqlDbType.Int,Script_Img),
                    db.MakeInParam("@Script_Font",SqlDbType.Int,Script_Font),
                    db.MakeInParam("@Script_A",SqlDbType.Int,Script_A),
                    db.MakeInParam("@Script_Html",SqlDbType.Int,Script_Html),
                    db.MakeInParam("@IsSaveImg",SqlDbType.Int,IsSaveImg),
                    db.MakeInParam("@IsDesc",SqlDbType.Int,IsDesc),
                    db.MakeInParam("@CollecNum",SqlDbType.Int,CollecNum),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }
Exemplo n.º 30
0
        /// <summary>
        /// �½��ɼ�
        /// </summary>
        /// <returns></returns>
        public bool Insert()
        {
            bool ret = true;
            DAO db = new DAO();
            try
            {
                string sql = "insert into JpCollect (ItemName,ClassId,WebEncode,WebName,WebUrl,ItemRemark,Script_Iframe";
                sql += ",Script_Object,Script_Script,Script_Div,Script_Table,Script_Span,Script_Img,Script_Font";
                sql += ",Script_A,Script_Html,IsSaveImg,IsDesc,CollecNum) values (";
                sql += "@ItemName,@ClassId,@WebEncode,@WebName,@WebUrl,@ItemRemark,@Script_Iframe";
                sql += ",@Script_Object,@Script_Script,@Script_Div,@Script_Table,@Script_Span,@Script_Img,@Script_Font";
                sql += ",@Script_A,@Script_Html,@IsSaveImg,@IsDesc,@CollecNum";
                sql += ")";

                SqlParameter[] sqlparam = {
                    db.MakeInParam("@ItemName",SqlDbType.VarChar,ItemName),
                    db.MakeInParam("@ClassId",SqlDbType.VarChar,ClassId),
                    db.MakeInParam("@WebEncode",SqlDbType.VarChar,WebEncode),
                    db.MakeInParam("@WebName",SqlDbType.VarChar,WebName),
                    db.MakeInParam("@WebUrl",SqlDbType.VarChar,WebUrl),
                    db.MakeInParam("@ItemRemark",SqlDbType.VarChar,ItemRemark),
                    db.MakeInParam("@Script_Iframe",SqlDbType.Int,Script_Iframe),
                    db.MakeInParam("@Script_Object",SqlDbType.Int,Script_Object),
                    db.MakeInParam("@Script_Script",SqlDbType.Int,Script_Script),
                    db.MakeInParam("@Script_Div",SqlDbType.Int,Script_Div),
                    db.MakeInParam("@Script_Table",SqlDbType.Int,Script_Table),
                    db.MakeInParam("@Script_Span",SqlDbType.Int,Script_Span),
                    db.MakeInParam("@Script_Img",SqlDbType.Int,Script_Img),
                    db.MakeInParam("@Script_Font",SqlDbType.Int,Script_Font),
                    db.MakeInParam("@Script_A",SqlDbType.Int,Script_A),
                    db.MakeInParam("@Script_Html",SqlDbType.Int,Script_Html),
                    db.MakeInParam("@IsSaveImg",SqlDbType.Int,IsSaveImg),
                    db.MakeInParam("@IsDesc",SqlDbType.Int,IsDesc),
                    db.MakeInParam("@CollecNum",SqlDbType.Int,CollecNum),
                };

                db.Execute(sql, sqlparam);
            }
            catch
            {
                ret = false;
            }
            finally
            {
                db.Close();
                db.Dispose();
            }
            return ret;
        }