public ActionResult AddOtherFare(BuyFare model)
{
//listOrderInfo.Add(model);
//var result = new { total = 100, rows = listOrderInfo };
//return Json(result, JsonRequestBehavior.AllowGet);
//string OcID = Request["OcID"] == null ? "" : Request["OcID"].ToString();
//model.OcID = OcID;
string result = PurchaseDAL.UpdateOtherFare(model);
if (result == "")
{
return(Json("OK"));
}
else
{
return(Json("Error"));
}
}
//返回附加費明細資料
public JsonResult GetOtherFareList(BuyFare model)
{
//构造成Json的格式传递
//if (!string.IsNullOrEmpty(model.OcID))
//{
// //var list = SalesOrderDAL.GetSalesBomByID(model.OcID,model.Ver,model.UpperSeq);
// //2021/03/12參數改為數據模型傳值
// var list = SalesOrderDAL.GetSalesBomByID(model);
// var result = new { total = list.Count, rows = list };
// return Json(result, JsonRequestBehavior.AllowGet);
//}
//else
//{
// return Json(null, JsonRequestBehavior.AllowGet);L
//}
var list = PurchaseDAL.GetOtherFareByID(model);
return(Json(list, JsonRequestBehavior.AllowGet));
}
//返回其他費用明細資料
public static List <BuyFare> GetOtherFareByID(BuyFare model)
{
string strSql = string.Format(@"Select * FROM pu_BuyFare Where ID='{0}' and Ver={1} ORDER BY FareID", model.ID, model.Ver);
DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql);
List <BuyFare> lsDetails = new List <BuyFare>();
for (int i = 0; i < dt.Rows.Count; i++)
{
BuyFare mdj = new BuyFare();
DataRow dr = dt.Rows[i];
mdj.ID = dr["ID"].ToString();
mdj.Ver = int.Parse(dr["Ver"].ToString());
mdj.FareID = dr["FareID"].ToString();
mdj.Name = dr["Name"].ToString();
mdj.Qty = int.Parse(dr["Qty"].ToString());
mdj.UnitCode = dr["UnitCode"].ToString();
mdj.Price = decimal.Parse(dr["Price"].ToString());
mdj.FareSum = decimal.Parse(dr["FareSum"].ToString());
mdj.ProductID = dr["ProductID"].ToString();
lsDetails.Add(mdj);
}
return(lsDetails);
}
public static string UpdateOtherFare(BuyFare model)
{
string result = "";
string strSql_i = "";
string strSql_u = "";
//string Seq = GetMaxSeq(model.ID, model.Ver);
strSql_i = string.Format(
@"Insert Into pu_BuyFare(ID,Ver,FareID, Name,FareSum,Qty,Price,UnitCode,ProductID) Values ('{0}','{1}', '{2}', '{3}', '{4}', '{5}', {6}, '{7}', '{8}')",
model.ID, model.Ver, model.FareID, model.Name, model.FareSum, model.Qty, model.Price, model.UnitCode, model.ProductID);
strSql_u = string.Format(
@"Update pu_BuyFare Set Name='{3}',FareSum={4}, Qty={5},Price={6}, UnitCode='{7}', ProductID='{8}' WHERE ID='{0}' And Ver='{1}' And FareID='{2}'",
model.ID, model.Ver, model.FareID, model.Name, model.FareSum, model.Qty, model.Price, model.UnitCode, model.ProductID);
if (model.ActionType == "NEW")
{
result = SQLHelper.ExecuteSqlUpdate(strSql_i);
}
else
{
result = SQLHelper.ExecuteSqlUpdate(strSql_u);
}
return(result);
}
