public List <VisitBill> HisVisit(string userName) { string cookies = HttpContext.Current.Request.Cookies["guid"] == null ? "" : HttpContext.Current.Request.Cookies["guid"].Value as string; string session = Session.SessionID.ToString(); if (!cookies.Equals(session)) { return(null); } MLogin.GetExeUname(); clientservice_VisitBill bills = new clientservice_VisitBill(); List <clientservice_VisitBill> list = bills.Select(" and billman='" + userName + "' order by id desc ", " top 20 client,billdate,notepre,code"); List <VisitBill> history = new List <VisitBill>(); foreach (clientservice_VisitBill c in list) { VisitBill b = new VisitBill(); b.code = c.CODE; b.client = c.CLIENT; b.date = c.BILLDATE.ToString("yyyy-MM-dd"); b.content = c.NOTEPRE; history.Add(b); } return(history); }
public List <VisitBill> GetBills(string userName) { string cookies = HttpContext.Current.Request.Cookies["guid"] == null ? "" : HttpContext.Current.Request.Cookies["guid"].Value as string; string session = Session.SessionID.ToString(); if (!cookies.Equals(session)) { return(null);//身份验证失败 } MLogin.GetExeUname(); List <VisitBill> result = new List <VisitBill>(); string date = DateTime.Now.Date.ToString(); clientservice_VisitBill bills = new clientservice_VisitBill(); List <clientservice_VisitBill> list = bills.Select(" and billman='" + userName + "' and BILLDATE='" + date + "' ", " client,billdate,notepre,code,zf3,zf4,zf5 ");//公司、拜访时间、内容、单号、名字、职位、电话 foreach (clientservice_VisitBill b in list) { VisitBill v = new VisitBill(); v.client = b.CLIENT; v.code = b.CODE; v.content = b.NOTEPRE; v.date = b.BILLDATE.ToString("yyyy-MM-dd"); v.hisname = b.ZF3; v.hisposition = b.ZF4; v.hisphone = b.ZF5; result.Add(v); } return(result); }
public void EditVisit(string code, string content) { string cookies = HttpContext.Current.Request.Cookies["guid"] == null ? "" : HttpContext.Current.Request.Cookies["guid"].Value as string; string session = Session.SessionID.ToString(); if (!cookies.Equals(session)) { return; } MLogin.GetExeUname(); clientservice_VisitBill bills = new clientservice_VisitBill(); List <clientservice_VisitBill> list = bills.Select(" and code='" + code + "'"); if (list.Count > 0) { clientservice_VisitBill bill = list[0]; bill.Reset_clientservice_VisitBill(); bill.NOTEPRE = content; // bill.FINISHDATE= SysTime.GetTime; bill.Updata(" and code='" + code + "' "); } }