Beispiel #1
0
        public static int Add(DeviceInfo device)
        {
            SqlParameter[] parameters = new SqlParameter[9];
            parameters[0] = new SqlParameter("@IP", SqlDbType.VarChar, 30);
            parameters[0].Value = device.IP;
            parameters[1] = new SqlParameter("@Port", SqlDbType.VarChar, 10);
            parameters[1].Value = device.Port;
            parameters[2] = new SqlParameter("@DeviceType", SqlDbType.VarChar, 2);
            parameters[2].Value = device.DeviceType;
            parameters[3] = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
            parameters[3].Value = device.UserName;
            parameters[4] = new SqlParameter("@Password", SqlDbType.VarChar, 50);
            parameters[4].Value = device.Password;
            parameters[5] = new SqlParameter("@AntNo", SqlDbType.Int);
            parameters[5].Value = device.AntNo;
            parameters[6] = new SqlParameter("@AccessFlag", SqlDbType.Int);
            parameters[6].Value = device.AccessFlag;
            parameters[7] = new SqlParameter("@Flag", SqlDbType.Int);
            parameters[7].Value = device.Active ? 1 : 0;
            parameters[8] = new SqlParameter("@Location", SqlDbType.NVarChar, 50);
            parameters[8].Value = device.Location;

            StringBuilder sql = new StringBuilder();
            sql.AppendLine("DECLARE @ID int");
            sql.AppendLine("INSERT INTO DevInfo (devIp, devPort, devType, devUserName, devPassword, antNo, accessFlag, flag, Location)");
            sql.AppendLine("VALUES (@IP, @Port, @DeviceType, @UserName, @Password, @AntNo, @AccessFlag, @Flag, @Location)");
            sql.AppendLine("SET @ID = SCOPE_IDENTITY()");
            sql.AppendLine("SELECT @ID");
            int newID = (int)helper.ExecuteScalar(sql.ToString(), parameters);
            return newID;
        }
Beispiel #2
0
 public static int Save(DeviceInfo device)
 {
     int id;
     if (device.ID <= 0) {
         id = DeviceDao.Add(device);
     }
     else {
         id = DeviceDao.Update(device) ? device.ID : 0;
     }
     return id;
 }
Beispiel #3
0
        public static bool Update(DeviceInfo device)
        {
            SqlParameter[] parameters = new SqlParameter[10];
            parameters[0] = new SqlParameter("@IP", SqlDbType.VarChar, 30);
            parameters[0].Value = device.IP;
            parameters[1] = new SqlParameter("@Port", SqlDbType.VarChar, 10);
            parameters[1].Value = device.Port;
            parameters[2] = new SqlParameter("@DeviceType", SqlDbType.VarChar, 2);
            parameters[2].Value = device.DeviceType;
            parameters[3] = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
            parameters[3].Value = device.UserName;
            parameters[4] = new SqlParameter("@Password", SqlDbType.VarChar, 50);
            parameters[4].Value = device.Password;
            parameters[5] = new SqlParameter("@AntNo", SqlDbType.Int);
            parameters[5].Value = device.AntNo;
            parameters[6] = new SqlParameter("@AccessFlag", SqlDbType.Int);
            parameters[6].Value = device.AccessFlag;
            parameters[7] = new SqlParameter("@Flag", SqlDbType.Int);
            parameters[7].Value = device.Active ? 1 : 0;
            parameters[8] = new SqlParameter("@ID", SqlDbType.Int);
            parameters[8].Value = device.ID;
            parameters[9] = new SqlParameter("@Location", SqlDbType.NVarChar, 50);
            parameters[9].Value = device.Location;

            StringBuilder sql = new StringBuilder();
            sql.AppendLine("UPDATE DevInfo SET devIp = @IP, devPort = @Port");
            sql.AppendLine("	, devType = @DeviceType, devUserName = @UserName, devPassword = @Password");
            sql.AppendLine("	, antNo = @AntNo, accessFlag = @AccessFlag, flag = @Flag, Location = @Location");
            sql.AppendLine("WHERE ID = @ID");
            return helper.ExecuteNonQuery(sql.ToString(), parameters.ToArray()) > 0;
        }