using SQLHelper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Http;
using WebAPI.Models.SBGL.SBBB;

namespace WebAPI.DLL.SBGL.SBBB
{
    public class Sb_EquipMentCollectionTechParam_Ctl: DBUtility.ClsGy_Base_Ctl
    {
        //数据库
        SQLHelper.ClsCN oCn;
        //数据对象创建
        private Sb_EquipMentCollectionTechParam oModel;

        /// <summary>
        /// 新增
        /// </summary>
        /// <returns></returns>
        public override bool AddNew()
        {
            //开启事务
            oCn.BeginTran();

            try
            {
                //调用SQL
                oCn.RunProc("insert into " + MvarItemKey +
                    "(HDate, HSourceCode, HTechParamID, HTechParamName, HCount" +
                    ", HCreateTime, HResult, HProcNumber, HFlag)" +
                    "values('" + DateTime.Now + "','" + oModel.HSourceCode + "'," + oModel.HTechParamID + ",'" +
                    oModel.HTechParamName + "'," + oModel.HCount + ",'" + DateTime.Now + "','" + oModel.HResult +
                    "','" + oModel.HProcNumber + "','" + Convert.ToString(oModel.HFlag ? 1 : 0) + "')"
                    , ref DBUtility.ClsPub.sExeReturnInfo);

                //提交事务
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                //回滚事务
                oCn.RollBack();
                throw(e);
            }

        }

        /// <summary>
        /// 编辑
        /// </summary>
        /// <param name="sItemID"></param>
        /// <returns></returns>
        public override bool ModifyByID(long sItemID)
        {
            try
            {
                //开启事务
                oCn.BeginTran();

                //调用SQL
                oCn.RunProc("Update " + MvarItemKey + "set " +
                    " HDate = '" + oModel.HDate + "' , " + "HSourceCode = '" + oModel.HSourceCode + 
                    "'," + " HTechParamID = "  + oModel.HTechParamID + "," +
                    " HTechParamName = '" + oModel.HTechParamName + "'," + " HCount = " + oModel.HCount +
                    "," + " HCreateTime = '" + oModel.HCreateTime + "'," + " HResult = '" + oModel.HResult +
                    "',"+ "HProcNumber = '" + oModel.HProcNumber + "'," + "HFlag = " + Convert.ToString(oModel.HFlag ? 1 : 0) + 
                    "where HItemID = " + sItemID
                    , ref DBUtility.ClsPub.sExeReturnInfo);

                //提交事务
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                //回滚事务
                oCn.RollBack();
                throw(e);
            }
        }

        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="oCn"></param>
        /// <param name="oModel"></param>
        public Sb_EquipMentCollectionTechParam_Ctl(ClsCN oCn, Sb_EquipMentCollectionTechParam oModel)
        {
            this.oCn = new SQLHelper.ClsCN();
            MvarItemKey = "Sb_EquipMentCollectionTechParam";
            MvarReportTitle = "设备工艺参数数采表";
            this.oModel = oModel;
        }
    }
}