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));
}
