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.Models;
|
|
namespace WebAPI.Controllers
|
{
|
public class Open_PrintTemController : ApiController
|
{
|
private JsonResult objJsonResult = new JsonResult();
|
private json objjson = new json();
|
// private POInStockBillServices oclscg_poinstockbillmain = new POInStockBillServices();
|
public string sWhere = "";
|
public WebServer webserver = new WebServer();
|
public DataSet ds = new DataSet();
|
|
#region [获取打印模板列表]
|
/// <summary>
|
/// 获取打印模板列表
|
/// </summary>
|
/// <returns></returns>
|
[Route("Open_PrintTem/GetOpenTmpList_Json")]
|
[HttpGet]
|
public object GetOpenTmpList_Json(string HNumber)
|
{
|
sWhere = " Where 1=1 ";
|
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
|
if (HNumber != "")
|
{
|
sWhere = sWhere + " and ( HNumber = '" + HNumber + "') ";
|
}
|
try
|
{
|
ds = webserver.GetOpenTmpList(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
|
|
#region [保存打印模板]
|
/// <summary>
|
/// 保存打印模板
|
/// </summary>
|
/// <returns></returns>
|
[Route("Open_PrintTem/SaveOpenTmp")]
|
[HttpGet]
|
public object SaveOpenTmp(string HNumber, string HName)
|
{
|
//ClsCNSRM oCn = new ClsCNSRM();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
try
|
{
|
|
oCn.BeginTran();
|
oCn.RunProc("Insert into SRM_OpenTmp " +
|
" (HNumber,HModel,HName) " +
|
" Values('" + HNumber + "','" + HName + "','" + HName + "')", ref DBUtility.ClsPub.sExeReturnInfo);
|
//修改上级为非末级代码
|
//oCn.RunProc("Update Gy_OpenTmp set HEndflag=0 where HItemID=" + oModel.HParentID, ref ClsPub.sExeReturnInfo);
|
oCn.Commit();
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "保存成功!";
|
objjson.data = null;
|
return objjson;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "保存失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
#endregion
|
|
#region [删除打印模板]
|
/// <summary>
|
/// 删除印模板
|
/// </summary>
|
/// <returns></returns>
|
[Route("Open_PrintTem/DelOpenTmp")]
|
[HttpGet]
|
public object DelOpenTmp(string HItemID)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
try
|
{
|
oCn.BeginTran();
|
oCn.RunProc("Delete from SRM_OpenTmp where HItemID='" + DBUtility.ClsPub.isLong(HItemID) + "'", ref DBUtility.ClsPub.sExeReturnInfo);
|
oCn.Commit();
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "删除成功!";
|
objjson.data = null;
|
return objjson;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "删除失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
#endregion
|
}
|
}
|
