Example #1
0
        public static SysMan ValidAuth(string manid, string password)
        {
            SysMan item = new SysMan();

            try
            {
                ArrayList paras = new ArrayList();
                paras.Add(DBUtils.MakeInParam("@Man_ID", SqlDbType.NVarChar, 6, manid));
                paras.Add(DBUtils.MakeInParam("@Password", SqlDbType.NVarChar, 50, Crypto.MD5Crypto(password)));

                SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Valid_AuthMan", paras);

                if (reader.Read())
                {
                    item.ManID     = reader["Man_ID"] as string;
                    item.ManName   = reader["Man_Name"] as string;
                    item.DeptID    = reader["Dept_ID"] as string;
                    item.ManLevel  = (short)reader["Man_Level"];
                    item.ManType   = (short)reader["Man_Type"];
                    item.IsLock    = Convert.ToBoolean(reader["Is_Lock"]);
                    item.AuthBound = (short)reader["Auth_Bound"];
                }

                reader.Close();
            }
            catch
            {
                throw;
            }

            return(item);
        }
Example #2
0
        public static void SaveSysMan(SysMan item, DataProviderAction action)
        {
            if (item == null)
            {
                return;
            }

            SqlConnection conn = DBUtils.GetConnection();
            SqlCommand    cmd  = DBUtils.GetCommand();

            try
            {
                cmd.Transaction = conn.BeginTransaction();

                ArrayList paras = new ArrayList();

                paras.Add(DBUtils.MakeInParam("@Man_ID", SqlDbType.NVarChar, 6, item.ManID));
                paras.Add(DBUtils.MakeInParam("@Man_Name", SqlDbType.NVarChar, 10, item.ManName));
                paras.Add(DBUtils.MakeInParam("@Co_ID", SqlDbType.NVarChar, 4, item.CoID));
                paras.Add(DBUtils.MakeInParam("@Dept_ID", SqlDbType.NVarChar, 8, item.DeptID));
                paras.Add(DBUtils.MakeInParam("@Man_Type", SqlDbType.SmallInt, item.ManType));
                paras.Add(DBUtils.MakeInParam("@Crt_Date", SqlDbType.DateTime, item.CrtDate));
                paras.Add(DBUtils.MakeInParam("@Crt_Oper", SqlDbType.NVarChar, 6, item.CrtOper));
                paras.Add(DBUtils.MakeInParam("@Man_Tele", SqlDbType.NVarChar, 30, item.ManTele));
                paras.Add(DBUtils.MakeInParam("@Man_EMail", SqlDbType.NVarChar, 32, item.ManEMail));
                paras.Add(DBUtils.MakeInParam("@Man_Date", SqlDbType.DateTime, Publics.GetDataDateTime(item.ManDate)));
                paras.Add(DBUtils.MakeInParam("@Man_Level", SqlDbType.SmallInt, item.ManLevel));
                paras.Add(DBUtils.MakeInParam("@Man_Title", SqlDbType.SmallInt, item.ManTitle));
                paras.Add(DBUtils.MakeInParam("@Man_Sex", SqlDbType.SmallInt, item.ManSex));
                paras.Add(DBUtils.MakeInParam("@Man_Status", SqlDbType.SmallInt, item.ManStatus));
                paras.Add(DBUtils.MakeInParam("@Oper_Password", SqlDbType.NVarChar, 50, item.OperPassword));
                paras.Add(DBUtils.MakeInParam("@Oper_Serial", SqlDbType.Int, item.OperSerial));
                paras.Add(DBUtils.MakeInParam("@Work_Date", SqlDbType.NVarChar, 8, item.WorkDate));
                paras.Add(DBUtils.MakeInParam("@Auth_Bound", SqlDbType.SmallInt, item.AuthBound));
                paras.Add(DBUtils.MakeInParam("@Is_Admin", SqlDbType.Bit, item.IsAdmin));
                paras.Add(DBUtils.MakeInParam("@Remark", SqlDbType.NVarChar, 20, item.Remark));
                paras.Add(DBUtils.MakeInParam("@Pre_Work_Date", SqlDbType.NVarChar, 8, item.WorkDate));
                paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));

                DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Save_SysMan", paras);

                cmd.Transaction.Commit();
            }
            catch
            {
                cmd.Transaction.Rollback();
                throw;
            }
            finally
            {
                DBUtils.SetDispose(conn, cmd);
            }
        }
Example #3
0
        public static SysMan PopulateSysMan(IDataReader reader)
        {
            SysMan item = new SysMan();

            item.ManID       = reader["Man_ID"] as string;
            item.ManName     = reader["Man_Name"] as string;
            item.CoID        = reader["Co_ID"] as string;
            item.CoName      = reader["Co_Name"] as string;
            item.DeptID      = reader["Dept_ID"] as string;
            item.DeptName    = reader["Dept_Name"] as string;
            item.ManType     = (short)reader["Man_Type"];
            item.ManTypeName = reader["Man_Type_Name"] as string;
            item.CrtDate     = Convert.ToDateTime(reader["Crt_Date"]);
            if (reader["Crt_Oper"] != DBNull.Value)
            {
                item.CrtOper = reader["Crt_Oper"] as string;
            }
            if (reader["Man_Tele"] != DBNull.Value)
            {
                item.ManTele = reader["Man_Tele"] as string;
            }
            if (reader["Man_EMail"] != DBNull.Value)
            {
                item.ManEMail = reader["Man_EMail"] as string;
            }
            if (reader["Man_Date"] != DBNull.Value)
            {
                item.ManDate = Convert.ToDateTime(reader["Man_Date"]);
            }
            item.ManLevel      = (short)reader["Man_Level"];
            item.ManLevelName  = reader["Man_Level_Name"] as string;
            item.ManTitle      = (short)reader["Man_Title"];
            item.ManTitleName  = reader["Man_Title_Name"] as string;
            item.ManSex        = (short)reader["Man_Sex"];
            item.ManSexName    = reader["Man_Sex_Name"] as string;
            item.ManStatus     = (short)reader["Man_Status"];
            item.ManStatusName = reader["Man_Status_Name"] as string;
            item.OperPassword  = reader["Oper_Password"] as string;
            item.OperSerial    = (int)reader["Oper_Serial"];
            item.WorkDate      = reader["Work_Date"] as string;
            item.AuthBound     = (short)reader["Auth_Bound"];
            item.IsAdmin       = Convert.ToBoolean(reader["Is_Admin"]);
            if (reader["Remark"] != DBNull.Value)
            {
                item.Remark = reader["Remark"] as string;
            }
            item.PreWorkDate = reader["Pre_Work_Date"] as string;
            item.IsLock      = Convert.ToBoolean(reader["Is_Lock"]);
            item.IsFirst     = Convert.ToBoolean(reader["Is_First"]);
            return(item);
        }
Example #4
0
        public static SysMan GetSysManByType(string deptid, short type)
        {
            SysMan item = new SysMan();

            try
            {
                ArrayList paras = new ArrayList();
                paras.Add(DBUtils.MakeInParam("@Dept_ID", SqlDbType.NVarChar, 10, deptid));
                paras.Add(DBUtils.MakeInParam("@Man_Type", SqlDbType.SmallInt, type));

                SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Get_ManByType", paras);

                if (reader.Read())
                {
                    item = PopulateSysMan(reader);
                }

                reader.Close();
            }
            catch { throw; }

            return(item);
        }
Example #5
0
        public static SysMan GetSysMan(string manid)
        {
            SysMan item = new SysMan();

            try
            {
                ArrayList paras = new ArrayList();
                paras.Add(DBUtils.MakeInParam("@Man_ID", SqlDbType.NVarChar, 6, manid));
                paras.Add(DBUtils.MakeInParam("@Get_Action", SqlDbType.NVarChar, 10, DataGetAction.Row.ToString().ToLower()));

                SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Get_SysMan", paras);

                if (reader.Read())
                {
                    item = PopulateSysMan(reader);
                }

                reader.Close();
            }
            catch { throw; }

            return(item);
        }