public int PoiBillAudit(string userName, string type, string id) { //审核bill 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(-1);//身份验证失败 } MLogin.GetExeUname(); L_PushPoi n = new L_PushPoi(); List <L_PushPoi> list = n.Select(" and id =" + id); if (list.Count <= 0) { return(-1); } else { n.ZF2 = userName; //审核人 n.ZF3 = SysTime.GetTime.ToString(); //审核时间 if (type.ToUpper() == "YES") { n.OPERATE_TYPE = "同意"; KFLocation.Set(list[0].BILLMAN, list[0].CLIENT, list[0].AFTER_LNG + "," + list[0].AFTER_LAT); } else { n.OPERATE_TYPE = "否决"; } return(n.Updata(" and id=" + id)); } }
public string PoiApply(string userName, string name, string position) { 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_kfku k = new ClientService_kfku(); List <ClientService_kfku> ts = k.Select(" and name='" + name.Trim() + "' and zf29<>'' and zf30<>'' "); if (ts.Count > 0) { L_PushPoi p = new L_PushPoi(); string sql = " select * from L_PushPoi a where not exists( " + " select 1 from L_PushPoi b where b.client = a.client and b.id > a.id) " + " and client='" + name.Trim() + "' "; DataTable dt = DBLL.ExecuteDataTable(MyGlobal.DataBase, sql); if (dt != null && dt.Rows.Count > 0) { string 当前单据状态 = dt.Rows[0]["OPERATE_TYPE"].ToString(); string 当前审核人 = dt.Rows[0]["ZF1"].ToString(); if (当前单据状态 != "已提交")//最新申请已被查看 { p.ZF1 = "总经办"; p.BILLMAN = userName; p.OPERATE_TIME = SysTime.GetTime.ToString(); p.OPERATE_TYPE = "已提交"; p.CLIENT = name; p.BEFORE_LNG = ts[0].ZF29;//原始定位 p.BEFORE_LAT = ts[0].ZF30; string[] po = position.Split(','); p.AFTER_LNG = po[0]; //经度//现在请求定位 p.AFTER_LAT = po[1]; //纬度 p.Insert(); return("已提交审核至总经办!"); //已提交总经办审核 } else//最新记录还在审核状态 { return("定位还在审核,请勿重复提交!");// } } else { p.ZF1 = "销售内勤"; p.BILLMAN = userName; p.OPERATE_TIME = SysTime.GetTime.ToString(); p.OPERATE_TYPE = "已提交"; p.CLIENT = name; p.BEFORE_LNG = ts[0].ZF29;//原始定位 p.BEFORE_LAT = ts[0].ZF30; string[] po = position.Split(','); p.AFTER_LNG = po[0]; //经度//现在请求定位 p.AFTER_LAT = po[1]; //纬度 p.Insert(); return("已提交审核至销售内勤!"); } } else { return("该客户尚未定位,无需申请修正!");//没有该用户 } }