public ActionResult PageLoad() { SZLogisiticsDTO.SZLogisticsEFContainer LogisticDB = new SZLogisiticsDTO.SZLogisticsEFContainer(); SZLogisiticsDTO.DataRet.ReturnValue <LoadObject> rv = new SZLogisiticsDTO.DataRet.ReturnValue <LoadObject>(); //SZLogisiticsDTO.DataRet.ReturnValue<List<SZLogisiticsDTO.T_Unit>> rv = new SZLogisiticsDTO.DataRet.ReturnValue<List<SZLogisiticsDTO.T_Unit>>(); //SZLogisiticsDTO.DataRet.ReturnValue<List<string>> rv = new SZLogisiticsDTO.DataRet.ReturnValue<List<string>>(); //Get Unit Info var retUnit = from uvr in LogisticDB.T_Unit select uvr; var retProvider = from rPrd in LogisticDB.T_ProviderInfo select rPrd; //Get Provider Info rv.data = new LoadObject(retUnit.ToList <SZLogisiticsDTO.T_Unit>(), retProvider.ToList <SZLogisiticsDTO.T_ProviderInfo>()); // rv.data = retUnit.ToList<SZLogisiticsDTO.T_Unit>(); //List<string> lsEx=new List<string>(); //lsEx.Add("1"); //lsEx.Add("2"); //rv.data = lsEx; rv.RetStatus = "loading successful!"; rv.RetValue = "loading successful!"; JsonSerializerSettings jsSettings = new JsonSerializerSettings(); jsSettings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; JsonResult jRe = Json(JsonConvert.SerializeObject(rv, jsSettings), JsonRequestBehavior.AllowGet); return(jRe); }
public ActionResult PageLoad(string strConn) { SZLogisiticsDTO.SZLogisticsEFContainer LogisticDB = new SZLogisiticsDTO.SZLogisticsEFContainer(); SZLogisiticsDTO.DataRet.ReturnValue <List <LoadObject> > rv = new SZLogisiticsDTO.DataRet.ReturnValue <List <LoadObject> >(); var retReport = from hReport in LogisticDB.T_ProductOrder join HotelInfo in LogisticDB.T_HotelInfo on hReport.F_HotelID equals HotelInfo.F_ID where hReport.F_Status.Contains("已发送") && HotelInfo.F_Name.Contains(strConn) select new LoadObject { ReportID = hReport.F_ID, ProductName = hReport.F_ProductName, RetDate = hReport.F_ImportDate.ToString(), HotelName = HotelInfo.F_Name }; //Get Provider Info rv.data = retReport.ToList <LoadObject>(); rv.RetStatus = "loading successful!"; rv.RetValue = "loading successful!"; JsonSerializerSettings jsSettings = new JsonSerializerSettings(); jsSettings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; JsonResult jRe = Json(JsonConvert.SerializeObject(rv, jsSettings), JsonRequestBehavior.AllowGet); return(jRe); }
public ActionResult PageLoad(int ReportID) { SZLogisiticsDTO.SZLogisticsEFContainer LogisticDB = new SZLogisiticsDTO.SZLogisticsEFContainer(); SZLogisiticsDTO.DataRet.ReturnValue <List <LoadObject> > rv = new SZLogisiticsDTO.DataRet.ReturnValue <List <LoadObject> >(); var retReport = from hReport in LogisticDB.T_ProductOrder join HotelInfo in LogisticDB.T_HotelInfo on hReport.F_HotelID equals HotelInfo.F_ID join UnitInfo in LogisticDB.T_Unit on hReport.F_UnitID equals UnitInfo.F_ID where hReport.F_ID == ReportID select new LoadObject { HotelName = HotelInfo.F_Name, ProductName = hReport.F_ProductName, Model = hReport.F_Model, Unit = UnitInfo.F_Name, Price = hReport.F_Price.ToString(), Brand = hReport.F_Brand, PublishDate = hReport.F_ImportDate.ToString(), Address = hReport.DeliveryPlace, Remark = hReport.F_Remark }; //Get Provider Info rv.data = retReport.ToList <LoadObject>(); rv.RetStatus = "1"; rv.RetValue = "loading successful!"; JsonSerializerSettings jsSettings = new JsonSerializerSettings(); jsSettings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; JsonResult jRe = Json(JsonConvert.SerializeObject(rv, jsSettings), JsonRequestBehavior.AllowGet); return(jRe); }
public ActionResult ReportUpdates(int strReportID, string strRemark) { SZLogisiticsDTO.SZLogisticsEFContainer LogisticDB = new SZLogisiticsDTO.SZLogisticsEFContainer(); SZLogisiticsDTO.DataRet.ReturnValue <string> rv = new SZLogisiticsDTO.DataRet.ReturnValue <string>(); var retReport = (from hReport in LogisticDB.T_ProductOrder where hReport.F_ID == strReportID select hReport).FirstOrDefault(); retReport.F_Remark = strRemark; retReport.F_Status = "已回复"; rv.data = LogisticDB.SaveChanges().ToString(); return(Json(rv, JsonRequestBehavior.AllowGet)); }
public ActionResult PageLoad(string strConn) { SZLogisiticsDTO.SZLogisticsEFContainer LogisticDB = new SZLogisiticsDTO.SZLogisticsEFContainer(); SZLogisiticsDTO.DataRet.ReturnValue <List <LoadObject> > rv = new SZLogisiticsDTO.DataRet.ReturnValue <List <LoadObject> >(); #region 查询例子 /*var q= from n in db.NewsModel * join b in db.BigClassModel on n.BigClassID equals b.BigClassID * join s in db.SmallClassModel on n.SmallClassID equals s.SmallClassID * orderby n.AddTime descending * select new * { * n.NewsID, * n.BigClassID, * n.SmallClassID, * n.Title, * b.BigClassName, * s.SmallClassName, * }; * return q.ToList(); * q.Count()//这个就是记录总数*/ #endregion var retReport = from pReport in LogisticDB.T_ProductOrder join ProviderInfo in LogisticDB.T_ProviderInfo on pReport.F_ProviderID equals ProviderInfo.F_ID where pReport.F_Status.Contains("已回复") && ProviderInfo.F_Name.Contains(strConn) select new LoadObject { ProductName = pReport.F_ProductName, RetDate = pReport.F_ImportDate.ToString(), ProviderName = ProviderInfo.F_Name }; //Get Provider Info rv.data = retReport.ToList <LoadObject>(); #region test code - 0904 // rv.data = retUnit.ToList<SZLogisiticsDTO.T_Unit>(); //List<string> lsEx=new List<string>(); //lsEx.Add("1"); //lsEx.Add("2"); //rv.data = lsEx; #endregion rv.RetStatus = "loading successful!"; rv.RetValue = "loading successful!"; JsonSerializerSettings jsSettings = new JsonSerializerSettings(); jsSettings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; JsonResult jRe = Json(JsonConvert.SerializeObject(rv, jsSettings), JsonRequestBehavior.AllowGet); return(jRe); }
/// <summary> /// set product report into database add by YangDu 0902 /// </summary> /// <param name="strProductName"> </param> /// <param name="strModel"></param> /// <param name="strUnit"></param> /// <param name="strPrice"></param> /// <param name="strBrandName"></param> /// <param name="strDate"></param> /// <param name="strDeliveryPlace"></param> /// <param name="strRemark"></param> /// <param name="strProvider"></param> /// <returns></returns> public ActionResult HotelReportAdd(string strProductName, string strModel, int strUnit, decimal strPrice, string strBrandName, string strDate, string strDeliveryPlace, string strRemark, int strProvider) { SZLogisiticsDTO.T_ProductOrder ProductVar = new SZLogisiticsDTO.T_ProductOrder() { F_ProductName = strProductName, F_Model = strModel, F_UnitID = strUnit, F_Price = strPrice, F_Brand = strBrandName, F_ImportDate = Convert.ToDateTime(strDate), DeliveryPlace = strDeliveryPlace, F_Remark = strRemark, F_ProviderID = strProvider, F_Status = "请求中" }; SZLogisiticsDTO.SZLogisticsEFContainer LogisticDB = new SZLogisiticsDTO.SZLogisticsEFContainer(); SZLogisiticsDTO.DataRet.ReturnValue <string> rv = new SZLogisiticsDTO.DataRet.ReturnValue <string>(); try { LogisticDB.T_ProductOrder.Add(ProductVar); int iChanges = LogisticDB.SaveChanges(); rv.data = "successful"; rv.RetStatus = "数据录入成功!"; rv.RetValue = "数据录入成功!"; } catch (Exception ex) { rv.RetStatus = "数据录入失败!"; rv.RetValue = ex.ToString(); } return(Json(rv, JsonRequestBehavior.AllowGet)); }
public ActionResult LoginSys(string strUserName, string strPassword, string strUserType) { ReturnValue <string> rv = new ReturnValue <string>(); if (strUserType == "1") { SZLogisiticsDTO.SZLogisticsEFContainer SzBuyerEntities = new SZLogisiticsDTO.SZLogisticsEFContainer(); var cls = (from UsObj in SzBuyerEntities.T_HUserInfo where UsObj.F_UserName == strUserName select UsObj); rv.RetStatus = cls.Count <SZLogisiticsDTO.T_HUserInfo>() == 0 ? "失败" : "成功"; rv.RetValue = cls.Count <SZLogisiticsDTO.T_HUserInfo>() == 0 ? "失败" : "成功"; } else { SZLogisiticsDTO.SZLogisticsEFContainer SzBuyerEntities = new SZLogisiticsDTO.SZLogisticsEFContainer(); var cls = (from UsObj in SzBuyerEntities.T_PUserInfo where UsObj.F_UserName == strUserName select UsObj); rv.RetStatus = cls.Count <SZLogisiticsDTO.T_PUserInfo>() == 0 ? "失败" : "成功"; rv.RetValue = cls.Count <SZLogisiticsDTO.T_PUserInfo>() == 0 ? "失败" : "成功"; } return(Json(rv, JsonRequestBehavior.AllowGet)); }