private ActionResult GetPages2(SelScale condition, string where) { PageJsonModel <SelScale> page = new PageJsonModel <SelScale>(); page.pageIndex = condition.pageIndex; page.pageSize = condition.pageSize; page.strForm = " SelScale"; page.strSelect = " province,city,Address,warning,count(ID) cnt"; page.strWhere = where + " and warning='窜货' group by province,city,Address,warning"; if (string.IsNullOrWhiteSpace(condition.orderby) == false) { page.strOrder = Common.FilteSQLStr(condition.orderby); } else { page.strOrder = "count(ID) desc"; } page.LoadList(); if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0) { return(Json(page.pageResponse, JsonRequestBehavior.AllowGet)); } return(Json("", JsonRequestBehavior.AllowGet)); }
private ActionResult GetPages(SelScale condition, string where) { PageJsonModel <View_AntiQuery> page = new PageJsonModel <View_AntiQuery>(); page.pageIndex = condition.pageIndex; page.pageSize = condition.pageSize; page.strForm = "View_AntiQuery"; page.strSelect = " ID, AntiCode, IP, province, city, warning, Address, UserName, CreateTime, BigCode, MiddleCode, SmallCode,SalesAddress "; page.strWhere = where; if (string.IsNullOrWhiteSpace(condition.orderby) == false) { page.strOrder = Common.FilteSQLStr(condition.orderby); } else { page.strOrder = "CreateTime desc"; } page.LoadList(); if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0) { return(Json(page.pageResponse, JsonRequestBehavior.AllowGet)); } return(Json("", JsonRequestBehavior.AllowGet)); }
public ActionResult ExportExcel(SelScale condition) { StringBuilder where = new StringBuilder(); where.Append("select SelScale.*,Scale.BigCode,Scale.SmallCode,Scale.SelectDate from SelScale left join Scale on SelScale.AntiCode=Scale.AntiCode where 1=1"); //where.Append("and state='已审核' and Chief=0 "); if (!string.IsNullOrWhiteSpace(condition.keyword)) { where.Append(string.Format(" and (BigCode like '%{0}%' or SmallCode like '%{0}%' or SelScale.AntiCode like '%{0}%' or Address like '%{0}%')", condition.keyword)); } DataTable dt = ExportWay.ExcelDataTable(where.ToString()); string[] list = { "ID", "防伪码", "IP", "消费者查询省份", "消费者查询城市", "查询状态", "销售地区", "经销商编号", "外箱条码", "产品条码", "查询时间" }; return(File(ExportWay.GetExcel(dt, list), "application/vnd.ms-excel", "防伪查询明细信息" + DateTime.Now.ToShortTimeString() + ".xls")); }
public ActionResult GetCodePage2(SelScale condition) { string where = string.Empty; if (!string.IsNullOrWhiteSpace(condition.province)) { where += string.Format(" and province+city like '%{0}%'", condition.province); } if (!string.IsNullOrWhiteSpace(condition.Address)) { where += string.Format(" and Address like '%{0}%'", condition.Address); } return(GetPages2(condition, where)); }
public ActionResult GetCodePage(SelScale condition) { string where = string.Empty; if (!string.IsNullOrWhiteSpace(condition.keyword)) { where += " and (isnull(BigCode,'')+isnull(MiddleCode,'')+isnull(SmallCode,'')+AntiCode like '%" + Common.FilteSQLStr(condition.keyword) + "%' )"; } if (!string.IsNullOrWhiteSpace(condition.province)) { where += " and (province+citye like '%" + Common.FilteSQLStr(condition.keyword) + "%' )"; } if (!string.IsNullOrWhiteSpace(condition.Address)) { where += " and (Address like '%" + Common.FilteSQLStr(condition.Address) + "%' )"; } return(GetPages(condition, where)); }
public JsonResult GetPage() { string fileStr = ""; List <string> json = new List <string>(); try { string filePath = AppDomain.CurrentDomain.BaseDirectory; if (!System.IO.Directory.Exists(filePath + "BaseFile\\")) { System.IO.Directory.CreateDirectory(filePath + "BaseFile\\"); } filePath = filePath + "BaseFile\\"; //读取文件 StreamReader sr = new StreamReader(filePath + "provincedata.json", Encoding.UTF8); String line; while ((line = sr.ReadLine()) != null) { fileStr += (line.ToString()); } sr.Close(); json = JsonConvert.DeserializeObject <List <string> >(fileStr); } catch (Exception ex) { } List <SelScale> fbs = SelScale.GetSelScale(); for (int i = 0; i < fbs.Count; i++) { var newname = json.FirstOrDefault(m => fbs[i].name.Contains(m)); if (string.IsNullOrWhiteSpace(newname) == false) { fbs[i].name = newname; } } return(Json(fbs, JsonRequestBehavior.AllowGet)); }
public ActionResult AntiFakeSel(string ID) { string ip = System.Web.HttpContext.Current.Request.ServerVariables.Get("Remote_Addr").ToString(); ModelQueryParam queryip = new ModelQueryParam(); queryip = GetAddress(ip); string province = queryip.Province; string city = queryip.City; string msg = "此防伪码不存在,请您检查标签,确认防伪码是否输入正确,然后再请您试一次。"; Scale scake = Scale.GetCAntiFake(ID); SelScale.GetSelScale(); int countto = 0; //string img = ""; if (scake != null) { int count = 0; // scake.SelCount + 1; if (count == 1) { DateTime time = DateTime.Now; msg = "此防伪码有效,您购买的是深圳市通程防伪科技有限公司所生产的正牌产品,请放心使用!"; //scake.SelectDate = time; SelScale selscale = new SelScale(); //查到当前标签的出货记录 ScaleOutStoke Stoke = ScaleOutStoke.GetSmallScaleListcode(ID); if (Stoke != null) { C_User user = new C_User(); if (Stoke.Consignee == "m2000") { //查到出货人信息 user = C_User.GetC_UserByUserName(Stoke.Shipper); if (user.Province != province) { selscale.warning = "窜货"; } else { selscale.warning = "正常"; } selscale.Address = user.Province + user.City; } else { user = C_User.GetC_UserByUserName(Stoke.Consignee); if (user.Province != province) { selscale.warning = "窜货"; } else { selscale.warning = "正常"; } selscale.Address = user.Province + user.City; } } selscale.province = province; selscale.city = city; selscale.IP = ip; selscale.AntiCode = ID; selscale.InsertAndReturnIdentity(); } else { msg = "注意!此防伪码有效,但已被查询" + count + "次"; } scake.UpdateByID(); countto = count; return(Content(countto + "|" + msg + "|" + scake.CreateTime)); } return(Content(countto + "|" + msg)); }
public RequestResult InsertQuery(int FID, string AntiCode, string IP, string Province, string City, string Address, string Country = "") { DAL.Log.Instance.Write("FID:" + FID.ToString() + ",AntiCode:" + AntiCode + ",IP:" + IP + ",Country:" + Country + ",Province:" + Province + ",City:" + City + ",Address:" + Address, "防伪查询回调参数"); RequestResult result = new RequestResult(); try { SelScale selscale = new SelScale(); ScaleOutStoke Stoke = ScaleOutStoke.GetSmallScaleListcode(AntiCode); if (Stoke == null) { Scale scale = Scale.GetEntityByAntiCode(AntiCode); if (scale == null) { selscale.warning = "错误"; result.message = "错误"; result.success = true; } else if (!scale.IsOut) { selscale.warning = "未出货"; result.message = "未出货"; result.success = true; } else { selscale.warning = "异常"; result.message = "异常"; result.success = true; } } else if (Province == "未知" || City == "未知") { selscale.warning = "异常"; result.message = "异常"; result.success = true; } else { C_User user = new C_User(); if (Stoke.Consignee == "m2000") { //查到出货人信息 user = C_User.GetC_UserByUserName(Stoke.Shipper); if (user != null) { if (user.Province != Province) { selscale.warning = "窜货"; } else { selscale.warning = "正常"; } } else { selscale.warning = "异常"; } } else { user = C_User.GetC_UserByUserName(Stoke.Consignee); if (user != null) { if (user.Province != Province) { selscale.warning = "窜货"; } else { selscale.warning = "正常"; } } else { selscale.warning = "异常"; } } result.message = "成功"; result.success = true; } selscale.warning = string.IsNullOrWhiteSpace(selscale.warning) ? "未知" : selscale.warning; selscale.Country = Country; selscale.province = Province; selscale.city = City; selscale.IP = IP; selscale.FID = FID; selscale.AntiCode = AntiCode; selscale.Address = Address; selscale.CreateTime = CommonFunc.GetNowTimestamp(); selscale.InsertAndReturnIdentity(); } catch (Exception ex) { DAL.Log.Instance.Write(ex.Message, "防伪查询回调出错"); result.message = "失败,error:" + ex.Message; result.success = false; } return(result); }