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 [获取打印模板列表] /// /// 获取打印模板列表 /// /// [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 [保存打印模板] /// /// 保存打印模板 /// /// [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 [删除打印模板] /// /// 删除印模板 /// /// [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 } }