using DAL;
|
using DBUtility;
|
using Model;
|
using Newtonsoft.Json.Linq;
|
using SQLHelper;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web.Http;
|
using WebAPI.BLL;
|
using WebAPI.Models;
|
|
namespace WebAPI.Controllers
|
{
|
public class WebAPIController : ApiController
|
{
|
public string sWhere = "";
|
public WebServer webserver = new WebServer();
|
public DataSet ds = new DataSet();
|
private json objjson = new json();
|
private json objJsonResult = new json();
|
// private POInStockBillServices oclscg_poinstockbillmain = new POInStockBillServices();
|
/// <summary>
|
/// 送货单表头信息
|
/// </summary>
|
/// <param name="sMsg"></param>
|
/// <returns></returns>
|
[Route("Web/GetMAXNum")]
|
[HttpGet]
|
public object GetMAXNum(string HBillType)
|
{
|
try
|
{
|
string HBillNo = "";
|
Int64 HInterID = 0;//显示的字段
|
HInterID = DBUtility.ClsPub.CreateBillID(HBillType, ref DBUtility.ClsPub.sExeReturnInfo);
|
HBillNo = DBUtility.ClsPub.CreateBillCode(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
|
//----------创建虚表------------------------
|
DataTable dt_Main = new DataTable("Json");
|
dt_Main.Columns.Add("HBillNo", typeof(string));
|
dt_Main.Columns.Add("HInterID", typeof(int));
|
//---------创建新行------------------------
|
DataRow dr_main = dt_Main.NewRow();//创建新行
|
dt_Main.Rows.Add(dr_main);//将新行加入到表中
|
dr_main["HBillNo"] = DBUtility.ClsPub.isStrNull(HBillNo);
|
dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID);
|
|
if (HBillNo == null || HInterID == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功";
|
objjson.data = dt_Main;
|
return objjson;
|
}
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 登录
|
/// </summary>
|
/// <param name="UserName">用户名</param>
|
/// <param name="PassWord">密码</param>
|
/// <returns></returns>
|
[Route("Web/GetUser")]
|
[HttpGet]
|
public object GetUser(string UserName, string PassWord)
|
{
|
try
|
{
|
DataSet ds = null;
|
ClsCN oCnLoc = new ClsCN();
|
DAL.ClsUser oUser = new DAL.ClsUser();
|
ds = oUser.CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "密码错误！";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "登录成功！";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "登录异常！";
|
objjson.data = null;
|
return objjson; ;
|
}
|
}
|
/// <summary>
|
/// 修改密码
|
/// </summary>
|
/// <param name="UserName"></param>
|
/// <param name="PassWord"></param>
|
/// <returns></returns>
|
[Route("Web/GetXGPassword")]
|
[HttpGet]
|
public object GetXGPassword(string UserName, string oldPassword, string PassWord, string Repassword)
|
{
|
try
|
{
|
ClsCN oCn = new ClsCN();
|
DataSet oDs = new DataSet();
|
//==========
|
if (PassWord.Trim() != Repassword.Trim())
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "2次密码不一致！";
|
objjson.data = null;
|
return objjson; ;
|
}
|
//===========
|
oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czybm='" + UserName + "'", "Gy_Czygl");
|
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "没有这个用户，不能修改密码！";
|
objjson.data = null;
|
return objjson; ;
|
}
|
else
|
{
|
oCn.RunProc("update Gy_Czygl set Czmm='" + ClsPub.StrToPsd(PassWord.Trim()) + "' where Czybm='" + UserName.Trim() + "'");
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "* 密码修改成功！";
|
objjson.data = null;
|
return objjson; ;
|
}
|
}
|
catch (Exception)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "修改密码异常！";
|
objjson.data = null;
|
return objjson; ;
|
}
|
}
|
|
|
//删除缓存列表记录
|
[Route("Web/Delete_Json")]
|
[HttpGet]
|
public object Delete_Json(long sHInterID)
|
{
|
string sErrMsg = string.Empty;
|
try
|
{
|
if (webserver.DeleteBillList(sHInterID, ref sErrMsg))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "删除成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
|
|
//缓存列表刷新
|
[Route("Web/DisBillEntryList_Mate_Webs_Json")]
|
[HttpGet]
|
public object DisBillEntryList_Webs_Json(string HBillType, string sWhere)
|
{
|
try
|
{
|
ds = webserver.GetKf_PonderationBillMain_TempList(HBillType, sWhere);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
|
//根据内码返回缓存列表信息
|
[Route("Web/GetPonderationBill")]
|
[HttpGet]
|
public object GetPonderationBill(long HInterID)
|
{
|
try
|
{
|
ds = webserver.GetPonderationBill(HInterID);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 获取扫码详情列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetWMSBarCodeDetailsList")]
|
[HttpGet]
|
public object GetWMSBarCodeDetailsList(int HInterID, string HBillType, int HMaterID, int HAuxPropID, string HMTONo, string HBatchNo, int HSourceInterID, int HSourceEntryID, string sWhere)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
//ds = oCN.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp_Sum where HInterID=" + HInterID + " and HBillType='" + HBillType + "' Order by HItemID ", "h_v_KF_PonderationBillMain_Temp_Sum");
|
ds = oCN.RunProcReturn("Select HMTONo,HBatchNo,HBarCode,HWHID,HStockPlaceID,HSCWHID,HOutStockPlaceID,sum(HQty) HQty from KF_PonderationBillMain_Temp Where HQty<>0 and HInterID=" + HInterID.ToString() +
|
" and HBillType='" + HBillType + "'" +
|
" and HMaterID=" + HMaterID +
|
" and HAuxPropID=" + HAuxPropID +
|
" and HMTONo='" + HMTONo + "'" +
|
//" and HWHID=" + HWhID +
|
//" and HStockPlaceID=" + HSPID +
|
//" and HSCWHID=" + HSCWhID +
|
//" and HOutStockPlaceID=" + HSCSPID +
|
" and (HBatchNo='" + HBatchNo + "' or '" + HBatchNo + "' ='')" +
|
" and HSourceInterID=" + HSourceInterID +
|
" and HSourceEntryID=" + HSourceEntryID +
|
sWhere +
|
" Group by HBatchNo,HMTONo,HBarCode,HWHID,HStockPlaceID,HSCWHID,HOutStockPlaceID", "KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
/// <summary>
|
/// 扫码详情中删除缓存表中扫码记录
|
/// </summary>
|
/// <param name="HInterID"></param>
|
/// <param name="HMaterID">物料ID</param>
|
/// <param name="HAuxPropID">辅助属性ID</param>
|
/// <param name="HMTONo"></param>
|
/// <param name="HBillType">单据类型</param>
|
/// <param name="HSourceInterID">源单主ID</param>
|
/// <param name="HSourceEntryID">源单子ID</param>
|
/// <returns>object</returns>
|
[Route("Web/DelCacheList")]
|
[HttpGet]
|
public object DelCacheList(int HInterID, int HMaterID, int HAuxPropID, string HMTONo, string HBillType, int HSourceInterID, int HSourceEntryID)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HitemID = " + sHitemID);
|
oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HInterID=" + HInterID.ToString() + " and HMaterID= " + HMaterID.ToString() + " and HAuxPropID= " + HAuxPropID.ToString() + " and HMTONo='" + HMTONo + "' and HBillType='" + HBillType + "' and HSourceInterID=" + HSourceInterID.ToString() + " and HSourceEntryID=" + HSourceEntryID.ToString() + " and HQty<>0 ", ref DBUtility.ClsPub.sExeReturnInfo);
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "删除成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！";
|
objJsonResult.data = e.ToString();
|
return objJsonResult;
|
}
|
}
|
|
|
/// <summary>
|
/// 获取即时库存wise
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/Get_ICInventoryByMaterIDList")]
|
[HttpGet]
|
public object Get_ICInventoryByMaterIDList(string HBarCode, long HWHID, long HSPID, long HOWNERID, string sWhere)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
ds = oCN.RunProcReturn("exec h_p_KF_ICInventoryByMaterIDList_wise '" + HBarCode + "'," + HWHID + "," + HSPID + "," + HOWNERID + ",'" + sWhere + "'", "ICInventoryByMaterIDList");
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
#region 基础资料
|
/// <summary>
|
/// 获取仓库列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetWarehouseList_Json")]
|
[HttpGet]
|
public object GetWarehouseList_Json(string Warehouse)
|
{
|
sWhere = " Where HStopFlag=0 and HEndFlag=1";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (Warehouse != "")
|
{
|
sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%' ) ";
|
}
|
try
|
{
|
ds = webserver.GetWarehouseList(sWhere, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 获取仓位列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetStockPlaceList_Json")]
|
[HttpGet]
|
public object GetStockPlaceList_Json(string StockPlace, Int64 HWhID)
|
{
|
sWhere = " Where HStopFlag=0 and HEndFlag=1";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (HWhID == 0)
|
{
|
if (StockPlace != "")
|
{
|
sWhere = " Where HStopFlag=0 and ( HNumber like '%" + StockPlace + "%' or HName like '%" + StockPlace + "%' ) ";
|
}
|
else
|
{
|
sWhere = " Where HStopFlag=0 ";
|
}
|
}
|
else
|
{
|
if (StockPlace != "")
|
{
|
sWhere = " Where HStopFlag=0 and HWHID=" + HWhID.ToString() + " and ( HNumber like '%" + StockPlace + "%' or HName like '%" + StockPlace + "%' ) ";
|
}
|
else
|
{
|
sWhere = " Where HStopFlag=0 and HWHID=" + HWhID.ToString();
|
}
|
}
|
try
|
{
|
ds = webserver.GetStockPlaceList(sWhere, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 获取供应商列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetSupplierList_Json")]
|
[HttpGet]
|
public object GetSupplierList_Json(string Supplier)
|
{
|
sWhere = " Where HStopFlag=0 and HEndFlag=1";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (Supplier != "")
|
{
|
sWhere = sWhere + " and ( HNumber like '%" + Supplier + "%' or HName like '%" + Supplier + "%' ) ";
|
}
|
try
|
{
|
ds = webserver.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 获取职员列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetEmployeeList_Json")]
|
[HttpGet]
|
public object GetEmployeeList_Json(string Employee, Int64 HGroupID)
|
{
|
sWhere = " Where HStopFlag=0 and HEndFlag=1";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (HGroupID == 0)
|
{
|
if (Employee != "")
|
{
|
sWhere = " Where HStopFlag=0 and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' ) ";
|
}
|
else
|
{
|
sWhere = " Where HStopFlag=0 ";
|
}
|
}
|
else
|
{
|
if (Employee != "")
|
{
|
sWhere = " Where HStopFlag=0 and HWHID=" + HGroupID.ToString() + " and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' ) ";
|
}
|
else
|
{
|
sWhere = " Where HStopFlag=0 and HWHID=" + HGroupID.ToString();
|
}
|
}
|
try
|
{
|
ds = webserver.GetEmployeeList(sWhere, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 获取部门列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetDepartmentList_Json")]
|
[HttpGet]
|
public object GetDepartmentList_Json(string Department)
|
{
|
sWhere = " Where HStopFlag=0 and HEndFlag=1";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (Department != "")
|
{
|
sWhere = sWhere + " and ( HNumber like '%" + Department + "%' or HName like '%" + Department + "%' ) ";
|
}
|
try
|
{
|
ds = webserver.GetDepartmentList(sWhere, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 获取客户列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Web/GetCustomerList_Json")]
|
[HttpGet]
|
public object GetCustomerList_Json(string Customer)
|
{
|
sWhere = " Where HStopFlag=0 and HEndFlag=1";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (Customer != "")
|
{
|
sWhere = sWhere + " and ( HNumber like '%" + Customer + "%' or HName like '%" + Customer + "%' ) ";
|
}
|
try
|
{
|
ds = webserver.GetCustomerList(sWhere, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功!";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + ex.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
#endregion
|
}
|
|
}
|
