/// <summary> /// ��ü�¼��Ϣ�� /// </summary> /// <param name="id"></param> /// <returns></returns> public static concatchEntity getcusnoteInfo(string id) { concatchEntity note = new concatchEntity(); string sql = "select * from contract_catch where id=" + id; using (SqlDataReader dr = SqlHelper.ExecuteReader(DataBll.conString.constr, CommandType.Text, sql)) { if (dr.Read()) { note.Ccname = dr["ccname"].ToString(); note.Ccdate = dr["ccdate"].ToString(); note.Ctitle = dr["ctitle"].ToString(); note.Ccontent = dr["ccontent"].ToString(); note.Coper = dr["coper"].ToString(); note.Csection = dr["csection"].ToString(); note.Cdate = dr["cdate"].ToString(); note.Cuser = dr["cuser"].ToString(); note.Clinkwork = dr["clinkwork"].ToString(); note.Clinkuser = dr["clinkuser"].ToString(); note.Clinktel = dr["clinktel"].ToString(); note.Clinkpho = dr["clinkpho"].ToString(); note.Clinkaddress = dr["clinkaddress"].ToString(); } } return note; }
public static int getCommcount(string mark, concatchEntity custinfo) { string strWhere = ""; if (mark == "begin") { if (custinfo.Cuser.Split('_')[1] == "1")//�����ϵͳ����Ա�鿴ȫ�� { strWhere = ""; } else { strWhere = " cuser = '******'_')[0] + "'"; } } else { if (custinfo.Cuser.Split('_')[1] == "1")//�����ϵͳ����Ա�鿴ȫ�� ͨ����ɫID���ж� { strWhere = " ccname like '" + custinfo.Cname + "%' and convert(datetime,ccdate) >= convert(datetime, '" + custinfo.Btime + "') and convert(datetime,ccdate) <= convert(datetime,'" + custinfo.Etime + "') and ctitle like '" + custinfo.Ctitle + "%'"; } else { strWhere = " cuser='******'_')[0] + "' and ccname like '" + custinfo.Cname + "%' and convert(datetime,ccdate) >= convert(datetime, '" + custinfo.Btime + "') and convert(datetime,ccdate) <= convert(datetime,'" + custinfo.Etime + "') and ctitle like '" + custinfo.Ctitle + "%'"; } } return conString.Getcommentcount("contract_catch", "id", strWhere); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { this.txtcid.Text = Request.QueryString["id"].ToString(); oper = contransBll.getcusnoteInfo(Request.QueryString["id"]); } } }
protected void Button1_Click(object sender, EventArgs e) { concatchEntity self = new concatchEntity(); self.Ccname = this.txtccname.Text; self.Ccdate = this.txtccdate.Text; self.Clinkpho = this.txtlinkpho.Text; self.Clinktel = this.txtlinktel.Text; self.Clinkuser = this.txtlinkuser.Text; self.Clinkwork = this.txtlinkwork.Text; self.Clinkaddress = this.txtlinkaddress.Text; self.Ctitle = this.txtctitle.Text; self.Ccontent = this.txtccontent.Text; self.Coper = this.dropoper.SelectedItem.Text; self.Csection = this.dropcsection.SelectedItem.Text; self.Cuser = Session["username"].ToString();//"honey";//session self.Cdate = DateTime.Now.ToString(); if (Request.QueryString["action"] == "update") { self.Id = cid; int i = contransBll.updateCusnote(self); if (i > 0) { js("更新成功!"); action = ""; } } else { int i = contransBll.insertCusnote(self); if (i > 0) { js("录入成功!"); } } Response.Redirect("contranList.aspx"); }
void bindlikedata(int pi, int ps, concatchEntity custinfo) { this.Repeater1.DataSource = contransBll.getCusnoteinfo("", pi, ps, custinfo); this.Repeater1.DataBind(); int pagecount = contransBll.getCommcount("", custinfo); this.AspNetPager1.PageSize = pageSize; this.AspNetPager1.RecordCount = pagecount; this.AspNetPager1.CustomInfoHTML = "总:" + AspNetPager1.RecordCount.ToString() + "条,每页:%PageSize%条,当前:%CurrentPageIndex%/%PageCount%"; }
public static DataSet getCusnoteinfo(string mark, int pi, int ps, concatchEntity custinfo) { string tablename = " contract_catch "; string sortfld = " id "; string selecfld = " *"; string PrimaryKey = "id"; int pageindex = pi; int pagesize = ps; int sortType = 1; string strWhere = ""; if (mark == "begin") { if (custinfo.Cuser.Split('_')[1] == "1")//�����ϵͳ����Ա�鿴ȫ�� { strWhere = ""; } else { strWhere = " cuser = '******'_')[0] + "'"; } } else { if (custinfo.Cuser.Split('_')[1] == "1")//�����ϵͳ����Ա�鿴ȫ�� ͨ����ɫID���ж� { strWhere = " ccname like '" + custinfo.Cname + "%' and convert(datetime,ccdate) >= convert(datetime, '" + custinfo.Btime + "') and convert(datetime,ccdate) <= convert(datetime,'" + custinfo.Etime + "') and ctitle like '" + custinfo.Ctitle + "%'"; } else { strWhere = " cuser='******'_')[0] + "' and ccname like '" + custinfo.Cname + "%' and convert(datetime,ccdate) >= convert(datetime, '" + custinfo.Btime + "') and convert(datetime,ccdate) <= convert(datetime,'" + custinfo.Etime + "') and ctitle like '" + custinfo.Ctitle + "%'"; } } string strM = "id"; return conString.GetcommdataSource(tablename, PrimaryKey, sortfld, pagesize, pageindex, sortType, strWhere, strM, selecfld); }
/// <summary> /// �������� /// </summary> /// <param name="note"></param> /// <returns></returns> public static int updateCusnote(concatchEntity note) { string sql = "update contract_catch set ccname='" + note.Ccname + "',ccdate='" + note.Ccdate + "',ctitle='" + note.Ctitle + "',ccontent='" + note.Ccontent + "',coper='" + note.Coper + "',csection='" + note.Csection + "',cdate='" + note.Cdate + "',cuser='******',clinkuser='******',clinktel='"+note.Clinktel+"',clinkpho='"+note.Clinkpho+"',clinkaddress='"+note.Clinkaddress+"',clinkwork='"+note.Clinkwork+"' where id=" + note.Id.ToString(); return SqlHelper.ExecuteNonQuery(DataBll.conString.constr, CommandType.Text, sql); }
/// <summary> ///�����¼��Ϣ /// </summary> /// <param name="note"></param> /// <returns></returns> public static int insertCusnote(concatchEntity note) { string sql = "insert into contract_catch ( ccname,ccdate,ctitle,ccontent,coper,csection,cdate,cuser,clinkuser,clinktel,clinkpho,clinkaddress,clinkwork) values"; sql += "('" + note.Ccname + "','" + note.Ccdate + "','" + note.Ctitle + "','" + note.Ccontent + "','" + note.Coper + "','" + note.Csection + "','" + note.Cdate + "','" + note.Cuser + "','"+note.Clinkuser+"','"+note.Clinktel+"','"+note.Clinkpho+"','"+note.Clinkaddress+"','"+note.Clinkwork+"')"; return SqlHelper.ExecuteNonQuery(DataBll.conString.constr, CommandType.Text, sql); }