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