コード例 #1
0
        public static bool Update(DTOInfor infor)
        {
            bool            result  = true;
            OleDbConnection connect = null;

            try
            {
                connect = openConnect();
                string       strCommand = "UPDATE [Infor] SET [FileName] = @file,[Size] = @size,[IPClient] = @ip,[PortClient] = @port,[FromClient] = @client,[Finish] = @flag WHERE FileName = @file AND FromClient = @client";
                OleDbCommand command    = new OleDbCommand(strCommand, connect);

                OleDbParameter parameter;
                parameter       = new OleDbParameter("@file", OleDbType.VarChar);
                parameter.Value = infor.FileName;
                command.Parameters.Add(parameter);

                parameter       = new OleDbParameter("@size", OleDbType.Integer);
                parameter.Value = infor.Size;
                command.Parameters.Add(parameter);

                parameter       = new OleDbParameter("@ip", OleDbType.VarChar);
                parameter.Value = infor.IpClient;
                command.Parameters.Add(parameter);

                parameter       = new OleDbParameter("@port", OleDbType.Integer);
                parameter.Value = infor.PortClient;
                command.Parameters.Add(parameter);

                parameter       = new OleDbParameter("@client", OleDbType.VarChar);
                parameter.Value = infor.FromClient;
                command.Parameters.Add(parameter);

                parameter       = new OleDbParameter("@flag", OleDbType.Boolean);
                parameter.Value = infor.Flag;
                command.Parameters.Add(parameter);

                parameter       = new OleDbParameter("@file", OleDbType.VarChar);
                parameter.Value = infor.FileName;
                command.Parameters.Add(parameter);

                parameter       = new OleDbParameter("@client", OleDbType.VarChar);
                parameter.Value = infor.FromClient;
                command.Parameters.Add(parameter);

                command.ExecuteNonQuery();
            }
            catch (Exception)
            {
                result = false;
            }
            finally
            {
                if (connect == null && connect.State == System.Data.ConnectionState.Open)
                {
                    connect.Close();
                }
            }
            return(result);
        }
コード例 #2
0
 public ThreadDownload(String ip, String port, String sourse, String nameFile, Socket sockDownload, bool online, String username, String mePort, String meIp, int index, Download my, DTOInfor data)
 {
     C_online     = online;
     IP_connect   = ip;
     Port_connect = port;
     Str_sourse   = sourse;
     Str_nameFile = nameFile;
     S_server     = sockDownload;
     UserName     = username;
     MePort       = port;
     MeIP         = ip;
     i_index      = index;
     me           = my;
     DataInfor    = data;
     me.Sema_addClient.Release();
     this.downloadFile();
 }
コード例 #3
0
        public static List <DTOInfor> getListInfor()
        {
            OleDbConnection connect   = null;
            List <DTOInfor> listInfor = new List <DTOInfor>();

            try
            {
                connect = openConnect();
                string          strCommand = "SELECT * FROM Infor";
                OleDbCommand    command    = new OleDbCommand(strCommand, connect);
                OleDbDataReader read       = command.ExecuteReader();
                while (read.Read())
                {
                    DTOInfor infor = new DTOInfor();
                    infor.Id         = read.GetInt32(0);
                    infor.FileName   = read.GetString(1);
                    infor.Size       = read.GetInt32(2);
                    infor.IpClient   = read.GetString(3);
                    infor.PortClient = read.GetInt32(4);
                    infor.FromClient = read.GetString(5);
                    infor.Flag       = read.GetBoolean(6);
                    listInfor.Add(infor);
                }
                read.Close();
            }
            catch (Exception)
            {
                listInfor = new List <DTOInfor>();
            }
            finally
            {
                if (connect == null && connect.State == System.Data.ConnectionState.Open)
                {
                    connect.Close();
                }
            }
            return(listInfor);
        }
コード例 #4
0
 public static bool Update(DTOInfor infor)
 {
     return(DAOInfor.Update(infor));
 }
コード例 #5
0
 public static bool Insert(DTOInfor infor)
 {
     return(DAOInfor.Insert(infor));
 }