using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Web;
|
using System.Web.Http;
|
using WebAPI.Models;
|
|
namespace WebAPI.Controllers.仓存管理.调拨盘点
|
{
|
public class Kf_MoveStockRequestBillController : ApiController
|
{
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）
|
private json objJsonResult = new json();
|
public DataSet ds = new DataSet();
|
public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
#region 调拨单列表
|
[Route("Kf_MoveStockRequestBill/GetMoveStockRequestBillList")]
|
[HttpGet]
|
public object GetMoveStockRequestBillList(string sWhere)
|
{
|
try
|
{
|
//判断权限(略)
|
|
string sql1 = string.Format("select * from h_v_IF_MoveStockRequestBillList_Litee where 1=1 ");
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCn.RunProcReturn(sql1 + " order by 日期 desc", "h_v_IF_MoveStockRequestBillList_Litee");
|
}
|
else
|
{
|
string sql = sql1 + sWhere ;
|
ds = oCn.RunProcReturn(sql, "h_v_IF_MoveStockRequestBillList_Litee");
|
}
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception ex)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
}
|
}
|
