using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CoreFS.CA06;
using System.Data;
using System.Collections;
using Core.Mes.Client.Common;
using Core.LgMes.Client.lgDbMgt;

namespace Core.LgMes.Client.lgServiceMgt.LgScmOpeateRule
{
   public class ScmOeateRule: Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
       private string UPDATEScmOeateRuleContextType = " update scm_opeaterule a set a.doctype = '{0}'  where  ruleid = '{1}'  and rownum = 1 ";
       private string SELECTScmOeateRuleByRuleId = " select ruleid,  rulename, description,  doc, deviceno,steelcode, recorder,inputtime, content, doctype, isvalid,isbegintime,  isendtime,descriptionname, posittion from  scm_opeaterule   a where a.ruleid = '{0}' ";
       private string SELECTScmOeateRuleByRuleIdAll = " select ruleid,  rulename, description,  doc, deviceno,steelcode, recorder,inputtime, doctype, isvalid,isbegintime,  isendtime,descriptionname, posittion from  scm_opeaterule   a where 1 = 1 {0}";

       /// <summary>
       /// 更新操作规程管理中的类型
       /// </summary>
       /// <param name="param1"></param>
       public void UpdateScmOperateRuleContextType(ClientParamWithSqlConditionAndOpenBase param1)
       {
           string sqlStr = string.Format(UPDATEScmOeateRuleContextType, param1.param[0].ToString(), param1.param[1].ToString());
           DbClientParam param = new DbClientParam(sqlStr, param1.ob);
           base.ReturnDbCommondByCommondType(DbCommandType.Ejgz).ExecuteNonQuery(param);
       }

       public DataSet GetScmOperateRuleDsByRuleId(ClientParamWithSqlConditionAndOpenBase param)
       {
           string sqlStr = string.Format(SELECTScmOeateRuleByRuleId, param.sqlCondition);
           try
           {
               return base.ReturnDbCommondByCommondType(DbCommandType.Ejgz).ExecuteReader(new DbClientParam(sqlStr, param.ob));
           }
           catch
           {
               return null;
           }
          
 
       }


       public DataSet GetScmOperateRuleDs(ClientParamWithSqlConditionAndOpenBase param)
       {
           string sqlStr = string.Format(SELECTScmOeateRuleByRuleIdAll, param.sqlCondition);
           try
           {
               return base.ReturnDbCommondByCommondType(DbCommandType.Ejgz).ExecuteReader(new DbClientParam(sqlStr, param.ob));
           }
           catch
           {
               return null;
           }


       }

    }
}