Exemple #1
0
    protected void btnconfirm_Click(object sender, EventArgs e)
    {
        custtransEntity trans = new custtransEntity();
        trans.Ttitle = this.txtttitle.Text;
        trans.Tgcustom = this.txtpname.Text;
        trans.Tglinkuser = this.txttransuser.Text;
        trans.Tcontent = this.txtcontent.Text;
        trans.Tdiopen = this.dropti.SelectedItem.Text;
        trans.Ttype = this.dropswtype.SelectedItem.Text;
        trans.Tdifinish = this.dropfinish.SelectedItem.Text;
        trans.Tdidate = this.txtditime.Text;
        trans.Tdate = this.txttranstime.Text;
        trans.Treader = Session["username"].ToString();//"honey";//session
        if (Request.QueryString["action"] == "update")
        {
            trans.Id = cid;
            int i = custransBll.updateCusnote(trans);
            if (i > 0)
            {
                js("更新成功!");
                action = "";

            }
        }
        else
        {
            int i = custransBll.insertCusnote(trans);
            if (i>0)
            {
                  js("录入成功!");
            }
        }
        Response.Redirect("custranlist.aspx");
    }
Exemple #2
0
        public static int getCommcountun(string mark, custtransEntity custinfo)
        {
            string strWhere = "";

            strWhere = " tdifinish='ĩ���'";

            return conString.Getcommentcount("custom_tranction", "id", strWhere);
        }
Exemple #3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (!string.IsNullOrEmpty(Request.QueryString["id"]))
         {
             this.txtcid.Text = Request.QueryString["id"];
             trans = custransBll.getcusnoteInfo(Request.QueryString["id"]);
         }
     }
 }
Exemple #4
0
 public static int getCommcount(string mark, custtransEntity custinfo)
 {
     string strWhere = "";
     if (mark == "begin")
     {
         strWhere = "";
     }
     else
     {
         strWhere = " ttitle like '" + custinfo.Ttitle + "%' and   convert(datetime,tdate) >= convert(datetime, '" + custinfo.Btime + "') and convert(datetime,tdate) <= convert(datetime,'" + custinfo.Etime + "') ";
     }
     return conString.Getcommentcount("custom_tranction", "id", strWhere);
 }
Exemple #5
0
 /// <summary>
 /// ��ü�¼��Ϣ��
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public static custtransEntity getcusnoteInfo(string id)
 {
     custtransEntity note = new custtransEntity();
     string sql = "select * from custom_tranction where id=" + id;
     using (SqlDataReader dr = SqlHelper.ExecuteReader(DataBll.conString.constr, CommandType.Text, sql))
     {
         if (dr.Read())
         {
             note.Ttitle = dr["ttitle"].ToString();
             note.Tgcustom = dr["tgcustom"].ToString();
             note.Tglinkuser = dr["tglinkuser"].ToString();
             note.Tdate = dr["tdate"].ToString();
             note.Tdidate = dr["tdidate"].ToString();
             note.Tcontent = dr["tcontent"].ToString();
             note.Tdiopen = dr["tdiopen"].ToString();
             note.Tdifinish = dr["tdifinish"].ToString();
             note.Treader = dr["treader"].ToString();
             note.Ttype = dr["ttype"].ToString();
         }
     }
     return note;
 }
Exemple #6
0
 void bindlikedata(int pi, int ps, custtransEntity custinfo)
 {
     this.Repeater1.DataSource = custransBll.getCusnoteinfo("", pi, ps, custinfo);
     this.Repeater1.DataBind();
     int pagecount = custransBll.getCommcount("", custinfo);
     this.AspNetPager1.PageSize = pageSize;
     this.AspNetPager1.RecordCount = pagecount;
     this.AspNetPager1.CustomInfoHTML = "总:" + AspNetPager1.RecordCount.ToString() + "条,每页:%PageSize%条,当前:%CurrentPageIndex%/%PageCount%";
 }
Exemple #7
0
 /// <summary>
 /// ��������
 /// </summary>
 /// <param name="note"></param>
 /// <returns></returns>
 public static int updateCusnote(custtransEntity note)
 {
     string sql = "update custom_tranction set ttitle='" + note.Ttitle + "',tgcustom='" + note.Tgcustom + "',tglinkuser='******',tdate='" + note.Tdate + "',tdidate='" + note.Tdidate + "',tcontent='" + note.Tcontent + "',tdiopen='" + note.Tdiopen + "',tdifinish='" + note.Tdifinish + "',treader ='" + note.Treader + "',ttype='"+note.Ttype+"' where id=" + note.Id.ToString();
     return SqlHelper.ExecuteNonQuery(DataBll.conString.constr, CommandType.Text, sql);
 }
Exemple #8
0
 /// <summary>
 /// �����¼��Ϣ
 /// </summary>
 /// <param name="note"></param>
 /// <returns></returns>
 /// 
 public static int insertCusnote(custtransEntity note)
 {
     string sql = "insert into custom_tranction ( ttitle,tgcustom,tglinkuser,tdate,tdidate,tcontent,tdiopen,tdifinish,treader,ttype ) values"; sql += "('" + note.Ttitle + "','" + note.Tgcustom + "','" + note.Tglinkuser + "','" + note.Tdate + "','" + note.Tdidate + "','" + note.Tcontent + "','" + note.Tdiopen + "','" + note.Tdifinish + "','" + note.Treader + "','" + note.Ttype + "')";
     return SqlHelper.ExecuteNonQuery(DataBll.conString.constr, CommandType.Text, sql);
 }
Exemple #9
0
        public static DataSet getCusnoteinfoun(string mark, int pi, int ps, custtransEntity custinfo)
        {
            string tablename = " custom_tranction ";
            string sortfld = " id ";
            string selecfld = " *";
            string PrimaryKey = "id";
            int pageindex = pi;
            int pagesize = ps;
            int sortType = 1;
            string strWhere = "";

            strWhere = " tdifinish='ĩ���'";

            string strM = "id";
            return conString.GetcommdataSource(tablename, PrimaryKey, sortfld, pagesize, pageindex, sortType, strWhere, strM, selecfld);
        }
Exemple #10
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, custtransEntity custinfo)
 {
     string tablename = " custom_tranction ";
     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 = " ttitle like '" + custinfo.Ttitle + "%' and   convert(datetime,tdate) >= convert(datetime, '" + custinfo.Btime + "') and convert(datetime,tdate) <= convert(datetime,'" + custinfo.Etime + "') ";
     }
     string strM = "id";
     return conString.GetcommdataSource(tablename, PrimaryKey, sortfld, pagesize, pageindex, sortType, strWhere, strM, selecfld);
 }