Example #1
0
 public static int getCommcount(string mark, cuslnoteEntity custinfo)
 {
     string strWhere = "";
     if (mark == "begin")
     {
         strWhere = "";
     }
     else
     {
         strWhere = " pname like '" + custinfo.Pname + "%' and   convert(datetime,lastlinkdate) >= convert(datetime, '" + custinfo.Btime + "') and convert(datetime,lastlinkdate) <= convert(datetime,'" + custinfo.Etime + "') ";
     }
     return conString.Getcommentcount("custom_linknote","id",strWhere);
 }
Example #2
0
    protected void btnconfirm_Click(object sender, EventArgs e)
    {
        cuslnoteEntity note = new cuslnoteEntity();
        note.Pname = this.txtpname.Text;
        note.Puser = this.txtpuser.Text;
        note.Linkdate = this.txtlinkdate.Text;
        note.Linktitle = this.txttitle.Text;
        note.Linkcontent = this.txtcontent.Text;
        note.Lastlinkdate = this.txtlasttime.Text;
        note.Istrycath = this.DropDownList2.SelectedItem.Text;
        note.TryCatch = this.DropDownList1.SelectedItem.Text;
        note.Nreader = Session["username"].ToString();//"honey";//session
        note.Newmoney = this.txtnewmoney.Text;
        note.Ndate = DateTime.Now.ToString();

        if (action == "update")
        {
            note.Id = Convert.ToInt32(cid);
            int icount = cusnoteBll.updateCusnote(note);
            if (icount >0)
            {
                 js("联系记录更新成功!");
                Response.Redirect("linknoteList.aspx");
            }
        }
        else
        {
            note.Cid = this.txtcid.Text;
            int icount = cusnoteBll.insertCusnote(note);
            if (icount > 0)
            {
                js("联系记录录入成功!");
                Response.Redirect("linknoteList.aspx");
            }
        }
    }
Example #3
0
        /// <summary>
        /// ��ü�¼��Ϣ��
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static cuslnoteEntity getcusnoteInfo(string id)
        {
            cuslnoteEntity note = new cuslnoteEntity();
            string sql = "select * from custom_linknote where id="+id;
            using (SqlDataReader dr = SqlHelper.ExecuteReader(DataBll.conString.constr,CommandType.Text,sql))
            {
                if (dr.Read())
                {
                    note.Pname = dr["pname"].ToString();
                    note.Puser = dr["puser"].ToString();
                    note.TryCatch = dr["trycatch"].ToString();
                    note.Linkcontent = dr["linkcontent"].ToString();
                    note.Lastlinkdate = dr["lastlinkdate"].ToString();
                    note.Istrycath = dr["istrycath"].ToString();
                    note.Newmoney = dr["newmoney"].ToString();
                    note.Linktitle = dr["linktitle"].ToString();
                    note.Linkdate = dr["linkdate"].ToString();
                    note.Ndate = dr["ndate"].ToString();
                    note.Nreader = dr["nreader"].ToString();

                }
            }
            return note;
        }
Example #4
0
 /// <summary>
 /// 
 /// </summary>
 /// <param name="mark">begin �����ʼ��</param>
 /// <param name="pi"></param>
 /// <param name="ps"></param>
 /// <param name="custinfo"></param>
 /// <returns></returns>
 public static DataSet getCusnoteinfo(string mark, int pi, int ps, cuslnoteEntity custinfo)
 {
     string tablename = " custom_linknote ";
     string sortfld = " id ";
     string selecfld = " *";
     string PrimaryKey = "id";
     int pageindex = pi;
     int pagesize = ps;
     int sortType = 1;
     string strWhere = "";
     if (mark == "begin")
     {
         strWhere = "";
     }
     else
     {
         strWhere = " pname like '" + custinfo.Pname + "%' and   convert(datetime,lastlinkdate) >= convert(datetime, '" + custinfo.Btime + "') and convert(datetime,lastlinkdate) <= convert(datetime,'" + custinfo.Etime + "') ";
     }
     string strM = "id";
     return conString.GetcommdataSource(tablename, PrimaryKey, sortfld, pagesize, pageindex, sortType, strWhere, strM, selecfld);
 }
Example #5
0
 /// <summary>
 /// ��������
 /// </summary>
 /// <param name="note"></param>
 /// <returns></returns>
 public static int updateCusnote(cuslnoteEntity note)
 {
     string sql = "update custom_linknote set pname='"+note.Pname+"',puser='******',newmoney='"+note.Newmoney+"',linkcontent='"+note.Linkcontent+"',lastlinkdate='"+note.Lastlinkdate+"',trycatch = '"+note.TryCatch+"',istrycath='"+note.Istrycath+"',linkdate='"+note.Linkdate+"',nreader='"+note.Nreader+"',ndate='"+note.Ndate+"',linktitle='"+note.Linktitle+"' where id="+note.Id.ToString() ;
     return SqlHelper.ExecuteNonQuery(DataBll.conString.constr, CommandType.Text, sql);
 }
Example #6
0
 /// <summary>
 /// �����¼��Ϣ
 /// </summary>
 /// <param name="note"></param>
 /// <returns></returns>
 public static int insertCusnote(cuslnoteEntity note)
 {
     string sql = "insert into custom_linknote (pname,puser,newmoney,linkcontent,lastlinkdate,trycatch,istrycath,linkdate,nreader,ndate,linktitle,cid) values";
     sql += "('"+note.Pname+"','"+note.Puser+"','"+note.Newmoney+"','"+note.Linkcontent+"','"+note.Lastlinkdate+"','"+note.TryCatch+"','"+note.Istrycath+"','"+note.Linkdate+"','"+note.Nreader+"','"+note.Ndate+"','"+note.Linktitle+"','"+note.Cid+"')";
     return SqlHelper.ExecuteNonQuery(DataBll.conString.constr, CommandType.Text, sql);
 }
Example #7
0
 void bindlikedata(int pi, int ps, cuslnoteEntity custinfo)
 {
     this.Repeater1.DataSource = cusnoteBll.getCusnoteinfo("", pi, ps, custinfo);
     this.Repeater1.DataBind();
     int pagecount = cusnoteBll.getCommcount("", custinfo);
     this.AspNetPager1.PageSize = pageSize;
     this.AspNetPager1.RecordCount = pagecount;
     this.AspNetPager1.CustomInfoHTML = "总:" + AspNetPager1.RecordCount.ToString() + "条,每页:%PageSize%条,当前:%CurrentPageIndex%/%PageCount%";
 }