public string Reply(int id, string reply, string userName, double lng, double lat, double kflng, double kflat) { 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(); if (MyGlobal.AERA_CHECK)//是否检核范围 { if (kflng == -1 || kflat == -1) { return("None"); } if (ScueFun.LngLatDis.GetDistance(lng, lat, kflng, kflat) > MyGlobal.VISITAERA)//超出范围 { return("Toofar"); } } //事务处理开始,劫持链接通道的sql语句 TransactionSql.Start(MyGlobal.DataBase); //===>开始 DateTime now = SysTime.GetTime; List <RpBill> result = new List <RpBill>(); L_ContactSheetMsg msg = new L_ContactSheetMsg(); msg.MTITLE = reply; msg.INSERTER = userName; msg.FID = id; msg.INSERTDATE = now; msg.STATE = "已提交"; int get_id = msg.Insert(); List <L_ContactSheetMsg> msg_list = msg.Select(" and INSERTDATE='" + now.ToString() + "' "); L_ContactSheet l_Contact = new L_ContactSheet(); List <L_ContactSheet> list = l_Contact.Select(" and id = " + id.ToString()); if (list.Count > 0) { //更新关联单据号,最新的,可作为最后打卡的目标公司,名称、地址 20180904 skl puku_user u = new puku_user(); u.REFERCODE = msg_list.Count > 0 ? msg_list[0].ID.ToString():""; u.ZF1 = list[0].CLIENT; u.ZF2 = kflng.ToString(); u.ZF3 = kflat.ToString(); u.ZF4 = now.ToString("yyyy-MM-dd HH:mm:ss"); u.Updata(" and TURENAME='" + userName + "' "); } else { return("没有该联络单!"); } //提交事务到sql服务器处理//===>结束 if (!TransactionSql.EndSql())//判断是否成功 { return("回复失败!"); } return(msg.INSERTDATE.ToString()); }
public List <RpBill> GetReply(string fid) { 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 <RpBill> result = new List <RpBill>(); L_ContactSheetMsg msg = new L_ContactSheetMsg(); List <L_ContactSheetMsg> list = msg.Select(" and fid='" + fid + "' order by id desc ", " top 30 * "); foreach (L_ContactSheetMsg r in list) { RpBill n = new RpBill(); n.createtime = r.INSERTDATE.ToString("yyyy-MM-dd HH:mm:ss"); n.state = r.STATE; n.inserter = r.INSERTER; n.content = r.MTITLE; result.Add(n); } return(result); }