Esempio n. 1
0
        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public int UpdateEmploySetting(neusoft.HISFC.Object.Base.EmploySetting obj)
        {
            string strSql = "";

            //取select语句
            if (this.Sql.GetSql("Manager.Person.UpdateEmploySetting", ref strSql) == -1)
            {
                this.Err = this.Sql.Err;
                return(-1);
            }
            strSql = string.Format(strSql, obj.person.ID, obj.WaitTime.ToString(), obj.person.ValidState.ToString());
            return(this.ExecNoQuery(strSql));
        }
Esempio n. 2
0
        /// <summary>
        /// 获取
        /// </summary>
        /// <param name="EmployCode"></param>
        /// <returns></returns>
        public neusoft.HISFC.Object.Base.EmploySetting GetEmploySetting(string EmployCode)
        {
            string strSql = "";

            //取select语句
            if (this.Sql.GetSql("Manager.Person.GetEmploySetting", ref strSql) == -1)
            {
                this.Err = this.Sql.Err;
                return(null);
            }
            strSql = string.Format(strSql, EmployCode);
            this.ExecQuery(strSql);
            neusoft.HISFC.Object.Base.EmploySetting emp = new neusoft.HISFC.Object.Base.EmploySetting();
            while (this.Reader.Read())
            {
                emp                   = new neusoft.HISFC.Object.Base.EmploySetting();
                emp.person.ID         = this.Reader[0].ToString();
                emp.WaitTime          = neusoft.neuFC.Function.NConvert.ToDecimal(this.Reader[1].ToString());
                emp.person.ValidState = neusoft.neuFC.Function.NConvert.ToInt32(this.Reader[2].ToString());
            }
            return(emp);
        }